PREVIEW / futures_30min / 2023-07-05
file: by_date/futures_30min/2023/2023-07-05.parquet size: 106 KB rows: 3,744
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 |
|---|---|---|---|---|---|---|---|
| 2023-07-05 00:00:00 | ES | Futures | 4929.13 | 4929.13 | 4928.03 | 4928.58 | 1561.0 |
| 2023-07-05 00:30:00 | ES | Futures | 4928.85 | 4929.13 | 4927.75 | 4928.3 | 1425.0 |
| 2023-07-05 01:00:00 | ES | Futures | 4928.3 | 4929.13 | 4927.75 | 4928.85 | 1928.0 |
| 2023-07-05 01:30:00 | ES | Futures | 4928.85 | 4929.68 | 4928.03 | 4928.3 | 1676.0 |
| 2023-07-05 02:00:00 | ES | Futures | 4928.03 | 4928.85 | 4923.36 | 4923.91 | 6359.0 |
| 2023-07-05 02:30:00 | ES | Futures | 4923.91 | 4924.46 | 4918.42 | 4918.97 | 7270.0 |
| 2023-07-05 03:00:00 | ES | Futures | 4919.24 | 4923.64 | 4917.87 | 4920.62 | 15136.0 |
| 2023-07-05 03:30:00 | ES | Futures | 4920.62 | 4922.54 | 4919.24 | 4920.62 | 7978.0 |
| 2023-07-05 04:00:00 | ES | Futures | 4920.62 | 4922.81 | 4918.42 | 4921.44 | 8699.0 |
| 2023-07-05 04:30:00 | ES | Futures | 4921.17 | 4921.71 | 4918.15 | 4919.24 | 7122.0 |
| 2023-07-05 05:00:00 | ES | Futures | 4919.24 | 4919.79 | 4911.83 | 4912.11 | 12554.0 |
| 2023-07-05 05:30:00 | ES | Futures | 4912.11 | 4913.48 | 4905.52 | 4910.19 | 17881.0 |
| 2023-07-05 06:00:00 | ES | Futures | 4909.91 | 4912.38 | 4908.54 | 4912.38 | 7386.0 |
| 2023-07-05 06:30:00 | ES | Futures | 4912.38 | 4914.03 | 4911.83 | 4912.66 | 6938.0 |
| 2023-07-05 07:00:00 | ES | Futures | 4912.66 | 4913.21 | 4909.36 | 4909.91 | 7838.0 |
| 2023-07-05 07:30:00 | ES | Futures | 4909.91 | 4911.56 | 4906.89 | 4907.17 | 10205.0 |
| 2023-07-05 08:00:00 | ES | Futures | 4907.17 | 4907.99 | 4904.15 | 4907.44 | 14157.0 |
| 2023-07-05 08:30:00 | ES | Futures | 4907.44 | 4907.99 | 4904.97 | 4906.34 | 10777.0 |
| 2023-07-05 09:00:00 | ES | Futures | 4906.62 | 4911.01 | 4905.79 | 4909.64 | 17441.0 |
| 2023-07-05 09:30:00 | ES | Futures | 4909.64 | 4925.56 | 4909.36 | 4923.91 | 137426.0 |
| 2023-07-05 10:00:00 | ES | Futures | 4924.19 | 4928.85 | 4920.62 | 4927.21 | 83047.0 |
| 2023-07-05 10:30:00 | ES | Futures | 4927.21 | 4931.05 | 4923.09 | 4930.5 | 68429.0 |
| 2023-07-05 11:00:00 | ES | Futures | 4930.5 | 4931.6 | 4925.83 | 4928.03 | 56041.0 |
| 2023-07-05 11:30:00 | ES | Futures | 4928.03 | 4930.5 | 4923.36 | 4925.01 | 46344.0 |
| 2023-07-05 12:00:00 | ES | Futures | 4924.73 | 4925.83 | 4921.71 | 4924.19 | 51323.0 |
| 2023-07-05 12:30:00 | ES | Futures | 4924.19 | 4925.56 | 4918.42 | 4923.09 | 52266.0 |
| 2023-07-05 13:00:00 | ES | Futures | 4923.36 | 4925.83 | 4921.71 | 4923.36 | 28767.0 |
| 2023-07-05 13:30:00 | ES | Futures | 4923.36 | 4925.56 | 4921.44 | 4925.01 | 21260.0 |
| 2023-07-05 14:00:00 | ES | Futures | 4924.73 | 4928.3 | 4913.75 | 4918.15 | 86069.0 |
| 2023-07-05 14:30:00 | ES | Futures | 4918.15 | 4927.48 | 4918.15 | 4926.93 | 52153.0 |
| 2023-07-05 15:00:00 | ES | Futures | 4926.93 | 4930.22 | 4926.38 | 4929.68 | 40169.0 |
| 2023-07-05 15:30:00 | ES | Futures | 4929.68 | 4929.95 | 4922.54 | 4923.09 | 105145.0 |
| 2023-07-05 16:00:00 | ES | Futures | 4923.09 | 4923.91 | 4921.71 | 4922.81 | 31992.0 |
| 2023-07-05 16:30:00 | ES | Futures | 4922.54 | 4923.64 | 4921.17 | 4921.44 | 5102.0 |
| 2023-07-05 18:00:00 | ES | Futures | 4921.17 | 4923.09 | 4920.62 | 4921.71 | 1586.0 |
| 2023-07-05 18:30:00 | ES | Futures | 4921.71 | 4921.99 | 4919.79 | 4920.07 | 1290.0 |
| 2023-07-05 19:00:00 | ES | Futures | 4920.34 | 4922.54 | 4920.07 | 4922.26 | 1268.0 |
| 2023-07-05 19:30:00 | ES | Futures | 4922.54 | 4922.54 | 4918.97 | 4920.07 | 1296.0 |
| 2023-07-05 20:00:00 | ES | Futures | 4919.79 | 4920.34 | 4915.68 | 4918.15 | 4294.0 |
| 2023-07-05 20:30:00 | ES | Futures | 4918.15 | 4918.97 | 4915.4 | 4916.22 | 2657.0 |
| 2023-07-05 21:00:00 | ES | Futures | 4916.22 | 4917.87 | 4915.68 | 4917.6 | 2314.0 |
| 2023-07-05 21:30:00 | ES | Futures | 4917.32 | 4919.52 | 4917.05 | 4918.97 | 2453.0 |
| 2023-07-05 22:00:00 | ES | Futures | 4918.97 | 4920.07 | 4917.6 | 4918.15 | 3648.0 |
| 2023-07-05 22:30:00 | ES | Futures | 4918.15 | 4918.42 | 4915.13 | 4916.22 | 3524.0 |
| 2023-07-05 23:00:00 | ES | Futures | 4916.22 | 4916.5 | 4910.73 | 4911.28 | 5380.0 |
| 2023-07-05 23:30:00 | ES | Futures | 4911.28 | 4912.11 | 4907.44 | 4907.71 | 6383.0 |
| 2023-07-05 00:00:00 | NQ | Futures | 17071.13 | 17071.41 | 17065.29 | 17068.63 | 605.0 |
| 2023-07-05 00:30:00 | NQ | Futures | 17069.19 | 17070.58 | 17065.57 | 17066.96 | 750.0 |
| 2023-07-05 01:00:00 | NQ | Futures | 17067.24 | 17072.8 | 17065.29 | 17071.41 | 1162.0 |
| 2023-07-05 01:30:00 | NQ | Futures | 17071.97 | 17075.03 | 17067.24 | 17068.07 | 929.0 |
> showing 50 of 3,744 rows — these rows as CSV