PREVIEW / futures_30min / 2021-08-04
file: by_date/futures_30min/2021/2021-08-04.parquet size: 102 KB rows: 3,709
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-08-04 00:00:00 | ES | Futures | 4967.67 | 4968.8 | 4967.39 | 4967.96 | 951.0 |
| 2021-08-04 00:30:00 | ES | Futures | 4967.67 | 4969.36 | 4967.67 | 4968.8 | 988.0 |
| 2021-08-04 01:00:00 | ES | Futures | 4969.08 | 4969.36 | 4967.11 | 4968.52 | 1827.0 |
| 2021-08-04 01:30:00 | ES | Futures | 4968.8 | 4971.05 | 4967.96 | 4970.49 | 2793.0 |
| 2021-08-04 02:00:00 | ES | Futures | 4970.49 | 4972.46 | 4968.8 | 4972.18 | 3592.0 |
| 2021-08-04 02:30:00 | ES | Futures | 4972.18 | 4972.74 | 4970.77 | 4971.05 | 3307.0 |
| 2021-08-04 03:00:00 | ES | Futures | 4971.33 | 4972.74 | 4969.36 | 4970.49 | 8829.0 |
| 2021-08-04 03:30:00 | ES | Futures | 4970.49 | 4971.62 | 4965.42 | 4965.98 | 5369.0 |
| 2021-08-04 04:00:00 | ES | Futures | 4965.7 | 4968.52 | 4964.58 | 4967.96 | 8289.0 |
| 2021-08-04 04:30:00 | ES | Futures | 4967.96 | 4969.93 | 4967.39 | 4968.24 | 3987.0 |
| 2021-08-04 05:00:00 | ES | Futures | 4968.24 | 4969.93 | 4967.11 | 4968.24 | 4434.0 |
| 2021-08-04 05:30:00 | ES | Futures | 4967.96 | 4971.05 | 4967.67 | 4968.8 | 3652.0 |
| 2021-08-04 06:00:00 | ES | Futures | 4969.08 | 4970.77 | 4968.24 | 4970.49 | 2366.0 |
| 2021-08-04 06:30:00 | ES | Futures | 4970.21 | 4972.18 | 4969.36 | 4969.93 | 2851.0 |
| 2021-08-04 07:00:00 | ES | Futures | 4969.64 | 4969.93 | 4966.55 | 4967.39 | 7675.0 |
| 2021-08-04 07:30:00 | ES | Futures | 4967.39 | 4967.39 | 4963.45 | 4963.73 | 9250.0 |
| 2021-08-04 08:00:00 | ES | Futures | 4964.01 | 4965.98 | 4956.69 | 4958.66 | 27442.0 |
| 2021-08-04 08:30:00 | ES | Futures | 4958.38 | 4961.48 | 4953.31 | 4957.54 | 29078.0 |
| 2021-08-04 09:00:00 | ES | Futures | 4957.25 | 4959.23 | 4953.59 | 4957.82 | 23681.0 |
| 2021-08-04 09:30:00 | ES | Futures | 4957.82 | 4962.61 | 4954.16 | 4959.79 | 146215.0 |
| 2021-08-04 10:00:00 | ES | Futures | 4959.79 | 4965.14 | 4956.41 | 4957.25 | 90017.0 |
| 2021-08-04 10:30:00 | ES | Futures | 4957.54 | 4960.92 | 4949.09 | 4953.88 | 84984.0 |
| 2021-08-04 11:00:00 | ES | Futures | 4953.59 | 4959.51 | 4950.78 | 4952.19 | 59346.0 |
| 2021-08-04 11:30:00 | ES | Futures | 4952.19 | 4954.72 | 4945.99 | 4953.88 | 70165.0 |
| 2021-08-04 12:00:00 | ES | Futures | 4953.59 | 4957.25 | 4951.34 | 4952.47 | 36316.0 |
| 2021-08-04 12:30:00 | ES | Futures | 4952.47 | 4955.85 | 4951.06 | 4955.28 | 25998.0 |
| 2021-08-04 13:00:00 | ES | Futures | 4955.57 | 4962.04 | 4955.0 | 4958.94 | 32603.0 |
| 2021-08-04 13:30:00 | ES | Futures | 4958.94 | 4960.35 | 4956.13 | 4958.66 | 28364.0 |
| 2021-08-04 14:00:00 | ES | Futures | 4958.66 | 4962.32 | 4958.38 | 4961.2 | 30398.0 |
| 2021-08-04 14:30:00 | ES | Futures | 4961.2 | 4963.45 | 4955.57 | 4956.97 | 47050.0 |
| 2021-08-04 15:00:00 | ES | Futures | 4956.97 | 4958.94 | 4952.75 | 4956.97 | 36958.0 |
| 2021-08-04 15:30:00 | ES | Futures | 4956.97 | 4958.66 | 4948.24 | 4949.09 | 109023.0 |
| 2021-08-04 16:00:00 | ES | Futures | 4948.81 | 4952.19 | 4948.53 | 4950.78 | 37274.0 |
| 2021-08-04 16:30:00 | ES | Futures | 4950.78 | 4952.47 | 4950.22 | 4951.9 | 3738.0 |
| 2021-08-04 18:00:00 | ES | Futures | 4951.62 | 4954.16 | 4949.93 | 4953.88 | 2453.0 |
| 2021-08-04 18:30:00 | ES | Futures | 4953.88 | 4955.0 | 4952.75 | 4954.16 | 2550.0 |
| 2021-08-04 19:00:00 | ES | Futures | 4953.88 | 4954.16 | 4951.62 | 4952.47 | 1136.0 |
| 2021-08-04 19:30:00 | ES | Futures | 4952.47 | 4953.59 | 4951.62 | 4953.03 | 1325.0 |
| 2021-08-04 20:00:00 | ES | Futures | 4953.03 | 4961.2 | 4952.75 | 4960.63 | 6579.0 |
| 2021-08-04 20:30:00 | ES | Futures | 4960.92 | 4962.04 | 4958.66 | 4959.79 | 2800.0 |
| 2021-08-04 21:00:00 | ES | Futures | 4959.51 | 4959.79 | 4956.69 | 4958.94 | 3275.0 |
| 2021-08-04 21:30:00 | ES | Futures | 4958.94 | 4959.79 | 4957.82 | 4958.94 | 2786.0 |
| 2021-08-04 22:00:00 | ES | Futures | 4958.66 | 4960.92 | 4958.1 | 4959.79 | 1771.0 |
| 2021-08-04 22:30:00 | ES | Futures | 4959.79 | 4960.35 | 4956.41 | 4957.54 | 1804.0 |
| 2021-08-04 23:00:00 | ES | Futures | 4957.82 | 4959.23 | 4957.54 | 4958.66 | 1109.0 |
| 2021-08-04 23:30:00 | ES | Futures | 4958.38 | 4959.51 | 4957.82 | 4958.38 | 1149.0 |
| 2021-08-04 00:00:00 | NQ | Futures | 17430.12 | 17434.18 | 17429.54 | 17433.6 | 446.0 |
| 2021-08-04 00:30:00 | NQ | Futures | 17433.89 | 17441.13 | 17433.6 | 17435.05 | 1139.0 |
| 2021-08-04 01:00:00 | NQ | Futures | 17434.76 | 17443.16 | 17430.7 | 17440.84 | 1204.0 |
| 2021-08-04 01:30:00 | NQ | Futures | 17441.71 | 17461.41 | 17439.68 | 17455.61 | 2782.0 |
> showing 50 of 3,709 rows — these rows as CSV