PREVIEW / futures_30min / 2010-08-18
file: by_date/futures_30min/2010/2010-08-18.parquet size: 68 KB rows: 2,466
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-18 00:00:00 | ES | Futures | 1066.91 | 1068.63 | 1066.66 | 1068.38 | 2964.0 |
| 2010-08-18 00:30:00 | ES | Futures | 1068.38 | 1068.63 | 1067.89 | 1067.89 | 1032.0 |
| 2010-08-18 01:00:00 | ES | Futures | 1067.89 | 1069.61 | 1067.65 | 1069.12 | 2888.0 |
| 2010-08-18 01:30:00 | ES | Futures | 1068.87 | 1069.12 | 1067.4 | 1067.89 | 1835.0 |
| 2010-08-18 02:00:00 | ES | Futures | 1067.89 | 1068.63 | 1067.65 | 1068.63 | 3497.0 |
| 2010-08-18 02:30:00 | ES | Futures | 1068.87 | 1069.61 | 1068.14 | 1068.38 | 4827.0 |
| 2010-08-18 03:00:00 | ES | Futures | 1068.63 | 1068.87 | 1067.16 | 1068.14 | 11096.0 |
| 2010-08-18 03:30:00 | ES | Futures | 1068.14 | 1068.14 | 1064.46 | 1065.44 | 17861.0 |
| 2010-08-18 04:00:00 | ES | Futures | 1065.19 | 1067.16 | 1065.19 | 1066.17 | 7762.0 |
| 2010-08-18 04:30:00 | ES | Futures | 1066.17 | 1067.4 | 1065.44 | 1066.42 | 8333.0 |
| 2010-08-18 05:00:00 | ES | Futures | 1066.42 | 1070.1 | 1066.17 | 1069.12 | 19225.0 |
| 2010-08-18 05:30:00 | ES | Futures | 1069.12 | 1069.85 | 1067.89 | 1069.61 | 13476.0 |
| 2010-08-18 06:00:00 | ES | Futures | 1069.36 | 1069.36 | 1067.16 | 1067.4 | 7697.0 |
| 2010-08-18 06:30:00 | ES | Futures | 1067.4 | 1069.12 | 1067.16 | 1067.4 | 6105.0 |
| 2010-08-18 07:00:00 | ES | Futures | 1067.4 | 1068.63 | 1067.4 | 1067.89 | 7635.0 |
| 2010-08-18 07:30:00 | ES | Futures | 1068.14 | 1070.59 | 1067.89 | 1069.61 | 13866.0 |
| 2010-08-18 08:00:00 | ES | Futures | 1069.36 | 1072.31 | 1069.12 | 1071.82 | 19863.0 |
| 2010-08-18 08:30:00 | ES | Futures | 1071.57 | 1072.8 | 1070.35 | 1072.06 | 20984.0 |
| 2010-08-18 09:00:00 | ES | Futures | 1072.31 | 1072.8 | 1069.61 | 1069.85 | 27622.0 |
| 2010-08-18 09:30:00 | ES | Futures | 1069.61 | 1070.1 | 1063.72 | 1066.42 | 260030.0 |
| 2010-08-18 10:00:00 | ES | Futures | 1066.42 | 1069.36 | 1064.46 | 1064.7 | 158851.0 |
| 2010-08-18 10:30:00 | ES | Futures | 1064.95 | 1067.65 | 1064.46 | 1066.91 | 111729.0 |
| 2010-08-18 11:00:00 | ES | Futures | 1067.16 | 1070.59 | 1066.42 | 1068.63 | 125563.0 |
| 2010-08-18 11:30:00 | ES | Futures | 1068.63 | 1071.82 | 1068.38 | 1070.59 | 93309.0 |
| 2010-08-18 12:00:00 | ES | Futures | 1070.59 | 1071.33 | 1069.36 | 1070.84 | 44707.0 |
| 2010-08-18 12:30:00 | ES | Futures | 1070.84 | 1074.52 | 1069.85 | 1074.03 | 87324.0 |
| 2010-08-18 13:00:00 | ES | Futures | 1074.03 | 1077.46 | 1073.54 | 1076.73 | 111068.0 |
| 2010-08-18 13:30:00 | ES | Futures | 1076.73 | 1077.71 | 1075.25 | 1077.22 | 61831.0 |
| 2010-08-18 14:00:00 | ES | Futures | 1077.22 | 1078.2 | 1075.01 | 1076.23 | 78404.0 |
| 2010-08-18 14:30:00 | ES | Futures | 1076.23 | 1076.97 | 1074.76 | 1075.5 | 50735.0 |
| 2010-08-18 15:00:00 | ES | Futures | 1075.74 | 1076.48 | 1072.31 | 1073.04 | 109417.0 |
| 2010-08-18 15:30:00 | ES | Futures | 1073.29 | 1075.01 | 1072.06 | 1072.31 | 142484.0 |
| 2010-08-18 16:00:00 | ES | Futures | 1072.31 | 1072.55 | 1065.93 | 1065.93 | 138658.0 |
| 2010-08-18 16:30:00 | ES | Futures | 1066.91 | 1068.63 | 1066.91 | 1068.38 | 8091.0 |
| 2010-08-18 17:00:00 | ES | Futures | 1068.14 | 1068.38 | 1066.91 | 1067.65 | 1945.0 |
| 2010-08-18 18:00:00 | ES | Futures | 1067.4 | 1067.65 | 1066.17 | 1066.91 | 2114.0 |
| 2010-08-18 18:30:00 | ES | Futures | 1066.91 | 1067.4 | 1066.66 | 1067.4 | 632.0 |
| 2010-08-18 19:00:00 | ES | Futures | 1067.4 | 1067.65 | 1066.42 | 1066.66 | 919.0 |
| 2010-08-18 19:30:00 | ES | Futures | 1066.42 | 1066.91 | 1065.68 | 1065.68 | 2747.0 |
| 2010-08-18 20:00:00 | ES | Futures | 1065.93 | 1068.14 | 1065.44 | 1067.89 | 4323.0 |
| 2010-08-18 20:30:00 | ES | Futures | 1067.65 | 1068.87 | 1067.65 | 1068.38 | 3869.0 |
| 2010-08-18 21:00:00 | ES | Futures | 1068.63 | 1068.87 | 1067.4 | 1068.38 | 2160.0 |
| 2010-08-18 21:30:00 | ES | Futures | 1068.14 | 1069.12 | 1067.16 | 1068.63 | 3242.0 |
| 2010-08-18 22:00:00 | ES | Futures | 1068.63 | 1069.36 | 1067.16 | 1067.16 | 2414.0 |
| 2010-08-18 22:30:00 | ES | Futures | 1067.16 | 1067.89 | 1065.93 | 1067.65 | 3775.0 |
| 2010-08-18 23:00:00 | ES | Futures | 1067.65 | 1067.89 | 1066.66 | 1067.16 | 1355.0 |
| 2010-08-18 23:30:00 | ES | Futures | 1067.4 | 1068.14 | 1066.91 | 1067.65 | 2678.0 |
| 2010-08-18 00:00:00 | NQ | Futures | 2105.69 | 2107.98 | 2105.4 | 2107.12 | 230.0 |
| 2010-08-18 00:30:00 | NQ | Futures | 2107.12 | 2107.98 | 2106.55 | 2106.83 | 82.0 |
| 2010-08-18 01:00:00 | NQ | Futures | 2106.83 | 2109.99 | 2106.55 | 2109.41 | 292.0 |
> showing 50 of 2,466 rows — these rows as CSV