PREVIEW / futures_30min / 2021-07-07
file: by_date/futures_30min/2021/2021-07-07.parquet size: 104 KB rows: 3,698
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 |
|---|---|---|---|---|---|---|---|
| 2021-07-07 00:00:00 | ES | Futures | 4880.1 | 4881.23 | 4880.1 | 4880.38 | 875.0 |
| 2021-07-07 00:30:00 | ES | Futures | 4880.38 | 4880.95 | 4877.57 | 4878.13 | 2187.0 |
| 2021-07-07 01:00:00 | ES | Futures | 4877.85 | 4878.69 | 4876.44 | 4877.29 | 2840.0 |
| 2021-07-07 01:30:00 | ES | Futures | 4877.29 | 4879.82 | 4877.29 | 4879.26 | 2691.0 |
| 2021-07-07 02:00:00 | ES | Futures | 4879.26 | 4881.51 | 4878.41 | 4879.82 | 4048.0 |
| 2021-07-07 02:30:00 | ES | Futures | 4880.1 | 4882.07 | 4878.41 | 4881.51 | 3023.0 |
| 2021-07-07 03:00:00 | ES | Futures | 4881.51 | 4888.83 | 4881.23 | 4888.83 | 16979.0 |
| 2021-07-07 03:30:00 | ES | Futures | 4888.55 | 4889.68 | 4884.61 | 4887.14 | 9011.0 |
| 2021-07-07 04:00:00 | ES | Futures | 4886.86 | 4891.36 | 4886.58 | 4887.7 | 10138.0 |
| 2021-07-07 04:30:00 | ES | Futures | 4887.7 | 4888.83 | 4884.04 | 4885.73 | 6807.0 |
| 2021-07-07 05:00:00 | ES | Futures | 4886.01 | 4890.8 | 4885.17 | 4889.39 | 6803.0 |
| 2021-07-07 05:30:00 | ES | Futures | 4889.39 | 4891.65 | 4888.55 | 4888.83 | 4224.0 |
| 2021-07-07 06:00:00 | ES | Futures | 4888.83 | 4889.11 | 4885.17 | 4887.42 | 6104.0 |
| 2021-07-07 06:30:00 | ES | Futures | 4887.42 | 4891.08 | 4885.17 | 4890.8 | 6498.0 |
| 2021-07-07 07:00:00 | ES | Futures | 4890.52 | 4892.77 | 4889.11 | 4889.39 | 9432.0 |
| 2021-07-07 07:30:00 | ES | Futures | 4889.39 | 4892.21 | 4889.11 | 4891.36 | 7222.0 |
| 2021-07-07 08:00:00 | ES | Futures | 4891.36 | 4894.46 | 4887.7 | 4889.68 | 14000.0 |
| 2021-07-07 08:30:00 | ES | Futures | 4889.68 | 4889.96 | 4884.04 | 4886.01 | 14039.0 |
| 2021-07-07 09:00:00 | ES | Futures | 4885.73 | 4891.36 | 4885.45 | 4890.8 | 15708.0 |
| 2021-07-07 09:30:00 | ES | Futures | 4890.8 | 4896.71 | 4887.42 | 4891.36 | 116541.0 |
| 2021-07-07 10:00:00 | ES | Futures | 4891.65 | 4892.49 | 4877.85 | 4878.69 | 102606.0 |
| 2021-07-07 10:30:00 | ES | Futures | 4878.69 | 4881.23 | 4866.02 | 4878.98 | 140512.0 |
| 2021-07-07 11:00:00 | ES | Futures | 4879.26 | 4888.55 | 4874.75 | 4888.27 | 81637.0 |
| 2021-07-07 11:30:00 | ES | Futures | 4888.27 | 4896.15 | 4885.45 | 4891.93 | 76060.0 |
| 2021-07-07 12:00:00 | ES | Futures | 4891.93 | 4899.53 | 4891.65 | 4893.62 | 52755.0 |
| 2021-07-07 12:30:00 | ES | Futures | 4893.62 | 4897.56 | 4891.65 | 4894.74 | 35143.0 |
| 2021-07-07 13:00:00 | ES | Futures | 4895.03 | 4895.31 | 4889.96 | 4891.65 | 29008.0 |
| 2021-07-07 13:30:00 | ES | Futures | 4891.65 | 4897.0 | 4890.24 | 4893.05 | 31286.0 |
| 2021-07-07 14:00:00 | ES | Futures | 4893.34 | 4903.19 | 4892.21 | 4896.71 | 83648.0 |
| 2021-07-07 14:30:00 | ES | Futures | 4896.71 | 4900.66 | 4891.36 | 4899.53 | 68924.0 |
| 2021-07-07 15:00:00 | ES | Futures | 4899.81 | 4902.63 | 4898.4 | 4899.81 | 45692.0 |
| 2021-07-07 15:30:00 | ES | Futures | 4900.09 | 4902.63 | 4895.31 | 4899.25 | 106733.0 |
| 2021-07-07 16:00:00 | ES | Futures | 4899.25 | 4900.66 | 4896.71 | 4899.53 | 29891.0 |
| 2021-07-07 16:30:00 | ES | Futures | 4899.25 | 4902.06 | 4899.25 | 4901.5 | 4035.0 |
| 2021-07-07 18:00:00 | ES | Futures | 4902.06 | 4902.06 | 4900.38 | 4900.94 | 1723.0 |
| 2021-07-07 18:30:00 | ES | Futures | 4900.66 | 4901.78 | 4900.09 | 4901.5 | 910.0 |
| 2021-07-07 19:00:00 | ES | Futures | 4901.5 | 4901.78 | 4900.38 | 4901.22 | 1066.0 |
| 2021-07-07 19:30:00 | ES | Futures | 4901.22 | 4901.22 | 4899.25 | 4900.09 | 1657.0 |
| 2021-07-07 20:00:00 | ES | Futures | 4900.09 | 4901.78 | 4898.4 | 4898.69 | 3495.0 |
| 2021-07-07 20:30:00 | ES | Futures | 4898.97 | 4899.81 | 4895.87 | 4897.28 | 2870.0 |
| 2021-07-07 21:00:00 | ES | Futures | 4897.28 | 4897.28 | 4894.18 | 4895.59 | 3846.0 |
| 2021-07-07 21:30:00 | ES | Futures | 4895.87 | 4897.0 | 4891.08 | 4891.08 | 5050.0 |
| 2021-07-07 22:00:00 | ES | Futures | 4891.36 | 4893.05 | 4890.24 | 4890.24 | 3685.0 |
| 2021-07-07 22:30:00 | ES | Futures | 4890.24 | 4891.08 | 4886.01 | 4889.96 | 5819.0 |
| 2021-07-07 23:00:00 | ES | Futures | 4889.96 | 4891.08 | 4887.7 | 4888.55 | 3106.0 |
| 2021-07-07 23:30:00 | ES | Futures | 4888.55 | 4890.24 | 4887.7 | 4889.68 | 2200.0 |
| 2021-07-07 00:00:00 | NQ | Futures | 17136.38 | 17140.44 | 17134.36 | 17134.65 | 693.0 |
| 2021-07-07 00:30:00 | NQ | Futures | 17134.07 | 17136.09 | 17130.88 | 17135.52 | 1096.0 |
| 2021-07-07 01:00:00 | NQ | Futures | 17134.94 | 17136.96 | 17121.9 | 17125.96 | 2136.0 |
| 2021-07-07 01:30:00 | NQ | Futures | 17125.38 | 17134.36 | 17125.09 | 17129.14 | 925.0 |
> showing 50 of 3,698 rows — these rows as CSV