PREVIEW / futures_1hour / 2024-08-23
file: by_date/futures_1hour/2024/2024-08-23.parquet size: 56 KB rows: 1,647
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-08-23 00:00:00 | ES | Futures | 5882.96 | 5886.89 | 5882.96 | 5885.32 | 2739.0 |
| 2024-08-23 01:00:00 | ES | Futures | 5885.32 | 5888.2 | 5884.79 | 5885.84 | 3019.0 |
| 2024-08-23 02:00:00 | ES | Futures | 5886.1 | 5887.94 | 5885.06 | 5886.37 | 3978.0 |
| 2024-08-23 03:00:00 | ES | Futures | 5886.63 | 5889.51 | 5883.75 | 5884.01 | 7501.0 |
| 2024-08-23 04:00:00 | ES | Futures | 5884.01 | 5891.87 | 5882.96 | 5891.61 | 9048.0 |
| 2024-08-23 05:00:00 | ES | Futures | 5891.87 | 5893.45 | 5887.68 | 5892.92 | 7658.0 |
| 2024-08-23 06:00:00 | ES | Futures | 5892.92 | 5901.57 | 5891.61 | 5898.69 | 11254.0 |
| 2024-08-23 07:00:00 | ES | Futures | 5898.43 | 5899.48 | 5894.76 | 5898.43 | 9332.0 |
| 2024-08-23 08:00:00 | ES | Futures | 5898.43 | 5902.88 | 5894.76 | 5902.36 | 16338.0 |
| 2024-08-23 09:00:00 | ES | Futures | 5902.1 | 5904.19 | 5892.13 | 5902.1 | 103231.0 |
| 2024-08-23 10:00:00 | ES | Futures | 5902.36 | 5937.75 | 5887.42 | 5910.22 | 378145.0 |
| 2024-08-23 11:00:00 | ES | Futures | 5909.96 | 5931.2 | 5899.48 | 5904.46 | 210655.0 |
| 2024-08-23 12:00:00 | ES | Futures | 5904.46 | 5906.29 | 5875.62 | 5896.85 | 174284.0 |
| 2024-08-23 13:00:00 | ES | Futures | 5896.85 | 5915.21 | 5893.45 | 5908.65 | 86032.0 |
| 2024-08-23 14:00:00 | ES | Futures | 5908.91 | 5917.3 | 5906.55 | 5912.85 | 66794.0 |
| 2024-08-23 15:00:00 | ES | Futures | 5912.85 | 5933.03 | 5906.29 | 5926.22 | 186474.0 |
| 2024-08-23 16:00:00 | ES | Futures | 5926.48 | 5930.67 | 5923.33 | 5925.69 | 44934.0 |
| 2024-08-23 00:00:00 | NQ | Futures | 20766.45 | 20792.58 | 20765.39 | 20779.12 | 2299.0 |
| 2024-08-23 01:00:00 | NQ | Futures | 20779.65 | 20802.09 | 20777.53 | 20783.87 | 2406.0 |
| 2024-08-23 02:00:00 | NQ | Futures | 20783.61 | 20797.07 | 20771.99 | 20793.9 | 2576.0 |
| 2024-08-23 03:00:00 | NQ | Futures | 20794.17 | 20810.27 | 20780.44 | 20780.7 | 4048.0 |
| 2024-08-23 04:00:00 | NQ | Futures | 20780.7 | 20815.81 | 20774.37 | 20815.81 | 4425.0 |
| 2024-08-23 05:00:00 | NQ | Futures | 20816.08 | 20822.94 | 20785.98 | 20818.72 | 3737.0 |
| 2024-08-23 06:00:00 | NQ | Futures | 20818.45 | 20859.9 | 20818.19 | 20844.32 | 5923.0 |
| 2024-08-23 07:00:00 | NQ | Futures | 20844.85 | 20850.66 | 20824.79 | 20841.68 | 5630.0 |
| 2024-08-23 08:00:00 | NQ | Futures | 20841.42 | 20865.44 | 20822.41 | 20862.27 | 9009.0 |
| 2024-08-23 09:00:00 | NQ | Futures | 20862.01 | 20884.45 | 20808.68 | 20859.37 | 54507.0 |
| 2024-08-23 10:00:00 | NQ | Futures | 20859.63 | 21017.49 | 20719.99 | 20822.94 | 152691.0 |
| 2024-08-23 11:00:00 | NQ | Futures | 20822.94 | 20926.68 | 20762.22 | 20819.77 | 88430.0 |
| 2024-08-23 12:00:00 | NQ | Futures | 20820.3 | 20828.48 | 20687.52 | 20781.76 | 67728.0 |
| 2024-08-23 13:00:00 | NQ | Futures | 20781.49 | 20874.42 | 20765.66 | 20836.4 | 43659.0 |
| 2024-08-23 14:00:00 | NQ | Futures | 20836.4 | 20872.04 | 20825.58 | 20842.74 | 34111.0 |
| 2024-08-23 15:00:00 | NQ | Futures | 20842.74 | 20919.29 | 20807.89 | 20895.8 | 65323.0 |
| 2024-08-23 16:00:00 | NQ | Futures | 20896.06 | 20904.77 | 20878.11 | 20882.86 | 11035.0 |
| 2024-08-23 00:00:00 | YM | Futures | 42976.9 | 42991.6 | 42976.9 | 42983.2 | 348.0 |
| 2024-08-23 01:00:00 | YM | Futures | 42982.1 | 42996.8 | 42980.0 | 42991.6 | 621.0 |
| 2024-08-23 02:00:00 | YM | Futures | 42991.6 | 43013.6 | 42991.6 | 42997.9 | 994.0 |
| 2024-08-23 03:00:00 | YM | Futures | 43000.0 | 43015.7 | 42985.3 | 42990.5 | 1074.0 |
| 2024-08-23 04:00:00 | YM | Futures | 42989.5 | 43030.5 | 42979.0 | 43028.4 | 1581.0 |
| 2024-08-23 05:00:00 | YM | Futures | 43028.4 | 43049.4 | 43011.5 | 43030.5 | 1271.0 |
| 2024-08-23 06:00:00 | YM | Futures | 43030.5 | 43071.4 | 43019.9 | 43064.1 | 1271.0 |
| 2024-08-23 07:00:00 | YM | Futures | 43064.1 | 43074.6 | 43045.2 | 43069.3 | 1239.0 |
| 2024-08-23 08:00:00 | YM | Futures | 43069.3 | 43103.0 | 43058.8 | 43099.8 | 2350.0 |
| 2024-08-23 09:00:00 | YM | Futures | 43098.8 | 43139.7 | 43010.5 | 43077.7 | 14124.0 |
| 2024-08-23 10:00:00 | YM | Futures | 43086.1 | 43347.8 | 43084.0 | 43240.6 | 38373.0 |
| 2024-08-23 11:00:00 | YM | Futures | 43240.6 | 43402.4 | 43199.6 | 43215.4 | 19292.0 |
| 2024-08-23 12:00:00 | YM | Futures | 43217.5 | 43228.0 | 43003.1 | 43157.6 | 16902.0 |
| 2024-08-23 13:00:00 | YM | Futures | 43154.4 | 43257.4 | 43138.7 | 43236.4 | 8986.0 |
| 2024-08-23 14:00:00 | YM | Futures | 43236.4 | 43277.4 | 43219.6 | 43260.6 | 6622.0 |
| 2024-08-23 15:00:00 | YM | Futures | 43259.5 | 43401.4 | 43234.3 | 43352.0 | 15340.0 |
> showing 50 of 1,647 rows — these rows as CSV