PREVIEW / futures_1hour / 2024-11-21
file: by_date/futures_1hour/2024/2024-11-21.parquet size: 67 KB rows: 2,088
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-11-21 00:00:00 | ES | Futures | 6149.67 | 6155.64 | 6147.59 | 6151.22 | 4734.0 |
| 2024-11-21 01:00:00 | ES | Futures | 6151.48 | 6154.6 | 6148.89 | 6153.56 | 4513.0 |
| 2024-11-21 02:00:00 | ES | Futures | 6153.56 | 6161.6 | 6135.91 | 6149.93 | 25586.0 |
| 2024-11-21 03:00:00 | ES | Futures | 6149.67 | 6156.67 | 6138.77 | 6148.11 | 29415.0 |
| 2024-11-21 04:00:00 | ES | Futures | 6147.85 | 6148.11 | 6130.2 | 6141.62 | 30860.0 |
| 2024-11-21 05:00:00 | ES | Futures | 6141.36 | 6150.7 | 6137.73 | 6148.89 | 13612.0 |
| 2024-11-21 06:00:00 | ES | Futures | 6148.89 | 6168.87 | 6148.63 | 6167.57 | 24222.0 |
| 2024-11-21 07:00:00 | ES | Futures | 6167.83 | 6187.56 | 6166.02 | 6176.4 | 40658.0 |
| 2024-11-21 08:00:00 | ES | Futures | 6176.14 | 6198.2 | 6175.88 | 6189.89 | 47883.0 |
| 2024-11-21 09:00:00 | ES | Futures | 6189.89 | 6198.98 | 6144.22 | 6156.67 | 298842.0 |
| 2024-11-21 10:00:00 | ES | Futures | 6156.67 | 6178.99 | 6132.28 | 6176.92 | 362869.0 |
| 2024-11-21 11:00:00 | ES | Futures | 6176.92 | 6192.75 | 6170.17 | 6179.77 | 211034.0 |
| 2024-11-21 12:00:00 | ES | Futures | 6179.77 | 6203.39 | 6171.21 | 6198.98 | 149232.0 |
| 2024-11-21 13:00:00 | ES | Futures | 6198.72 | 6210.4 | 6197.94 | 6206.24 | 119442.0 |
| 2024-11-21 14:00:00 | ES | Futures | 6206.24 | 6209.1 | 6196.64 | 6207.54 | 112303.0 |
| 2024-11-21 15:00:00 | ES | Futures | 6207.54 | 6212.99 | 6197.16 | 6197.42 | 171757.0 |
| 2024-11-21 16:00:00 | ES | Futures | 6197.42 | 6200.01 | 6193.27 | 6193.79 | 80430.0 |
| 2024-11-21 18:00:00 | ES | Futures | 6194.3 | 6196.12 | 6188.34 | 6191.45 | 8747.0 |
| 2024-11-21 19:00:00 | ES | Futures | 6191.45 | 6196.64 | 6189.11 | 6190.67 | 7051.0 |
| 2024-11-21 20:00:00 | ES | Futures | 6190.93 | 6198.98 | 6190.67 | 6195.34 | 5679.0 |
| 2024-11-21 21:00:00 | ES | Futures | 6195.34 | 6200.27 | 6193.53 | 6199.24 | 4471.0 |
| 2024-11-21 22:00:00 | ES | Futures | 6198.98 | 6204.69 | 6187.04 | 6193.01 | 12965.0 |
| 2024-11-21 23:00:00 | ES | Futures | 6193.01 | 6198.98 | 6191.71 | 6196.12 | 5478.0 |
| 2024-11-21 00:00:00 | NQ | Futures | 21579.8 | 21607.98 | 21562.58 | 21580.84 | 3879.0 |
| 2024-11-21 01:00:00 | NQ | Futures | 21581.1 | 21596.23 | 21567.27 | 21591.8 | 3293.0 |
| 2024-11-21 02:00:00 | NQ | Futures | 21592.84 | 21629.63 | 21505.44 | 21572.23 | 14337.0 |
| 2024-11-21 03:00:00 | NQ | Futures | 21571.97 | 21606.15 | 21535.96 | 21578.49 | 14344.0 |
| 2024-11-21 04:00:00 | NQ | Futures | 21577.97 | 21579.54 | 21494.22 | 21548.23 | 17219.0 |
| 2024-11-21 05:00:00 | NQ | Futures | 21547.97 | 21590.49 | 21532.57 | 21582.41 | 8423.0 |
| 2024-11-21 06:00:00 | NQ | Futures | 21582.15 | 21647.11 | 21580.84 | 21636.94 | 14865.0 |
| 2024-11-21 07:00:00 | NQ | Futures | 21636.68 | 21717.04 | 21627.8 | 21668.25 | 19747.0 |
| 2024-11-21 08:00:00 | NQ | Futures | 21667.72 | 21783.83 | 21665.12 | 21754.35 | 24979.0 |
| 2024-11-21 09:00:00 | NQ | Futures | 21754.35 | 21818.27 | 21528.66 | 21569.1 | 124335.0 |
| 2024-11-21 10:00:00 | NQ | Futures | 21569.1 | 21620.24 | 21409.68 | 21612.41 | 136135.0 |
| 2024-11-21 11:00:00 | NQ | Futures | 21612.41 | 21698.77 | 21591.02 | 21637.2 | 70985.0 |
| 2024-11-21 12:00:00 | NQ | Futures | 21637.72 | 21767.39 | 21600.93 | 21728.26 | 55350.0 |
| 2024-11-21 13:00:00 | NQ | Futures | 21728.26 | 21776.79 | 21720.17 | 21767.39 | 40997.0 |
| 2024-11-21 14:00:00 | NQ | Futures | 21767.13 | 21780.18 | 21699.82 | 21758.26 | 41133.0 |
| 2024-11-21 15:00:00 | NQ | Futures | 21758.0 | 21790.09 | 21728.0 | 21732.69 | 49680.0 |
| 2024-11-21 16:00:00 | NQ | Futures | 21732.17 | 21740.26 | 21697.99 | 21701.38 | 15342.0 |
| 2024-11-21 18:00:00 | NQ | Futures | 21701.64 | 21716.25 | 21664.59 | 21680.25 | 5277.0 |
| 2024-11-21 19:00:00 | NQ | Futures | 21680.77 | 21700.6 | 21670.86 | 21676.6 | 3821.0 |
| 2024-11-21 20:00:00 | NQ | Futures | 21679.99 | 21720.43 | 21678.68 | 21707.91 | 4197.0 |
| 2024-11-21 21:00:00 | NQ | Futures | 21707.12 | 21735.04 | 21700.86 | 21728.78 | 3013.0 |
| 2024-11-21 22:00:00 | NQ | Futures | 21728.78 | 21754.35 | 21666.42 | 21698.51 | 7955.0 |
| 2024-11-21 23:00:00 | NQ | Futures | 21698.25 | 21730.6 | 21688.6 | 21717.04 | 4638.0 |
| 2024-11-21 00:00:00 | YM | Futures | 45265.4 | 45299.8 | 45265.4 | 45284.2 | 533.0 |
| 2024-11-21 01:00:00 | YM | Futures | 45285.2 | 45317.5 | 45275.8 | 45314.4 | 463.0 |
| 2024-11-21 02:00:00 | YM | Futures | 45312.3 | 45352.9 | 45190.5 | 45271.7 | 3411.0 |
| 2024-11-21 03:00:00 | YM | Futures | 45271.7 | 45312.3 | 45182.2 | 45245.7 | 4557.0 |
> showing 50 of 2,088 rows — these rows as CSV