PREVIEW / futures_1hour / 2024-07-12
file: by_date/futures_1hour/2024/2024-07-12.parquet size: 55 KB rows: 1,648
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-07-12 00:00:00 | ES | Futures | 5914.16 | 5915.47 | 5910.75 | 5911.53 | 3799.0 |
| 2024-07-12 01:00:00 | ES | Futures | 5911.8 | 5915.99 | 5908.39 | 5915.47 | 6284.0 |
| 2024-07-12 02:00:00 | ES | Futures | 5915.47 | 5917.83 | 5914.16 | 5915.73 | 7237.0 |
| 2024-07-12 03:00:00 | ES | Futures | 5915.73 | 5917.56 | 5911.27 | 5914.68 | 9869.0 |
| 2024-07-12 04:00:00 | ES | Futures | 5914.68 | 5919.66 | 5914.68 | 5919.4 | 11879.0 |
| 2024-07-12 05:00:00 | ES | Futures | 5919.4 | 5920.71 | 5915.73 | 5918.88 | 8734.0 |
| 2024-07-12 06:00:00 | ES | Futures | 5918.88 | 5920.71 | 5912.85 | 5915.73 | 12444.0 |
| 2024-07-12 07:00:00 | ES | Futures | 5915.99 | 5918.09 | 5911.53 | 5917.3 | 12782.0 |
| 2024-07-12 08:00:00 | ES | Futures | 5917.04 | 5921.5 | 5894.76 | 5918.35 | 62429.0 |
| 2024-07-12 09:00:00 | ES | Futures | 5918.61 | 5936.18 | 5914.94 | 5934.08 | 183651.0 |
| 2024-07-12 10:00:00 | ES | Futures | 5934.34 | 5961.08 | 5931.2 | 5958.99 | 240891.0 |
| 2024-07-12 11:00:00 | ES | Futures | 5958.99 | 5965.28 | 5954.01 | 5955.05 | 149421.0 |
| 2024-07-12 12:00:00 | ES | Futures | 5954.79 | 5963.97 | 5947.71 | 5963.97 | 147591.0 |
| 2024-07-12 13:00:00 | ES | Futures | 5963.97 | 5985.99 | 5962.39 | 5979.17 | 148056.0 |
| 2024-07-12 14:00:00 | ES | Futures | 5979.17 | 5983.37 | 5974.45 | 5981.01 | 113993.0 |
| 2024-07-12 15:00:00 | ES | Futures | 5981.01 | 5981.79 | 5935.39 | 5946.14 | 377993.0 |
| 2024-07-12 16:00:00 | ES | Futures | 5946.14 | 5950.34 | 5941.68 | 5943.26 | 69961.0 |
| 2024-07-12 00:00:00 | NQ | Futures | 21562.35 | 21568.43 | 21527.25 | 21536.75 | 3432.0 |
| 2024-07-12 01:00:00 | NQ | Futures | 21537.28 | 21563.94 | 21511.14 | 21560.24 | 5747.0 |
| 2024-07-12 02:00:00 | NQ | Futures | 21559.98 | 21580.04 | 21544.93 | 21566.05 | 4646.0 |
| 2024-07-12 03:00:00 | NQ | Futures | 21565.79 | 21573.97 | 21520.38 | 21542.29 | 6770.0 |
| 2024-07-12 04:00:00 | NQ | Futures | 21542.03 | 21580.04 | 21542.03 | 21578.46 | 7634.0 |
| 2024-07-12 05:00:00 | NQ | Futures | 21578.99 | 21591.66 | 21559.71 | 21579.51 | 6841.0 |
| 2024-07-12 06:00:00 | NQ | Futures | 21577.93 | 21590.6 | 21554.7 | 21570.8 | 5603.0 |
| 2024-07-12 07:00:00 | NQ | Futures | 21571.07 | 21589.02 | 21545.2 | 21586.91 | 7436.0 |
| 2024-07-12 08:00:00 | NQ | Futures | 21587.17 | 21613.3 | 21472.34 | 21582.42 | 29427.0 |
| 2024-07-12 09:00:00 | NQ | Futures | 21582.68 | 21699.1 | 21563.94 | 21691.71 | 102597.0 |
| 2024-07-12 10:00:00 | NQ | Futures | 21691.97 | 21816.83 | 21669.8 | 21790.7 | 120372.0 |
| 2024-07-12 11:00:00 | NQ | Futures | 21790.44 | 21822.64 | 21741.33 | 21746.88 | 68404.0 |
| 2024-07-12 12:00:00 | NQ | Futures | 21746.88 | 21786.74 | 21704.38 | 21784.36 | 66466.0 |
| 2024-07-12 13:00:00 | NQ | Futures | 21784.36 | 21901.04 | 21776.18 | 21868.57 | 64392.0 |
| 2024-07-12 14:00:00 | NQ | Futures | 21868.57 | 21882.83 | 21837.95 | 21868.31 | 48210.0 |
| 2024-07-12 15:00:00 | NQ | Futures | 21867.25 | 21870.42 | 21657.39 | 21689.33 | 119988.0 |
| 2024-07-12 16:00:00 | NQ | Futures | 21689.33 | 21712.3 | 21673.76 | 21688.54 | 18030.0 |
| 2024-07-12 00:00:00 | YM | Futures | 42144.7 | 42157.3 | 42141.5 | 42149.9 | 600.0 |
| 2024-07-12 01:00:00 | YM | Futures | 42149.9 | 42167.8 | 42137.3 | 42165.7 | 723.0 |
| 2024-07-12 02:00:00 | YM | Futures | 42166.8 | 42181.5 | 42155.2 | 42166.8 | 1391.0 |
| 2024-07-12 03:00:00 | YM | Futures | 42167.8 | 42180.4 | 42148.9 | 42163.6 | 1292.0 |
| 2024-07-12 04:00:00 | YM | Futures | 42163.6 | 42186.7 | 42157.3 | 42173.1 | 2180.0 |
| 2024-07-12 05:00:00 | YM | Futures | 42172.0 | 42174.1 | 42138.4 | 42156.3 | 1199.0 |
| 2024-07-12 06:00:00 | YM | Futures | 42156.3 | 42244.5 | 42131.0 | 42146.8 | 5045.0 |
| 2024-07-12 07:00:00 | YM | Futures | 42147.8 | 42176.2 | 42128.9 | 42139.4 | 2322.0 |
| 2024-07-12 08:00:00 | YM | Futures | 42138.4 | 42210.9 | 42051.2 | 42205.6 | 7900.0 |
| 2024-07-12 09:00:00 | YM | Futures | 42206.7 | 42270.8 | 42154.1 | 42188.8 | 21251.0 |
| 2024-07-12 10:00:00 | YM | Futures | 42193.0 | 42352.7 | 42139.4 | 42351.7 | 22131.0 |
| 2024-07-12 11:00:00 | YM | Futures | 42351.7 | 42463.1 | 42342.2 | 42417.9 | 15650.0 |
| 2024-07-12 12:00:00 | YM | Futures | 42417.9 | 42470.4 | 42384.3 | 42467.3 | 9193.0 |
| 2024-07-12 13:00:00 | YM | Futures | 42467.3 | 42630.1 | 42453.6 | 42566.0 | 15447.0 |
| 2024-07-12 14:00:00 | YM | Futures | 42565.0 | 42595.5 | 42524.0 | 42558.7 | 8334.0 |
| 2024-07-12 15:00:00 | YM | Futures | 42558.7 | 42582.8 | 42322.3 | 42374.8 | 24778.0 |
> showing 50 of 1,648 rows — these rows as CSV