PREVIEW / futures_1hour / 2025-01-16
file: by_date/futures_1hour/2025/2025-01-16.parquet size: 68 KB rows: 2,116
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 |
|---|---|---|---|---|---|---|---|
| 2025-01-16 00:00:00 | ES | Futures | 6143.58 | 6143.58 | 6135.63 | 6138.19 | 5436.0 |
| 2025-01-16 01:00:00 | ES | Futures | 6138.45 | 6154.34 | 6136.4 | 6150.24 | 16398.0 |
| 2025-01-16 02:00:00 | ES | Futures | 6149.99 | 6170.75 | 6147.93 | 6169.73 | 20790.0 |
| 2025-01-16 03:00:00 | ES | Futures | 6169.47 | 6171.01 | 6159.98 | 6161.01 | 21021.0 |
| 2025-01-16 04:00:00 | ES | Futures | 6161.01 | 6163.83 | 6149.73 | 6154.86 | 21257.0 |
| 2025-01-16 05:00:00 | ES | Futures | 6155.11 | 6163.32 | 6148.19 | 6160.5 | 15718.0 |
| 2025-01-16 06:00:00 | ES | Futures | 6160.24 | 6162.04 | 6154.6 | 6159.73 | 11502.0 |
| 2025-01-16 07:00:00 | ES | Futures | 6159.98 | 6160.5 | 6141.78 | 6143.32 | 24013.0 |
| 2025-01-16 08:00:00 | ES | Futures | 6143.58 | 6152.04 | 6139.47 | 6149.22 | 50907.0 |
| 2025-01-16 09:00:00 | ES | Futures | 6149.22 | 6156.4 | 6133.06 | 6134.6 | 186811.0 |
| 2025-01-16 10:00:00 | ES | Futures | 6134.35 | 6147.93 | 6125.63 | 6147.68 | 268218.0 |
| 2025-01-16 11:00:00 | ES | Futures | 6147.68 | 6157.42 | 6130.76 | 6147.93 | 200595.0 |
| 2025-01-16 12:00:00 | ES | Futures | 6147.93 | 6151.52 | 6140.5 | 6142.29 | 114692.0 |
| 2025-01-16 13:00:00 | ES | Futures | 6142.55 | 6148.45 | 6121.27 | 6125.89 | 133690.0 |
| 2025-01-16 14:00:00 | ES | Futures | 6125.89 | 6143.83 | 6122.55 | 6142.04 | 118680.0 |
| 2025-01-16 15:00:00 | ES | Futures | 6142.29 | 6146.4 | 6126.4 | 6128.71 | 208481.0 |
| 2025-01-16 16:00:00 | ES | Futures | 6128.96 | 6129.48 | 6113.84 | 6121.78 | 57122.0 |
| 2025-01-16 18:00:00 | ES | Futures | 6122.55 | 6127.17 | 6120.25 | 6126.91 | 6465.0 |
| 2025-01-16 19:00:00 | ES | Futures | 6126.66 | 6127.94 | 6124.35 | 6127.68 | 5226.0 |
| 2025-01-16 20:00:00 | ES | Futures | 6127.68 | 6136.65 | 6127.17 | 6134.35 | 6357.0 |
| 2025-01-16 21:00:00 | ES | Futures | 6134.6 | 6138.19 | 6129.99 | 6131.53 | 4570.0 |
| 2025-01-16 22:00:00 | ES | Futures | 6131.53 | 6137.42 | 6129.48 | 6137.17 | 3333.0 |
| 2025-01-16 23:00:00 | ES | Futures | 6136.91 | 6142.29 | 6136.65 | 6138.71 | 4781.0 |
| 2025-01-16 00:00:00 | NQ | Futures | 22018.58 | 22019.35 | 21982.04 | 21994.65 | 5171.0 |
| 2025-01-16 01:00:00 | NQ | Futures | 21994.13 | 22087.29 | 21980.49 | 22070.82 | 10896.0 |
| 2025-01-16 02:00:00 | NQ | Futures | 22070.57 | 22193.58 | 22062.33 | 22188.95 | 13186.0 |
| 2025-01-16 03:00:00 | NQ | Futures | 22188.69 | 22201.04 | 22135.93 | 22172.48 | 12479.0 |
| 2025-01-16 04:00:00 | NQ | Futures | 22171.96 | 22180.71 | 22084.98 | 22105.05 | 12285.0 |
| 2025-01-16 05:00:00 | NQ | Futures | 22105.57 | 22144.68 | 22075.2 | 22129.76 | 8141.0 |
| 2025-01-16 06:00:00 | NQ | Futures | 22130.53 | 22150.6 | 22115.09 | 22139.02 | 5946.0 |
| 2025-01-16 07:00:00 | NQ | Futures | 22139.53 | 22142.11 | 22060.27 | 22069.79 | 11498.0 |
| 2025-01-16 08:00:00 | NQ | Futures | 22070.57 | 22115.86 | 22049.46 | 22105.57 | 20099.0 |
| 2025-01-16 09:00:00 | NQ | Futures | 22105.05 | 22132.07 | 21997.48 | 22007.0 | 76215.0 |
| 2025-01-16 10:00:00 | NQ | Futures | 22005.71 | 22056.93 | 21963.25 | 22054.35 | 92449.0 |
| 2025-01-16 11:00:00 | NQ | Futures | 22054.35 | 22105.82 | 21943.95 | 22029.65 | 75220.0 |
| 2025-01-16 12:00:00 | NQ | Futures | 22029.13 | 22055.64 | 21997.22 | 22013.95 | 39650.0 |
| 2025-01-16 13:00:00 | NQ | Futures | 22014.98 | 22042.52 | 21887.08 | 21916.16 | 50948.0 |
| 2025-01-16 14:00:00 | NQ | Futures | 21915.64 | 22009.06 | 21902.52 | 22002.63 | 43678.0 |
| 2025-01-16 15:00:00 | NQ | Futures | 22002.63 | 22024.5 | 21867.78 | 21872.41 | 63848.0 |
| 2025-01-16 16:00:00 | NQ | Futures | 21872.15 | 21874.73 | 21794.43 | 21837.67 | 24248.0 |
| 2025-01-16 18:00:00 | NQ | Futures | 21851.31 | 21863.66 | 21832.52 | 21859.03 | 4464.0 |
| 2025-01-16 19:00:00 | NQ | Futures | 21857.48 | 21866.23 | 21850.79 | 21864.17 | 2852.0 |
| 2025-01-16 20:00:00 | NQ | Futures | 21864.69 | 21899.43 | 21862.63 | 21890.17 | 3594.0 |
| 2025-01-16 21:00:00 | NQ | Futures | 21890.68 | 21909.21 | 21873.7 | 21882.7 | 3141.0 |
| 2025-01-16 22:00:00 | NQ | Futures | 21882.96 | 21908.44 | 21870.86 | 21906.38 | 3157.0 |
| 2025-01-16 23:00:00 | NQ | Futures | 21905.86 | 21933.66 | 21903.29 | 21914.61 | 3811.0 |
| 2025-01-16 00:00:00 | YM | Futures | 44771.0 | 44772.0 | 44728.8 | 44741.2 | 529.0 |
| 2025-01-16 01:00:00 | YM | Futures | 44743.2 | 44798.8 | 44738.1 | 44778.2 | 1816.0 |
| 2025-01-16 02:00:00 | YM | Futures | 44775.1 | 44843.1 | 44765.9 | 44821.5 | 2776.0 |
| 2025-01-16 03:00:00 | YM | Futures | 44820.4 | 44833.8 | 44713.4 | 44717.5 | 2188.0 |
> showing 50 of 2,116 rows — these rows as CSV