PREVIEW / futures_1hour / 2024-09-04
file: by_date/futures_1hour/2024/2024-09-04.parquet size: 67 KB rows: 2,069
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-04 00:00:00 | ES | Futures | 5783.34 | 5789.1 | 5778.62 | 5779.67 | 6285.0 |
| 2024-09-04 01:00:00 | ES | Futures | 5779.67 | 5784.12 | 5776.26 | 5778.36 | 12553.0 |
| 2024-09-04 02:00:00 | ES | Futures | 5778.36 | 5788.32 | 5776.0 | 5776.0 | 20740.0 |
| 2024-09-04 03:00:00 | ES | Futures | 5776.26 | 5794.61 | 5774.69 | 5791.46 | 32442.0 |
| 2024-09-04 04:00:00 | ES | Futures | 5791.2 | 5798.54 | 5787.53 | 5791.2 | 24970.0 |
| 2024-09-04 05:00:00 | ES | Futures | 5791.2 | 5799.59 | 5789.1 | 5794.35 | 13511.0 |
| 2024-09-04 06:00:00 | ES | Futures | 5794.61 | 5796.44 | 5786.22 | 5787.01 | 14690.0 |
| 2024-09-04 07:00:00 | ES | Futures | 5786.74 | 5793.82 | 5783.86 | 5787.79 | 22325.0 |
| 2024-09-04 08:00:00 | ES | Futures | 5788.06 | 5798.02 | 5785.17 | 5795.66 | 30908.0 |
| 2024-09-04 09:00:00 | ES | Futures | 5795.66 | 5816.37 | 5789.37 | 5815.32 | 202972.0 |
| 2024-09-04 10:00:00 | ES | Futures | 5815.32 | 5831.31 | 5789.63 | 5830.79 | 328906.0 |
| 2024-09-04 11:00:00 | ES | Futures | 5830.79 | 5835.77 | 5803.0 | 5808.24 | 186670.0 |
| 2024-09-04 12:00:00 | ES | Futures | 5808.24 | 5821.61 | 5800.38 | 5813.49 | 126840.0 |
| 2024-09-04 13:00:00 | ES | Futures | 5813.22 | 5813.49 | 5796.18 | 5799.07 | 99672.0 |
| 2024-09-04 14:00:00 | ES | Futures | 5799.33 | 5807.46 | 5789.1 | 5789.63 | 143840.0 |
| 2024-09-04 15:00:00 | ES | Futures | 5789.63 | 5809.55 | 5783.34 | 5796.97 | 266192.0 |
| 2024-09-04 16:00:00 | ES | Futures | 5797.23 | 5797.76 | 5786.74 | 5796.18 | 69817.0 |
| 2024-09-04 18:00:00 | ES | Futures | 5796.44 | 5801.69 | 5796.18 | 5799.33 | 4720.0 |
| 2024-09-04 19:00:00 | ES | Futures | 5799.33 | 5799.85 | 5783.34 | 5791.99 | 7107.0 |
| 2024-09-04 20:00:00 | ES | Futures | 5791.99 | 5807.19 | 5791.46 | 5803.79 | 10945.0 |
| 2024-09-04 21:00:00 | ES | Futures | 5803.79 | 5807.19 | 5800.64 | 5803.52 | 5178.0 |
| 2024-09-04 22:00:00 | ES | Futures | 5803.52 | 5804.57 | 5797.23 | 5801.43 | 4934.0 |
| 2024-09-04 23:00:00 | ES | Futures | 5801.16 | 5801.95 | 5788.32 | 5790.15 | 8382.0 |
| 2024-09-04 00:00:00 | NQ | Futures | 19937.81 | 19972.92 | 19909.3 | 19921.7 | 3879.0 |
| 2024-09-04 01:00:00 | NQ | Futures | 19921.7 | 19940.18 | 19891.08 | 19910.09 | 5983.0 |
| 2024-09-04 02:00:00 | NQ | Futures | 19909.82 | 19970.28 | 19893.99 | 19898.21 | 10031.0 |
| 2024-09-04 03:00:00 | NQ | Futures | 19898.21 | 19975.56 | 19883.43 | 19957.87 | 12352.0 |
| 2024-09-04 04:00:00 | NQ | Futures | 19956.81 | 19988.49 | 19930.15 | 19965.79 | 9689.0 |
| 2024-09-04 05:00:00 | NQ | Futures | 19965.79 | 20002.22 | 19952.59 | 19980.57 | 6467.0 |
| 2024-09-04 06:00:00 | NQ | Futures | 19981.1 | 19989.81 | 19912.73 | 19916.16 | 6876.0 |
| 2024-09-04 07:00:00 | NQ | Futures | 19916.42 | 19943.88 | 19898.21 | 19928.57 | 8317.0 |
| 2024-09-04 08:00:00 | NQ | Futures | 19929.09 | 19975.56 | 19909.3 | 19968.43 | 13154.0 |
| 2024-09-04 09:00:00 | NQ | Futures | 19967.9 | 20053.43 | 19914.84 | 20033.63 | 73020.0 |
| 2024-09-04 10:00:00 | NQ | Futures | 20034.16 | 20163.78 | 19891.87 | 20159.29 | 108974.0 |
| 2024-09-04 11:00:00 | NQ | Futures | 20159.02 | 20183.84 | 20039.44 | 20071.91 | 66274.0 |
| 2024-09-04 12:00:00 | NQ | Futures | 20071.65 | 20155.33 | 20038.38 | 20132.1 | 43230.0 |
| 2024-09-04 13:00:00 | NQ | Futures | 20131.31 | 20134.47 | 20058.97 | 20068.21 | 35166.0 |
| 2024-09-04 14:00:00 | NQ | Futures | 20068.48 | 20096.2 | 19992.19 | 19996.15 | 43721.0 |
| 2024-09-04 15:00:00 | NQ | Futures | 19996.15 | 20083.26 | 19965.26 | 20017.27 | 66612.0 |
| 2024-09-04 16:00:00 | NQ | Futures | 20017.0 | 20029.67 | 19980.31 | 20025.18 | 16601.0 |
| 2024-09-04 18:00:00 | NQ | Futures | 20026.5 | 20046.83 | 20022.02 | 20036.8 | 2371.0 |
| 2024-09-04 19:00:00 | NQ | Futures | 20036.27 | 20038.38 | 19948.1 | 19989.02 | 5975.0 |
| 2024-09-04 20:00:00 | NQ | Futures | 19989.55 | 20068.21 | 19987.96 | 20053.17 | 5599.0 |
| 2024-09-04 21:00:00 | NQ | Futures | 20053.96 | 20069.01 | 20031.78 | 20046.3 | 3815.0 |
| 2024-09-04 22:00:00 | NQ | Futures | 20045.51 | 20050.53 | 20007.23 | 20027.56 | 4048.0 |
| 2024-09-04 23:00:00 | NQ | Futures | 20027.56 | 20031.52 | 19952.59 | 19962.88 | 5478.0 |
| 2024-09-04 00:00:00 | YM | Futures | 42964.3 | 42995.8 | 42947.4 | 42954.8 | 783.0 |
| 2024-09-04 01:00:00 | YM | Futures | 42954.8 | 42973.7 | 42929.6 | 42943.2 | 1143.0 |
| 2024-09-04 02:00:00 | YM | Futures | 42941.1 | 42995.8 | 42921.2 | 42926.4 | 2656.0 |
| 2024-09-04 03:00:00 | YM | Futures | 42926.4 | 43055.7 | 42926.4 | 43034.7 | 3439.0 |
> showing 50 of 2,069 rows — these rows as CSV