PREVIEW / futures_1hour / 2025-01-27
file: by_date/futures_1hour/2025/2025-01-27.parquet size: 71 KB rows: 2,137
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-27 00:00:00 | ES | Futures | 6229.98 | 6231.26 | 6211.52 | 6214.59 | 16241.0 |
| 2025-01-27 01:00:00 | ES | Futures | 6214.59 | 6215.87 | 6197.42 | 6202.54 | 17686.0 |
| 2025-01-27 02:00:00 | ES | Futures | 6202.8 | 6206.13 | 6181.52 | 6182.8 | 31156.0 |
| 2025-01-27 03:00:00 | ES | Futures | 6183.06 | 6191.78 | 6159.98 | 6171.01 | 53422.0 |
| 2025-01-27 04:00:00 | ES | Futures | 6170.75 | 6174.34 | 6160.5 | 6163.83 | 43606.0 |
| 2025-01-27 05:00:00 | ES | Futures | 6164.09 | 6164.86 | 6099.74 | 6125.89 | 90101.0 |
| 2025-01-27 06:00:00 | ES | Futures | 6125.89 | 6144.6 | 6123.32 | 6134.6 | 62228.0 |
| 2025-01-27 07:00:00 | ES | Futures | 6134.35 | 6159.73 | 6133.32 | 6153.06 | 59369.0 |
| 2025-01-27 08:00:00 | ES | Futures | 6153.06 | 6168.19 | 6146.14 | 6160.75 | 72558.0 |
| 2025-01-27 09:00:00 | ES | Futures | 6160.75 | 6191.78 | 6148.7 | 6191.01 | 295093.0 |
| 2025-01-27 10:00:00 | ES | Futures | 6190.75 | 6202.29 | 6171.01 | 6185.62 | 317750.0 |
| 2025-01-27 11:00:00 | ES | Futures | 6185.62 | 6187.42 | 6166.65 | 6172.8 | 228146.0 |
| 2025-01-27 12:00:00 | ES | Futures | 6173.06 | 6187.42 | 6166.14 | 6166.65 | 175761.0 |
| 2025-01-27 13:00:00 | ES | Futures | 6166.65 | 6179.73 | 6165.11 | 6171.01 | 131727.0 |
| 2025-01-27 14:00:00 | ES | Futures | 6171.27 | 6197.42 | 6168.19 | 6175.37 | 175762.0 |
| 2025-01-27 15:00:00 | ES | Futures | 6175.11 | 6203.06 | 6168.96 | 6201.0 | 328710.0 |
| 2025-01-27 16:00:00 | ES | Futures | 6201.0 | 6211.0 | 6198.44 | 6204.59 | 74989.0 |
| 2025-01-27 18:00:00 | ES | Futures | 6214.08 | 6214.08 | 6191.01 | 6206.9 | 27310.0 |
| 2025-01-27 19:00:00 | ES | Futures | 6206.9 | 6208.7 | 6193.31 | 6197.93 | 9906.0 |
| 2025-01-27 20:00:00 | ES | Futures | 6198.18 | 6207.16 | 6187.42 | 6189.21 | 12408.0 |
| 2025-01-27 21:00:00 | ES | Futures | 6189.21 | 6203.83 | 6186.14 | 6198.18 | 10260.0 |
| 2025-01-27 22:00:00 | ES | Futures | 6198.18 | 6205.88 | 6196.9 | 6197.93 | 5538.0 |
| 2025-01-27 23:00:00 | ES | Futures | 6197.67 | 6201.77 | 6195.88 | 6201.26 | 4228.0 |
| 2025-01-27 00:00:00 | NQ | Futures | 22128.98 | 22138.76 | 22040.2 | 22062.07 | 13702.0 |
| 2025-01-27 01:00:00 | NQ | Futures | 22063.1 | 22070.05 | 21984.61 | 22017.04 | 13069.0 |
| 2025-01-27 02:00:00 | NQ | Futures | 22017.3 | 22041.23 | 21908.18 | 21909.47 | 20816.0 |
| 2025-01-27 03:00:00 | NQ | Futures | 21910.24 | 21938.8 | 21816.05 | 21866.75 | 37742.0 |
| 2025-01-27 04:00:00 | NQ | Futures | 21867.0 | 21894.03 | 21776.68 | 21786.2 | 31696.0 |
| 2025-01-27 05:00:00 | NQ | Futures | 21786.2 | 21792.12 | 21373.93 | 21500.54 | 61632.0 |
| 2025-01-27 06:00:00 | NQ | Futures | 21501.57 | 21650.58 | 21491.54 | 21617.12 | 37512.0 |
| 2025-01-27 07:00:00 | NQ | Futures | 21616.09 | 21726.75 | 21613.0 | 21704.1 | 26983.0 |
| 2025-01-27 08:00:00 | NQ | Futures | 21702.56 | 21797.01 | 21651.86 | 21781.82 | 39465.0 |
| 2025-01-27 09:00:00 | NQ | Futures | 21780.28 | 21968.14 | 21723.15 | 21961.19 | 127889.0 |
| 2025-01-27 10:00:00 | NQ | Futures | 21960.94 | 22047.92 | 21851.82 | 21937.78 | 131674.0 |
| 2025-01-27 11:00:00 | NQ | Futures | 21938.29 | 21952.96 | 21808.07 | 21832.52 | 99506.0 |
| 2025-01-27 12:00:00 | NQ | Futures | 21833.81 | 21892.22 | 21761.49 | 21763.55 | 62982.0 |
| 2025-01-27 13:00:00 | NQ | Futures | 21763.81 | 21840.5 | 21759.95 | 21772.3 | 50706.0 |
| 2025-01-27 14:00:00 | NQ | Futures | 21773.33 | 21885.28 | 21714.91 | 21754.03 | 70187.0 |
| 2025-01-27 15:00:00 | NQ | Futures | 21754.03 | 21889.91 | 21748.37 | 21882.7 | 95229.0 |
| 2025-01-27 16:00:00 | NQ | Futures | 21883.22 | 21956.82 | 21875.24 | 21930.57 | 26362.0 |
| 2025-01-27 18:00:00 | NQ | Futures | 21970.46 | 21985.13 | 21869.06 | 21953.47 | 11768.0 |
| 2025-01-27 19:00:00 | NQ | Futures | 21953.73 | 21968.14 | 21894.8 | 21911.53 | 5743.0 |
| 2025-01-27 20:00:00 | NQ | Futures | 21911.01 | 21953.99 | 21851.82 | 21862.12 | 6989.0 |
| 2025-01-27 21:00:00 | NQ | Futures | 21860.31 | 21935.2 | 21842.56 | 21916.93 | 5652.0 |
| 2025-01-27 22:00:00 | NQ | Futures | 21917.19 | 21958.62 | 21908.44 | 21915.39 | 4631.0 |
| 2025-01-27 23:00:00 | NQ | Futures | 21914.87 | 21931.34 | 21900.97 | 21928.0 | 3201.0 |
| 2025-01-27 00:00:00 | YM | Futures | 45726.2 | 45733.4 | 45627.4 | 45645.9 | 1785.0 |
| 2025-01-27 01:00:00 | YM | Futures | 45648.0 | 45655.2 | 45505.9 | 45538.8 | 2518.0 |
| 2025-01-27 02:00:00 | YM | Futures | 45540.9 | 45569.7 | 45443.1 | 45445.2 | 3685.0 |
| 2025-01-27 03:00:00 | YM | Futures | 45447.2 | 45529.6 | 45297.0 | 45384.5 | 7304.0 |
> showing 50 of 2,137 rows — these rows as CSV