PREVIEW / futures_30min / 2010-06-18
file: by_date/futures_30min/2010/2010-06-18.parquet size: 57 KB rows: 1,998
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-06-18 00:00:00 | ES | Futures | 1091.94 | 1091.94 | 1090.96 | 1091.45 | 808.0 |
| 2010-06-18 00:30:00 | ES | Futures | 1091.45 | 1091.69 | 1089.98 | 1090.22 | 1644.0 |
| 2010-06-18 01:00:00 | ES | Futures | 1089.98 | 1090.71 | 1089.98 | 1090.22 | 1396.0 |
| 2010-06-18 01:30:00 | ES | Futures | 1090.22 | 1090.22 | 1088.75 | 1089.98 | 3258.0 |
| 2010-06-18 02:00:00 | ES | Futures | 1090.22 | 1091.2 | 1089.73 | 1090.96 | 2378.0 |
| 2010-06-18 02:30:00 | ES | Futures | 1090.71 | 1090.96 | 1088.5 | 1089.24 | 4272.0 |
| 2010-06-18 03:00:00 | ES | Futures | 1088.99 | 1090.47 | 1088.5 | 1090.22 | 9077.0 |
| 2010-06-18 03:30:00 | ES | Futures | 1090.22 | 1092.18 | 1089.98 | 1090.47 | 13285.0 |
| 2010-06-18 04:00:00 | ES | Futures | 1090.47 | 1092.67 | 1090.47 | 1091.69 | 13469.0 |
| 2010-06-18 04:30:00 | ES | Futures | 1091.45 | 1092.43 | 1090.96 | 1091.69 | 9422.0 |
| 2010-06-18 05:00:00 | ES | Futures | 1091.69 | 1093.17 | 1090.47 | 1091.94 | 8033.0 |
| 2010-06-18 05:30:00 | ES | Futures | 1091.94 | 1092.43 | 1090.47 | 1091.45 | 9338.0 |
| 2010-06-18 06:00:00 | ES | Futures | 1091.69 | 1091.69 | 1088.99 | 1089.24 | 18933.0 |
| 2010-06-18 06:30:00 | ES | Futures | 1088.99 | 1089.73 | 1087.77 | 1088.99 | 12177.0 |
| 2010-06-18 07:00:00 | ES | Futures | 1088.99 | 1090.96 | 1088.99 | 1090.71 | 14317.0 |
| 2010-06-18 07:30:00 | ES | Futures | 1090.71 | 1091.2 | 1089.98 | 1090.22 | 8685.0 |
| 2010-06-18 08:00:00 | ES | Futures | 1090.22 | 1092.18 | 1089.24 | 1089.24 | 23040.0 |
| 2010-06-18 08:30:00 | ES | Futures | 1089.24 | 1091.69 | 1088.75 | 1089.73 | 34802.0 |
| 2010-06-18 09:00:00 | ES | Futures | 1089.98 | 1093.41 | 1088.75 | 1093.17 | 86914.0 |
| 2010-06-18 09:30:00 | ES | Futures | 1092.92 | 1093.41 | 1088.5 | 1088.99 | 211341.0 |
| 2010-06-18 10:00:00 | ES | Futures | 1088.99 | 1094.15 | 1088.75 | 1093.41 | 169569.0 |
| 2010-06-18 10:30:00 | ES | Futures | 1093.66 | 1096.11 | 1093.17 | 1095.37 | 163125.0 |
| 2010-06-18 11:00:00 | ES | Futures | 1095.13 | 1096.11 | 1092.43 | 1092.92 | 107000.0 |
| 2010-06-18 11:30:00 | ES | Futures | 1092.92 | 1093.9 | 1091.2 | 1092.18 | 86850.0 |
| 2010-06-18 12:00:00 | ES | Futures | 1092.18 | 1094.15 | 1089.98 | 1090.71 | 71363.0 |
| 2010-06-18 12:30:00 | ES | Futures | 1090.47 | 1092.18 | 1089.49 | 1090.96 | 47994.0 |
| 2010-06-18 13:00:00 | ES | Futures | 1090.96 | 1092.43 | 1089.98 | 1091.45 | 52174.0 |
| 2010-06-18 13:30:00 | ES | Futures | 1091.69 | 1093.17 | 1089.98 | 1091.45 | 41328.0 |
| 2010-06-18 14:00:00 | ES | Futures | 1091.2 | 1093.66 | 1090.71 | 1093.41 | 43096.0 |
| 2010-06-18 14:30:00 | ES | Futures | 1093.41 | 1093.41 | 1091.69 | 1092.43 | 43981.0 |
| 2010-06-18 15:00:00 | ES | Futures | 1092.43 | 1092.67 | 1089.73 | 1091.2 | 67164.0 |
| 2010-06-18 15:30:00 | ES | Futures | 1091.45 | 1092.67 | 1090.47 | 1091.69 | 97304.0 |
| 2010-06-18 16:00:00 | ES | Futures | 1091.94 | 1092.18 | 1089.49 | 1089.73 | 93283.0 |
| 2010-06-18 00:00:00 | NQ | Futures | 2191.08 | 2191.08 | 2190.51 | 2190.51 | 24.0 |
| 2010-06-18 00:30:00 | NQ | Futures | 2190.51 | 2190.51 | 2187.65 | 2188.22 | 138.0 |
| 2010-06-18 01:00:00 | NQ | Futures | 2188.22 | 2189.36 | 2187.36 | 2187.65 | 88.0 |
| 2010-06-18 01:30:00 | NQ | Futures | 2187.36 | 2188.5 | 2185.64 | 2187.93 | 271.0 |
| 2010-06-18 02:00:00 | NQ | Futures | 2187.36 | 2189.08 | 2187.07 | 2188.5 | 189.0 |
| 2010-06-18 02:30:00 | NQ | Futures | 2188.5 | 2188.79 | 2184.49 | 2185.35 | 413.0 |
| 2010-06-18 03:00:00 | NQ | Futures | 2185.35 | 2188.79 | 2185.35 | 2188.5 | 696.0 |
| 2010-06-18 03:30:00 | NQ | Futures | 2188.79 | 2191.94 | 2188.5 | 2189.36 | 1093.0 |
| 2010-06-18 04:00:00 | NQ | Futures | 2189.65 | 2192.23 | 2189.65 | 2190.8 | 709.0 |
| 2010-06-18 04:30:00 | NQ | Futures | 2191.08 | 2192.52 | 2189.65 | 2191.66 | 758.0 |
| 2010-06-18 05:00:00 | NQ | Futures | 2191.66 | 2194.24 | 2189.65 | 2191.94 | 543.0 |
| 2010-06-18 05:30:00 | NQ | Futures | 2192.23 | 2192.8 | 2189.65 | 2191.37 | 624.0 |
| 2010-06-18 06:00:00 | NQ | Futures | 2191.37 | 2192.23 | 2187.07 | 2187.65 | 1217.0 |
| 2010-06-18 06:30:00 | NQ | Futures | 2187.36 | 2188.22 | 2184.49 | 2187.07 | 502.0 |
| 2010-06-18 07:00:00 | NQ | Futures | 2187.36 | 2190.8 | 2187.07 | 2190.22 | 760.0 |
| 2010-06-18 07:30:00 | NQ | Futures | 2190.22 | 2190.51 | 2188.79 | 2188.79 | 519.0 |
| 2010-06-18 08:00:00 | NQ | Futures | 2189.08 | 2192.23 | 2184.49 | 2184.49 | 1855.0 |
> showing 50 of 1,998 rows — these rows as CSV