PREVIEW / futures_1hour / 2024-05-21
file: by_date/futures_1hour/2024/2024-05-21.parquet size: 64 KB rows: 2,041
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-05-21 00:00:00 | ES | Futures | 5658.76 | 5660.08 | 5658.23 | 5659.55 | 1634.0 |
| 2024-05-21 01:00:00 | ES | Futures | 5659.82 | 5660.61 | 5657.96 | 5658.49 | 3330.0 |
| 2024-05-21 02:00:00 | ES | Futures | 5658.49 | 5660.35 | 5657.96 | 5658.76 | 4617.0 |
| 2024-05-21 03:00:00 | ES | Futures | 5658.76 | 5661.94 | 5658.23 | 5660.08 | 8194.0 |
| 2024-05-21 04:00:00 | ES | Futures | 5660.08 | 5660.35 | 5656.1 | 5657.43 | 7221.0 |
| 2024-05-21 05:00:00 | ES | Futures | 5657.7 | 5658.76 | 5655.04 | 5655.57 | 6461.0 |
| 2024-05-21 06:00:00 | ES | Futures | 5655.84 | 5659.82 | 5655.84 | 5659.82 | 6762.0 |
| 2024-05-21 07:00:00 | ES | Futures | 5659.82 | 5660.61 | 5658.49 | 5659.29 | 8756.0 |
| 2024-05-21 08:00:00 | ES | Futures | 5659.29 | 5660.35 | 5652.66 | 5653.72 | 23396.0 |
| 2024-05-21 09:00:00 | ES | Futures | 5653.72 | 5655.84 | 5648.15 | 5652.92 | 151107.0 |
| 2024-05-21 10:00:00 | ES | Futures | 5652.92 | 5664.33 | 5652.92 | 5661.68 | 121707.0 |
| 2024-05-21 11:00:00 | ES | Futures | 5661.68 | 5665.92 | 5656.1 | 5657.43 | 103505.0 |
| 2024-05-21 12:00:00 | ES | Futures | 5657.7 | 5661.41 | 5655.57 | 5657.43 | 84213.0 |
| 2024-05-21 13:00:00 | ES | Futures | 5657.17 | 5666.45 | 5653.98 | 5665.92 | 88271.0 |
| 2024-05-21 14:00:00 | ES | Futures | 5666.19 | 5666.45 | 5659.55 | 5662.74 | 77788.0 |
| 2024-05-21 15:00:00 | ES | Futures | 5662.47 | 5674.68 | 5660.61 | 5673.08 | 188278.0 |
| 2024-05-21 16:00:00 | ES | Futures | 5673.35 | 5673.88 | 5669.63 | 5670.96 | 38947.0 |
| 2024-05-21 18:00:00 | ES | Futures | 5670.43 | 5673.88 | 5670.17 | 5673.08 | 2750.0 |
| 2024-05-21 19:00:00 | ES | Futures | 5673.08 | 5674.41 | 5673.08 | 5673.61 | 1761.0 |
| 2024-05-21 20:00:00 | ES | Futures | 5673.61 | 5675.21 | 5672.82 | 5673.08 | 3730.0 |
| 2024-05-21 21:00:00 | ES | Futures | 5673.35 | 5675.47 | 5672.02 | 5674.94 | 3770.0 |
| 2024-05-21 22:00:00 | ES | Futures | 5674.94 | 5676.53 | 5673.08 | 5673.88 | 3451.0 |
| 2024-05-21 23:00:00 | ES | Futures | 5673.88 | 5673.88 | 5672.55 | 5672.82 | 2292.0 |
| 2024-05-21 00:00:00 | NQ | Futures | 20064.14 | 20068.95 | 20063.07 | 20066.81 | 838.0 |
| 2024-05-21 01:00:00 | NQ | Futures | 20066.55 | 20070.02 | 20057.72 | 20060.66 | 1273.0 |
| 2024-05-21 02:00:00 | NQ | Futures | 20060.66 | 20067.35 | 20055.31 | 20057.18 | 1926.0 |
| 2024-05-21 03:00:00 | NQ | Futures | 20057.45 | 20076.98 | 20053.97 | 20068.15 | 4833.0 |
| 2024-05-21 04:00:00 | NQ | Futures | 20067.62 | 20068.42 | 20047.82 | 20053.97 | 5029.0 |
| 2024-05-21 05:00:00 | NQ | Futures | 20053.97 | 20058.52 | 20040.33 | 20048.09 | 4518.0 |
| 2024-05-21 06:00:00 | NQ | Futures | 20048.62 | 20066.81 | 20048.62 | 20065.74 | 4457.0 |
| 2024-05-21 07:00:00 | NQ | Futures | 20066.01 | 20073.5 | 20061.46 | 20063.34 | 6498.0 |
| 2024-05-21 08:00:00 | NQ | Futures | 20064.14 | 20071.36 | 20025.89 | 20028.03 | 14962.0 |
| 2024-05-21 09:00:00 | NQ | Futures | 20028.83 | 20031.24 | 19985.76 | 20017.59 | 95411.0 |
| 2024-05-21 10:00:00 | NQ | Futures | 20017.59 | 20072.16 | 20011.17 | 20068.15 | 66111.0 |
| 2024-05-21 11:00:00 | NQ | Futures | 20067.88 | 20077.25 | 20043.01 | 20057.45 | 40151.0 |
| 2024-05-21 12:00:00 | NQ | Futures | 20057.45 | 20086.07 | 20050.23 | 20059.59 | 33436.0 |
| 2024-05-21 13:00:00 | NQ | Futures | 20059.59 | 20090.36 | 20045.68 | 20090.36 | 35033.0 |
| 2024-05-21 14:00:00 | NQ | Futures | 20090.36 | 20095.97 | 20068.42 | 20083.67 | 29400.0 |
| 2024-05-21 15:00:00 | NQ | Futures | 20083.67 | 20125.67 | 20077.78 | 20117.11 | 54869.0 |
| 2024-05-21 16:00:00 | NQ | Futures | 20116.84 | 20124.33 | 20109.35 | 20114.97 | 11337.0 |
| 2024-05-21 18:00:00 | NQ | Futures | 20114.43 | 20130.75 | 20111.49 | 20128.07 | 2276.0 |
| 2024-05-21 19:00:00 | NQ | Futures | 20128.34 | 20133.16 | 20126.2 | 20130.75 | 1215.0 |
| 2024-05-21 20:00:00 | NQ | Futures | 20130.75 | 20134.49 | 20124.06 | 20127.54 | 2238.0 |
| 2024-05-21 21:00:00 | NQ | Futures | 20127.54 | 20135.03 | 20123.26 | 20133.69 | 2263.0 |
| 2024-05-21 22:00:00 | NQ | Futures | 20133.42 | 20141.98 | 20125.67 | 20129.41 | 2696.0 |
| 2024-05-21 23:00:00 | NQ | Futures | 20128.88 | 20129.68 | 20124.33 | 20127.0 | 1331.0 |
| 2024-05-21 00:00:00 | YM | Futures | 42407.6 | 42419.3 | 42407.6 | 42419.3 | 349.0 |
| 2024-05-21 01:00:00 | YM | Futures | 42419.3 | 42422.4 | 42406.5 | 42408.6 | 430.0 |
| 2024-05-21 02:00:00 | YM | Futures | 42408.6 | 42426.7 | 42404.4 | 42407.6 | 1248.0 |
| 2024-05-21 03:00:00 | YM | Futures | 42407.6 | 42433.1 | 42404.4 | 42412.9 | 1075.0 |
> showing 50 of 2,041 rows — these rows as CSV