PREVIEW / futures_1hour / 2024-09-05
file: by_date/futures_1hour/2024/2024-09-05.parquet size: 65 KB rows: 2,043
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-05 00:00:00 | ES | Futures | 5789.89 | 5793.82 | 5789.1 | 5791.73 | 4945.0 |
| 2024-09-05 01:00:00 | ES | Futures | 5791.73 | 5799.07 | 5787.27 | 5795.92 | 7876.0 |
| 2024-09-05 02:00:00 | ES | Futures | 5795.66 | 5798.8 | 5786.48 | 5788.06 | 9098.0 |
| 2024-09-05 03:00:00 | ES | Futures | 5788.32 | 5809.55 | 5785.43 | 5809.03 | 23780.0 |
| 2024-09-05 04:00:00 | ES | Futures | 5808.77 | 5809.29 | 5803.52 | 5805.62 | 11123.0 |
| 2024-09-05 05:00:00 | ES | Futures | 5805.36 | 5805.62 | 5792.25 | 5799.33 | 14129.0 |
| 2024-09-05 06:00:00 | ES | Futures | 5799.07 | 5803.52 | 5796.18 | 5802.74 | 10672.0 |
| 2024-09-05 07:00:00 | ES | Futures | 5802.47 | 5806.67 | 5794.09 | 5795.92 | 16493.0 |
| 2024-09-05 08:00:00 | ES | Futures | 5795.66 | 5803.0 | 5780.19 | 5791.73 | 68463.0 |
| 2024-09-05 09:00:00 | ES | Futures | 5791.73 | 5811.91 | 5790.15 | 5808.77 | 170876.0 |
| 2024-09-05 10:00:00 | ES | Futures | 5807.98 | 5827.64 | 5791.46 | 5791.73 | 279293.0 |
| 2024-09-05 11:00:00 | ES | Futures | 5791.99 | 5793.82 | 5759.74 | 5761.31 | 271687.0 |
| 2024-09-05 12:00:00 | ES | Futures | 5761.31 | 5780.45 | 5757.12 | 5774.42 | 143408.0 |
| 2024-09-05 13:00:00 | ES | Futures | 5774.42 | 5795.66 | 5763.94 | 5795.13 | 140063.0 |
| 2024-09-05 14:00:00 | ES | Futures | 5795.13 | 5800.38 | 5786.48 | 5789.63 | 132928.0 |
| 2024-09-05 15:00:00 | ES | Futures | 5789.63 | 5790.94 | 5767.61 | 5783.34 | 249845.0 |
| 2024-09-05 16:00:00 | ES | Futures | 5783.07 | 5791.73 | 5776.78 | 5779.67 | 74090.0 |
| 2024-09-05 18:00:00 | ES | Futures | 5781.24 | 5782.03 | 5774.16 | 5778.36 | 4509.0 |
| 2024-09-05 19:00:00 | ES | Futures | 5778.62 | 5778.88 | 5773.11 | 5778.09 | 3432.0 |
| 2024-09-05 20:00:00 | ES | Futures | 5778.09 | 5778.88 | 5763.41 | 5763.67 | 11758.0 |
| 2024-09-05 21:00:00 | ES | Futures | 5763.94 | 5775.47 | 5755.55 | 5774.16 | 18621.0 |
| 2024-09-05 22:00:00 | ES | Futures | 5774.16 | 5777.57 | 5772.85 | 5776.26 | 5182.0 |
| 2024-09-05 23:00:00 | ES | Futures | 5776.52 | 5779.14 | 5771.28 | 5772.06 | 5952.0 |
| 2024-09-05 00:00:00 | NQ | Futures | 19962.36 | 19985.59 | 19957.61 | 19970.28 | 2755.0 |
| 2024-09-05 01:00:00 | NQ | Futures | 19968.43 | 20010.14 | 19940.18 | 19998.26 | 4831.0 |
| 2024-09-05 02:00:00 | NQ | Futures | 19996.15 | 20013.83 | 19947.31 | 19955.23 | 5483.0 |
| 2024-09-05 03:00:00 | NQ | Futures | 19955.76 | 20064.78 | 19944.14 | 20060.29 | 11128.0 |
| 2024-09-05 04:00:00 | NQ | Futures | 20059.24 | 20061.09 | 20023.34 | 20031.52 | 5849.0 |
| 2024-09-05 05:00:00 | NQ | Futures | 20031.52 | 20032.58 | 19954.7 | 19997.2 | 9091.0 |
| 2024-09-05 06:00:00 | NQ | Futures | 19997.73 | 20015.42 | 19981.89 | 20006.71 | 4835.0 |
| 2024-09-05 07:00:00 | NQ | Futures | 20006.71 | 20027.82 | 19966.32 | 19974.76 | 7238.0 |
| 2024-09-05 08:00:00 | NQ | Futures | 19973.71 | 20000.11 | 19880.26 | 19946.25 | 30071.0 |
| 2024-09-05 09:00:00 | NQ | Futures | 19947.05 | 20126.82 | 19937.28 | 20118.9 | 76532.0 |
| 2024-09-05 10:00:00 | NQ | Futures | 20116.52 | 20221.59 | 20042.08 | 20044.72 | 104635.0 |
| 2024-09-05 11:00:00 | NQ | Futures | 20045.25 | 20053.96 | 19895.83 | 19915.63 | 78778.0 |
| 2024-09-05 12:00:00 | NQ | Futures | 19916.16 | 20024.13 | 19911.67 | 19991.39 | 45305.0 |
| 2024-09-05 13:00:00 | NQ | Futures | 19991.92 | 20078.77 | 19943.35 | 20075.34 | 39760.0 |
| 2024-09-05 14:00:00 | NQ | Futures | 20075.87 | 20105.17 | 20044.72 | 20051.58 | 35872.0 |
| 2024-09-05 15:00:00 | NQ | Futures | 20051.85 | 20060.82 | 19956.29 | 20036.8 | 67448.0 |
| 2024-09-05 16:00:00 | NQ | Futures | 20036.8 | 20096.99 | 19961.3 | 19983.21 | 20926.0 |
| 2024-09-05 18:00:00 | NQ | Futures | 19979.25 | 19992.71 | 19959.45 | 19978.2 | 3141.0 |
| 2024-09-05 19:00:00 | NQ | Futures | 19979.25 | 19981.1 | 19948.37 | 19970.01 | 1847.0 |
| 2024-09-05 20:00:00 | NQ | Futures | 19967.9 | 19973.44 | 19887.39 | 19890.29 | 7643.0 |
| 2024-09-05 21:00:00 | NQ | Futures | 19891.08 | 19936.49 | 19841.98 | 19931.73 | 8610.0 |
| 2024-09-05 22:00:00 | NQ | Futures | 19932.26 | 19954.44 | 19920.65 | 19946.52 | 3600.0 |
| 2024-09-05 23:00:00 | NQ | Futures | 19947.31 | 19964.2 | 19916.95 | 19925.93 | 3523.0 |
| 2024-09-05 00:00:00 | YM | Futures | 43095.6 | 43111.4 | 43087.2 | 43098.8 | 515.0 |
| 2024-09-05 01:00:00 | YM | Futures | 43099.8 | 43131.3 | 43078.8 | 43112.4 | 856.0 |
| 2024-09-05 02:00:00 | YM | Futures | 43114.5 | 43126.1 | 43063.0 | 43072.5 | 1108.0 |
| 2024-09-05 03:00:00 | YM | Futures | 43073.5 | 43204.9 | 43053.6 | 43203.8 | 2377.0 |
> showing 50 of 2,043 rows — these rows as CSV