INSERT INTO `trading_market_data_cache` (`id`, `key`, `market_type`, `data_type`, `data`, `expires_at`, `created_at`, `updated_at`) VALUES
(175, 'huobi_candles_SUIUSDT_1h_100', 'general', 'json', '[{\"time\":1743415200,\"open\":2.22520000000000006679101716144941747188568115234375,\"high\":2.258999999999999896971303314785473048686981201171875,\"low\":2.20000000000000017763568394002504646778106689453125,\"close\":2.24040000000000016910917111090384423732757568359375,\"volume\":2729693.112633380107581615447998046875},{\"time\":1743418800,\"open\":2.2416999999999998038902049302123486995697021484375,\"high\":2.242999999999999882760448599583469331264495849609375,\"low\":2.19320000000000003836930773104541003704071044921875,\"close\":2.209400000000000030553337637684307992458343505859375,\"volume\":2448717.1173002799041569232940673828125},{\"time\":1743422400,\"open\":2.208800000000000096633812063373625278472900390625,\"high\":2.289800000000000057553961596568115055561065673828125,\"low\":2.198300000000000142819089887780137360095977783203125,\"close\":2.26520000000000010231815394945442676544189453125,\"volume\":2529937.7719738702289760112762451171875},{\"time\":1743426000,\"open\":2.265299999999999869260136620141565799713134765625,\"high\":2.26799999999999979394260662957094609737396240234375,\"low\":2.1852000000000000312638803734444081783294677734375,\"close\":2.22710000000000007958078640513122081756591796875,\"volume\":2894119.87238493002951145172119140625},{\"time\":1743429600,\"open\":2.227300000000000057553961596568115055561065673828125,\"high\":2.297899999999999831601371624856255948543548583984375,\"low\":2.227300000000000057553961596568115055561065673828125,\"close\":2.289099999999999912603243501507677137851715087890625,\"volume\":3182176.4069586000405251979827880859375},{\"time\":1743433200,\"open\":2.289400000000000101607611213694326579570770263671875,\"high\":2.313099999999999933919525574310682713985443115234375,\"low\":2.282200000000000006394884621840901672840118408203125,\"close\":2.2858999999999998209432305884547531604766845703125,\"volume\":2123075.051803410053253173828125},{\"time\":1743436800,\"open\":2.286399999999999987920773492078296840190887451171875,\"high\":2.3056000000000000937916411203332245349884033203125,\"low\":2.28399999999999980815346134477294981479644775390625,\"close\":2.290200000000000013500311979441903531551361083984375,\"volume\":1317344.6414827699773013591766357421875},{\"time\":1743440400,\"open\":2.29000000000000003552713678800500929355621337890625,\"high\":2.307300000000000128608235172578133642673492431640625,\"low\":2.262000000000000010658141036401502788066864013671875,\"close\":2.27090000000000014068746168049983680248260498046875,\"volume\":1195466.7880640099756419658660888671875},{\"time\":1743444000,\"open\":2.272699999999999942446038403431884944438934326171875,\"high\":2.30839999999999978541609380044974386692047119140625,\"low\":2.271900000000000030553337637684307992458343505859375,\"close\":2.287199999999999899813474257825873792171478271484375,\"volume\":1144869.4722035001032054424285888671875},{\"time\":1743447600,\"open\":2.286500000000000198951966012828052043914794921875,\"high\":2.295199999999999906918901615426875650882720947265625,\"low\":2.263599999999999834443542567896656692028045654296875,\"close\":2.27179999999999981952214511693455278873443603515625,\"volume\":905938.1131735700182616710662841796875},{\"time\":1743451200,\"open\":2.273099999999999898392388786305673420429229736328125,\"high\":2.28779999999999983373299983213655650615692138671875,\"low\":2.255199999999999871391764827421866357326507568359375,\"close\":2.257600000000000051159076974727213382720947265625,\"volume\":685608.024755390011705458164215087890625},{\"time\":1743454800,\"open\":2.256299999999999972288833305356092751026153564453125,\"high\":2.272699999999999942446038403431884944438934326171875,\"low\":2.2522999999999999687361196265555918216705322265625,\"close\":2.25720000000000009521272659185342490673065185546875,\"volume\":689043.5675616599619388580322265625},{\"time\":1743458400,\"open\":2.257099999999999884181534071103669703006744384765625,\"high\":2.271500000000000074606987254810519516468048095703125,\"low\":2.25199999999999977973175191436894237995147705078125,\"close\":2.26989999999999980673237587325274944305419921875,\"volume\":1220438.0583381201140582561492919921875},{\"time\":1743462000,\"open\":2.26940000000000008384404281969182193279266357421875,\"high\":2.284899999999999931077354631270281970500946044921875,\"low\":2.260099999999999997868371792719699442386627197265625,\"close\":2.2675000000000000710542735760100185871124267578125,\"volume\":1372354.04365695989690721035003662109375},{\"time\":1743465600,\"open\":2.267399999999999860023081055260263383388519287109375,\"high\":2.289800000000000057553961596568115055561065673828125,\"low\":2.26189999999999979962694851565174758434295654296875,\"close\":2.26869999999999993889332472463138401508331298828125,\"volume\":1010824.706386539968661963939666748046875},{\"time\":1743469200,\"open\":2.266900000000000137134748001699335873126983642578125,\"high\":2.27629999999999999005240169935859739780426025390625,\"low\":2.2522999999999999687361196265555918216705322265625,\"close\":2.2667000000000001591615728102624416351318359375,\"volume\":672737.1596291400492191314697265625},{\"time\":1743472800,\"open\":2.265400000000000080291329140891321003437042236328125,\"high\":2.338499999999999801048033987171947956085205078125,\"low\":2.265400000000000080291329140891321003437042236328125,\"close\":2.33809999999999984510168360429815948009490966796875,\"volume\":1377374.33549965010024607181549072265625},{\"time\":1743476400,\"open\":2.33809999999999984510168360429815948009490966796875,\"high\":2.37300000000000022026824808563105762004852294921875,\"low\":2.332300000000000039790393202565610408782958984375,\"close\":2.345800000000000107291953099775128066539764404296875,\"volume\":2237954.901930239982903003692626953125},{\"time\":1743480000,\"open\":2.345800000000000107291953099775128066539764404296875,\"high\":2.355399999999999938182781988871283829212188720703125,\"low\":2.334499999999999797495320308371447026729583740234375,\"close\":2.3445999999999997953636921010911464691162109375,\"volume\":954339.9827671400271356105804443359375},{\"time\":1743483600,\"open\":2.343999999999999861444166526780463755130767822265625,\"high\":2.366899999999999781863380121649242937564849853515625,\"low\":2.3239999999999998436805981327779591083526611328125,\"close\":2.3254999999999999005240169935859739780426025390625,\"volume\":1051026.35898357001133263111114501953125},{\"time\":1743487200,\"open\":2.3254000000000001335820343228988349437713623046875,\"high\":2.33579999999999987636556397774256765842437744140625,\"low\":2.297400000000000108713038571295328438282012939453125,\"close\":2.326799999999999979394260662957094609737396240234375,\"volume\":1824419.409516110084950923919677734375},{\"time\":1743490800,\"open\":2.328300000000000036237679523765109479427337646484375,\"high\":2.33049999999999979394260662957094609737396240234375,\"low\":2.3056999999999998607336237910203635692596435546875,\"close\":2.318700000000000205346850634668953716754913330078125,\"volume\":1036541.31255607004277408123016357421875},{\"time\":1743494400,\"open\":2.318599999999999994315658113919198513031005859375,\"high\":2.39900000000000002131628207280300557613372802734375,\"low\":2.318599999999999994315658113919198513031005859375,\"close\":2.3925000000000000710542735760100185871124267578125,\"volume\":2379841.4961237502284348011016845703125},{\"time\":1743498000,\"open\":2.39290000000000002700062395888380706310272216796875,\"high\":2.436100000000000154187773659941740334033966064453125,\"low\":2.39290000000000002700062395888380706310272216796875,\"close\":2.43330000000000001847411112976260483264923095703125,\"volume\":2707386.1426994991488754749298095703125},{\"time\":1743501600,\"open\":2.433499999999999996447286321199499070644378662109375,\"high\":2.439999999999999946709294817992486059665679931640625,\"low\":2.396399999999999863575794734060764312744140625,\"close\":2.404900000000000037658764995285309851169586181640625,\"volume\":2311421.761626780033111572265625},{\"time\":1743505200,\"open\":2.404900000000000037658764995285309851169586181640625,\"high\":2.4077000000000001733724275254644453525543212890625,\"low\":2.37150000000000016342482922482304275035858154296875,\"close\":2.38079999999999980531129040173254907131195068359375,\"volume\":1821507.10026835999451577663421630859375},{\"time\":1743508800,\"open\":2.38149999999999995026200849679298698902130126953125,\"high\":2.399500000000000188293824976426549255847930908203125,\"low\":2.361899999999999888444790485664270818233489990234375,\"close\":2.37349999999999994315658113919198513031005859375,\"volume\":1558347.15745396004058420658111572265625},{\"time\":1743512400,\"open\":2.374499999999999833022457096376456320285797119140625,\"high\":2.448399999999999909761072558467276394367218017578125,\"low\":2.372500000000000053290705182007513940334320068359375,\"close\":2.435099999999999820232687852694652974605560302734375,\"volume\":2610942.5851577301509678363800048828125},{\"time\":1743516000,\"open\":2.430499999999999882760448599583469331264495849609375,\"high\":2.439299999999999801758576722932048141956329345703125,\"low\":2.362999999999999989341858963598497211933135986328125,\"close\":2.433499999999999996447286321199499070644378662109375,\"volume\":3933514.6359788901172578334808349609375},{\"time\":1743519600,\"open\":2.432399999999999895550217843265272676944732666015625,\"high\":2.52550000000000007815970093361102044582366943359375,\"low\":2.430499999999999882760448599583469331264495849609375,\"close\":2.4916000000000000369482222595252096652984619140625,\"volume\":4836998.332197950221598148345947265625},{\"time\":1743523200,\"open\":2.4916000000000000369482222595252096652984619140625,\"high\":2.5038000000000000255795384873636066913604736328125,\"low\":2.465800000000000213873363463790155947208404541015625,\"close\":2.469399999999999817390516909654252231121063232421875,\"volume\":2742499.4064200199209153652191162109375},{\"time\":1743526800,\"open\":2.469300000000000050448534238967113196849822998046875,\"high\":2.4763999999999999346300683100707828998565673828125,\"low\":2.4489000000000000767386154620908200740814208984375,\"close\":2.456700000000000105870867628254927694797515869140625,\"volume\":1881258.4366668700240552425384521484375},{\"time\":1743530400,\"open\":2.458299999999999929656269159750081598758697509765625,\"high\":2.458899999999999863575794734060764312744140625,\"low\":2.418200000000000127187149701057933270931243896484375,\"close\":2.431200000000000027711166694643907248973846435546875,\"volume\":1531451.3310575899668037891387939453125},{\"time\":1743534000,\"open\":2.430800000000000071764816311770118772983551025390625,\"high\":2.4375,\"low\":2.40819999999999989626076057902537286281585693359375,\"close\":2.423999999999999932498440102790482342243194580078125,\"volume\":924781.44919527997262775897979736328125},{\"time\":1743537600,\"open\":2.423599999999999976552089719916693866252899169921875,\"high\":2.432700000000000084554585555451922118663787841796875,\"low\":2.40350000000000019184653865522705018520355224609375,\"close\":2.426899999999999835154085303656756877899169921875,\"volume\":1095700.712960599921643733978271484375},{\"time\":1743541200,\"open\":2.42790000000000016910917111090384423732757568359375,\"high\":2.44770000000000020889956431346945464611053466796875,\"low\":2.418699999999999850075482754618860781192779541015625,\"close\":2.431900000000000172661884789704345166683197021484375,\"volume\":1044912.579383870004676282405853271484375},{\"time\":1743544800,\"open\":2.433100000000000040500935938325710594654083251953125,\"high\":2.444199999999999928235183688229881227016448974609375,\"low\":2.420900000000000051869619710487313568592071533203125,\"close\":2.422099999999999919708670859108678996562957763671875,\"volume\":690946.76218706998042762279510498046875},{\"time\":1743548400,\"open\":2.422200000000000130739863379858434200286865234375,\"high\":2.4245000000000000994759830064140260219573974609375,\"low\":2.3955999999999999516830939683131873607635498046875,\"close\":2.408500000000000085265128291212022304534912109375,\"volume\":1582246.08921691006980836391448974609375},{\"time\":1743552000,\"open\":2.40899999999999980815346134477294981479644775390625,\"high\":2.409400000000000208189021577709354460239410400390625,\"low\":2.37849999999999983657517077517695724964141845703125,\"close\":2.380599999999999827338115210295654833316802978515625,\"volume\":1412928.73457983997650444507598876953125},{\"time\":1743555600,\"open\":2.381200000000000205346850634668953716754913330078125,\"high\":2.3910999999999997811528373858891427516937255859375,\"low\":2.365299999999999958077978590154089033603668212890625,\"close\":2.383599999999999941024952931911684572696685791015625,\"volume\":1137460.98154738009907305240631103515625},{\"time\":1743559200,\"open\":2.38459999999999983089082888909615576267242431640625,\"high\":2.384799999999999808864004080533050000667572021484375,\"low\":2.35400000000000009237055564881302416324615478515625,\"close\":2.3643000000000000682121026329696178436279296875,\"volume\":1221549.34605981991626322269439697265625},{\"time\":1743562800,\"open\":2.36470000000000002415845301584340631961822509765625,\"high\":2.38520000000000020889956431346945464611053466796875,\"low\":2.355199999999999960209606797434389591217041015625,\"close\":2.356100000000000083133500083931721746921539306640625,\"volume\":89856.8271563799935393035411834716796875},{\"time\":1743566400,\"open\":2.354200000000000070343730840249918401241302490234375,\"high\":2.371399999999999952393636704073287546634674072265625,\"low\":2.34719999999999995310417943983338773250579833984375,\"close\":2.357299999999999950972551232553087174892425537109375,\"volume\":15465.389489589999357121996581554412841796875},{\"time\":1743570000,\"open\":2.35320000000000018047785488306544721126556396484375,\"high\":2.35320000000000018047785488306544721126556396484375,\"low\":2.314299999999999801758576722932048141956329345703125,\"close\":2.319500000000000117239551400416530668735504150390625,\"volume\":681021.288204379961825907230377197265625},{\"time\":1743573600,\"open\":2.31899999999999995026200849679298698902130126953125,\"high\":2.3452999999999999403144101961515843868255615234375,\"low\":2.313499999999999889865875957184471189975738525390625,\"close\":2.323799999999999865707422941341064870357513427734375,\"volume\":1039604.05595437996089458465576171875},{\"time\":1743577200,\"open\":2.32359999999999988773424774990417063236236572265625,\"high\":2.36169999999999991047161529422737658023834228515625,\"low\":2.317200000000000148503431773860938847064971923828125,\"close\":2.3589999999999999857891452847979962825775146484375,\"volume\":1796511.809147059917449951171875},{\"time\":1743580800,\"open\":2.3589999999999999857891452847979962825775146484375,\"high\":2.394200000000000105870867628254927694797515869140625,\"low\":2.34790000000000009805489753489382565021514892578125,\"close\":2.3940000000000001278976924368180334568023681640625,\"volume\":2332677.9773233397863805294036865234375},{\"time\":1743584400,\"open\":2.393100000000000004973799150320701301097869873046875,\"high\":2.458800000000000096633812063373625278472900390625,\"low\":2.389200000000000212452277992269955575466156005859375,\"close\":2.455299999999999815969431438134051859378814697265625,\"volume\":2921774.9845033399760723114013671875},{\"time\":1743588000,\"open\":2.45469999999999988204990586382336914539337158203125,\"high\":2.499899999999999788968807479250244796276092529296875,\"low\":2.44700000000000006394884621840901672840118408203125,\"close\":2.45739999999999980673237587325274944305419921875,\"volume\":3388931.7150596198625862598419189453125},{\"time\":1743591600,\"open\":2.45739999999999980673237587325274944305419921875,\"high\":2.47210000000000018616219676914624869823455810546875,\"low\":2.43900000000000005684341886080801486968994140625,\"close\":2.443700000000000205346850634668953716754913330078125,\"volume\":1578498.73658143007196485996246337890625},{\"time\":1743595200,\"open\":2.44399999999999995026200849679298698902130126953125,\"high\":2.4611999999999998323119143606163561344146728515625,\"low\":2.43250000000000010658141036401502788066864013671875,\"close\":2.460900000000000087396756498492322862148284912109375,\"volume\":2056163.9056884800083935260772705078125},{\"time\":1743598800,\"open\":2.46079999999999987636556397774256765842437744140625,\"high\":2.496300000000000185451654033386148512363433837890625,\"low\":2.41579999999999994741983755375258624553680419921875,\"close\":2.455200000000000049027448767446912825107574462890625,\"volume\":3081651.3832616698928177356719970703125},{\"time\":1743602400,\"open\":2.4550999999999998379962562466971576213836669921875,\"high\":2.479900000000000215294448935310356318950653076171875,\"low\":2.42720000000000002415845301584340631961822509765625,\"close\":2.466499999999999914734871708787977695465087890625,\"volume\":918763.608108759974129498004913330078125},{\"time\":1743606000,\"open\":2.458800000000000096633812063373625278472900390625,\"high\":2.520000000000000017763568394002504646778106689453125,\"low\":2.458800000000000096633812063373625278472900390625,\"close\":2.47679999999999989057641869294457137584686279296875,\"volume\":220691.1069032099912874400615692138671875},{\"time\":1743609600,\"open\":2.479999999999999982236431605997495353221893310546875,\"high\":2.501599999999999823785401531495153903961181640625,\"low\":2.4611999999999998323119143606163561344146728515625,\"close\":2.470099999999999962341235004714690148830413818359375,\"volume\":98625.565229109997744672000408172607421875},{\"time\":1743613200,\"open\":2.467000000000000081712414612411521375179290771484375,\"high\":2.478499999999999925393012745189480483531951904296875,\"low\":2.430000000000000159872115546022541821002960205078125,\"close\":2.44329999999999980531129040173254907131195068359375,\"volume\":345927.90013003000058233737945556640625},{\"time\":1743616800,\"open\":2.44629999999999991899812812334857881069183349609375,\"high\":2.45929999999999981952214511693455278873443603515625,\"low\":2.426299999999999901234559729346074163913726806640625,\"close\":2.450200000000000155608859131461940705776214599609375,\"volume\":595947.923566609970293939113616943359375},{\"time\":1743620400,\"open\":2.45239999999999991331378623726777732372283935546875,\"high\":2.4832999999999998408384271897375583648681640625,\"low\":2.44200000000000017053025658242404460906982421875,\"close\":2.48200000000000020605739337042905390262603759765625,\"volume\":1296670.8819844699464738368988037109375},{\"time\":1743624000,\"open\":2.48200000000000020605739337042905390262603759765625,\"high\":2.5464999999999999857891452847979962825775146484375,\"low\":2.413199999999999789679350215010344982147216796875,\"close\":2.438899999999999845812226340058259665966033935546875,\"volume\":5672605.82124255038797855377197265625},{\"time\":1743627600,\"open\":2.44090000000000006963318810448981821537017822265625,\"high\":2.44090000000000006963318810448981821537017822265625,\"low\":2.347799999999999887023705014144070446491241455078125,\"close\":2.3742999999999998550492819049395620822906494140625,\"volume\":3735377.92030264995992183685302734375},{\"time\":1743631200,\"open\":2.372199999999999864286337469820864498615264892578125,\"high\":2.372199999999999864286337469820864498615264892578125,\"low\":2.257099999999999884181534071103669703006744384765625,\"close\":2.264299999999999979394260662957094609737396240234375,\"volume\":4123986.37124967761337757110595703125},{\"time\":1743634800,\"open\":2.263900000000000023447910280083306133747100830078125,\"high\":2.32430000000000003268496584496460855007171630859375,\"low\":2.253299999999999858601995583740063011646270751953125,\"close\":2.308499999999999996447286321199499070644378662109375,\"volume\":3463152.606187240220606327056884765625},{\"time\":1743638400,\"open\":2.3086000000000002074784788419492542743682861328125,\"high\":2.38300000000000000710542735760100185871124267578125,\"low\":2.28690000000000015489831639570184051990509033203125,\"close\":2.3818000000000001392663762089796364307403564453125,\"volume\":4339911.309172379784286022186279296875},{\"time\":1743642000,\"open\":2.382499999999999840127884453977458178997039794921875,\"high\":2.415200000000000013500311979441903531551361083984375,\"low\":2.366099999999999869970679355901665985584259033203125,\"close\":2.404599999999999848654397283098660409450531005859375,\"volume\":4341156.014092179946601390838623046875},{\"time\":1743645600,\"open\":2.40430000000000010373923942097462713718414306640625,\"high\":2.4375,\"low\":2.392700000000000049027448767446912825107574462890625,\"close\":2.436900000000000066080474425689317286014556884765625,\"volume\":2651763.7837251699529588222503662109375},{\"time\":1743649200,\"open\":2.436199999999999921129756330628879368305206298828125,\"high\":2.438499999999999889865875957184471189975738525390625,\"low\":2.396900000000000030553337637684307992458343505859375,\"close\":2.408799999999999830180286153336055576801300048828125,\"volume\":1285101.5813682801090180873870849609375},{\"time\":1743652800,\"open\":2.408700000000000063238303482648916542530059814453125,\"high\":2.425800000000000178346226675785146653652191162109375,\"low\":2.39740000000000019753088054130785167217254638671875,\"close\":2.416199999999999903366187936626374721527099609375,\"volume\":1168282.3642142401076853275299072265625},{\"time\":1743656400,\"open\":2.4169000000000000483169060316868126392364501953125,\"high\":2.419799999999999950972551232553087174892425537109375,\"low\":2.355199999999999960209606797434389591217041015625,\"close\":2.3574999999999999289457264239899814128875732421875,\"volume\":1464169.6044167499057948589324951171875},{\"time\":1743660000,\"open\":2.3582999999999998408384271897375583648681640625,\"high\":2.36779999999999990478727340814657509326934814453125,\"low\":2.316899999999999959499064061674289405345916748046875,\"close\":2.32050000000000000710542735760100185871124267578125,\"volume\":2085755.19787649996578693389892578125},{\"time\":1743663600,\"open\":2.321099999999999941024952931911684572696685791015625,\"high\":2.3346000000000000085265128291212022304534912109375,\"low\":2.2842999999999999971578290569595992565155029296875,\"close\":2.318400000000000016342482922482304275035858154296875,\"volume\":2649721.5005365200340747833251953125},{\"time\":1743667200,\"open\":2.318400000000000016342482922482304275035858154296875,\"high\":2.344700000000000006394884621840901672840118408203125,\"low\":2.306299999999999794653149365331046283245086669921875,\"close\":2.313899999999999845812226340058259665966033935546875,\"volume\":2230990.95368045009672641754150390625},{\"time\":1743670800,\"open\":2.312600000000000211031192520749755203723907470703125,\"high\":2.3193000000000001392663762089796364307403564453125,\"low\":2.292899999999999938182781988871283829212188720703125,\"close\":2.2949999999999999289457264239899814128875732421875,\"volume\":1474732.8201557300053536891937255859375},{\"time\":1743674400,\"open\":2.294200000000000017053025658242404460906982421875,\"high\":2.300899999999999945288209346472285687923431396484375,\"low\":2.244800000000000128608235172578133642673492431640625,\"close\":2.244800000000000128608235172578133642673492431640625,\"volume\":2704299.6102245501242578029632568359375},{\"time\":1743678000,\"open\":2.24500000000000010658141036401502788066864013671875,\"high\":2.2576999999999998181010596454143524169921875,\"low\":2.23050000000000014921397450962103903293609619140625,\"close\":2.239199999999999857180910112219862639904022216796875,\"volume\":2186145.9162457198835909366607666015625},{\"time\":1743681600,\"open\":2.239399999999999835154085303656756877899169921875,\"high\":2.255500000000000060396132539608515799045562744140625,\"low\":2.183499999999999996447286321199499070644378662109375,\"close\":2.1989000000000000767386154620908200740814208984375,\"volume\":506028.2381239400128833949565887451171875},{\"time\":1743685200,\"open\":2.198700000000000098765440270653925836086273193359375,\"high\":2.2827000000000001733724275254644453525543212890625,\"low\":2.194900000000000073185901783290319144725799560546875,\"close\":2.271199999999999885602619542623870074748992919921875,\"volume\":113290.601841809999314136803150177001953125},{\"time\":1743688800,\"open\":2.268299999999999982946974341757595539093017578125,\"high\":2.268299999999999982946974341757595539093017578125,\"low\":2.218999999999999861444166526780463755130767822265625,\"close\":2.237999999999999989341858963598497211933135986328125,\"volume\":2032340.626279070042073726654052734375},{\"time\":1743692400,\"open\":2.235300000000000064659388954169116914272308349609375,\"high\":2.26989999999999980673237587325274944305419921875,\"low\":2.222700000000000120081722343456931412220001220703125,\"close\":2.260499999999999953814722175593487918376922607421875,\"volume\":3231130.8407472898252308368682861328125},{\"time\":1743696000,\"open\":2.260400000000000186872739504906348884105682373046875,\"high\":2.272299999999999986499688020558096468448638916015625,\"low\":2.220800000000000107291953099775128066539764404296875,\"close\":2.223599999999999798916405779891647398471832275390625,\"volume\":2829603.9076274600811302661895751953125},{\"time\":1743699600,\"open\":2.223599999999999798916405779891647398471832275390625,\"high\":2.237999999999999989341858963598497211933135986328125,\"low\":2.21769999999999978257392285740934312343597412109375,\"close\":2.222500000000000142108547152020037174224853515625,\"volume\":1477348.28461834997870028018951416015625},{\"time\":1743703200,\"open\":2.222799999999999887023705014144070446491241455078125,\"high\":2.257499999999999840127884453977458178997039794921875,\"low\":2.2065999999999998948396751075051724910736083984375,\"close\":2.236200000000000187583282240666449069976806640625,\"volume\":2483448.1036019599996507167816162109375},{\"time\":1743706800,\"open\":2.236400000000000165556457432103343307971954345703125,\"high\":2.24730000000000007531752999057061970233917236328125,\"low\":2.21609999999999995878852132591418921947479248046875,\"close\":2.2202999999999999403144101961515843868255615234375,\"volume\":1827221.45391458994708955287933349609375},{\"time\":1743710400,\"open\":2.220899999999999874233935770462267100811004638671875,\"high\":2.23899999999999987920773492078296840190887451171875,\"low\":2.204899999999999860023081055260263383388519287109375,\"close\":2.226199999999999956656893118633888661861419677734375,\"volume\":1941927.3056176300160586833953857421875},{\"time\":1743714000,\"open\":2.226199999999999956656893118633888661861419677734375,\"high\":2.261200000000000098765440270653925836086273193359375,\"low\":2.215199999999999835864628039416857063770294189453125,\"close\":2.25150000000000005684341886080801486968994140625,\"volume\":2008192.7529311799444258213043212890625},{\"time\":1743717600,\"open\":2.251399999999999845812226340058259665966033935546875,\"high\":2.25919999999999987494447850622236728668212890625,\"low\":2.231100000000000083133500083931721746921539306640625,\"close\":2.250999999999999889865875957184471189975738525390625,\"volume\":2011860.76929001999087631702423095703125},{\"time\":1743721200,\"open\":2.250999999999999889865875957184471189975738525390625,\"high\":2.26639999999999997015720509807579219341278076171875,\"low\":2.22370000000000000994759830064140260219573974609375,\"close\":2.26339999999999985647036737645976245403289794921875,\"volume\":2147191.999787460081279277801513671875},{\"time\":1743724800,\"open\":2.264600000000000168398628375143744051456451416015625,\"high\":2.271599999999999841548969925497658550739288330078125,\"low\":2.22210000000000018616219676914624869823455810546875,\"close\":2.225099999999999855759824640699662268161773681640625,\"volume\":2493385.32156503014266490936279296875},{\"time\":1743728400,\"open\":2.226199999999999956656893118633888661861419677734375,\"high\":2.251599999999999823785401531495153903961181640625,\"low\":2.19010000000000015774048733874224126338958740234375,\"close\":2.19249999999999989341858963598497211933135986328125,\"volume\":2425413.105113930068910121917724609375},{\"time\":1743732000,\"open\":2.192699999999999871391764827421866357326507568359375,\"high\":2.22449999999999992184029906638897955417633056640625,\"low\":2.190599999999999880628820392303168773651123046875,\"close\":2.20540000000000002700062395888380706310272216796875,\"volume\":2279351.2193628600798547267913818359375},{\"time\":1743735600,\"open\":2.20460000000000011510792319313623011112213134765625,\"high\":2.20739999999999980673237587325274944305419921875,\"low\":2.1501000000000001222133505507372319698333740234375,\"close\":2.18109999999999981667997417389415204524993896484375,\"volume\":2951442.7627420020289719104766845703125},{\"time\":1743739200,\"open\":2.180899999999999838706798982457257807254791259765625,\"high\":2.189200000000000034816594052244909107685089111328125,\"low\":2.163699999999999956656893118633888661861419677734375,\"close\":2.172499999999999875655021241982467472553253173828125,\"volume\":1390653.995505820028483867645263671875},{\"time\":1743742800,\"open\":2.17189999999999994173549566767178475856781005859375,\"high\":2.2080000000000001847411112976260483264923095703125,\"low\":2.15359999999999995878852132591418921947479248046875,\"close\":2.20699999999999985078602549037896096706390380859375,\"volume\":1601120.74615133996121585369110107421875},{\"time\":1743746400,\"open\":2.2065000000000001278976924368180334568023681640625,\"high\":2.22750000000000003552713678800500929355621337890625,\"low\":2.204000000000000181188397618825547397136688232421875,\"close\":2.20540000000000002700062395888380706310272216796875,\"volume\":2250143.7254315898753702640533447265625},{\"time\":1743750000,\"open\":2.204800000000000093081098384573124349117279052734375,\"high\":2.267700000000000049027448767446912825107574462890625,\"low\":2.20380000000000020321522242738865315914154052734375,\"close\":2.262300000000000199662508748588152229785919189453125,\"volume\":1741324.48308772989548742771148681640625},{\"time\":1743753600,\"open\":2.2644999999999999573674358543939888477325439453125,\"high\":2.29999999999999982236431605997495353221893310546875,\"low\":2.249000000000000110134124042815528810024261474609375,\"close\":2.27179999999999981952214511693455278873443603515625,\"volume\":1780748.94682755996473133563995361328125},{\"time\":1743757200,\"open\":2.27249999999999996447286321199499070644378662109375,\"high\":2.2766000000000001790567694115452468395233154296875,\"low\":2.25119999999999986783905114862136542797088623046875,\"close\":2.267300000000000093081098384573124349117279052734375,\"volume\":2225358.9628222598694264888763427734375},{\"time\":1743760800,\"open\":2.268299999999999982946974341757595539093017578125,\"high\":2.2751000000000001222133505507372319698333740234375,\"low\":2.173900000000000165556457432103343307971954345703125,\"close\":2.180800000000000071764816311770118772983551025390625,\"volume\":5098683.36459065973758697509765625},{\"time\":1743764400,\"open\":2.181999999999999939603867460391484200954437255859375,\"high\":2.187699999999999977973175191436894237995147705078125,\"low\":2.12849999999999983657517077517695724964141845703125,\"close\":2.182900000000000062527760746888816356658935546875,\"volume\":4402599.75251838006079196929931640625},{\"time\":1743768000,\"open\":2.182900000000000062527760746888816356658935546875,\"high\":2.213600000000000012079226507921703159809112548828125,\"low\":2.157500000000000195399252334027551114559173583984375,\"close\":2.209099999999999841548969925497658550739288330078125,\"volume\":2984075.36436966992914676666259765625},{\"time\":1743771600,\"open\":2.209700000000000219557705349870957434177398681640625,\"high\":2.22829999999999994741983755375258624553680419921875,\"low\":2.2019999999999999573674358543939888477325439453125,\"close\":2.223599999999999798916405779891647398471832275390625,\"volume\":1120721.3112537399865686893463134765625}]', '2025-04-04 17:20:53', '2025-04-04 17:20:23', '2025-04-04 17:20:23');
INSERT INTO `trading_market_data_cache` (`id`, `key`, `market_type`, `data_type`, `data`, `expires_at`, `created_at`, `updated_at`) VALUES
(176, 'huobi_candles_ETHUSDT_15m_100', 'general', 'json', '[{\"time\":1743765300,\"open\":1779.69000000000005456968210637569427490234375,\"high\":1785.2100000000000363797880709171295166015625,\"low\":1764.339999999999918145476840436458587646484375,\"close\":1767.549999999999954525264911353588104248046875,\"volume\":1897983.3780603199265897274017333984375},{\"time\":1743766200,\"open\":1766.579999999999927240423858165740966796875,\"high\":1777.90000000000009094947017729282379150390625,\"low\":1758.720000000000027284841053187847137451171875,\"close\":1767.180000000000063664629124104976654052734375,\"volume\":1624312.53892355994321405887603759765625},{\"time\":1743767100,\"open\":1767.140000000000100044417195022106170654296875,\"high\":1784.569999999999936335370875895023345947265625,\"low\":1767.140000000000100044417195022106170654296875,\"close\":1784.259999999999990905052982270717620849609375,\"volume\":2664529.097114779986441135406494140625},{\"time\":1743768000,\"open\":1783.859999999999899955582804977893829345703125,\"high\":1783.859999999999899955582804977893829345703125,\"low\":1777.140000000000100044417195022106170654296875,\"close\":1781.3699999999998908606357872486114501953125,\"volume\":1499886.941331000067293643951416015625},{\"time\":1743768900,\"open\":1782.859999999999899955582804977893829345703125,\"high\":1784.7899999999999636202119290828704833984375,\"low\":1773.430000000000063664629124104976654052734375,\"close\":1778.609999999999899955582804977893829345703125,\"volume\":744727.43582000001333653926849365234375},{\"time\":1743769800,\"open\":1777.640000000000100044417195022106170654296875,\"high\":1800,\"low\":1770,\"close\":1780.829999999999927240423858165740966796875,\"volume\":3599450.1655035200528800487518310546875},{\"time\":1743770700,\"open\":1780.509999999999990905052982270717620849609375,\"high\":1788.529999999999972715158946812152862548828125,\"low\":1777.170000000000072759576141834259033203125,\"close\":1788.3699999999998908606357872486114501953125,\"volume\":1613741.80119750997982919216156005859375},{\"time\":1743771600,\"open\":1788.579999999999927240423858165740966796875,\"high\":1799.7899999999999636202119290828704833984375,\"low\":1783.34999999999990905052982270717620849609375,\"close\":1786.4600000000000363797880709171295166015625,\"volume\":1536114.74181571998633444309234619140625},{\"time\":1743772500,\"open\":1786.089999999999918145476840436458587646484375,\"high\":1788.920000000000072759576141834259033203125,\"low\":1780.049999999999954525264911353588104248046875,\"close\":1780.049999999999954525264911353588104248046875,\"volume\":425414.576095000025816261768341064453125},{\"time\":1743773400,\"open\":1780,\"high\":1788.509999999999990905052982270717620849609375,\"low\":1772.19000000000005456968210637569427490234375,\"close\":1776.970000000000027284841053187847137451171875,\"volume\":1589000.915000000037252902984619140625},{\"time\":1743774300,\"open\":1776.84999999999990905052982270717620849609375,\"high\":1808.990000000000009094947017729282379150390625,\"low\":1774.59999999999990905052982270717620849609375,\"close\":1803.279999999999972715158946812152862548828125,\"volume\":1856305.940384239889681339263916015625},{\"time\":1743775200,\"open\":1802.779999999999972715158946812152862548828125,\"high\":1805.25,\"low\":1787.15000000000009094947017729282379150390625,\"close\":1792.009999999999990905052982270717620849609375,\"volume\":1707609.17053094995208084583282470703125},{\"time\":1743776100,\"open\":1793.09999999999990905052982270717620849609375,\"high\":1797.90000000000009094947017729282379150390625,\"low\":1784.259999999999990905052982270717620849609375,\"close\":1787.48000000000001818989403545856475830078125,\"volume\":1325874.038249189965426921844482421875},{\"time\":1743777000,\"open\":1787.15000000000009094947017729282379150390625,\"high\":1792.1300000000001091393642127513885498046875,\"low\":1781.470000000000027284841053187847137451171875,\"close\":1784.160000000000081854523159563541412353515625,\"volume\":870337.5863540000282227993011474609375},{\"time\":1743777900,\"open\":1783.94000000000005456968210637569427490234375,\"high\":1793.410000000000081854523159563541412353515625,\"low\":1776,\"close\":1790.34999999999990905052982270717620849609375,\"volume\":1439087.25589599995873868465423583984375},{\"time\":1743778800,\"open\":1789.829999999999927240423858165740966796875,\"high\":1815.09999999999990905052982270717620849609375,\"low\":1788.950000000000045474735088646411895751953125,\"close\":1812.65000000000009094947017729282379150390625,\"volume\":2682337.0344191598705947399139404296875},{\"time\":1743779700,\"open\":1812.779999999999972715158946812152862548828125,\"high\":1820.670000000000072759576141834259033203125,\"low\":1801.509999999999990905052982270717620849609375,\"close\":1802.569999999999936335370875895023345947265625,\"volume\":1961996.6504544899798929691314697265625},{\"time\":1743780600,\"open\":1802.55999999999994543031789362430572509765625,\"high\":1807.220000000000027284841053187847137451171875,\"low\":1787.640000000000100044417195022106170654296875,\"close\":1792.94000000000005456968210637569427490234375,\"volume\":2147616.741830999962985515594482421875},{\"time\":1743781500,\"open\":1792.51999999999998181010596454143524169921875,\"high\":1804.359999999999899955582804977893829345703125,\"low\":1788.720000000000027284841053187847137451171875,\"close\":1795.859999999999899955582804977893829345703125,\"volume\":854734.6156190000474452972412109375},{\"time\":1743782400,\"open\":1795.6300000000001091393642127513885498046875,\"high\":1805.029999999999972715158946812152862548828125,\"low\":1791.990000000000009094947017729282379150390625,\"close\":1800.98000000000001818989403545856475830078125,\"volume\":834498.310231180046685039997100830078125},{\"time\":1743783300,\"open\":1801.30999999999994543031789362430572509765625,\"high\":1801.30999999999994543031789362430572509765625,\"low\":1783.160000000000081854523159563541412353515625,\"close\":1789.80999999999994543031789362430572509765625,\"volume\":886722.791002340032719075679779052734375},{\"time\":1743784200,\"open\":1789.6199999999998908606357872486114501953125,\"high\":1797.170000000000072759576141834259033203125,\"low\":1787.329999999999927240423858165740966796875,\"close\":1790.910000000000081854523159563541412353515625,\"volume\":2525007.9195530000142753124237060546875},{\"time\":1743785100,\"open\":1790.009999999999990905052982270717620849609375,\"high\":1801.069999999999936335370875895023345947265625,\"low\":1787.339999999999918145476840436458587646484375,\"close\":1797.180000000000063664629124104976654052734375,\"volume\":1094369.8436975399963557720184326171875},{\"time\":1743786000,\"open\":1797.55999999999994543031789362430572509765625,\"high\":1802.160000000000081854523159563541412353515625,\"low\":1790.740000000000009094947017729282379150390625,\"close\":1792.1300000000001091393642127513885498046875,\"volume\":622543.55284300004132091999053955078125},{\"time\":1743786900,\"open\":1792.029999999999972715158946812152862548828125,\"high\":1803.420000000000072759576141834259033203125,\"low\":1788.15000000000009094947017729282379150390625,\"close\":1801.069999999999936335370875895023345947265625,\"volume\":341546.35699000000022351741790771484375},{\"time\":1743787800,\"open\":1799.23000000000001818989403545856475830078125,\"high\":1820,\"low\":1797.339999999999918145476840436458587646484375,\"close\":1813.30999999999994543031789362430572509765625,\"volume\":1659291.68038000003434717655181884765625},{\"time\":1743788700,\"open\":1814.759999999999990905052982270717620849609375,\"high\":1828.90000000000009094947017729282379150390625,\"low\":1811.759999999999990905052982270717620849609375,\"close\":1820.759999999999990905052982270717620849609375,\"volume\":2150032.316881000064313411712646484375},{\"time\":1743789600,\"open\":1821.859999999999899955582804977893829345703125,\"high\":1823.069999999999936335370875895023345947265625,\"low\":1812.75,\"close\":1813.930000000000063664629124104976654052734375,\"volume\":499359.094056510017253458499908447265625},{\"time\":1743790500,\"open\":1813.26999999999998181010596454143524169921875,\"high\":1815.76999999999998181010596454143524169921875,\"low\":1808.680000000000063664629124104976654052734375,\"close\":1810.98000000000001818989403545856475830078125,\"volume\":2486172.4284970001317560672760009765625},{\"time\":1743791400,\"open\":1811.589999999999918145476840436458587646484375,\"high\":1812.94000000000005456968210637569427490234375,\"low\":1806.1199999999998908606357872486114501953125,\"close\":1806.69000000000005456968210637569427490234375,\"volume\":1176857.80650636996142566204071044921875},{\"time\":1743792300,\"open\":1806.910000000000081854523159563541412353515625,\"high\":1812.970000000000027284841053187847137451171875,\"low\":1804.7100000000000363797880709171295166015625,\"close\":1805.59999999999990905052982270717620849609375,\"volume\":1961581.92559199989773333072662353515625},{\"time\":1743793200,\"open\":1805.59999999999990905052982270717620849609375,\"high\":1813.51999999999998181010596454143524169921875,\"low\":1801.839999999999918145476840436458587646484375,\"close\":1812.6199999999998908606357872486114501953125,\"volume\":1918158.6059099999256432056427001953125},{\"time\":1743794100,\"open\":1812.6300000000001091393642127513885498046875,\"high\":1815.279999999999972715158946812152862548828125,\"low\":1806.740000000000009094947017729282379150390625,\"close\":1810.589999999999918145476840436458587646484375,\"volume\":1093448.58124700002372264862060546875},{\"time\":1743795000,\"open\":1810.329999999999927240423858165740966796875,\"high\":1814.819999999999936335370875895023345947265625,\"low\":1807.8699999999998908606357872486114501953125,\"close\":1813.359999999999899955582804977893829345703125,\"volume\":1362669.23105700011365115642547607421875},{\"time\":1743795900,\"open\":1813.200000000000045474735088646411895751953125,\"high\":1814.579999999999927240423858165740966796875,\"low\":1809.170000000000072759576141834259033203125,\"close\":1810,\"volume\":413641.8377071699942462146282196044921875},{\"time\":1743796800,\"open\":1810.490000000000009094947017729282379150390625,\"high\":1813.359999999999899955582804977893829345703125,\"low\":1808.779999999999972715158946812152862548828125,\"close\":1809.819999999999936335370875895023345947265625,\"volume\":1436064.34642000007443130016326904296875},{\"time\":1743797700,\"open\":1809.84999999999990905052982270717620849609375,\"high\":1811.240000000000009094947017729282379150390625,\"low\":1807.3699999999998908606357872486114501953125,\"close\":1810.670000000000072759576141834259033203125,\"volume\":580191.123143870034255087375640869140625},{\"time\":1743798600,\"open\":1810.970000000000027284841053187847137451171875,\"high\":1819.30999999999994543031789362430572509765625,\"low\":1810.970000000000027284841053187847137451171875,\"close\":1818.80999999999994543031789362430572509765625,\"volume\":329966.278944000019691884517669677734375},{\"time\":1743799500,\"open\":1818.819999999999936335370875895023345947265625,\"high\":1822.7100000000000363797880709171295166015625,\"low\":1817.2899999999999636202119290828704833984375,\"close\":1818.69000000000005456968210637569427490234375,\"volume\":502057.71657404000870883464813232421875},{\"time\":1743800400,\"open\":1818.420000000000072759576141834259033203125,\"high\":1823.30999999999994543031789362430572509765625,\"low\":1816.23000000000001818989403545856475830078125,\"close\":1821.140000000000100044417195022106170654296875,\"volume\":382769.160792000009678304195404052734375},{\"time\":1743801300,\"open\":1820.670000000000072759576141834259033203125,\"high\":1821.609999999999899955582804977893829345703125,\"low\":1817.410000000000081854523159563541412353515625,\"close\":1819.140000000000100044417195022106170654296875,\"volume\":112763.789172000004327856004238128662109375},{\"time\":1743802200,\"open\":1819.160000000000081854523159563541412353515625,\"high\":1822.9600000000000363797880709171295166015625,\"low\":1812.839999999999918145476840436458587646484375,\"close\":1822.640000000000100044417195022106170654296875,\"volume\":421963.955491999979130923748016357421875},{\"time\":1743803100,\"open\":1822.829999999999927240423858165740966796875,\"high\":1827.76999999999998181010596454143524169921875,\"low\":1817.25,\"close\":1817.2899999999999636202119290828704833984375,\"volume\":1107585.52459123008884489536285400390625},{\"time\":1743804000,\"open\":1818.2899999999999636202119290828704833984375,\"high\":1820.48000000000001818989403545856475830078125,\"low\":1815.759999999999990905052982270717620849609375,\"close\":1819.720000000000027284841053187847137451171875,\"volume\":618221.291937000001780688762664794921875},{\"time\":1743804900,\"open\":1819.829999999999927240423858165740966796875,\"high\":1825.84999999999990905052982270717620849609375,\"low\":1819.529999999999972715158946812152862548828125,\"close\":1824.009999999999990905052982270717620849609375,\"volume\":486810.1367319999844767153263092041015625},{\"time\":1743805800,\"open\":1823.90000000000009094947017729282379150390625,\"high\":1823.90000000000009094947017729282379150390625,\"low\":1818.2899999999999636202119290828704833984375,\"close\":1821.40000000000009094947017729282379150390625,\"volume\":924569.213533660047687590122222900390625},{\"time\":1743806700,\"open\":1819.98000000000001818989403545856475830078125,\"high\":1820.48000000000001818989403545856475830078125,\"low\":1818.7100000000000363797880709171295166015625,\"close\":1818.779999999999972715158946812152862548828125,\"volume\":327381.716743999975733458995819091796875},{\"time\":1743807600,\"open\":1818.759999999999990905052982270717620849609375,\"high\":1819.740000000000009094947017729282379150390625,\"low\":1812.339999999999918145476840436458587646484375,\"close\":1813.4600000000000363797880709171295166015625,\"volume\":243452.5787659999914467334747314453125},{\"time\":1743808500,\"open\":1813.26999999999998181010596454143524169921875,\"high\":1814.15000000000009094947017729282379150390625,\"low\":1809.140000000000100044417195022106170654296875,\"close\":1809.930000000000063664629124104976654052734375,\"volume\":643717.275328999967314302921295166015625},{\"time\":1743809400,\"open\":1810.180000000000063664629124104976654052734375,\"high\":1812.65000000000009094947017729282379150390625,\"low\":1809.80999999999994543031789362430572509765625,\"close\":1812.450000000000045474735088646411895751953125,\"volume\":289312.2850130000151693820953369140625},{\"time\":1743810300,\"open\":1812.65000000000009094947017729282379150390625,\"high\":1816.700000000000045474735088646411895751953125,\"low\":1812.65000000000009094947017729282379150390625,\"close\":1816.700000000000045474735088646411895751953125,\"volume\":208270.5958171300007961690425872802734375},{\"time\":1743811200,\"open\":1816.6300000000001091393642127513885498046875,\"high\":1816.6300000000001091393642127513885498046875,\"low\":1812.529999999999972715158946812152862548828125,\"close\":1814.339999999999918145476840436458587646484375,\"volume\":512693.87606899999082088470458984375},{\"time\":1743812100,\"open\":1814.759999999999990905052982270717620849609375,\"high\":1819.40000000000009094947017729282379150390625,\"low\":1814.759999999999990905052982270717620849609375,\"close\":1816.73000000000001818989403545856475830078125,\"volume\":295982.1824609999894164502620697021484375},{\"time\":1743813000,\"open\":1817.680000000000063664629124104976654052734375,\"high\":1817.700000000000045474735088646411895751953125,\"low\":1813.569999999999936335370875895023345947265625,\"close\":1813.930000000000063664629124104976654052734375,\"volume\":339542.6918639999930746853351593017578125},{\"time\":1743813900,\"open\":1814.970000000000027284841053187847137451171875,\"high\":1824.73000000000001818989403545856475830078125,\"low\":1814.970000000000027284841053187847137451171875,\"close\":1822.65000000000009094947017729282379150390625,\"volume\":584558.6693979999981820583343505859375},{\"time\":1743814800,\"open\":1823.25,\"high\":1824.279999999999972715158946812152862548828125,\"low\":1820.0399999999999636202119290828704833984375,\"close\":1820.509999999999990905052982270717620849609375,\"volume\":598511.394613999989815056324005126953125},{\"time\":1743815700,\"open\":1820.84999999999990905052982270717620849609375,\"high\":1827.049999999999954525264911353588104248046875,\"low\":1820.84999999999990905052982270717620849609375,\"close\":1825.890000000000100044417195022106170654296875,\"volume\":378004.7787820000085048377513885498046875},{\"time\":1743816600,\"open\":1824.990000000000009094947017729282379150390625,\"high\":1825.950000000000045474735088646411895751953125,\"low\":1822.34999999999990905052982270717620849609375,\"close\":1822.609999999999899955582804977893829345703125,\"volume\":167327.62759600000572390854358673095703125},{\"time\":1743817500,\"open\":1822.59999999999990905052982270717620849609375,\"high\":1822.59999999999990905052982270717620849609375,\"low\":1819.049999999999954525264911353588104248046875,\"close\":1819.40000000000009094947017729282379150390625,\"volume\":221128.114315000013448297977447509765625},{\"time\":1743818400,\"open\":1819.529999999999972715158946812152862548828125,\"high\":1821.19000000000005456968210637569427490234375,\"low\":1815.7100000000000363797880709171295166015625,\"close\":1817.09999999999990905052982270717620849609375,\"volume\":162556.56971700000576674938201904296875},{\"time\":1743819300,\"open\":1817.430000000000063664629124104976654052734375,\"high\":1818.009999999999990905052982270717620849609375,\"low\":1814.329999999999927240423858165740966796875,\"close\":1814.329999999999927240423858165740966796875,\"volume\":179754.96172863998799584805965423583984375},{\"time\":1743820200,\"open\":1814.470000000000027284841053187847137451171875,\"high\":1820.140000000000100044417195022106170654296875,\"low\":1813.30999999999994543031789362430572509765625,\"close\":1820.140000000000100044417195022106170654296875,\"volume\":124647.133557930006645619869232177734375},{\"time\":1743821100,\"open\":1819.9600000000000363797880709171295166015625,\"high\":1819.9600000000000363797880709171295166015625,\"low\":1814.450000000000045474735088646411895751953125,\"close\":1815.609999999999899955582804977893829345703125,\"volume\":132739.37186323999776504933834075927734375},{\"time\":1743822000,\"open\":1815.7100000000000363797880709171295166015625,\"high\":1816,\"low\":1811.84999999999990905052982270717620849609375,\"close\":1812.660000000000081854523159563541412353515625,\"volume\":117070.291177999999490566551685333251953125},{\"time\":1743822900,\"open\":1812.15000000000009094947017729282379150390625,\"high\":1814.930000000000063664629124104976654052734375,\"low\":1809.3800000000001091393642127513885498046875,\"close\":1809.3800000000001091393642127513885498046875,\"volume\":240922.12784000000101514160633087158203125},{\"time\":1743823800,\"open\":1809.640000000000100044417195022106170654296875,\"high\":1812.25,\"low\":1809.430000000000063664629124104976654052734375,\"close\":1812.109999999999899955582804977893829345703125,\"volume\":162455.25584016999346204102039337158203125},{\"time\":1743824700,\"open\":1812.109999999999899955582804977893829345703125,\"high\":1813.0399999999999636202119290828704833984375,\"low\":1809.8699999999998908606357872486114501953125,\"close\":1810.01999999999998181010596454143524169921875,\"volume\":191700.6399439999950118362903594970703125},{\"time\":1743825600,\"open\":1809.759999999999990905052982270717620849609375,\"high\":1814.609999999999899955582804977893829345703125,\"low\":1809.759999999999990905052982270717620849609375,\"close\":1814.34999999999990905052982270717620849609375,\"volume\":519497.2342790000257082283496856689453125},{\"time\":1743826500,\"open\":1813.80999999999994543031789362430572509765625,\"high\":1815.299999999999954525264911353588104248046875,\"low\":1812.680000000000063664629124104976654052734375,\"close\":1815.299999999999954525264911353588104248046875,\"volume\":82892.28259200000320561230182647705078125},{\"time\":1743827400,\"open\":1815.140000000000100044417195022106170654296875,\"high\":1815.390000000000100044417195022106170654296875,\"low\":1812,\"close\":1812,\"volume\":66534.76617899999837391078472137451171875},{\"time\":1743828300,\"open\":1811.9600000000000363797880709171295166015625,\"high\":1811.9600000000000363797880709171295166015625,\"low\":1807.390000000000100044417195022106170654296875,\"close\":1808.3699999999998908606357872486114501953125,\"volume\":255596.92891799999051727354526519775390625},{\"time\":1743829200,\"open\":1808.2899999999999636202119290828704833984375,\"high\":1811.009999999999990905052982270717620849609375,\"low\":1807,\"close\":1810.30999999999994543031789362430572509765625,\"volume\":441942.3346649999730288982391357421875},{\"time\":1743830100,\"open\":1810.65000000000009094947017729282379150390625,\"high\":1814.69000000000005456968210637569427490234375,\"low\":1810.299999999999954525264911353588104248046875,\"close\":1814.299999999999954525264911353588104248046875,\"volume\":115146.883096999998087994754314422607421875},{\"time\":1743831000,\"open\":1814.5,\"high\":1815.079999999999927240423858165740966796875,\"low\":1811.4600000000000363797880709171295166015625,\"close\":1811.98000000000001818989403545856475830078125,\"volume\":160956.72448045000783167779445648193359375},{\"time\":1743831900,\"open\":1811.549999999999954525264911353588104248046875,\"high\":1811.549999999999954525264911353588104248046875,\"low\":1809.9600000000000363797880709171295166015625,\"close\":1810.490000000000009094947017729282379150390625,\"volume\":109122.716501000002608634531497955322265625},{\"time\":1743832800,\"open\":1810.01999999999998181010596454143524169921875,\"high\":1812.490000000000009094947017729282379150390625,\"low\":1809.65000000000009094947017729282379150390625,\"close\":1812.490000000000009094947017729282379150390625,\"volume\":83292.9276470000040717422962188720703125},{\"time\":1743833700,\"open\":1812.490000000000009094947017729282379150390625,\"high\":1813.319999999999936335370875895023345947265625,\"low\":1811.4600000000000363797880709171295166015625,\"close\":1811.470000000000027284841053187847137451171875,\"volume\":88217.576732999994419515132904052734375},{\"time\":1743834600,\"open\":1811.51999999999998181010596454143524169921875,\"high\":1811.529999999999972715158946812152862548828125,\"low\":1807.15000000000009094947017729282379150390625,\"close\":1807.73000000000001818989403545856475830078125,\"volume\":551424.042520000017248094081878662109375},{\"time\":1743835500,\"open\":1807.859999999999899955582804977893829345703125,\"high\":1809.640000000000100044417195022106170654296875,\"low\":1804.009999999999990905052982270717620849609375,\"close\":1809.44000000000005456968210637569427490234375,\"volume\":462018.9385864199721254408359527587890625},{\"time\":1743836400,\"open\":1808.84999999999990905052982270717620849609375,\"high\":1810.640000000000100044417195022106170654296875,\"low\":1807.1199999999998908606357872486114501953125,\"close\":1808.069999999999936335370875895023345947265625,\"volume\":310176.2948004200006835162639617919921875},{\"time\":1743837300,\"open\":1807.94000000000005456968210637569427490234375,\"high\":1811.26999999999998181010596454143524169921875,\"low\":1807.029999999999972715158946812152862548828125,\"close\":1810.970000000000027284841053187847137451171875,\"volume\":245834.05302500000107102096080780029296875},{\"time\":1743838200,\"open\":1811.240000000000009094947017729282379150390625,\"high\":1811.65000000000009094947017729282379150390625,\"low\":1809.410000000000081854523159563541412353515625,\"close\":1811.65000000000009094947017729282379150390625,\"volume\":191832.2000359999947249889373779296875},{\"time\":1743839100,\"open\":1811.65000000000009094947017729282379150390625,\"high\":1814.299999999999954525264911353588104248046875,\"low\":1811.65000000000009094947017729282379150390625,\"close\":1812.6199999999998908606357872486114501953125,\"volume\":131729.011033919989131391048431396484375},{\"time\":1743840000,\"open\":1813,\"high\":1814.3699999999998908606357872486114501953125,\"low\":1811.2100000000000363797880709171295166015625,\"close\":1811.2100000000000363797880709171295166015625,\"volume\":46705.9879419999997480772435665130615234375},{\"time\":1743840900,\"open\":1810.609999999999899955582804977893829345703125,\"high\":1813.089999999999918145476840436458587646484375,\"low\":1809.7899999999999636202119290828704833984375,\"close\":1810.90000000000009094947017729282379150390625,\"volume\":100580.235381999998935498297214508056640625},{\"time\":1743841800,\"open\":1811.279999999999972715158946812152862548828125,\"high\":1813.089999999999918145476840436458587646484375,\"low\":1810.009999999999990905052982270717620849609375,\"close\":1812.75,\"volume\":120907.76262525000493042171001434326171875},{\"time\":1743842700,\"open\":1812.80999999999994543031789362430572509765625,\"high\":1814.859999999999899955582804977893829345703125,\"low\":1812.80999999999994543031789362430572509765625,\"close\":1813.80999999999994543031789362430572509765625,\"volume\":80183.702719950000755488872528076171875},{\"time\":1743843600,\"open\":1814.05999999999994543031789362430572509765625,\"high\":1818.259999999999990905052982270717620849609375,\"low\":1814.05999999999994543031789362430572509765625,\"close\":1817.670000000000072759576141834259033203125,\"volume\":147649.3714289999916218221187591552734375},{\"time\":1743844500,\"open\":1817.7899999999999636202119290828704833984375,\"high\":1818.90000000000009094947017729282379150390625,\"low\":1816.2899999999999636202119290828704833984375,\"close\":1818.4600000000000363797880709171295166015625,\"volume\":586762.531507999985478818416595458984375},{\"time\":1743845400,\"open\":1818.59999999999990905052982270717620849609375,\"high\":1820.420000000000072759576141834259033203125,\"low\":1816.23000000000001818989403545856475830078125,\"close\":1820.420000000000072759576141834259033203125,\"volume\":346222.063458609976805746555328369140625},{\"time\":1743846300,\"open\":1820.339999999999918145476840436458587646484375,\"high\":1821.84999999999990905052982270717620849609375,\"low\":1819.490000000000009094947017729282379150390625,\"close\":1820.8699999999998908606357872486114501953125,\"volume\":284967.3026473799836821854114532470703125},{\"time\":1743847200,\"open\":1821,\"high\":1821.390000000000100044417195022106170654296875,\"low\":1817.470000000000027284841053187847137451171875,\"close\":1819.990000000000009094947017729282379150390625,\"volume\":254954.7060331800021231174468994140625},{\"time\":1743848100,\"open\":1820,\"high\":1820.25,\"low\":1816.680000000000063664629124104976654052734375,\"close\":1818.009999999999990905052982270717620849609375,\"volume\":186239.54717472000629641115665435791015625},{\"time\":1743849000,\"open\":1817.90000000000009094947017729282379150390625,\"high\":1820.220000000000027284841053187847137451171875,\"low\":1816.930000000000063664629124104976654052734375,\"close\":1817.049999999999954525264911353588104248046875,\"volume\":349935.4728059999761171638965606689453125},{\"time\":1743849900,\"open\":1817.2100000000000363797880709171295166015625,\"high\":1819.48000000000001818989403545856475830078125,\"low\":1816.44000000000005456968210637569427490234375,\"close\":1817.920000000000072759576141834259033203125,\"volume\":677168.842499000020325183868408203125},{\"time\":1743850800,\"open\":1817.930000000000063664629124104976654052734375,\"high\":1819.15000000000009094947017729282379150390625,\"low\":1803.509999999999990905052982270717620849609375,\"close\":1809.579999999999927240423858165740966796875,\"volume\":970473.356753999949432909488677978515625},{\"time\":1743851700,\"open\":1809.6199999999998908606357872486114501953125,\"high\":1812.089999999999918145476840436458587646484375,\"low\":1809.220000000000027284841053187847137451171875,\"close\":1810.69000000000005456968210637569427490234375,\"volume\":516162.0220490000210702419281005859375},{\"time\":1743852600,\"open\":1810.839999999999918145476840436458587646484375,\"high\":1811.319999999999936335370875895023345947265625,\"low\":1806.80999999999994543031789362430572509765625,\"close\":1809.2100000000000363797880709171295166015625,\"volume\":270624.3134184500086121261119842529296875},{\"time\":1743853500,\"open\":1809.220000000000027284841053187847137451171875,\"high\":1809.890000000000100044417195022106170654296875,\"low\":1806.80999999999994543031789362430572509765625,\"close\":1807.549999999999954525264911353588104248046875,\"volume\":316817.3938962299725972115993499755859375},{\"time\":1743854400,\"open\":1807.549999999999954525264911353588104248046875,\"high\":1808.279999999999972715158946812152862548828125,\"low\":1806.839999999999918145476840436458587646484375,\"close\":1808.26999999999998181010596454143524169921875,\"volume\":13280.113509000000703963451087474822998046875}]', '2025-04-05 16:04:42', '2025-04-05 16:04:12', '2025-04-05 16:04:12');
INSERT INTO `trading_market_data_cache` (`id`, `key`, `market_type`, `data_type`, `data`, `expires_at`, `created_at`, `updated_at`) VALUES
(177, 'huobi_candles_ETHUSDT_1m_100', 'general', 'json', '[{\"time\":1743848700,\"open\":1817.579999999999927240423858165740966796875,\"high\":1817.779999999999972715158946812152862548828125,\"low\":1817.579999999999927240423858165740966796875,\"close\":1817.779999999999972715158946812152862548828125,\"volume\":189.593833999999986872353474609553813934326171875},{\"time\":1743848760,\"open\":1818.279999999999972715158946812152862548828125,\"high\":1818.279999999999972715158946812152862548828125,\"low\":1818.079999999999927240423858165740966796875,\"close\":1818.079999999999927240423858165740966796875,\"volume\":10663.592883999999685329385101795196533203125},{\"time\":1743848820,\"open\":1818.079999999999927240423858165740966796875,\"high\":1818.079999999999927240423858165740966796875,\"low\":1818.079999999999927240423858165740966796875,\"close\":1818.079999999999927240423858165740966796875,\"volume\":0},{\"time\":1743848880,\"open\":1818.079999999999927240423858165740966796875,\"high\":1818.079999999999927240423858165740966796875,\"low\":1818.079999999999927240423858165740966796875,\"close\":1818.079999999999927240423858165740966796875,\"volume\":0},{\"time\":1743848940,\"open\":1817.84999999999990905052982270717620849609375,\"high\":1818.009999999999990905052982270717620849609375,\"low\":1817.84999999999990905052982270717620849609375,\"close\":1818.009999999999990905052982270717620849609375,\"volume\":1472.21985799999993105302564799785614013671875},{\"time\":1743849000,\"open\":1817.90000000000009094947017729282379150390625,\"high\":1817.90000000000009094947017729282379150390625,\"low\":1817.569999999999936335370875895023345947265625,\"close\":1817.80999999999994543031789362430572509765625,\"volume\":34232.882628999999724328517913818359375},{\"time\":1743849060,\"open\":1817.98000000000001818989403545856475830078125,\"high\":1817.98000000000001818989403545856475830078125,\"low\":1817.98000000000001818989403545856475830078125,\"close\":1817.98000000000001818989403545856475830078125,\"volume\":52.72142000000000194859239854849874973297119140625},{\"time\":1743849120,\"open\":1818.109999999999899955582804977893829345703125,\"high\":1818.109999999999899955582804977893829345703125,\"low\":1817.98000000000001818989403545856475830078125,\"close\":1818.009999999999990905052982270717620849609375,\"volume\":28571.6429250000001047737896442413330078125},{\"time\":1743849180,\"open\":1818.170000000000072759576141834259033203125,\"high\":1818.5,\"low\":1818.170000000000072759576141834259033203125,\"close\":1818.5,\"volume\":1307.647619000000076994183473289012908935546875},{\"time\":1743849240,\"open\":1818.579999999999927240423858165740966796875,\"high\":1818.609999999999899955582804977893829345703125,\"low\":1818.579999999999927240423858165740966796875,\"close\":1818.609999999999899955582804977893829345703125,\"volume\":13603.271220000000539585016667842864990234375},{\"time\":1743849300,\"open\":1818.700000000000045474735088646411895751953125,\"high\":1819.05999999999994543031789362430572509765625,\"low\":1818.700000000000045474735088646411895751953125,\"close\":1819.05999999999994543031789362430572509765625,\"volume\":16446.79244000000107917003333568572998046875},{\"time\":1743849360,\"open\":1819.299999999999954525264911353588104248046875,\"high\":1820.220000000000027284841053187847137451171875,\"low\":1819.299999999999954525264911353588104248046875,\"close\":1819.80999999999994543031789362430572509765625,\"volume\":3157.7742889999999533756636083126068115234375},{\"time\":1743849420,\"open\":1819.410000000000081854523159563541412353515625,\"high\":1819.410000000000081854523159563541412353515625,\"low\":1817.2100000000000363797880709171295166015625,\"close\":1817.40000000000009094947017729282379150390625,\"volume\":8783.259351000000606290996074676513671875},{\"time\":1743849480,\"open\":1817.73000000000001818989403545856475830078125,\"high\":1817.73000000000001818989403545856475830078125,\"low\":1817.73000000000001818989403545856475830078125,\"close\":1817.73000000000001818989403545856475830078125,\"volume\":115.607628000000005386027623899281024932861328125},{\"time\":1743849540,\"open\":1817.759999999999990905052982270717620849609375,\"high\":1817.759999999999990905052982270717620849609375,\"low\":1816.990000000000009094947017729282379150390625,\"close\":1817,\"volume\":74309.06213299999944865703582763671875},{\"time\":1743849600,\"open\":1817.509999999999990905052982270717620849609375,\"high\":1817.509999999999990905052982270717620849609375,\"low\":1817.069999999999936335370875895023345947265625,\"close\":1817.069999999999936335370875895023345947265625,\"volume\":8090.15735700000004726462066173553466796875},{\"time\":1743849660,\"open\":1817.1300000000001091393642127513885498046875,\"high\":1817.19000000000005456968210637569427490234375,\"low\":1816.930000000000063664629124104976654052734375,\"close\":1816.990000000000009094947017729282379150390625,\"volume\":98249.253970000005210749804973602294921875},{\"time\":1743849720,\"open\":1817.23000000000001818989403545856475830078125,\"high\":1817.69000000000005456968210637569427490234375,\"low\":1817.23000000000001818989403545856475830078125,\"close\":1817.69000000000005456968210637569427490234375,\"volume\":40624.7678749999977299012243747711181640625},{\"time\":1743849780,\"open\":1817.5399999999999636202119290828704833984375,\"high\":1817.5399999999999636202119290828704833984375,\"low\":1817.15000000000009094947017729282379150390625,\"close\":1817.15000000000009094947017729282379150390625,\"volume\":1830.433710000000019135768525302410125732421875},{\"time\":1743849840,\"open\":1817.200000000000045474735088646411895751953125,\"high\":1817.609999999999899955582804977893829345703125,\"low\":1817.049999999999954525264911353588104248046875,\"close\":1817.049999999999954525264911353588104248046875,\"volume\":20560.19824000000153318978846073150634765625},{\"time\":1743849900,\"open\":1817.2100000000000363797880709171295166015625,\"high\":1817.2100000000000363797880709171295166015625,\"low\":1817.009999999999990905052982270717620849609375,\"close\":1817.009999999999990905052982270717620849609375,\"volume\":43463.2954959999988204799592494964599609375},{\"time\":1743849960,\"open\":1817.069999999999936335370875895023345947265625,\"high\":1817.25,\"low\":1816.6199999999998908606357872486114501953125,\"close\":1816.6199999999998908606357872486114501953125,\"volume\":3840.54365300000017668935470283031463623046875},{\"time\":1743850020,\"open\":1816.640000000000100044417195022106170654296875,\"high\":1816.640000000000100044417195022106170654296875,\"low\":1816.44000000000005456968210637569427490234375,\"close\":1816.549999999999954525264911353588104248046875,\"volume\":354891.9150800000061281025409698486328125},{\"time\":1743850080,\"open\":1816.670000000000072759576141834259033203125,\"high\":1818.759999999999990905052982270717620849609375,\"low\":1816.670000000000072759576141834259033203125,\"close\":1818.759999999999990905052982270717620849609375,\"volume\":228273.7008550000027753412723541259765625},{\"time\":1743850140,\"open\":1818.079999999999927240423858165740966796875,\"high\":1818.1199999999998908606357872486114501953125,\"low\":1817.990000000000009094947017729282379150390625,\"close\":1818.1199999999998908606357872486114501953125,\"volume\":424.70332400000000916406861506402492523193359375},{\"time\":1743850200,\"open\":1818.859999999999899955582804977893829345703125,\"high\":1818.859999999999899955582804977893829345703125,\"low\":1818.3800000000001091393642127513885498046875,\"close\":1818.6199999999998908606357872486114501953125,\"volume\":182.576368000000002211891114711761474609375},{\"time\":1743850260,\"open\":1818.839999999999918145476840436458587646484375,\"high\":1819.089999999999918145476840436458587646484375,\"low\":1818.839999999999918145476840436458587646484375,\"close\":1819.089999999999918145476840436458587646484375,\"volume\":107.3125600000000048339643399231135845184326171875},{\"time\":1743850320,\"open\":1819.339999999999918145476840436458587646484375,\"high\":1819.339999999999918145476840436458587646484375,\"low\":1819.339999999999918145476840436458587646484375,\"close\":1819.339999999999918145476840436458587646484375,\"volume\":199.9454660000000103536876849830150604248046875},{\"time\":1743850380,\"open\":1819.34999999999990905052982270717620849609375,\"high\":1819.48000000000001818989403545856475830078125,\"low\":1819.34999999999990905052982270717620849609375,\"close\":1819.48000000000001818989403545856475830078125,\"volume\":178.886520999999987679984769783914089202880859375},{\"time\":1743850440,\"open\":1819.48000000000001818989403545856475830078125,\"high\":1819.48000000000001818989403545856475830078125,\"low\":1819.48000000000001818989403545856475830078125,\"close\":1819.48000000000001818989403545856475830078125,\"volume\":0},{\"time\":1743850500,\"open\":1819.0399999999999636202119290828704833984375,\"high\":1819.23000000000001818989403545856475830078125,\"low\":1819.0399999999999636202119290828704833984375,\"close\":1819.23000000000001818989403545856475830078125,\"volume\":516.5112159999999903448042459785938262939453125},{\"time\":1743850560,\"open\":1818.450000000000045474735088646411895751953125,\"high\":1818.450000000000045474735088646411895751953125,\"low\":1817.98000000000001818989403545856475830078125,\"close\":1818.44000000000005456968210637569427490234375,\"volume\":40375.7887039999986882321536540985107421875},{\"time\":1743850620,\"open\":1818.109999999999899955582804977893829345703125,\"high\":1818.109999999999899955582804977893829345703125,\"low\":1818.109999999999899955582804977893829345703125,\"close\":1818.109999999999899955582804977893829345703125,\"volume\":20.1810210000000012087184586562216281890869140625},{\"time\":1743850680,\"open\":1817.84999999999990905052982270717620849609375,\"high\":1817.84999999999990905052982270717620849609375,\"low\":1817.84999999999990905052982270717620849609375,\"close\":1817.84999999999990905052982270717620849609375,\"volume\":58.716554999999999608917278237640857696533203125},{\"time\":1743850740,\"open\":1817.740000000000009094947017729282379150390625,\"high\":1817.920000000000072759576141834259033203125,\"low\":1817.740000000000009094947017729282379150390625,\"close\":1817.920000000000072759576141834259033203125,\"volume\":4634.76568000000042957253754138946533203125},{\"time\":1743850800,\"open\":1817.930000000000063664629124104976654052734375,\"high\":1817.930000000000063664629124104976654052734375,\"low\":1817.8800000000001091393642127513885498046875,\"close\":1817.8800000000001091393642127513885498046875,\"volume\":331.4061490000000276268110610544681549072265625},{\"time\":1743850860,\"open\":1818.029999999999972715158946812152862548828125,\"high\":1818.029999999999972715158946812152862548828125,\"low\":1818.029999999999972715158946812152862548828125,\"close\":1818.029999999999972715158946812152862548828125,\"volume\":106.9001640000000037389327189885079860687255859375},{\"time\":1743850920,\"open\":1818.029999999999972715158946812152862548828125,\"high\":1818.029999999999972715158946812152862548828125,\"low\":1818.029999999999972715158946812152862548828125,\"close\":1818.029999999999972715158946812152862548828125,\"volume\":0},{\"time\":1743850980,\"open\":1818.55999999999994543031789362430572509765625,\"high\":1819.15000000000009094947017729282379150390625,\"low\":1818.55999999999994543031789362430572509765625,\"close\":1819.0399999999999636202119290828704833984375,\"volume\":889.6452030000000377185642719268798828125},{\"time\":1743851040,\"open\":1818.779999999999972715158946812152862548828125,\"high\":1818.779999999999972715158946812152862548828125,\"low\":1818.410000000000081854523159563541412353515625,\"close\":1818.420000000000072759576141834259033203125,\"volume\":8178.0857960000003004097379744052886962890625},{\"time\":1743851100,\"open\":1817.470000000000027284841053187847137451171875,\"high\":1817.470000000000027284841053187847137451171875,\"low\":1815.720000000000027284841053187847137451171875,\"close\":1815.839999999999918145476840436458587646484375,\"volume\":102009.949288000003434717655181884765625},{\"time\":1743851160,\"open\":1815.720000000000027284841053187847137451171875,\"high\":1815.720000000000027284841053187847137451171875,\"low\":1814.890000000000100044417195022106170654296875,\"close\":1814.890000000000100044417195022106170654296875,\"volume\":6987.251884999999674619175493717193603515625},{\"time\":1743851220,\"open\":1814.80999999999994543031789362430572509765625,\"high\":1814.890000000000100044417195022106170654296875,\"low\":1814.640000000000100044417195022106170654296875,\"close\":1814.640000000000100044417195022106170654296875,\"volume\":27913.15989700000136508606374263763427734375},{\"time\":1743851280,\"open\":1814.640000000000100044417195022106170654296875,\"high\":1814.640000000000100044417195022106170654296875,\"low\":1814.640000000000100044417195022106170654296875,\"close\":1814.640000000000100044417195022106170654296875,\"volume\":0},{\"time\":1743851340,\"open\":1815.0399999999999636202119290828704833984375,\"high\":1815.470000000000027284841053187847137451171875,\"low\":1814.890000000000100044417195022106170654296875,\"close\":1815.470000000000027284841053187847137451171875,\"volume\":5717.054842999999891617335379123687744140625},{\"time\":1743851400,\"open\":1815.339999999999918145476840436458587646484375,\"high\":1815.339999999999918145476840436458587646484375,\"low\":1814.80999999999994543031789362430572509765625,\"close\":1814.80999999999994543031789362430572509765625,\"volume\":259.887257999999974344973452389240264892578125},{\"time\":1743851460,\"open\":1815.140000000000100044417195022106170654296875,\"high\":1815.140000000000100044417195022106170654296875,\"low\":1815.140000000000100044417195022106170654296875,\"close\":1815.140000000000100044417195022106170654296875,\"volume\":91.483056000000004814864951185882091522216796875},{\"time\":1743851520,\"open\":1814.779999999999972715158946812152862548828125,\"high\":1814.779999999999972715158946812152862548828125,\"low\":1814.779999999999972715158946812152862548828125,\"close\":1814.779999999999972715158946812152862548828125,\"volume\":911.3825160000000096260919235646724700927734375},{\"time\":1743851580,\"open\":1814.40000000000009094947017729282379150390625,\"high\":1814.40000000000009094947017729282379150390625,\"low\":1811.15000000000009094947017729282379150390625,\"close\":1811.8699999999998908606357872486114501953125,\"volume\":138760.78249899999354965984821319580078125},{\"time\":1743851640,\"open\":1812.089999999999918145476840436458587646484375,\"high\":1812.089999999999918145476840436458587646484375,\"low\":1803.509999999999990905052982270717620849609375,\"close\":1809.579999999999927240423858165740966796875,\"volume\":678316.368200000026263296604156494140625},{\"time\":1743851700,\"open\":1809.6199999999998908606357872486114501953125,\"high\":1810.859999999999899955582804977893829345703125,\"low\":1809.6199999999998908606357872486114501953125,\"close\":1810.859999999999899955582804977893829345703125,\"volume\":14357.7029770000008284114301204681396484375},{\"time\":1743851760,\"open\":1810.240000000000009094947017729282379150390625,\"high\":1810.76999999999998181010596454143524169921875,\"low\":1809.220000000000027284841053187847137451171875,\"close\":1810.76999999999998181010596454143524169921875,\"volume\":61922.9276420000023790635168552398681640625},{\"time\":1743851820,\"open\":1811.109999999999899955582804977893829345703125,\"high\":1811.180000000000063664629124104976654052734375,\"low\":1811.069999999999936335370875895023345947265625,\"close\":1811.180000000000063664629124104976654052734375,\"volume\":77022.7160060000023804605007171630859375},{\"time\":1743851880,\"open\":1811.319999999999936335370875895023345947265625,\"high\":1812.089999999999918145476840436458587646484375,\"low\":1811.319999999999936335370875895023345947265625,\"close\":1812.089999999999918145476840436458587646484375,\"volume\":1138.46993599999996149563230574131011962890625},{\"time\":1743851940,\"open\":1812.089999999999918145476840436458587646484375,\"high\":1812.089999999999918145476840436458587646484375,\"low\":1812.089999999999918145476840436458587646484375,\"close\":1812.089999999999918145476840436458587646484375,\"volume\":0},{\"time\":1743852000,\"open\":1811.950000000000045474735088646411895751953125,\"high\":1811.950000000000045474735088646411895751953125,\"low\":1810.549999999999954525264911353588104248046875,\"close\":1811.220000000000027284841053187847137451171875,\"volume\":28268.81990700000096694566309452056884765625},{\"time\":1743852060,\"open\":1811.549999999999954525264911353588104248046875,\"high\":1811.720000000000027284841053187847137451171875,\"low\":1811.549999999999954525264911353588104248046875,\"close\":1811.720000000000027284841053187847137451171875,\"volume\":37648.446932999999262392520904541015625},{\"time\":1743852120,\"open\":1811.3800000000001091393642127513885498046875,\"high\":1811.3800000000001091393642127513885498046875,\"low\":1810.079999999999927240423858165740966796875,\"close\":1810.079999999999927240423858165740966796875,\"volume\":138717.2200859999866224825382232666015625},{\"time\":1743852180,\"open\":1810.140000000000100044417195022106170654296875,\"high\":1810.670000000000072759576141834259033203125,\"low\":1810.140000000000100044417195022106170654296875,\"close\":1810.40000000000009094947017729282379150390625,\"volume\":124170.46643000000040046870708465576171875},{\"time\":1743852240,\"open\":1811.180000000000063664629124104976654052734375,\"high\":1811.390000000000100044417195022106170654296875,\"low\":1811.180000000000063664629124104976654052734375,\"close\":1811.319999999999936335370875895023345947265625,\"volume\":758.2382499999999936335370875895023345947265625},{\"time\":1743852300,\"open\":1811.9600000000000363797880709171295166015625,\"high\":1811.9600000000000363797880709171295166015625,\"low\":1811.9600000000000363797880709171295166015625,\"close\":1811.9600000000000363797880709171295166015625,\"volume\":79.9074360000000041281964513473212718963623046875},{\"time\":1743852360,\"open\":1812.089999999999918145476840436458587646484375,\"high\":1812.089999999999918145476840436458587646484375,\"low\":1812.089999999999918145476840436458587646484375,\"close\":1812.089999999999918145476840436458587646484375,\"volume\":875.0582610000000158834154717624187469482421875},{\"time\":1743852420,\"open\":1811.65000000000009094947017729282379150390625,\"high\":1811.65000000000009094947017729282379150390625,\"low\":1811.2100000000000363797880709171295166015625,\"close\":1811.3699999999998908606357872486114501953125,\"volume\":1364.755175000000008367351256310939788818359375},{\"time\":1743852480,\"open\":1811.259999999999990905052982270717620849609375,\"high\":1811.259999999999990905052982270717620849609375,\"low\":1810.420000000000072759576141834259033203125,\"close\":1810.420000000000072759576141834259033203125,\"volume\":24555.46796700000049895606935024261474609375},{\"time\":1743852540,\"open\":1810.240000000000009094947017729282379150390625,\"high\":1810.69000000000005456968210637569427490234375,\"low\":1810.240000000000009094947017729282379150390625,\"close\":1810.69000000000005456968210637569427490234375,\"volume\":5281.8250429999998232233338057994842529296875},{\"time\":1743852600,\"open\":1810.839999999999918145476840436458587646484375,\"high\":1810.839999999999918145476840436458587646484375,\"low\":1810.829999999999927240423858165740966796875,\"close\":1810.829999999999927240423858165740966796875,\"volume\":32.37712744999999614492480759508907794952392578125},{\"time\":1743852660,\"open\":1810.55999999999994543031789362430572509765625,\"high\":1810.55999999999994543031789362430572509765625,\"low\":1809.950000000000045474735088646411895751953125,\"close\":1810.2100000000000363797880709171295166015625,\"volume\":21828.98678799999834154732525348663330078125},{\"time\":1743852720,\"open\":1810.98000000000001818989403545856475830078125,\"high\":1811.319999999999936335370875895023345947265625,\"low\":1810.98000000000001818989403545856475830078125,\"close\":1811.319999999999936335370875895023345947265625,\"volume\":3272.99315100000012535019777715206146240234375},{\"time\":1743852780,\"open\":1810.7899999999999636202119290828704833984375,\"high\":1810.7899999999999636202119290828704833984375,\"low\":1807.920000000000072759576141834259033203125,\"close\":1808.0399999999999636202119290828704833984375,\"volume\":56902.504442999997991137206554412841796875},{\"time\":1743852840,\"open\":1808.819999999999936335370875895023345947265625,\"high\":1808.819999999999936335370875895023345947265625,\"low\":1807.7100000000000363797880709171295166015625,\"close\":1808.089999999999918145476840436458587646484375,\"volume\":16427.8526910000000498257577419281005859375},{\"time\":1743852900,\"open\":1808.089999999999918145476840436458587646484375,\"high\":1808.089999999999918145476840436458587646484375,\"low\":1807.55999999999994543031789362430572509765625,\"close\":1807.55999999999994543031789362430572509765625,\"volume\":11761.23608099999910336919128894805908203125},{\"time\":1743852960,\"open\":1807.720000000000027284841053187847137451171875,\"high\":1808.140000000000100044417195022106170654296875,\"low\":1807.3699999999998908606357872486114501953125,\"close\":1807.44000000000005456968210637569427490234375,\"volume\":36402.7833129999999073334038257598876953125},{\"time\":1743853020,\"open\":1806.90000000000009094947017729282379150390625,\"high\":1806.90000000000009094947017729282379150390625,\"low\":1806.90000000000009094947017729282379150390625,\"close\":1806.90000000000009094947017729282379150390625,\"volume\":16.387100000000000221689333557151257991790771484375},{\"time\":1743853080,\"open\":1806.80999999999994543031789362430572509765625,\"high\":1807.69000000000005456968210637569427490234375,\"low\":1806.80999999999994543031789362430572509765625,\"close\":1807.69000000000005456968210637569427490234375,\"volume\":25067.00788000000102329067885875701904296875},{\"time\":1743853140,\"open\":1807.69000000000005456968210637569427490234375,\"high\":1807.69000000000005456968210637569427490234375,\"low\":1807.69000000000005456968210637569427490234375,\"close\":1807.69000000000005456968210637569427490234375,\"volume\":0},{\"time\":1743853200,\"open\":1807.990000000000009094947017729282379150390625,\"high\":1807.990000000000009094947017729282379150390625,\"low\":1807.990000000000009094947017729282379150390625,\"close\":1807.990000000000009094947017729282379150390625,\"volume\":692.4601699999999482315615750849246978759765625},{\"time\":1743853260,\"open\":1808.1199999999998908606357872486114501953125,\"high\":1808.1199999999998908606357872486114501953125,\"low\":1808.029999999999972715158946812152862548828125,\"close\":1808.029999999999972715158946812152862548828125,\"volume\":1857.61228600000004007597453892230987548828125},{\"time\":1743853320,\"open\":1808.25,\"high\":1808.25,\"low\":1808.25,\"close\":1808.25,\"volume\":8181.7887749999999869032762944698333740234375},{\"time\":1743853380,\"open\":1808.25,\"high\":1808.819999999999936335370875895023345947265625,\"low\":1808.25,\"close\":1808.680000000000063664629124104976654052734375,\"volume\":88051.538480999995954334735870361328125},{\"time\":1743853440,\"open\":1808.720000000000027284841053187847137451171875,\"high\":1809.2100000000000363797880709171295166015625,\"low\":1808.720000000000027284841053187847137451171875,\"close\":1809.2100000000000363797880709171295166015625,\"volume\":128.785132000000004381945473141968250274658203125},{\"time\":1743853500,\"open\":1809.220000000000027284841053187847137451171875,\"high\":1809.220000000000027284841053187847137451171875,\"low\":1809.200000000000045474735088646411895751953125,\"close\":1809.2100000000000363797880709171295166015625,\"volume\":14913.433215999999447376467287540435791015625},{\"time\":1743853560,\"open\":1809.329999999999927240423858165740966796875,\"high\":1809.670000000000072759576141834259033203125,\"low\":1809.329999999999927240423858165740966796875,\"close\":1809.670000000000072759576141834259033203125,\"volume\":634.752981999999974505044519901275634765625},{\"time\":1743853620,\"open\":1809.670000000000072759576141834259033203125,\"high\":1809.670000000000072759576141834259033203125,\"low\":1809.670000000000072759576141834259033203125,\"close\":1809.670000000000072759576141834259033203125,\"volume\":0},{\"time\":1743853680,\"open\":1809.890000000000100044417195022106170654296875,\"high\":1809.890000000000100044417195022106170654296875,\"low\":1809.890000000000100044417195022106170654296875,\"close\":1809.890000000000100044417195022106170654296875,\"volume\":94.83823599999999487408786080777645111083984375},{\"time\":1743853740,\"open\":1809.26999999999998181010596454143524169921875,\"high\":1809.26999999999998181010596454143524169921875,\"low\":1809.26999999999998181010596454143524169921875,\"close\":1809.26999999999998181010596454143524169921875,\"volume\":731.4878609999999525825842283666133880615234375},{\"time\":1743853800,\"open\":1809.170000000000072759576141834259033203125,\"high\":1809.170000000000072759576141834259033203125,\"low\":1808.420000000000072759576141834259033203125,\"close\":1808.450000000000045474735088646411895751953125,\"volume\":117112.672367389997816644608974456787109375},{\"time\":1743853860,\"open\":1808.529999999999972715158946812152862548828125,\"high\":1808.6300000000001091393642127513885498046875,\"low\":1808.470000000000027284841053187847137451171875,\"close\":1808.470000000000027284841053187847137451171875,\"volume\":1079.345004999999900974216870963573455810546875},{\"time\":1743853920,\"open\":1808.34999999999990905052982270717620849609375,\"high\":1808.549999999999954525264911353588104248046875,\"low\":1808.009999999999990905052982270717620849609375,\"close\":1808.009999999999990905052982270717620849609375,\"volume\":6998.245533999999679508619010448455810546875},{\"time\":1743853980,\"open\":1808.009999999999990905052982270717620849609375,\"high\":1808.30999999999994543031789362430572509765625,\"low\":1806.890000000000100044417195022106170654296875,\"close\":1806.890000000000100044417195022106170654296875,\"volume\":99706.943568999995477497577667236328125},{\"time\":1743854040,\"open\":1806.80999999999994543031789362430572509765625,\"high\":1807.470000000000027284841053187847137451171875,\"low\":1806.80999999999994543031789362430572509765625,\"close\":1807.470000000000027284841053187847137451171875,\"volume\":4456.9777679999997417326085269451141357421875},{\"time\":1743854100,\"open\":1807.569999999999936335370875895023345947265625,\"high\":1808.259999999999990905052982270717620849609375,\"low\":1807.569999999999936335370875895023345947265625,\"close\":1808.259999999999990905052982270717620849609375,\"volume\":1066.473590999999942141585052013397216796875},{\"time\":1743854160,\"open\":1807.75,\"high\":1807.75,\"low\":1807.4600000000000363797880709171295166015625,\"close\":1807.549999999999954525264911353588104248046875,\"volume\":26277.4887200000011944212019443511962890625},{\"time\":1743854220,\"open\":1807.55999999999994543031789362430572509765625,\"high\":1807.819999999999936335370875895023345947265625,\"low\":1807.069999999999936335370875895023345947265625,\"close\":1807.80999999999994543031789362430572509765625,\"volume\":41203.4059550000019953586161136627197265625},{\"time\":1743854280,\"open\":1807.720000000000027284841053187847137451171875,\"high\":1807.720000000000027284841053187847137451171875,\"low\":1807.3699999999998908606357872486114501953125,\"close\":1807.3699999999998908606357872486114501953125,\"volume\":1439.6567230000000563450157642364501953125},{\"time\":1743854340,\"open\":1807.55999999999994543031789362430572509765625,\"high\":1807.740000000000009094947017729282379150390625,\"low\":1807.549999999999954525264911353588104248046875,\"close\":1807.549999999999954525264911353588104248046875,\"volume\":1101.672368839999990086653269827365875244140625},{\"time\":1743854400,\"open\":1807.549999999999954525264911353588104248046875,\"high\":1807.549999999999954525264911353588104248046875,\"low\":1807.1300000000001091393642127513885498046875,\"close\":1807.19000000000005456968210637569427490234375,\"volume\":4873.4693799999995462712831795215606689453125},{\"time\":1743854460,\"open\":1807.2899999999999636202119290828704833984375,\"high\":1807.2899999999999636202119290828704833984375,\"low\":1807.0399999999999636202119290828704833984375,\"close\":1807.25,\"volume\":6526.1173189999999522115103900432586669921875},{\"time\":1743854520,\"open\":1807.339999999999918145476840436458587646484375,\"high\":1807.339999999999918145476840436458587646484375,\"low\":1806.839999999999918145476840436458587646484375,\"close\":1806.839999999999918145476840436458587646484375,\"volume\":244.34196800000000848740455694496631622314453125},{\"time\":1743854580,\"open\":1807.920000000000072759576141834259033203125,\"high\":1808.279999999999972715158946812152862548828125,\"low\":1807.920000000000072759576141834259033203125,\"close\":1808.279999999999972715158946812152862548828125,\"volume\":1583.745012000000087937223725020885467529296875},{\"time\":1743854640,\"open\":1808.26999999999998181010596454143524169921875,\"high\":1808.26999999999998181010596454143524169921875,\"low\":1808.26999999999998181010596454143524169921875,\"close\":1808.26999999999998181010596454143524169921875,\"volume\":52.439830000000000609361450187861919403076171875}]', '2025-04-05 16:04:49', '2025-04-05 16:04:19', '2025-04-05 16:04:19'),
(178, 'huobi_ticker_SOLUSDT', 'general', 'json', '{\"symbol\":\"SOLUSDT\",\"lastPrice\":143.9523,\"priceChange\":7.396500000000003,\"priceChangePercent\":5.42,\"highPrice\":147.5974,\"lowPrice\":134.6954,\"volume\":24834306.5344179,\"quoteVolume\":175342.9829422718,\"openPrice\":136.5558,\"source\":\"huobi\"}', '2025-04-22 19:35:57', '2025-04-22 19:34:57', '2025-04-22 19:34:57'),
(179, 'twelvedata_quote_AAPL', 'general', 'json', '{\"symbol\":\"AAPL\",\"name\":\"Apple Inc.\",\"exchange\":\"NASDAQ\",\"price\":248.45,\"open\":247.37,\"high\":249.4,\"low\":244.69,\"previous_close\":248.35001,\"change\":0.099993896,\"percent_change\":0.040263295,\"volume\":3329391,\"timestamp\":1769178600,\"source\":\"twelvedata\"}', '2026-01-23 19:46:12', '2026-01-21 11:36:26', '2026-01-23 19:45:12'),
(180, 'twelvedata_quote_MSFT', 'general', 'json', '{\"symbol\":\"MSFT\",\"name\":\"Microsoft Corp.\",\"exchange\":\"NASDAQ\",\"price\":468.54,\"open\":451.86,\"high\":471.075,\"low\":450.62,\"previous_close\":451.14001,\"change\":17.39999,\"percent_change\":3.85689,\"volume\":2656266,\"timestamp\":1769178600,\"source\":\"twelvedata\"}', '2026-01-23 19:48:00', '2026-01-21 11:36:44', '2026-01-23 19:47:00'),
(181, 'twelvedata_quote_GOOGL', 'general', 'json', '{\"symbol\":\"GOOGL\",\"name\":\"Alphabet Inc.\",\"exchange\":\"NASDAQ\",\"price\":327.99,\"open\":332.485,\"high\":333.63,\"low\":327.5,\"previous_close\":330.54001,\"change\":-2.55001,\"percent_change\":-0.77146744,\"volume\":2506188,\"timestamp\":1769178600,\"source\":\"twelvedata\"}', '2026-01-23 19:46:37', '2026-01-21 11:37:02', '2026-01-23 19:45:37'),
(182, 'twelvedata_quote_AMZN', 'general', 'json', '{\"symbol\":\"AMZN\",\"name\":\"Amazon.com Inc.\",\"exchange\":\"NASDAQ\",\"price\":239.19,\"open\":234.92,\"high\":240.435,\"low\":234.62,\"previous_close\":234.34,\"change\":4.85,\"percent_change\":2.069644,\"volume\":3734787,\"timestamp\":1769178600,\"source\":\"twelvedata\"}', '2026-01-23 19:46:20', '2026-01-21 11:37:20', '2026-01-23 19:45:20'),
(183, 'twelvedata_quote_NVDA', 'general', 'json', '{\"symbol\":\"NVDA\",\"name\":\"NVIDIA Corp\",\"exchange\":\"NASDAQ\",\"price\":178.070007,\"open\":181.89999,\"high\":182.38,\"low\":177.61,\"previous_close\":186.23,\"change\":-8.15999,\"percent_change\":-4.38167,\"volume\":222563700,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:38:38', '2026-01-21 11:37:38', '2026-01-21 11:37:38'),
(184, 'twelvedata_logo_META', 'general', 'json', '\"https:\\/\\/logo.twelvedata.com\\/symbols\\/fb-meta.jpg\"', '2026-01-28 11:37:57', '2026-01-21 11:37:57', '2026-01-21 11:37:57'),
(185, 'twelvedata_quote_META', 'general', 'json', '{\"symbol\":\"META\",\"name\":\"Meta Platforms, Inc. Class A Common Stock\",\"exchange\":\"NASDAQ\",\"price\":604.12,\"open\":607.88,\"high\":611.40002,\"low\":600,\"previous_close\":620.25,\"change\":-16.13,\"percent_change\":-2.60057,\"volume\":15130500,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":\"https:\\/\\/logo.twelvedata.com\\/symbols\\/fb-meta.jpg\"}', '2026-01-21 11:38:57', '2026-01-21 11:37:57', '2026-01-21 11:37:57'),
(186, 'twelvedata_quote_BRK.B', 'general', 'json', '{\"symbol\":\"BRK.B\",\"name\":\"Berkshire Hathaway Inc.\",\"exchange\":\"NYSE\",\"price\":485.39001,\"open\":490.79999,\"high\":490.97,\"low\":482.72,\"previous_close\":493.29001,\"change\":-7.89999,\"percent_change\":-1.60149,\"volume\":5509400,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:39:15', '2026-01-21 11:38:15', '2026-01-21 11:38:15'),
(187, 'twelvedata_quote_TSLA', 'general', 'json', '{\"symbol\":\"TSLA\",\"name\":\"Tesla Inc.\",\"exchange\":\"NASDAQ\",\"price\":447.65,\"open\":447.33,\"high\":452.43,\"low\":444.13,\"previous_close\":449.35999,\"change\":-1.70999,\"percent_change\":-0.38053797,\"volume\":1915725,\"timestamp\":1769178600,\"source\":\"twelvedata\"}', '2026-01-23 19:48:08', '2026-01-21 11:38:32', '2026-01-23 19:47:08'),
(188, 'twelvedata_quote_UNH', 'general', 'json', '{\"symbol\":\"UNH\",\"name\":\"UnitedHealth Group Incorporated\",\"exchange\":\"NYSE\",\"price\":338.42999,\"open\":327.39999,\"high\":339.89001,\"low\":326.5,\"previous_close\":331.019989,\"change\":7.41,\"percent_change\":2.23854,\"volume\":7589100,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:39:50', '2026-01-21 11:38:50', '2026-01-21 11:38:50'),
(189, 'twelvedata_quote_JNJ', 'general', 'json', '{\"symbol\":\"JNJ\",\"name\":\"Johnson & Johnson\",\"exchange\":\"NYSE\",\"price\":218.21001,\"open\":217.089996,\"high\":218.73,\"low\":214.5,\"previous_close\":218.66,\"change\":-0.44999695,\"percent_change\":-0.20579756,\"volume\":14052500,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:40:08', '2026-01-21 11:39:08', '2026-01-21 11:39:08'),
(190, 'twelvedata_quote_V', 'general', 'json', '{\"symbol\":\"V\",\"name\":\"Visa Inc\",\"exchange\":\"NYSE\",\"price\":325.82001,\"open\":322.23001,\"high\":328.32001,\"low\":321.56,\"previous_close\":328.29999,\"change\":-2.47998,\"percent_change\":-0.75540072,\"volume\":8274700,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:40:26', '2026-01-21 11:39:26', '2026-01-21 11:39:26'),
(191, 'twelvedata_quote_WMT', 'general', 'json', '{\"symbol\":\"WMT\",\"name\":\"Walmart Inc.\",\"exchange\":\"NYSE\",\"price\":118.71,\"open\":120.89,\"high\":121.62,\"low\":117.61,\"previous_close\":119.7,\"change\":-0.98999786,\"percent_change\":-0.82706591,\"volume\":45314700,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:40:43', '2026-01-21 11:39:43', '2026-01-21 11:39:43'),
(192, 'twelvedata_quote_XOM', 'general', 'json', '{\"symbol\":\"XOM\",\"name\":\"Exxon Mobil Corporation\",\"exchange\":\"NYSE\",\"price\":133.635,\"open\":133.17,\"high\":134.18,\"low\":131.87,\"previous_close\":133.61,\"change\":0.02499939,\"percent_change\":0.018710717,\"volume\":1701842,\"timestamp\":1769092200,\"source\":\"twelvedata\"}', '2026-01-22 19:34:32', '2026-01-21 11:40:01', '2026-01-22 19:33:32'),
(193, 'twelvedata_quote_JPM', 'general', 'json', '{\"symbol\":\"JPM\",\"name\":\"JPMorgan Chase & Co.\",\"exchange\":\"NYSE\",\"price\":297.76,\"open\":302,\"high\":302.21,\"low\":296.56,\"previous_close\":303.63,\"change\":-5.87,\"percent_change\":-1.93328,\"volume\":869103,\"timestamp\":1769178600,\"source\":\"twelvedata\"}', '2026-01-23 19:46:48', '2026-01-21 11:40:19', '2026-01-23 19:45:48'),
(194, 'twelvedata_quote_PG', 'general', 'json', '{\"symbol\":\"PG\",\"name\":\"The Procter & Gamble Company\",\"exchange\":\"NYSE\",\"price\":147,\"open\":144.46001,\"high\":147,\"low\":144.12,\"previous_close\":144.53,\"change\":2.47,\"percent_change\":1.70899,\"volume\":12892500,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:41:38', '2026-01-21 11:40:38', '2026-01-21 11:40:38'),
(195, 'twelvedata_quote_MA', 'general', 'json', '{\"symbol\":\"MA\",\"name\":\"Mastercard Inc.\",\"exchange\":\"NYSE\",\"price\":523.35,\"open\":531.42,\"high\":532.04,\"low\":520.17,\"previous_close\":532.85999,\"change\":-9.50999,\"percent_change\":-1.78471,\"volume\":597492,\"timestamp\":1769178600,\"source\":\"twelvedata\"}', '2026-01-23 19:47:25', '2026-01-21 11:40:55', '2026-01-23 19:46:25'),
(196, 'twelvedata_quote_LLY', 'general', 'json', '{\"symbol\":\"LLY\",\"name\":\"Eli Lilly and Company\",\"exchange\":\"NYSE\",\"price\":1041.29004,\"open\":1028.15002,\"high\":1045.84998,\"low\":1015.96002,\"previous_close\":1038.40002,\"change\":2.89001,\"percent_change\":0.27831419,\"volume\":2483400,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:42:13', '2026-01-21 11:41:13', '2026-01-21 11:41:13'),
(197, 'twelvedata_quote_AVGO', 'general', 'json', '{\"symbol\":\"AVGO\",\"name\":\"Broadcom Inc.\",\"exchange\":\"NASDAQ\",\"price\":332.60001,\"open\":344.10001,\"high\":345.39999,\"low\":331.79999,\"previous_close\":351.70999,\"change\":-19.10999,\"percent_change\":-5.43345,\"volume\":32211800,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:42:31', '2026-01-21 11:41:31', '2026-01-21 11:41:31'),
(198, 'twelvedata_quote_HD', 'general', 'json', '{\"symbol\":\"HD\",\"name\":\"Home Depot Inc.\",\"exchange\":\"NYSE\",\"price\":375.10999,\"open\":372.23999,\"high\":377.34,\"low\":371.29999,\"previous_close\":380.17001,\"change\":-5.060028,\"percent_change\":-1.33099,\"volume\":5350900,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:42:50', '2026-01-21 11:41:50', '2026-01-21 11:41:50'),
(199, 'twelvedata_quote_CVX', 'general', 'json', '{\"symbol\":\"CVX\",\"name\":\"Chevron Corporation\",\"exchange\":\"NYSE\",\"price\":165.3,\"open\":166.71001,\"high\":167.64999,\"low\":165.14999,\"previous_close\":166.25999,\"change\":-0.95999146,\"percent_change\":-0.57740376,\"volume\":11131400,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:43:09', '2026-01-21 11:42:09', '2026-01-21 11:42:09'),
(200, 'twelvedata_quote_MRK', 'general', 'json', '{\"symbol\":\"MRK\",\"name\":\"Merck & Co., Inc.\",\"exchange\":\"NYSE\",\"price\":109.45,\"open\":108.11,\"high\":109.64,\"low\":106.93,\"previous_close\":108.83,\"change\":0.61999512,\"percent_change\":0.56969136,\"volume\":15233000,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:43:27', '2026-01-21 11:42:27', '2026-01-21 11:42:27'),
(201, 'twelvedata_quote_KO', 'general', 'json', '{\"symbol\":\"KO\",\"name\":\"The Coca-Cola Company\",\"exchange\":\"NYSE\",\"price\":71.75,\"open\":70,\"high\":71.78,\"low\":69.79,\"previous_close\":70.44,\"change\":1.31,\"percent_change\":1.85974,\"volume\":22139600,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:43:44', '2026-01-21 11:42:44', '2026-01-21 11:42:44'),
(202, 'twelvedata_quote_ABBV', 'general', 'json', '{\"symbol\":\"ABBV\",\"name\":\"AbbVie Inc.\",\"exchange\":\"NYSE\",\"price\":217.63,\"open\":216.04,\"high\":219,\"low\":214.76,\"previous_close\":216.14999,\"change\":1.48001,\"percent_change\":0.68471254,\"volume\":644304,\"timestamp\":1769092200,\"source\":\"twelvedata\"}', '2026-01-22 19:32:55', '2026-01-21 11:43:02', '2026-01-22 19:31:55'),
(203, 'twelvedata_quote_PEP', 'general', 'json', '{\"symbol\":\"PEP\",\"name\":\"PepsiCo, Inc.\",\"exchange\":\"NASDAQ\",\"price\":147.66,\"open\":146.22,\"high\":147.66,\"low\":144.32001,\"previous_close\":146.32001,\"change\":1.34,\"percent_change\":0.91579844,\"volume\":9979400,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:44:19', '2026-01-21 11:43:19', '2026-01-21 11:43:19'),
(204, 'twelvedata_quote_COST', 'general', 'json', '{\"symbol\":\"COST\",\"name\":\"Costco Wholesale Corporation\",\"exchange\":\"NASDAQ\",\"price\":964.26001,\"open\":958.38,\"high\":969.90002,\"low\":954.13,\"previous_close\":963.60999,\"change\":0.65002441,\"percent_change\":0.06745721,\"volume\":3206400,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:44:37', '2026-01-21 11:43:37', '2026-01-21 11:43:37'),
(205, 'twelvedata_quote_ADBE', 'general', 'json', '{\"symbol\":\"ADBE\",\"name\":\"Adobe Inc.\",\"exchange\":\"NASDAQ\",\"price\":299.36,\"open\":295.78,\"high\":301.73,\"low\":295.29,\"previous_close\":294.23001,\"change\":5.12999,\"percent_change\":1.74353,\"volume\":268098,\"timestamp\":1769092200,\"source\":\"twelvedata\"}', '2026-01-22 19:33:15', '2026-01-21 11:43:55', '2026-01-22 19:32:15'),
(206, 'twelvedata_quote_MCD', 'general', 'json', '{\"symbol\":\"MCD\",\"name\":\"McDonald\'s Corporation\",\"exchange\":\"NYSE\",\"price\":302.84,\"open\":306.44,\"high\":306.54999,\"low\":302.45001,\"previous_close\":307.42999,\"change\":-4.59,\"percent_change\":-1.49302,\"volume\":3016200,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:45:13', '2026-01-21 11:44:13', '2026-01-21 11:44:13'),
(207, 'twelvedata_quote_TMO', 'general', 'json', '{\"symbol\":\"TMO\",\"name\":\"Thermo Fisher Scientific Inc.\",\"exchange\":\"NYSE\",\"price\":619.01001,\"open\":609.5,\"high\":620.84998,\"low\":606,\"previous_close\":618.71997,\"change\":0.29003906,\"percent_change\":0.046877275,\"volume\":3108800,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:45:31', '2026-01-21 11:44:31', '2026-01-21 11:44:31'),
(208, 'twelvedata_quote_CSCO', 'general', 'json', '{\"symbol\":\"CSCO\",\"name\":\"Cisco Systems, Inc.\",\"exchange\":\"NASDAQ\",\"price\":73.35,\"open\":74.52,\"high\":74.87,\"low\":73.21,\"previous_close\":75.19,\"change\":-1.84,\"percent_change\":-2.44714,\"volume\":23990500,\"timestamp\":1768919400,\"source\":\"twelvedata\",\"logo_url\":null}', '2026-01-21 11:45:49', '2026-01-21 11:44:49', '2026-01-21 11:44:49'),
(209, 'twelvedata_quote_ABT', 'general', 'json', '{\"symbol\":\"ABT\",\"name\":\"Abbott Laboratories\",\"exchange\":\"NYSE\",\"price\":108.09,\"open\":107.59,\"high\":113.85,\"low\":105.88,\"previous_close\":120.73,\"change\":-12.64,\"percent_change\":-10.46965,\"volume\":3247974,\"timestamp\":1769092200,\"source\":\"twelvedata\"}', '2026-01-22 19:33:06', '2026-01-21 11:45:07', '2026-01-22 19:32:06'),
(210, 'twelvedata_quote_GOOG', 'general', 'json', '{\"symbol\":\"GOOG\",\"name\":\"Alphabet Inc.\",\"exchange\":\"NASDAQ\",\"price\":328.485,\"open\":332.655,\"high\":334.02,\"low\":327.975,\"previous_close\":330.84,\"change\":-2.355,\"percent_change\":-0.71182335,\"volume\":1194231,\"timestamp\":1769178600,\"source\":\"twelvedata\"}', '2026-01-23 19:46:29', '2026-01-21 11:59:08', '2026-01-23 19:45:29');

-- --------------------------------------------------------

--
-- Table structure for table `trading_orders`
--

CREATE TABLE `trading_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `order_type` varchar(255) NOT NULL,
  `side` varchar(255) NOT NULL,
  `symbol` varchar(255) NOT NULL,
  `market_type` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `quantity` decimal(18,8) NOT NULL,
  `price` decimal(18,8) DEFAULT NULL,
  `stop_price` decimal(18,8) DEFAULT NULL,
  `filled_quantity` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `average_price` decimal(18,8) DEFAULT NULL,
  `total_cost` decimal(18,8) DEFAULT NULL,
  `fee` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `fee_currency` varchar(255) DEFAULT NULL,
  `filled_at` timestamp NULL DEFAULT NULL,
  `cancelled_at` timestamp NULL DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `external_order_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `trading_preferences`
--

CREATE TABLE `trading_preferences` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  `category` varchar(255) NOT NULL DEFAULT 'general',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `trading_watchlists`
--

CREATE TABLE `trading_watchlists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'crypto',
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trading_watchlists`
--

INSERT INTO `trading_watchlists` (`id`, `user_id`, `name`, `type`, `is_default`, `sort_order`, `created_at`, `updated_at`) VALUES
(16, 230, 'My Cryptos', 'crypto', 1, 0, '2026-01-25 05:39:47', '2026-01-25 05:39:47'),
(17, 230, 'My Stocks', 'stock', 1, 0, '2026-01-25 05:42:44', '2026-01-25 05:42:44');

-- --------------------------------------------------------

--
-- Table structure for table `trading_watchlist_items`
--

CREATE TABLE `trading_watchlist_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `watchlist_id` bigint(20) UNSIGNED NOT NULL,
  `symbol` varchar(255) NOT NULL,
  `market` varchar(255) DEFAULT NULL,
  `base_currency` varchar(255) DEFAULT NULL,
  `quote_currency` varchar(255) DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_favorite` tinyint(1) NOT NULL DEFAULT 0,
  `notes` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trading_watchlist_items`
--

INSERT INTO `trading_watchlist_items` (`id`, `watchlist_id`, `symbol`, `market`, `base_currency`, `quote_currency`, `sort_order`, `is_favorite`, `notes`, `created_at`, `updated_at`) VALUES
(104, 16, 'BTC', 'CRYPTO', NULL, NULL, 0, 0, NULL, '2026-01-25 05:39:47', '2026-01-25 05:39:47'),
(105, 16, 'ETH', 'CRYPTO', NULL, NULL, 1, 0, NULL, '2026-01-25 05:39:47', '2026-01-25 05:39:47'),
(106, 16, 'BNB', 'CRYPTO', NULL, NULL, 2, 0, NULL, '2026-01-25 05:39:47', '2026-01-25 05:39:47'),
(107, 16, 'XRP', 'CRYPTO', NULL, NULL, 3, 0, NULL, '2026-01-25 05:39:47', '2026-01-25 05:39:47'),
(108, 16, 'ADA', 'CRYPTO', NULL, NULL, 4, 0, NULL, '2026-01-25 05:39:47', '2026-01-25 05:39:47'),
(109, 17, 'AAPL', 'NASDAQ', NULL, NULL, 0, 0, NULL, '2026-01-25 05:42:44', '2026-01-25 05:42:44'),
(110, 17, 'MSFT', 'NASDAQ', NULL, NULL, 1, 0, NULL, '2026-01-25 05:42:44', '2026-01-25 05:42:44'),
(111, 17, 'GOOGL', 'NASDAQ', NULL, NULL, 2, 0, NULL, '2026-01-25 05:42:44', '2026-01-25 05:42:44'),
(112, 17, 'AMZN', 'NASDAQ', NULL, NULL, 3, 0, NULL, '2026-01-25 05:42:44', '2026-01-25 05:42:44'),
(113, 17, 'TSLA', 'NASDAQ', NULL, NULL, 4, 0, NULL, '2026-01-25 05:42:44', '2026-01-25 05:42:44'),
(114, 17, 'ADBE', NULL, NULL, NULL, 5, 0, NULL, '2026-01-25 05:42:50', '2026-01-25 05:42:50');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `kyc_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `verification_code` varchar(255) DEFAULT NULL,
  `verification_code_expires_at` timestamp NULL DEFAULT NULL,
  `verification_attempts` tinyint(4) NOT NULL DEFAULT 0,
  `password` varchar(255) NOT NULL,
  `two_factor_secret` text DEFAULT NULL,
  `two_factor_recovery_codes` text DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `cstatus` varchar(255) DEFAULT NULL,
  `userupdate` text DEFAULT NULL,
  `assign_to` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `dashboard_style` varchar(255) NOT NULL DEFAULT 'light',
  `bank_name` varchar(255) DEFAULT NULL,
  `account_name` varchar(255) DEFAULT NULL,
  `account_number` varchar(255) DEFAULT NULL,
  `swift_code` varchar(255) DEFAULT NULL,
  `acnt_type_active` varchar(255) DEFAULT NULL,
  `btc_address` varchar(255) DEFAULT NULL,
  `eth_address` varchar(255) DEFAULT NULL,
  `ltc_address` varchar(255) DEFAULT NULL,
  `usdt_address` varchar(191) DEFAULT NULL,
  `plan` varchar(255) DEFAULT NULL,
  `user_plan` varchar(255) DEFAULT NULL,
  `account_bal` float DEFAULT NULL,
  `roi` float DEFAULT NULL,
  `bonus` float DEFAULT NULL,
  `ref_bonus` float DEFAULT NULL,
  `signup_bonus` varchar(255) DEFAULT NULL,
  `auto_trade` varchar(255) DEFAULT NULL,
  `bonus_released` int(11) NOT NULL DEFAULT 0,
  `ref_by` varchar(255) DEFAULT NULL,
  `ref_link` varchar(255) DEFAULT NULL,
  `account_verify` varchar(255) DEFAULT NULL,
  `entered_at` datetime DEFAULT NULL,
  `activated_at` datetime DEFAULT NULL,
  `last_growth` datetime DEFAULT NULL,
  `status` varchar(25) DEFAULT 'active',
  `block_reason` text DEFAULT NULL,
  `trade_mode` varchar(255) DEFAULT 'on',
  `act_session` varchar(255) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `current_team_id` bigint(20) UNSIGNED DEFAULT NULL,
  `profile_photo_path` text DEFAULT NULL,
  `withdrawotp` varchar(255) DEFAULT NULL,
  `sendotpemail` varchar(255) NOT NULL DEFAULT 'No',
  `sendroiemail` varchar(255) NOT NULL DEFAULT 'Yes',
  `sendpromoemail` varchar(255) NOT NULL DEFAULT 'Yes',
  `sendinvplanemail` varchar(255) NOT NULL DEFAULT 'Yes',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `notify` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `kyc_id`, `name`, `email`, `username`, `email_verified_at`, `verification_code`, `verification_code_expires_at`, `verification_attempts`, `password`, `two_factor_secret`, `two_factor_recovery_codes`, `dob`, `cstatus`, `userupdate`, `assign_to`, `address`, `country`, `phone`, `dashboard_style`, `bank_name`, `account_name`, `account_number`, `swift_code`, `acnt_type_active`, `btc_address`, `eth_address`, `ltc_address`, `usdt_address`, `plan`, `user_plan`, `account_bal`, `roi`, `bonus`, `ref_bonus`, `signup_bonus`, `auto_trade`, `bonus_released`, `ref_by`, `ref_link`, `account_verify`, `entered_at`, `activated_at`, `last_growth`, `status`, `block_reason`, `trade_mode`, `act_session`, `remember_token`, `current_team_id`, `profile_photo_path`, `withdrawotp`, `sendotpemail`, `sendroiemail`, `sendpromoemail`, `sendinvplanemail`, `created_at`, `updated_at`, `notify`) VALUES
(230, NULL, 'real ana', 'real12@gmail.com', 'real12', '2026-01-24 10:50:49', NULL, NULL, 0, '$2y$10$2t.S7VRyiEohW/Ik4SkFKOMjOS1LoljATZURla6QgQlENHhKqBtzO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'American Samoa', '1234567889', 'light', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 44434, NULL, 44434, NULL, NULL, NULL, 0, NULL, 'http://localhost/brembypro/ref/real12', NULL, NULL, NULL, NULL, 'active', NULL, 'on', NULL, 'nLQ0xIJgMip2hDUeVDTuxeOCfRLgHiilzQdOiv0QVlXntHTiilSQjzbF8rVL', NULL, NULL, NULL, 'No', 'Yes', 'Yes', 'Yes', '2026-01-24 10:50:49', '2026-01-25 06:02:27', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `user_plans`
--

CREATE TABLE `user_plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `plan` int(11) DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `active` varchar(255) DEFAULT NULL,
  `inv_duration` varchar(255) DEFAULT NULL,
  `expire_date` datetime DEFAULT NULL,
  `activated_at` datetime DEFAULT NULL,
  `last_growth` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `profit_earned` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_plans`
--

INSERT INTO `user_plans` (`id`, `plan`, `user`, `amount`, `active`, `inv_duration`, `expire_date`, `activated_at`, `last_growth`, `created_at`, `updated_at`, `profit_earned`) VALUES
(27, 10, 197, '500', 'expired', '6 Days', '2025-04-06 17:42:52', '2025-03-31 17:42:52', '2025-04-01 16:42:52', '2025-03-31 21:42:52', '2025-04-26 11:13:18', NULL),
(28, 10, 197, '500', 'expired', '6 Days', '2025-04-06 17:45:36', '2025-03-31 17:45:36', '2025-04-01 16:45:36', '2025-03-31 21:45:36', '2025-04-26 11:13:19', NULL),
(29, 10, 197, '250', 'expired', '6 Days', '2025-04-19 11:41:59', '2025-04-13 11:41:59', '2025-04-14 10:41:59', '2025-04-13 10:41:59', '2025-04-26 11:13:19', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `wdmethods`
--

CREATE TABLE `wdmethods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `minimum` varchar(255) DEFAULT NULL,
  `maximum` varchar(255) DEFAULT NULL,
  `charges_amount` varchar(255) DEFAULT NULL,
  `charges_type` varchar(255) DEFAULT NULL,
  `duration` varchar(255) DEFAULT NULL,
  `img_url` text DEFAULT NULL,
  `bankname` varchar(255) DEFAULT NULL,
  `account_name` varchar(255) DEFAULT NULL,
  `account_number` varchar(255) DEFAULT NULL,
  `swift_code` varchar(255) DEFAULT NULL,
  `wallet_address` text DEFAULT NULL,
  `barcode` text DEFAULT NULL,
  `network` varchar(255) DEFAULT NULL,
  `methodtype` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `defaultpay` varchar(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wdmethods`
--

INSERT INTO `wdmethods` (`id`, `name`, `minimum`, `maximum`, `charges_amount`, `charges_type`, `duration`, `img_url`, `bankname`, `account_name`, `account_number`, `swift_code`, `wallet_address`, `barcode`, `network`, `methodtype`, `type`, `status`, `defaultpay`, `created_at`, `updated_at`) VALUES
(1, 'Bitcoin', '50', '10003445566', '0', 'percentage', 'Instant', 'https://assets.coingecko.com/coins/images/1/standard/bitcoin.png?1696501400', NULL, NULL, NULL, NULL, '17f5t4sRNCup1vf5nXX6bPoegmdm6k68YS', '938893993', 'Bitcoin', 'crypto', 'both', 'enabled', 'yes', '2021-03-11 17:53:32', '2026-01-22 14:38:05'),
(2, 'Ethereum', '10', '2100000000', '0', 'percentage', 'Instant', 'https://assets.coingecko.com/coins/images/279/standard/ethereum.png?1696501628', NULL, NULL, NULL, NULL, '0xD8B9fcc62639910e2CFF672Fa72A31faF6e6A7C0', '938893993', 'Erc', 'crypto', 'both', 'enabled', 'yes', '2021-03-22 15:36:03', '2026-01-22 14:40:46'),
(3, 'Litecoin', '100', '10000', '0', 'percentage', 'Instant', 'https://lulo.com', NULL, NULL, NULL, NULL, 'ltc1qwqhjwpftqlsqjjgnwu4xun0889stytl7dscx4u', 'hhhhhhhhhhh', 'Erc', 'crypto', 'both', 'disabled', 'yes', '2021-03-22 15:36:33', '2023-02-23 12:28:54'),
(10, 'Paypal', '10', '10000', '0', 'percentage', 'Instant Payment', 'https://lulo.com', 'Automatic', 'Automatic', '99388383', NULL, NULL, NULL, NULL, 'currency', 'deposit', 'disabled', 'yes', '2021-10-07 13:56:14', '2023-03-27 02:04:21'),
(12, 'Bank Transfer', '100', '1000000000000000000', '0', 'percentage', 'Instant Payment', NULL, 'Mining Bank', 'Miller lauren', '99388383', '3222ASD', NULL, NULL, NULL, 'currency', 'both', 'enabled', 'yes', '2021-10-11 16:35:35', '2023-03-27 02:02:51'),
(21, 'USDT', '10', '1000000000', '0', 'percentage', 'Instant Payment', 'https://assets.coingecko.com/coins/images/325/standard/Tether.png?1696501661', NULL, NULL, NULL, NULL, 'TYgQCmGQqahgQVQ8hpy4Rb8neLz3y8N8G5', NULL, 'TRC20', 'crypto', 'both', 'enabled', 'yes', '2021-04-14 14:45:06', '2026-01-22 14:40:35'),
(23, 'BUSD', '0', '1000', '0', 'percentage', NULL, NULL, NULL, NULL, NULL, NULL, 'Enter your correct wallet address here', NULL, 'ERC20', 'crypto', 'withdrawal', 'disabled', 'yes', '2022-06-28 04:25:41', '2023-02-23 12:31:17'),
(24, 'Credit Card', '0', '0', '0', 'percentage', 'Instant Payment', NULL, '-', '-', '0', NULL, NULL, NULL, NULL, 'currency', 'deposit', 'disabled', 'yes', '2022-07-20 17:02:29', '2023-03-27 02:05:31'),
(25, 'BNB', '10', '400000000', '0', 'percentage', NULL, 'https://assets.coingecko.com/coins/images/825/standard/bnb-icon2_2x.png?1696501970', NULL, NULL, NULL, NULL, '0xD8B9fcc62639910e2CFF672Fa72A31faF6e6A7C0', NULL, 'Erc20', 'crypto', 'both', 'enabled', NULL, '2026-01-22 14:42:23', '2026-01-22 14:42:23'),
(26, 'XRP', '10', '5000000000000', '0', 'percentage', NULL, 'https://assets.coingecko.com/coins/images/44/standard/xrp-symbol-white-128.png?1696501442', NULL, NULL, NULL, NULL, 'rMTWq2fcyFATfkjmc6p9bRyWubDWv24Zpe', NULL, 'ripple', 'crypto', 'both', 'enabled', NULL, '2026-01-22 14:44:08', '2026-01-22 14:44:08'),
(27, 'Solana', '10', '4000000000', '0', 'percentage', NULL, 'https://assets.coingecko.com/coins/images/4128/standard/solana.png?1718769756', NULL, NULL, NULL, NULL, '51iKD9psB47iM1n7mwsavKDMgj6Xt2DwjAFRoRixa4pP', NULL, 'sol', 'crypto', 'both', 'enabled', NULL, '2026-01-22 14:45:56', '2026-01-22 14:45:56'),
(28, 'Doge', '10', '4000000000', '0', 'percentage', NULL, 'https://assets.coingecko.com/coins/images/5/standard/dogecoin.png?1696501409', NULL, NULL, NULL, NULL, 'DLF1jguqJpGGxtoTC9eRc9ED6cFXmmA4Hv', NULL, 'doge', 'crypto', 'both', 'enabled', NULL, '2026-01-22 14:47:14', '2026-01-22 14:47:14'),
(29, 'Ada', '20', '1355555555', '0', 'percentage', NULL, 'https://assets.coingecko.com/coins/images/975/standard/cardano.png?1696502090', NULL, NULL, NULL, NULL, 'addr1q8a3uueh9n6nhup45ehe35u5n77z7du3ftdugvurvzsn32lfjr3xstwg4z8vmrkyvva0rt34revald4kmsjzjvmrrygqpvgkxc', NULL, 'ada', 'crypto', 'both', 'enabled', NULL, '2026-01-22 14:50:06', '2026-01-22 14:50:06'),
(30, 'Bitcoin Cash', '10', '30000000', '0', 'percentage', NULL, 'https://assets.coingecko.com/coins/images/780/standard/bitcoin-cash-circle.png?1696501932', NULL, NULL, NULL, NULL, 'qppe0kadestwvhnf3d5rw7pmr6wsk95a4uzu7vgs4y', NULL, 'bitcoin cash', 'crypto', 'both', 'enabled', NULL, '2026-01-22 14:51:41', '2026-01-22 14:51:41'),
(31, 'Stellar XLM', '10', '40000000', '0', 'percentage', NULL, 'https://assets.coingecko.com/coins/images/100/standard/fmpFRHHQ_400x400.jpg?1735231350', NULL, NULL, NULL, NULL, 'GB24DRQLY24JDGUFID5UGALUUFUJESJ2ESML7MVK2SPHSWARZY3VYGEC', NULL, 'xlm', 'crypto', 'both', 'enabled', NULL, '2026-01-22 14:55:47', '2026-01-22 14:55:47'),
(32, 'SUI', '10', '400000000', '0', 'percentage', NULL, 'https://assets.coingecko.com/coins/images/26375/standard/sui-ocean-square.png?1727791290', NULL, NULL, NULL, NULL, '0x503eab96b0e66f2ed02bca7eace3fae8c468dd061edb2e357f6be2520f5ee5cd', NULL, 'sui', 'crypto', 'both', 'enabled', NULL, '2026-01-24 09:38:42', '2026-01-24 09:55:27'),
(33, 'Hype', '10', '300000000', '0', 'percentage', NULL, 'https://assets.coingecko.com/coins/images/50882/standard/hyperliquid.jpg?1729431300', NULL, NULL, NULL, NULL, 'LU3tG2ab7eWw9jF4TtsMqXNkkjR48X32Wz', NULL, 'ERC20', 'crypto', 'both', 'enabled', NULL, '2026-01-24 09:41:57', '2026-01-24 09:41:57'),
(34, 'Litecoin', '10', '3000000', '0', 'percentage', NULL, 'https://assets.coingecko.com/coins/images/2/standard/litecoin.png?1696501400', NULL, NULL, NULL, NULL, 'LU3tG2ab7eWw9jF4TtsMqXNkkjR48X32Wz', NULL, 'ltc', 'crypto', 'both', 'disabled', NULL, '2026-01-24 09:45:53', '2026-01-24 09:46:12'),
(35, 'Litecoin', '10', '3000000', '0', 'percentage', NULL, 'https://assets.coingecko.com/coins/images/2/standard/litecoin.png?1696501400', NULL, NULL, NULL, NULL, 'LU3tG2ab7eWw9jF4TtsMqXNkkjR48X32Wz', NULL, 'ltc', 'crypto', 'both', 'enabled', NULL, '2026-01-24 09:45:53', '2026-01-24 09:45:53'),
(36, 'Near', '10', '4000000000000000', '0', 'percentage', NULL, 'https://assets.coingecko.com/coins/images/10365/standard/near.jpg?1696510367', NULL, NULL, NULL, NULL, '0xD8B9fcc62639910e2CFF672Fa72A31faF6e6A7C0', NULL, 'ERC20', 'crypto', 'both', 'enabled', NULL, '2026-01-24 09:51:32', '2026-01-24 09:52:17'),
(37, 'Avax', '10', '390000000', '0', 'percentage', NULL, 'https://assets.coingecko.com/coins/images/12559/standard/Avalanche_Circle_RedWhite_Trans.png?1696512369', NULL, NULL, NULL, NULL, '1009e43fe0494852a78b2b6584264ebc', NULL, 'ERC20', 'crypto', 'both', 'enabled', NULL, '2026-01-24 09:53:39', '2026-01-25 05:20:29');

-- --------------------------------------------------------

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `txn_id` varchar(255) DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `columns` varchar(255) DEFAULT NULL,
  `to_deduct` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `payment_mode` varchar(255) DEFAULT NULL,
  `paydetails` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activities`
--
ALTER TABLE `activities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admins_email_unique` (`email`);

--
-- Indexes for table `agents`
--
ALTER TABLE `agents`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `autologin_tokens`
--
ALTER TABLE `autologin_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `autologin_tokens_token_unique` (`token`);

--
-- Indexes for table `bnc_transactions`
--
ALTER TABLE `bnc_transactions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bot_subscriptions`
--
ALTER TABLE `bot_subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bot_subscriptions_user_id_foreign` (`user_id`),
  ADD KEY `bot_subscriptions_trading_bot_id_foreign` (`trading_bot_id`);

--
-- Indexes for table `bot_trades`
--
ALTER TABLE `bot_trades`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bot_trades_bot_subscription_id_foreign` (`bot_subscription_id`),
  ADD KEY `bot_trades_trading_bot_id_foreign` (`trading_bot_id`),
  ADD KEY `bot_trades_user_id_foreign` (`user_id`);

--
-- Indexes for table `contents`
--
ALTER TABLE `contents`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cp_transactions`
--
ALTER TABLE `cp_transactions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crypto_accounts`
--
ALTER TABLE `crypto_accounts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crypto_prices`
--
ALTER TABLE `crypto_prices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `crypto_prices_coin_symbol_unique` (`coin_symbol`);

--
-- Indexes for table `crypto_records`
--
ALTER TABLE `crypto_records`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crypto_staking_plans`
--
ALTER TABLE `crypto_staking_plans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `crypto_staking_plans_coin_symbol_foreign` (`coin_symbol`);

--
-- Indexes for table `crypto_trades`
--
ALTER TABLE `crypto_trades`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_coin` (`user_id`,`coin_symbol`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_order_type` (`order_type`);

--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `expert_traders`
--
ALTER TABLE `expert_traders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `expert_trader_subscribers`
--
ALTER TABLE `expert_trader_subscribers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `expert_trader_subscribers_expert_trader_id_foreign` (`expert_trader_id`),
  ADD KEY `expert_trader_subscribers_user_id_foreign` (`user_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `images`
--
ALTER TABLE `images`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ipaddresses`
--
ALTER TABLE `ipaddresses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kycs`
--
ALTER TABLE `kycs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kycs_email_unique` (`email`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mt4_details`
--
ALTER TABLE `mt4_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `paystacks`
--
ALTER TABLE `paystacks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `plans`
--
ALTER TABLE `plans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `scheduled_tasks`
--
ALTER TABLE `scheduled_tasks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings_conts`
--
ALTER TABLE `settings_conts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `staking_subscriptions`
--
ALTER TABLE `staking_subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `staking_subscriptions_user_id_status_index` (`user_id`,`status`),
  ADD KEY `staking_subscriptions_crypto_staking_plan_id_status_index` (`crypto_staking_plan_id`,`status`);

--
-- Indexes for table `stock_prices`
--
ALTER TABLE `stock_prices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `stock_prices_symbol_unique` (`symbol`),
  ADD KEY `stock_prices_symbol_exchange_index` (`symbol`,`exchange`);

--
-- Indexes for table `stock_trades`
--
ALTER TABLE `stock_trades`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stock_trades_user_id_stock_symbol_index` (`user_id`,`stock_symbol`),
  ADD KEY `stock_trades_status_index` (`status`);

--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `terms_privacies`
--
ALTER TABLE `terms_privacies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `testimonies`
--
ALTER TABLE `testimonies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tp__transactions`
--
ALTER TABLE `tp__transactions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `trading_bots`
--
ALTER TABLE `trading_bots`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `trading_market_data_cache`
--
ALTER TABLE `trading_market_data_cache`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `trading_market_data_cache_key_unique` (`key`),
  ADD KEY `trading_market_data_cache_market_type_data_type_index` (`market_type`,`data_type`),
  ADD KEY `trading_market_data_cache_expires_at_index` (`expires_at`);

--
-- Indexes for table `trading_orders`
--
ALTER TABLE `trading_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `trading_orders_user_id_index` (`user_id`),
  ADD KEY `trading_orders_user_id_status_index` (`user_id`,`status`),
  ADD KEY `trading_orders_user_id_symbol_index` (`user_id`,`symbol`),
  ADD KEY `trading_orders_user_id_created_at_index` (`user_id`,`created_at`);

--
-- Indexes for table `trading_preferences`
--
ALTER TABLE `trading_preferences`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `trading_preferences_user_id_key_unique` (`user_id`,`key`),
  ADD KEY `trading_preferences_user_id_category_index` (`user_id`,`category`);

--
-- Indexes for table `trading_watchlists`
--
ALTER TABLE `trading_watchlists`
  ADD PRIMARY KEY (`id`),
  ADD KEY `trading_watchlists_user_id_index` (`user_id`),
  ADD KEY `trading_watchlists_user_id_type_index` (`user_id`,`type`);

--
-- Indexes for table `trading_watchlist_items`
--
ALTER TABLE `trading_watchlist_items`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `trading_watchlist_items_watchlist_id_symbol_unique` (`watchlist_id`,`symbol`),
  ADD KEY `trading_watchlist_items_watchlist_id_index` (`watchlist_id`),
  ADD KEY `trading_watchlist_items_watchlist_id_symbol_index` (`watchlist_id`,`symbol`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indexes for table `user_plans`
--
ALTER TABLE `user_plans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wdmethods`
--
ALTER TABLE `wdmethods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `withdrawals`
--
ALTER TABLE `withdrawals`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activities`
--
ALTER TABLE `activities`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=602;

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `agents`
--
ALTER TABLE `agents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `autologin_tokens`
--
ALTER TABLE `autologin_tokens`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bnc_transactions`
--
ALTER TABLE `bnc_transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `bot_subscriptions`
--
ALTER TABLE `bot_subscriptions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `bot_trades`
--
ALTER TABLE `bot_trades`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=594;

--
-- AUTO_INCREMENT for table `contents`
--
ALTER TABLE `contents`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- AUTO_INCREMENT for table `cp_transactions`
--
ALTER TABLE `cp_transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `crypto_accounts`
--
ALTER TABLE `crypto_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;

--
-- AUTO_INCREMENT for table `crypto_prices`
--
ALTER TABLE `crypto_prices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=126;

--
-- AUTO_INCREMENT for table `crypto_records`
--
ALTER TABLE `crypto_records`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `crypto_staking_plans`
--
ALTER TABLE `crypto_staking_plans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `crypto_trades`
--
ALTER TABLE `crypto_trades`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `deposits`
--
ALTER TABLE `deposits`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- AUTO_INCREMENT for table `expert_traders`
--
ALTER TABLE `expert_traders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `expert_trader_subscribers`
--
ALTER TABLE `expert_trader_subscribers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `images`
--
ALTER TABLE `images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `ipaddresses`
--
ALTER TABLE `ipaddresses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `kycs`
--
ALTER TABLE `kycs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- AUTO_INCREMENT for table `mt4_details`
--
ALTER TABLE `mt4_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1362;

--
-- AUTO_INCREMENT for table `paystacks`
--
ALTER TABLE `paystacks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `scheduled_tasks`
--
ALTER TABLE `scheduled_tasks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `settings_conts`
--
ALTER TABLE `settings_conts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `staking_subscriptions`
--
ALTER TABLE `staking_subscriptions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `stock_prices`
--
ALTER TABLE `stock_prices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `stock_trades`
--
ALTER TABLE `stock_trades`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `terms_privacies`
--
ALTER TABLE `terms_privacies`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `testimonies`
--
ALTER TABLE `testimonies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tp__transactions`
--
ALTER TABLE `tp__transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1610;

--
-- AUTO_INCREMENT for table `trading_bots`
--
ALTER TABLE `trading_bots`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `trading_market_data_cache`
--
ALTER TABLE `trading_market_data_cache`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=211;

--
-- AUTO_INCREMENT for table `trading_orders`
--
ALTER TABLE `trading_orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `trading_preferences`
--
ALTER TABLE `trading_preferences`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `trading_watchlists`
--
ALTER TABLE `trading_watchlists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `trading_watchlist_items`
--
ALTER TABLE `trading_watchlist_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=115;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=231;

--
-- AUTO_INCREMENT for table `user_plans`
--
ALTER TABLE `user_plans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- AUTO_INCREMENT for table `wdmethods`
--
ALTER TABLE `wdmethods`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `withdrawals`
--
ALTER TABLE `withdrawals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `bot_subscriptions`
--
ALTER TABLE `bot_subscriptions`
  ADD CONSTRAINT `bot_subscriptions_trading_bot_id_foreign` FOREIGN KEY (`trading_bot_id`) REFERENCES `trading_bots` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bot_subscriptions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `bot_trades`
--
ALTER TABLE `bot_trades`
  ADD CONSTRAINT `bot_trades_bot_subscription_id_foreign` FOREIGN KEY (`bot_subscription_id`) REFERENCES `bot_subscriptions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bot_trades_trading_bot_id_foreign` FOREIGN KEY (`trading_bot_id`) REFERENCES `trading_bots` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bot_trades_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `crypto_staking_plans`
--
ALTER TABLE `crypto_staking_plans`
  ADD CONSTRAINT `crypto_staking_plans_coin_symbol_foreign` FOREIGN KEY (`coin_symbol`) REFERENCES `crypto_prices` (`coin_symbol`) ON DELETE CASCADE;

--
-- Constraints for table `crypto_trades`
--
ALTER TABLE `crypto_trades`
  ADD CONSTRAINT `crypto_trades_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `expert_trader_subscribers`
--
ALTER TABLE `expert_trader_subscribers`
  ADD CONSTRAINT `expert_trader_subscribers_expert_trader_id_foreign` FOREIGN KEY (`expert_trader_id`) REFERENCES `expert_traders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `expert_trader_subscribers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `staking_subscriptions`
--
ALTER TABLE `staking_subscriptions`
  ADD CONSTRAINT `staking_subscriptions_crypto_staking_plan_id_foreign` FOREIGN KEY (`crypto_staking_plan_id`) REFERENCES `crypto_staking_plans` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `staking_subscriptions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `stock_trades`
--
ALTER TABLE `stock_trades`
  ADD CONSTRAINT `stock_trades_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `trading_orders`
--
ALTER TABLE `trading_orders`
  ADD CONSTRAINT `trading_orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `trading_preferences`
--
ALTER TABLE `trading_preferences`
  ADD CONSTRAINT `trading_preferences_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `trading_watchlists`
--
ALTER TABLE `trading_watchlists`
  ADD CONSTRAINT `trading_watchlists_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `trading_watchlist_items`
--
ALTER TABLE `trading_watchlist_items`
  ADD CONSTRAINT `trading_watchlist_items_watchlist_id_foreign` FOREIGN KEY (`watchlist_id`) REFERENCES `trading_watchlists` (`id`) ON DELETE CASCADE;
COMMIT;

