PREVIEW / futures_1hour / 2023-08-24
file: by_date/futures_1hour/2023/2023-08-24.parquet size: 66 KB rows: 2,030
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-24 00:00:00 | ES | Futures | 4916.22 | 4919.52 | 4914.85 | 4918.97 | 4052.0 |
| 2023-08-24 01:00:00 | ES | Futures | 4919.24 | 4923.09 | 4918.15 | 4920.62 | 8691.0 |
| 2023-08-24 02:00:00 | ES | Futures | 4920.34 | 4920.89 | 4914.85 | 4916.22 | 11002.0 |
| 2023-08-24 03:00:00 | ES | Futures | 4916.22 | 4925.28 | 4909.36 | 4912.66 | 36124.0 |
| 2023-08-24 04:00:00 | ES | Futures | 4912.66 | 4919.52 | 4911.01 | 4912.11 | 14824.0 |
| 2023-08-24 05:00:00 | ES | Futures | 4912.11 | 4913.48 | 4900.58 | 4903.87 | 19898.0 |
| 2023-08-24 06:00:00 | ES | Futures | 4903.6 | 4912.93 | 4903.05 | 4912.11 | 14508.0 |
| 2023-08-24 07:00:00 | ES | Futures | 4911.83 | 4915.68 | 4906.34 | 4907.99 | 18764.0 |
| 2023-08-24 08:00:00 | ES | Futures | 4907.99 | 4908.54 | 4899.48 | 4902.22 | 37595.0 |
| 2023-08-24 09:00:00 | ES | Futures | 4901.95 | 4906.62 | 4887.4 | 4903.87 | 213689.0 |
| 2023-08-24 10:00:00 | ES | Futures | 4903.87 | 4906.89 | 4860.77 | 4861.6 | 314049.0 |
| 2023-08-24 11:00:00 | ES | Futures | 4861.6 | 4861.6 | 4839.91 | 4840.19 | 221951.0 |
| 2023-08-24 12:00:00 | ES | Futures | 4840.19 | 4858.03 | 4839.09 | 4847.6 | 145721.0 |
| 2023-08-24 13:00:00 | ES | Futures | 4847.87 | 4850.07 | 4837.99 | 4841.83 | 112384.0 |
| 2023-08-24 14:00:00 | ES | Futures | 4841.83 | 4847.87 | 4832.77 | 4838.81 | 123439.0 |
| 2023-08-24 15:00:00 | ES | Futures | 4838.54 | 4841.83 | 4814.11 | 4814.93 | 274869.0 |
| 2023-08-24 16:00:00 | ES | Futures | 4815.2 | 4818.5 | 4807.79 | 4813.56 | 91484.0 |
| 2023-08-24 18:00:00 | ES | Futures | 4814.38 | 4820.69 | 4812.73 | 4820.42 | 7882.0 |
| 2023-08-24 19:00:00 | ES | Futures | 4820.42 | 4820.42 | 4814.11 | 4817.95 | 5672.0 |
| 2023-08-24 20:00:00 | ES | Futures | 4818.22 | 4823.44 | 4817.68 | 4821.79 | 8450.0 |
| 2023-08-24 21:00:00 | ES | Futures | 4822.07 | 4823.44 | 4816.03 | 4820.15 | 8560.0 |
| 2023-08-24 22:00:00 | ES | Futures | 4819.87 | 4821.24 | 4815.48 | 4817.68 | 7326.0 |
| 2023-08-24 23:00:00 | ES | Futures | 4817.68 | 4819.05 | 4814.93 | 4817.4 | 5169.0 |
| 2023-08-24 00:00:00 | NQ | Futures | 17114.52 | 17126.2 | 17107.29 | 17123.98 | 2945.0 |
| 2023-08-24 01:00:00 | NQ | Futures | 17124.26 | 17137.61 | 17114.8 | 17130.1 | 5964.0 |
| 2023-08-24 02:00:00 | NQ | Futures | 17129.82 | 17131.77 | 17099.78 | 17115.63 | 6744.0 |
| 2023-08-24 03:00:00 | NQ | Futures | 17116.47 | 17152.9 | 17096.44 | 17114.24 | 17105.0 |
| 2023-08-24 04:00:00 | NQ | Futures | 17114.8 | 17149.57 | 17100.06 | 17107.85 | 11485.0 |
| 2023-08-24 05:00:00 | NQ | Futures | 17108.96 | 17113.69 | 17064.46 | 17086.43 | 13517.0 |
| 2023-08-24 06:00:00 | NQ | Futures | 17086.71 | 17114.24 | 17083.09 | 17107.57 | 9791.0 |
| 2023-08-24 07:00:00 | NQ | Futures | 17106.73 | 17127.59 | 17087.82 | 17095.33 | 13053.0 |
| 2023-08-24 08:00:00 | NQ | Futures | 17095.05 | 17099.5 | 17046.94 | 17064.74 | 27328.0 |
| 2023-08-24 09:00:00 | NQ | Futures | 17064.74 | 17088.1 | 16893.69 | 16936.8 | 132457.0 |
| 2023-08-24 10:00:00 | NQ | Futures | 16937.07 | 16948.76 | 16721.52 | 16731.54 | 154694.0 |
| 2023-08-24 11:00:00 | NQ | Futures | 16732.09 | 16732.93 | 16625.01 | 16634.47 | 101694.0 |
| 2023-08-24 12:00:00 | NQ | Futures | 16635.02 | 16731.81 | 16631.96 | 16686.2 | 69980.0 |
| 2023-08-24 13:00:00 | NQ | Futures | 16686.76 | 16701.5 | 16643.65 | 16660.06 | 57267.0 |
| 2023-08-24 14:00:00 | NQ | Futures | 16660.33 | 16695.1 | 16612.77 | 16643.37 | 54176.0 |
| 2023-08-24 15:00:00 | NQ | Futures | 16643.65 | 16651.71 | 16526.27 | 16531.28 | 91322.0 |
| 2023-08-24 16:00:00 | NQ | Futures | 16531.56 | 16545.19 | 16484.28 | 16501.52 | 27544.0 |
| 2023-08-24 18:00:00 | NQ | Futures | 16502.08 | 16544.63 | 16498.74 | 16543.24 | 5564.0 |
| 2023-08-24 19:00:00 | NQ | Futures | 16543.24 | 16543.52 | 16502.91 | 16523.77 | 4402.0 |
| 2023-08-24 20:00:00 | NQ | Futures | 16524.33 | 16549.36 | 16521.82 | 16535.17 | 5034.0 |
| 2023-08-24 21:00:00 | NQ | Futures | 16535.73 | 16544.91 | 16509.03 | 16529.61 | 6264.0 |
| 2023-08-24 22:00:00 | NQ | Futures | 16528.5 | 16534.34 | 16504.3 | 16513.48 | 4755.0 |
| 2023-08-24 23:00:00 | NQ | Futures | 16513.2 | 16520.99 | 16494.85 | 16504.58 | 4023.0 |
| 2023-08-24 00:00:00 | YM | Futures | 37860.9 | 37887.2 | 37855.5 | 37882.9 | 488.0 |
| 2023-08-24 01:00:00 | YM | Futures | 37884.0 | 37904.8 | 37875.2 | 37885.0 | 1403.0 |
| 2023-08-24 02:00:00 | YM | Futures | 37882.9 | 37886.1 | 37848.9 | 37859.9 | 1546.0 |
| 2023-08-24 03:00:00 | YM | Futures | 37858.8 | 37919.0 | 37795.2 | 37811.6 | 4929.0 |
> showing 50 of 2,030 rows — these rows as CSV