PREVIEW / futures_30min / 2023-06-30
file: by_date/futures_30min/2023/2023-06-30.parquet size: 94 KB rows: 3,127
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-06-30 00:00:00 | ES | Futures | 4872.3 | 4872.85 | 4871.2 | 4872.58 | 1561.0 |
| 2023-06-30 00:30:00 | ES | Futures | 4872.58 | 4873.13 | 4872.03 | 4872.85 | 1198.0 |
| 2023-06-30 01:00:00 | ES | Futures | 4872.85 | 4876.97 | 4872.85 | 4876.42 | 2855.0 |
| 2023-06-30 01:30:00 | ES | Futures | 4876.42 | 4878.62 | 4875.6 | 4876.7 | 3882.0 |
| 2023-06-30 02:00:00 | ES | Futures | 4876.7 | 4876.7 | 4872.58 | 4873.13 | 4753.0 |
| 2023-06-30 02:30:00 | ES | Futures | 4873.13 | 4874.22 | 4871.48 | 4871.75 | 2562.0 |
| 2023-06-30 03:00:00 | ES | Futures | 4871.75 | 4873.95 | 4870.66 | 4873.13 | 7436.0 |
| 2023-06-30 03:30:00 | ES | Futures | 4873.13 | 4876.7 | 4871.48 | 4875.87 | 5065.0 |
| 2023-06-30 04:00:00 | ES | Futures | 4875.87 | 4878.89 | 4875.6 | 4876.97 | 7019.0 |
| 2023-06-30 04:30:00 | ES | Futures | 4876.97 | 4882.73 | 4876.7 | 4881.64 | 6506.0 |
| 2023-06-30 05:00:00 | ES | Futures | 4881.91 | 4886.03 | 4881.36 | 4886.03 | 8271.0 |
| 2023-06-30 05:30:00 | ES | Futures | 4885.75 | 4887.68 | 4884.66 | 4885.48 | 9430.0 |
| 2023-06-30 06:00:00 | ES | Futures | 4885.48 | 4889.05 | 4884.93 | 4887.68 | 9049.0 |
| 2023-06-30 06:30:00 | ES | Futures | 4887.68 | 4893.17 | 4887.13 | 4889.87 | 10992.0 |
| 2023-06-30 07:00:00 | ES | Futures | 4889.87 | 4891.79 | 4887.68 | 4887.95 | 7903.0 |
| 2023-06-30 07:30:00 | ES | Futures | 4887.95 | 4889.05 | 4886.03 | 4887.68 | 11825.0 |
| 2023-06-30 08:00:00 | ES | Futures | 4887.68 | 4891.79 | 4887.68 | 4890.15 | 18403.0 |
| 2023-06-30 08:30:00 | ES | Futures | 4890.15 | 4904.15 | 4889.87 | 4901.95 | 44296.0 |
| 2023-06-30 09:00:00 | ES | Futures | 4902.22 | 4909.09 | 4901.95 | 4906.34 | 39379.0 |
| 2023-06-30 09:30:00 | ES | Futures | 4906.34 | 4920.07 | 4902.77 | 4916.77 | 160564.0 |
| 2023-06-30 10:00:00 | ES | Futures | 4916.77 | 4927.48 | 4916.22 | 4923.91 | 122620.0 |
| 2023-06-30 10:30:00 | ES | Futures | 4923.91 | 4927.48 | 4913.21 | 4920.34 | 115669.0 |
| 2023-06-30 11:00:00 | ES | Futures | 4920.34 | 4925.28 | 4918.42 | 4920.62 | 77160.0 |
| 2023-06-30 11:30:00 | ES | Futures | 4920.34 | 4920.62 | 4912.66 | 4917.6 | 83566.0 |
| 2023-06-30 12:00:00 | ES | Futures | 4917.87 | 4924.73 | 4915.68 | 4924.73 | 64618.0 |
| 2023-06-30 12:30:00 | ES | Futures | 4924.73 | 4930.77 | 4923.91 | 4929.68 | 55434.0 |
| 2023-06-30 13:00:00 | ES | Futures | 4929.68 | 4930.77 | 4926.93 | 4929.95 | 43257.0 |
| 2023-06-30 13:30:00 | ES | Futures | 4929.95 | 4934.62 | 4929.13 | 4933.24 | 52562.0 |
| 2023-06-30 14:00:00 | ES | Futures | 4933.24 | 4936.81 | 4931.05 | 4936.26 | 50875.0 |
| 2023-06-30 14:30:00 | ES | Futures | 4936.26 | 4936.54 | 4931.05 | 4934.07 | 57612.0 |
| 2023-06-30 15:00:00 | ES | Futures | 4934.34 | 4937.36 | 4931.05 | 4935.71 | 69857.0 |
| 2023-06-30 15:30:00 | ES | Futures | 4935.71 | 4939.01 | 4925.28 | 4926.11 | 292827.0 |
| 2023-06-30 16:00:00 | ES | Futures | 4926.38 | 4928.03 | 4920.07 | 4921.44 | 114191.0 |
| 2023-06-30 16:30:00 | ES | Futures | 4921.44 | 4923.36 | 4920.62 | 4921.99 | 22948.0 |
| 2023-06-30 00:00:00 | NQ | Futures | 16824.43 | 16829.99 | 16822.21 | 16829.99 | 748.0 |
| 2023-06-30 00:30:00 | NQ | Futures | 16829.44 | 16831.94 | 16826.66 | 16829.72 | 469.0 |
| 2023-06-30 01:00:00 | NQ | Futures | 16831.11 | 16852.52 | 16831.11 | 16849.74 | 1687.0 |
| 2023-06-30 01:30:00 | NQ | Futures | 16849.46 | 16860.59 | 16840.84 | 16846.96 | 2160.0 |
| 2023-06-30 02:00:00 | NQ | Futures | 16846.96 | 16848.07 | 16831.11 | 16834.72 | 2260.0 |
| 2023-06-30 02:30:00 | NQ | Futures | 16833.89 | 16837.5 | 16823.32 | 16828.32 | 1447.0 |
| 2023-06-30 03:00:00 | NQ | Futures | 16828.05 | 16846.4 | 16822.21 | 16836.95 | 3333.0 |
| 2023-06-30 03:30:00 | NQ | Futures | 16837.22 | 16850.3 | 16827.49 | 16846.4 | 2147.0 |
| 2023-06-30 04:00:00 | NQ | Futures | 16846.68 | 16864.48 | 16845.57 | 16850.3 | 3456.0 |
| 2023-06-30 04:30:00 | NQ | Futures | 16850.3 | 16876.16 | 16849.18 | 16871.44 | 2523.0 |
| 2023-06-30 05:00:00 | NQ | Futures | 16871.71 | 16885.9 | 16868.1 | 16885.62 | 3105.0 |
| 2023-06-30 05:30:00 | NQ | Futures | 16884.79 | 16888.68 | 16876.44 | 16877.83 | 2367.0 |
| 2023-06-30 06:00:00 | NQ | Futures | 16876.72 | 16882.56 | 16869.49 | 16873.38 | 2391.0 |
| 2023-06-30 06:30:00 | NQ | Futures | 16874.22 | 16893.69 | 16869.49 | 16882.56 | 3184.0 |
| 2023-06-30 07:00:00 | NQ | Futures | 16881.73 | 16893.13 | 16874.49 | 16878.11 | 2783.0 |
| 2023-06-30 07:30:00 | NQ | Futures | 16877.83 | 16884.23 | 16871.71 | 16878.39 | 2754.0 |
> showing 50 of 3,127 rows — these rows as CSV