PREVIEW / futures_1hour / 2024-04-18
file: by_date/futures_1hour/2024/2024-04-18.parquet size: 70 KB rows: 2,102
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-04-18 00:00:00 | ES | Futures | 5387.09 | 5388.69 | 5385.77 | 5386.3 | 2718.0 |
| 2024-04-18 01:00:00 | ES | Futures | 5386.56 | 5391.87 | 5383.12 | 5390.28 | 8087.0 |
| 2024-04-18 02:00:00 | ES | Futures | 5390.28 | 5395.32 | 5389.75 | 5392.93 | 11928.0 |
| 2024-04-18 03:00:00 | ES | Futures | 5392.93 | 5393.73 | 5387.09 | 5390.28 | 16051.0 |
| 2024-04-18 04:00:00 | ES | Futures | 5390.28 | 5391.87 | 5381.52 | 5384.44 | 16476.0 |
| 2024-04-18 05:00:00 | ES | Futures | 5384.18 | 5386.03 | 5373.56 | 5382.58 | 14988.0 |
| 2024-04-18 06:00:00 | ES | Futures | 5382.58 | 5387.63 | 5377.54 | 5383.91 | 23617.0 |
| 2024-04-18 07:00:00 | ES | Futures | 5383.91 | 5390.28 | 5380.99 | 5386.56 | 20048.0 |
| 2024-04-18 08:00:00 | ES | Futures | 5386.83 | 5387.36 | 5373.03 | 5379.93 | 47872.0 |
| 2024-04-18 09:00:00 | ES | Futures | 5380.2 | 5387.89 | 5359.77 | 5375.42 | 232700.0 |
| 2024-04-18 10:00:00 | ES | Futures | 5375.42 | 5403.81 | 5366.14 | 5399.03 | 240215.0 |
| 2024-04-18 11:00:00 | ES | Futures | 5399.03 | 5406.99 | 5390.81 | 5393.73 | 161064.0 |
| 2024-04-18 12:00:00 | ES | Futures | 5393.73 | 5398.77 | 5368.79 | 5370.91 | 155995.0 |
| 2024-04-18 13:00:00 | ES | Futures | 5370.65 | 5374.89 | 5350.22 | 5358.18 | 210127.0 |
| 2024-04-18 14:00:00 | ES | Futures | 5358.44 | 5367.46 | 5346.77 | 5351.28 | 162548.0 |
| 2024-04-18 15:00:00 | ES | Futures | 5351.28 | 5371.97 | 5351.28 | 5357.12 | 218139.0 |
| 2024-04-18 16:00:00 | ES | Futures | 5357.38 | 5364.28 | 5351.81 | 5356.85 | 76937.0 |
| 2024-04-18 18:00:00 | ES | Futures | 5356.06 | 5360.57 | 5355.52 | 5356.32 | 4313.0 |
| 2024-04-18 19:00:00 | ES | Futures | 5356.32 | 5356.59 | 5344.38 | 5348.36 | 9842.0 |
| 2024-04-18 20:00:00 | ES | Futures | 5348.36 | 5350.22 | 5328.46 | 5331.65 | 33765.0 |
| 2024-04-18 21:00:00 | ES | Futures | 5331.65 | 5334.04 | 5277.79 | 5290.79 | 86810.0 |
| 2024-04-18 22:00:00 | ES | Futures | 5290.79 | 5294.24 | 5267.18 | 5292.12 | 73047.0 |
| 2024-04-18 23:00:00 | ES | Futures | 5292.12 | 5312.02 | 5287.61 | 5306.44 | 42842.0 |
| 2024-04-18 00:00:00 | NQ | Futures | 18971.39 | 18978.34 | 18963.9 | 18966.57 | 2330.0 |
| 2024-04-18 01:00:00 | NQ | Futures | 18967.11 | 18998.67 | 18952.13 | 18986.1 | 6932.0 |
| 2024-04-18 02:00:00 | NQ | Futures | 18986.1 | 19014.99 | 18982.35 | 19006.7 | 7458.0 |
| 2024-04-18 03:00:00 | NQ | Futures | 19007.77 | 19008.84 | 18972.19 | 18989.58 | 10948.0 |
| 2024-04-18 04:00:00 | NQ | Futures | 18989.04 | 19000.28 | 18948.92 | 18963.63 | 10465.0 |
| 2024-04-18 05:00:00 | NQ | Futures | 18963.36 | 18972.99 | 18912.27 | 18950.52 | 11348.0 |
| 2024-04-18 06:00:00 | NQ | Futures | 18950.52 | 18962.29 | 18922.7 | 18948.65 | 8877.0 |
| 2024-04-18 07:00:00 | NQ | Futures | 18947.85 | 18965.5 | 18933.4 | 18949.99 | 9885.0 |
| 2024-04-18 08:00:00 | NQ | Futures | 18949.99 | 18953.46 | 18900.23 | 18918.95 | 24983.0 |
| 2024-04-18 09:00:00 | NQ | Futures | 18919.49 | 18935.54 | 18780.92 | 18843.52 | 109525.0 |
| 2024-04-18 10:00:00 | NQ | Futures | 18842.98 | 18972.46 | 18813.56 | 18952.13 | 106800.0 |
| 2024-04-18 11:00:00 | NQ | Futures | 18951.86 | 18988.51 | 18921.09 | 18932.06 | 72801.0 |
| 2024-04-18 12:00:00 | NQ | Futures | 18931.8 | 18952.66 | 18834.69 | 18842.98 | 70569.0 |
| 2024-04-18 13:00:00 | NQ | Futures | 18843.25 | 18859.03 | 18764.87 | 18791.09 | 85209.0 |
| 2024-04-18 14:00:00 | NQ | Futures | 18790.82 | 18828.81 | 18748.29 | 18760.86 | 73539.0 |
| 2024-04-18 15:00:00 | NQ | Futures | 18761.4 | 18824.79 | 18756.85 | 18773.43 | 82889.0 |
| 2024-04-18 16:00:00 | NQ | Futures | 18773.7 | 18817.57 | 18731.97 | 18756.85 | 33350.0 |
| 2024-04-18 18:00:00 | NQ | Futures | 18758.18 | 18771.03 | 18746.68 | 18750.16 | 3738.0 |
| 2024-04-18 19:00:00 | NQ | Futures | 18749.62 | 18750.16 | 18697.73 | 18714.05 | 6194.0 |
| 2024-04-18 20:00:00 | NQ | Futures | 18714.05 | 18721.27 | 18639.68 | 18658.41 | 15514.0 |
| 2024-04-18 21:00:00 | NQ | Futures | 18658.14 | 18666.97 | 18440.93 | 18486.4 | 47592.0 |
| 2024-04-18 22:00:00 | NQ | Futures | 18484.26 | 18497.64 | 18384.75 | 18491.48 | 34736.0 |
| 2024-04-18 23:00:00 | NQ | Futures | 18491.48 | 18570.93 | 18465.54 | 18551.67 | 19444.0 |
| 2024-04-18 00:00:00 | YM | Futures | 40404.1 | 40412.6 | 40393.5 | 40394.6 | 1038.0 |
| 2024-04-18 01:00:00 | YM | Futures | 40394.6 | 40432.8 | 40377.6 | 40429.6 | 1312.0 |
| 2024-04-18 02:00:00 | YM | Futures | 40430.7 | 40450.9 | 40425.4 | 40430.7 | 1829.0 |
| 2024-04-18 03:00:00 | YM | Futures | 40430.7 | 40447.7 | 40402.0 | 40414.8 | 2587.0 |
> showing 50 of 2,102 rows — these rows as CSV