PREVIEW / futures_1hour / 2024-03-04
file: by_date/futures_1hour/2024/2024-03-04.parquet size: 63 KB rows: 2,042
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-03-04 00:00:00 | ES | Futures | 5523.3 | 5523.57 | 5521.95 | 5522.22 | 2671.0 |
| 2024-03-04 01:00:00 | ES | Futures | 5521.95 | 5523.83 | 5521.42 | 5522.76 | 3981.0 |
| 2024-03-04 02:00:00 | ES | Futures | 5523.03 | 5524.91 | 5521.95 | 5524.1 | 6146.0 |
| 2024-03-04 03:00:00 | ES | Futures | 5524.37 | 5526.52 | 5523.57 | 5525.45 | 12348.0 |
| 2024-03-04 04:00:00 | ES | Futures | 5525.45 | 5527.59 | 5521.69 | 5522.22 | 13261.0 |
| 2024-03-04 05:00:00 | ES | Futures | 5521.95 | 5523.83 | 5520.34 | 5521.69 | 10530.0 |
| 2024-03-04 06:00:00 | ES | Futures | 5521.95 | 5522.49 | 5516.85 | 5521.69 | 16310.0 |
| 2024-03-04 07:00:00 | ES | Futures | 5521.69 | 5523.83 | 5520.07 | 5520.07 | 12405.0 |
| 2024-03-04 08:00:00 | ES | Futures | 5520.34 | 5522.76 | 5515.51 | 5515.78 | 30216.0 |
| 2024-03-04 09:00:00 | ES | Futures | 5515.78 | 5523.83 | 5513.63 | 5522.49 | 176663.0 |
| 2024-03-04 10:00:00 | ES | Futures | 5522.76 | 5526.79 | 5517.93 | 5524.64 | 134796.0 |
| 2024-03-04 11:00:00 | ES | Futures | 5524.37 | 5526.25 | 5519.0 | 5525.18 | 103812.0 |
| 2024-03-04 12:00:00 | ES | Futures | 5525.18 | 5530.01 | 5522.49 | 5527.59 | 73770.0 |
| 2024-03-04 13:00:00 | ES | Futures | 5527.59 | 5528.94 | 5520.88 | 5525.45 | 78786.0 |
| 2024-03-04 14:00:00 | ES | Futures | 5525.71 | 5540.49 | 5523.83 | 5537.0 | 135619.0 |
| 2024-03-04 15:00:00 | ES | Futures | 5537.0 | 5541.29 | 5519.0 | 5519.81 | 249059.0 |
| 2024-03-04 16:00:00 | ES | Futures | 5519.81 | 5520.61 | 5514.97 | 5516.05 | 56316.0 |
| 2024-03-04 18:00:00 | ES | Futures | 5515.51 | 5517.39 | 5510.67 | 5512.28 | 7593.0 |
| 2024-03-04 19:00:00 | ES | Futures | 5512.28 | 5516.31 | 5510.67 | 5512.82 | 12259.0 |
| 2024-03-04 20:00:00 | ES | Futures | 5513.09 | 5514.17 | 5509.06 | 5511.75 | 10343.0 |
| 2024-03-04 21:00:00 | ES | Futures | 5512.02 | 5512.55 | 5509.06 | 5510.67 | 7107.0 |
| 2024-03-04 22:00:00 | ES | Futures | 5510.94 | 5513.9 | 5510.67 | 5512.82 | 5545.0 |
| 2024-03-04 23:00:00 | ES | Futures | 5512.82 | 5513.9 | 5511.21 | 5511.48 | 2934.0 |
| 2024-03-04 00:00:00 | NQ | Futures | 19905.41 | 19911.37 | 19902.15 | 19903.78 | 2085.0 |
| 2024-03-04 01:00:00 | NQ | Futures | 19903.24 | 19914.36 | 19898.63 | 19908.12 | 2244.0 |
| 2024-03-04 02:00:00 | NQ | Futures | 19908.66 | 19918.15 | 19904.32 | 19916.26 | 3380.0 |
| 2024-03-04 03:00:00 | NQ | Futures | 19916.8 | 19929.27 | 19909.2 | 19921.95 | 6322.0 |
| 2024-03-04 04:00:00 | NQ | Futures | 19921.68 | 19936.6 | 19885.61 | 19886.97 | 10342.0 |
| 2024-03-04 05:00:00 | NQ | Futures | 19886.97 | 19890.76 | 19872.32 | 19883.44 | 8169.0 |
| 2024-03-04 06:00:00 | NQ | Futures | 19883.98 | 19892.12 | 19863.91 | 19889.68 | 9212.0 |
| 2024-03-04 07:00:00 | NQ | Futures | 19890.22 | 19909.48 | 19883.71 | 19888.86 | 9677.0 |
| 2024-03-04 08:00:00 | NQ | Futures | 19888.86 | 19907.58 | 19881.27 | 19890.22 | 12250.0 |
| 2024-03-04 09:00:00 | NQ | Futures | 19890.22 | 19891.58 | 19839.23 | 19848.18 | 89479.0 |
| 2024-03-04 10:00:00 | NQ | Futures | 19848.73 | 19888.05 | 19830.83 | 19876.12 | 79398.0 |
| 2024-03-04 11:00:00 | NQ | Futures | 19875.85 | 19881.0 | 19831.91 | 19870.15 | 63135.0 |
| 2024-03-04 12:00:00 | NQ | Futures | 19870.42 | 19882.08 | 19844.93 | 19855.23 | 40927.0 |
| 2024-03-04 13:00:00 | NQ | Futures | 19855.78 | 19865.27 | 19819.98 | 19854.15 | 39197.0 |
| 2024-03-04 14:00:00 | NQ | Futures | 19854.42 | 19902.7 | 19840.32 | 19885.88 | 54595.0 |
| 2024-03-04 15:00:00 | NQ | Futures | 19886.15 | 19902.15 | 19800.45 | 19807.23 | 89194.0 |
| 2024-03-04 16:00:00 | NQ | Futures | 19807.23 | 19810.49 | 19780.92 | 19791.77 | 15922.0 |
| 2024-03-04 18:00:00 | NQ | Futures | 19793.67 | 19800.18 | 19762.21 | 19769.26 | 5944.0 |
| 2024-03-04 19:00:00 | NQ | Futures | 19768.72 | 19785.81 | 19757.6 | 19770.08 | 4933.0 |
| 2024-03-04 20:00:00 | NQ | Futures | 19769.53 | 19774.96 | 19735.09 | 19748.38 | 6787.0 |
| 2024-03-04 21:00:00 | NQ | Futures | 19748.92 | 19753.26 | 19728.04 | 19736.99 | 4751.0 |
| 2024-03-04 22:00:00 | NQ | Futures | 19736.99 | 19758.69 | 19736.45 | 19756.52 | 3560.0 |
| 2024-03-04 23:00:00 | NQ | Futures | 19756.52 | 19762.75 | 19749.19 | 19752.45 | 2814.0 |
| 2024-03-04 00:00:00 | YM | Futures | 41978.2 | 41980.3 | 41967.4 | 41968.5 | 376.0 |
| 2024-03-04 01:00:00 | YM | Futures | 41968.5 | 41978.2 | 41964.2 | 41975.0 | 471.0 |
| 2024-03-04 02:00:00 | YM | Futures | 41975.0 | 41981.4 | 41959.9 | 41967.4 | 917.0 |
| 2024-03-04 03:00:00 | YM | Futures | 41968.5 | 41980.3 | 41947.0 | 41959.9 | 2139.0 |
> showing 50 of 2,042 rows — these rows as CSV