PREVIEW / futures_30min / 2010-08-05
file: by_date/futures_30min/2010/2010-08-05.parquet size: 69 KB rows: 2,520
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-05 00:00:00 | ES | Futures | 1101.75 | 1102.74 | 1101.75 | 1102.74 | 1387.0 |
| 2010-08-05 00:30:00 | ES | Futures | 1102.74 | 1102.98 | 1102.24 | 1102.74 | 814.0 |
| 2010-08-05 01:00:00 | ES | Futures | 1102.49 | 1103.72 | 1102.49 | 1103.47 | 1083.0 |
| 2010-08-05 01:30:00 | ES | Futures | 1103.47 | 1104.21 | 1103.23 | 1103.96 | 2308.0 |
| 2010-08-05 02:00:00 | ES | Futures | 1103.96 | 1104.21 | 1102.49 | 1102.49 | 3878.0 |
| 2010-08-05 02:30:00 | ES | Futures | 1102.49 | 1102.74 | 1101.75 | 1102.0 | 3799.0 |
| 2010-08-05 03:00:00 | ES | Futures | 1102.0 | 1102.74 | 1101.26 | 1101.51 | 11618.0 |
| 2010-08-05 03:30:00 | ES | Futures | 1101.51 | 1102.49 | 1101.26 | 1102.24 | 7528.0 |
| 2010-08-05 04:00:00 | ES | Futures | 1102.24 | 1102.49 | 1101.26 | 1101.75 | 6407.0 |
| 2010-08-05 04:30:00 | ES | Futures | 1101.51 | 1104.21 | 1101.51 | 1103.47 | 8939.0 |
| 2010-08-05 05:00:00 | ES | Futures | 1103.47 | 1104.7 | 1103.23 | 1104.7 | 6835.0 |
| 2010-08-05 05:30:00 | ES | Futures | 1104.7 | 1104.7 | 1103.72 | 1103.96 | 4125.0 |
| 2010-08-05 06:00:00 | ES | Futures | 1103.96 | 1105.19 | 1103.72 | 1104.94 | 9311.0 |
| 2010-08-05 06:30:00 | ES | Futures | 1104.94 | 1106.66 | 1104.7 | 1106.17 | 10845.0 |
| 2010-08-05 07:00:00 | ES | Futures | 1106.17 | 1106.91 | 1104.7 | 1105.19 | 12755.0 |
| 2010-08-05 07:30:00 | ES | Futures | 1105.19 | 1105.43 | 1103.47 | 1103.96 | 12433.0 |
| 2010-08-05 08:00:00 | ES | Futures | 1103.96 | 1104.7 | 1101.75 | 1103.72 | 24478.0 |
| 2010-08-05 08:30:00 | ES | Futures | 1103.47 | 1103.47 | 1097.58 | 1098.81 | 87403.0 |
| 2010-08-05 09:00:00 | ES | Futures | 1098.56 | 1099.05 | 1096.36 | 1096.6 | 46818.0 |
| 2010-08-05 09:30:00 | ES | Futures | 1096.6 | 1100.53 | 1094.88 | 1099.3 | 208751.0 |
| 2010-08-05 10:00:00 | ES | Futures | 1099.3 | 1101.51 | 1098.32 | 1101.02 | 123414.0 |
| 2010-08-05 10:30:00 | ES | Futures | 1101.26 | 1102.0 | 1096.85 | 1097.09 | 95172.0 |
| 2010-08-05 11:00:00 | ES | Futures | 1097.34 | 1099.3 | 1095.86 | 1098.81 | 93885.0 |
| 2010-08-05 11:30:00 | ES | Futures | 1098.81 | 1100.04 | 1097.34 | 1098.56 | 68226.0 |
| 2010-08-05 12:00:00 | ES | Futures | 1098.32 | 1100.28 | 1097.83 | 1099.3 | 40542.0 |
| 2010-08-05 12:30:00 | ES | Futures | 1099.55 | 1100.04 | 1098.32 | 1098.81 | 27084.0 |
| 2010-08-05 13:00:00 | ES | Futures | 1098.81 | 1099.3 | 1097.09 | 1098.81 | 32210.0 |
| 2010-08-05 13:30:00 | ES | Futures | 1098.81 | 1101.51 | 1098.81 | 1100.53 | 49654.0 |
| 2010-08-05 14:00:00 | ES | Futures | 1100.77 | 1101.26 | 1099.79 | 1100.53 | 34210.0 |
| 2010-08-05 14:30:00 | ES | Futures | 1100.77 | 1101.26 | 1100.04 | 1100.53 | 38112.0 |
| 2010-08-05 15:00:00 | ES | Futures | 1100.77 | 1103.23 | 1100.53 | 1101.75 | 66084.0 |
| 2010-08-05 15:30:00 | ES | Futures | 1101.75 | 1102.74 | 1100.04 | 1102.49 | 102831.0 |
| 2010-08-05 16:00:00 | ES | Futures | 1102.49 | 1103.23 | 1102.24 | 1102.98 | 59585.0 |
| 2010-08-05 16:30:00 | ES | Futures | 1102.74 | 1103.96 | 1102.74 | 1103.47 | 3737.0 |
| 2010-08-05 17:00:00 | ES | Futures | 1103.47 | 1103.72 | 1103.47 | 1103.47 | 833.0 |
| 2010-08-05 18:00:00 | ES | Futures | 1103.47 | 1103.96 | 1103.23 | 1103.23 | 697.0 |
| 2010-08-05 18:30:00 | ES | Futures | 1103.23 | 1103.47 | 1102.98 | 1102.98 | 172.0 |
| 2010-08-05 19:00:00 | ES | Futures | 1102.98 | 1103.23 | 1102.49 | 1102.98 | 772.0 |
| 2010-08-05 19:30:00 | ES | Futures | 1102.98 | 1102.98 | 1102.74 | 1102.74 | 709.0 |
| 2010-08-05 20:00:00 | ES | Futures | 1102.74 | 1102.98 | 1102.0 | 1102.74 | 3274.0 |
| 2010-08-05 20:30:00 | ES | Futures | 1102.49 | 1102.98 | 1102.24 | 1102.24 | 1491.0 |
| 2010-08-05 21:00:00 | ES | Futures | 1102.24 | 1102.74 | 1102.24 | 1102.49 | 1326.0 |
| 2010-08-05 21:30:00 | ES | Futures | 1102.24 | 1103.47 | 1102.24 | 1103.23 | 1374.0 |
| 2010-08-05 22:00:00 | ES | Futures | 1103.23 | 1103.47 | 1102.24 | 1102.49 | 1994.0 |
| 2010-08-05 22:30:00 | ES | Futures | 1102.49 | 1102.74 | 1102.0 | 1102.49 | 807.0 |
| 2010-08-05 23:00:00 | ES | Futures | 1102.24 | 1102.98 | 1102.0 | 1102.98 | 1615.0 |
| 2010-08-05 23:30:00 | ES | Futures | 1102.74 | 1104.7 | 1102.74 | 1104.45 | 2919.0 |
| 2010-08-05 00:00:00 | NQ | Futures | 2182.2 | 2182.77 | 2181.63 | 2182.77 | 89.0 |
| 2010-08-05 00:30:00 | NQ | Futures | 2183.06 | 2183.63 | 2182.49 | 2183.63 | 13.0 |
| 2010-08-05 01:00:00 | NQ | Futures | 2183.06 | 2185.93 | 2183.06 | 2185.64 | 39.0 |
> showing 50 of 2,520 rows — these rows as CSV