PREVIEW / futures_30min / 2024-05-26
file: by_date/futures_30min/2024/2024-05-26.parquet size: 24 KB rows: 681
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-05-26 18:00:00 | ES | Futures | 5647.35 | 5650.0 | 5646.82 | 5649.21 | 1661.0 |
| 2024-05-26 18:30:00 | ES | Futures | 5649.21 | 5649.21 | 5646.55 | 5647.62 | 935.0 |
| 2024-05-26 19:00:00 | ES | Futures | 5647.35 | 5647.35 | 5642.84 | 5642.84 | 1629.0 |
| 2024-05-26 19:30:00 | ES | Futures | 5642.84 | 5643.37 | 5640.45 | 5640.98 | 2252.0 |
| 2024-05-26 20:00:00 | ES | Futures | 5641.25 | 5643.37 | 5639.92 | 5640.72 | 2100.0 |
| 2024-05-26 20:30:00 | ES | Futures | 5640.45 | 5642.04 | 5640.45 | 5642.04 | 1328.0 |
| 2024-05-26 21:00:00 | ES | Futures | 5642.04 | 5643.37 | 5640.72 | 5642.04 | 1620.0 |
| 2024-05-26 21:30:00 | ES | Futures | 5642.31 | 5644.43 | 5642.04 | 5643.9 | 1818.0 |
| 2024-05-26 22:00:00 | ES | Futures | 5643.9 | 5644.17 | 5640.72 | 5640.72 | 1369.0 |
| 2024-05-26 22:30:00 | ES | Futures | 5640.98 | 5641.51 | 5637.53 | 5641.25 | 1914.0 |
| 2024-05-26 23:00:00 | ES | Futures | 5641.51 | 5643.1 | 5641.51 | 5642.57 | 762.0 |
| 2024-05-26 23:30:00 | ES | Futures | 5642.57 | 5642.84 | 5641.78 | 5641.78 | 491.0 |
| 2024-05-26 18:00:00 | NQ | Futures | 20196.29 | 20208.86 | 20189.87 | 20208.06 | 1340.0 |
| 2024-05-26 18:30:00 | NQ | Futures | 20207.79 | 20208.59 | 20192.27 | 20196.82 | 1103.0 |
| 2024-05-26 19:00:00 | NQ | Futures | 20196.02 | 20196.02 | 20165.52 | 20166.33 | 2215.0 |
| 2024-05-26 19:30:00 | NQ | Futures | 20166.59 | 20170.07 | 20155.09 | 20155.36 | 1594.0 |
| 2024-05-26 20:00:00 | NQ | Futures | 20155.63 | 20169.54 | 20152.15 | 20159.1 | 1425.0 |
| 2024-05-26 20:30:00 | NQ | Futures | 20157.77 | 20170.07 | 20157.77 | 20166.86 | 943.0 |
| 2024-05-26 21:00:00 | NQ | Futures | 20167.13 | 20171.94 | 20162.58 | 20167.66 | 743.0 |
| 2024-05-26 21:30:00 | NQ | Futures | 20167.93 | 20174.89 | 20165.52 | 20172.21 | 927.0 |
| 2024-05-26 22:00:00 | NQ | Futures | 20172.75 | 20173.28 | 20165.26 | 20165.79 | 655.0 |
| 2024-05-26 22:30:00 | NQ | Futures | 20166.06 | 20170.87 | 20155.36 | 20169.54 | 1077.0 |
| 2024-05-26 23:00:00 | NQ | Futures | 20170.87 | 20177.03 | 20170.07 | 20174.89 | 679.0 |
| 2024-05-26 23:30:00 | NQ | Futures | 20174.89 | 20175.96 | 20170.07 | 20170.61 | 340.0 |
| 2024-05-26 18:00:00 | YM | Futures | 41579.4 | 41585.8 | 41562.5 | 41581.6 | 304.0 |
| 2024-05-26 18:30:00 | YM | Futures | 41579.4 | 41580.5 | 41556.1 | 41560.3 | 202.0 |
| 2024-05-26 19:00:00 | YM | Futures | 41560.3 | 41560.3 | 41541.2 | 41543.4 | 280.0 |
| 2024-05-26 19:30:00 | YM | Futures | 41543.4 | 41544.4 | 41522.1 | 41532.7 | 215.0 |
| 2024-05-26 20:00:00 | YM | Futures | 41532.7 | 41548.7 | 41527.4 | 41532.7 | 514.0 |
| 2024-05-26 20:30:00 | YM | Futures | 41531.7 | 41544.4 | 41530.6 | 41542.3 | 374.0 |
| 2024-05-26 21:00:00 | YM | Futures | 41543.4 | 41552.9 | 41507.3 | 41525.3 | 1515.0 |
| 2024-05-26 21:30:00 | YM | Futures | 41525.3 | 41556.1 | 41525.3 | 41554.0 | 627.0 |
| 2024-05-26 22:00:00 | YM | Futures | 41555.0 | 41558.2 | 41530.6 | 41530.6 | 470.0 |
| 2024-05-26 22:30:00 | YM | Futures | 41529.5 | 41531.7 | 41508.3 | 41529.5 | 295.0 |
| 2024-05-26 23:00:00 | YM | Futures | 41530.6 | 41541.2 | 41530.6 | 41539.1 | 122.0 |
| 2024-05-26 23:30:00 | YM | Futures | 41539.1 | 41539.1 | 41532.7 | 41532.7 | 102.0 |
| 2024-05-26 18:00:00 | CL | Futures | 66.25 | 66.28 | 66.15 | 66.23 | 636.0 |
| 2024-05-26 18:30:00 | CL | Futures | 66.23 | 66.28 | 66.22 | 66.27 | 398.0 |
| 2024-05-26 19:00:00 | CL | Futures | 66.27 | 66.28 | 66.2 | 66.23 | 389.0 |
| 2024-05-26 19:30:00 | CL | Futures | 66.22 | 66.28 | 66.22 | 66.27 | 388.0 |
| 2024-05-26 20:00:00 | CL | Futures | 66.28 | 66.33 | 66.26 | 66.31 | 869.0 |
| 2024-05-26 20:30:00 | CL | Futures | 66.32 | 66.32 | 66.28 | 66.28 | 389.0 |
| 2024-05-26 21:00:00 | CL | Futures | 66.29 | 66.33 | 66.2 | 66.28 | 1214.0 |
| 2024-05-26 21:30:00 | CL | Futures | 66.28 | 66.33 | 66.2 | 66.32 | 1052.0 |
| 2024-05-26 22:00:00 | CL | Futures | 66.32 | 66.42 | 66.28 | 66.39 | 689.0 |
| 2024-05-26 22:30:00 | CL | Futures | 66.4 | 66.4 | 66.31 | 66.34 | 718.0 |
| 2024-05-26 23:00:00 | CL | Futures | 66.34 | 66.44 | 66.33 | 66.39 | 735.0 |
| 2024-05-26 23:30:00 | CL | Futures | 66.39 | 66.39 | 66.35 | 66.39 | 248.0 |
| 2024-05-26 18:00:00 | GC | Futures | 2534.1 | 2539.1 | 2530.9 | 2534.3 | 286.0 |
| 2024-05-26 18:30:00 | GC | Futures | 2534.0 | 2539.3 | 2534.0 | 2538.5 | 840.0 |
> showing 50 of 681 rows — these rows as CSV