PREVIEW / futures_1hour / 2024-09-13
file: by_date/futures_1hour/2024/2024-09-13.parquet size: 54 KB rows: 1,595
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-09-13 00:00:00 | ES | Futures | 5877.72 | 5878.24 | 5876.14 | 5877.72 | 1497.0 |
| 2024-09-13 01:00:00 | ES | Futures | 5877.72 | 5885.84 | 5876.67 | 5876.67 | 5527.0 |
| 2024-09-13 02:00:00 | ES | Futures | 5876.93 | 5878.5 | 5874.31 | 5876.93 | 5314.0 |
| 2024-09-13 03:00:00 | ES | Futures | 5876.67 | 5887.94 | 5876.67 | 5879.29 | 15054.0 |
| 2024-09-13 04:00:00 | ES | Futures | 5879.29 | 5885.06 | 5875.62 | 5881.39 | 10444.0 |
| 2024-09-13 05:00:00 | ES | Futures | 5881.65 | 5891.09 | 5880.86 | 5886.89 | 8916.0 |
| 2024-09-13 06:00:00 | ES | Futures | 5886.89 | 5889.51 | 5885.06 | 5889.25 | 6726.0 |
| 2024-09-13 07:00:00 | ES | Futures | 5889.25 | 5889.78 | 5881.39 | 5885.84 | 8826.0 |
| 2024-09-13 08:00:00 | ES | Futures | 5885.58 | 5888.73 | 5877.72 | 5885.58 | 23393.0 |
| 2024-09-13 09:00:00 | ES | Futures | 5885.84 | 5897.12 | 5877.72 | 5893.71 | 116883.0 |
| 2024-09-13 10:00:00 | ES | Futures | 5893.71 | 5911.01 | 5882.96 | 5903.41 | 176591.0 |
| 2024-09-13 11:00:00 | ES | Futures | 5903.15 | 5913.37 | 5899.74 | 5912.06 | 95185.0 |
| 2024-09-13 12:00:00 | ES | Futures | 5911.8 | 5914.94 | 5897.9 | 5907.08 | 97930.0 |
| 2024-09-13 13:00:00 | ES | Futures | 5907.08 | 5915.99 | 5906.29 | 5910.75 | 84207.0 |
| 2024-09-13 14:00:00 | ES | Futures | 5911.01 | 5915.47 | 5895.28 | 5898.95 | 142518.0 |
| 2024-09-13 15:00:00 | ES | Futures | 5898.69 | 5908.39 | 5894.49 | 5903.93 | 171092.0 |
| 2024-09-13 16:00:00 | ES | Futures | 5903.93 | 5905.77 | 5898.95 | 5900.52 | 46611.0 |
| 2024-09-13 00:00:00 | NQ | Futures | 20539.42 | 20542.33 | 20527.28 | 20536.25 | 1223.0 |
| 2024-09-13 01:00:00 | NQ | Futures | 20537.57 | 20578.49 | 20532.3 | 20532.3 | 3845.0 |
| 2024-09-13 02:00:00 | NQ | Futures | 20533.35 | 20539.69 | 20516.98 | 20527.02 | 2612.0 |
| 2024-09-13 03:00:00 | NQ | Futures | 20527.54 | 20565.56 | 20520.42 | 20522.26 | 6967.0 |
| 2024-09-13 04:00:00 | NQ | Futures | 20522.79 | 20556.32 | 20511.44 | 20540.74 | 5352.0 |
| 2024-09-13 05:00:00 | NQ | Futures | 20541.27 | 20567.93 | 20534.93 | 20551.3 | 3831.0 |
| 2024-09-13 06:00:00 | NQ | Futures | 20550.51 | 20562.13 | 20541.53 | 20558.43 | 3245.0 |
| 2024-09-13 07:00:00 | NQ | Futures | 20558.69 | 20559.75 | 20526.49 | 20541.53 | 4742.0 |
| 2024-09-13 08:00:00 | NQ | Futures | 20540.48 | 20554.73 | 20498.51 | 20536.25 | 9632.0 |
| 2024-09-13 09:00:00 | NQ | Futures | 20536.52 | 20592.22 | 20483.19 | 20552.62 | 60872.0 |
| 2024-09-13 10:00:00 | NQ | Futures | 20554.47 | 20626.8 | 20499.03 | 20603.83 | 83279.0 |
| 2024-09-13 11:00:00 | NQ | Futures | 20603.57 | 20637.1 | 20589.32 | 20628.12 | 40948.0 |
| 2024-09-13 12:00:00 | NQ | Futures | 20627.59 | 20655.05 | 20567.4 | 20635.51 | 43714.0 |
| 2024-09-13 13:00:00 | NQ | Futures | 20635.25 | 20672.21 | 20628.65 | 20654.78 | 32031.0 |
| 2024-09-13 14:00:00 | NQ | Futures | 20655.05 | 20667.98 | 20586.94 | 20604.63 | 43510.0 |
| 2024-09-13 15:00:00 | NQ | Futures | 20604.63 | 20645.54 | 20582.19 | 20619.41 | 44284.0 |
| 2024-09-13 16:00:00 | NQ | Futures | 20619.67 | 20621.26 | 20591.96 | 20594.33 | 11324.0 |
| 2024-09-13 00:00:00 | YM | Futures | 43262.7 | 43265.8 | 43253.2 | 43256.4 | 287.0 |
| 2024-09-13 01:00:00 | YM | Futures | 43257.4 | 43293.1 | 43240.6 | 43240.6 | 996.0 |
| 2024-09-13 02:00:00 | YM | Futures | 43243.8 | 43255.3 | 43231.1 | 43237.4 | 995.0 |
| 2024-09-13 03:00:00 | YM | Futures | 43236.4 | 43331.0 | 43236.4 | 43283.7 | 1940.0 |
| 2024-09-13 04:00:00 | YM | Futures | 43280.5 | 43280.5 | 43228.0 | 43253.2 | 2253.0 |
| 2024-09-13 05:00:00 | YM | Futures | 43254.3 | 43324.7 | 43250.1 | 43299.4 | 1403.0 |
| 2024-09-13 06:00:00 | YM | Futures | 43299.4 | 43323.6 | 43293.1 | 43320.5 | 1100.0 |
| 2024-09-13 07:00:00 | YM | Futures | 43321.5 | 43323.6 | 43262.7 | 43287.9 | 1526.0 |
| 2024-09-13 08:00:00 | YM | Futures | 43291.0 | 43336.2 | 43258.5 | 43317.3 | 2957.0 |
| 2024-09-13 09:00:00 | YM | Futures | 43318.4 | 43476.0 | 43257.4 | 43452.8 | 28227.0 |
| 2024-09-13 10:00:00 | YM | Futures | 43452.8 | 43607.3 | 43364.6 | 43522.2 | 36244.0 |
| 2024-09-13 11:00:00 | YM | Futures | 43520.1 | 43677.7 | 43477.0 | 43649.3 | 20862.0 |
| 2024-09-13 12:00:00 | YM | Futures | 43649.3 | 43664.0 | 43480.2 | 43524.3 | 15976.0 |
| 2024-09-13 13:00:00 | YM | Futures | 43524.3 | 43645.1 | 43520.1 | 43561.1 | 11545.0 |
| 2024-09-13 14:00:00 | YM | Futures | 43560.0 | 43606.3 | 43457.1 | 43510.6 | 19400.0 |
| 2024-09-13 15:00:00 | YM | Futures | 43508.5 | 43566.3 | 43471.8 | 43532.7 | 13801.0 |
> showing 50 of 1,595 rows — these rows as CSV