PREVIEW / futures_30min / 2010-11-19
file: by_date/futures_30min/2010/2010-11-19.parquet size: 63 KB rows: 2,139
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-11-19 00:00:00 | ES | Futures | 1178.42 | 1178.42 | 1177.43 | 1178.17 | 2203.0 |
| 2010-11-19 00:30:00 | ES | Futures | 1178.17 | 1178.91 | 1178.17 | 1178.17 | 1851.0 |
| 2010-11-19 01:00:00 | ES | Futures | 1178.17 | 1180.88 | 1177.92 | 1180.39 | 3671.0 |
| 2010-11-19 01:30:00 | ES | Futures | 1180.39 | 1182.11 | 1180.39 | 1181.62 | 3176.0 |
| 2010-11-19 02:00:00 | ES | Futures | 1181.62 | 1182.85 | 1181.37 | 1181.62 | 6232.0 |
| 2010-11-19 02:30:00 | ES | Futures | 1181.87 | 1182.11 | 1181.37 | 1181.87 | 2758.0 |
| 2010-11-19 03:00:00 | ES | Futures | 1181.87 | 1182.11 | 1179.89 | 1180.63 | 12112.0 |
| 2010-11-19 03:30:00 | ES | Futures | 1180.63 | 1180.88 | 1178.91 | 1180.14 | 16883.0 |
| 2010-11-19 04:00:00 | ES | Futures | 1179.89 | 1180.14 | 1178.17 | 1178.42 | 10771.0 |
| 2010-11-19 04:30:00 | ES | Futures | 1178.42 | 1179.15 | 1177.92 | 1178.66 | 9917.0 |
| 2010-11-19 05:00:00 | ES | Futures | 1178.42 | 1178.66 | 1177.68 | 1178.66 | 13166.0 |
| 2010-11-19 05:30:00 | ES | Futures | 1178.42 | 1179.15 | 1175.95 | 1177.18 | 41215.0 |
| 2010-11-19 06:00:00 | ES | Futures | 1177.43 | 1178.66 | 1175.95 | 1177.18 | 20897.0 |
| 2010-11-19 06:30:00 | ES | Futures | 1177.18 | 1178.66 | 1176.94 | 1177.92 | 13965.0 |
| 2010-11-19 07:00:00 | ES | Futures | 1177.92 | 1178.42 | 1174.96 | 1175.46 | 18369.0 |
| 2010-11-19 07:30:00 | ES | Futures | 1175.46 | 1175.7 | 1173.73 | 1174.96 | 29226.0 |
| 2010-11-19 08:00:00 | ES | Futures | 1174.72 | 1175.95 | 1174.23 | 1175.21 | 20177.0 |
| 2010-11-19 08:30:00 | ES | Futures | 1175.46 | 1177.68 | 1175.21 | 1175.95 | 37737.0 |
| 2010-11-19 09:00:00 | ES | Futures | 1175.95 | 1177.43 | 1175.46 | 1177.43 | 38504.0 |
| 2010-11-19 09:30:00 | ES | Futures | 1177.18 | 1177.43 | 1170.77 | 1172.99 | 279489.0 |
| 2010-11-19 10:00:00 | ES | Futures | 1172.99 | 1173.73 | 1170.77 | 1172.75 | 150420.0 |
| 2010-11-19 10:30:00 | ES | Futures | 1172.5 | 1176.94 | 1171.51 | 1175.46 | 151381.0 |
| 2010-11-19 11:00:00 | ES | Futures | 1175.46 | 1176.94 | 1174.72 | 1176.44 | 106183.0 |
| 2010-11-19 11:30:00 | ES | Futures | 1176.69 | 1178.17 | 1176.2 | 1176.44 | 85838.0 |
| 2010-11-19 12:00:00 | ES | Futures | 1176.69 | 1177.43 | 1176.2 | 1176.44 | 36343.0 |
| 2010-11-19 12:30:00 | ES | Futures | 1176.2 | 1178.91 | 1175.7 | 1178.42 | 55317.0 |
| 2010-11-19 13:00:00 | ES | Futures | 1178.42 | 1179.65 | 1177.68 | 1178.17 | 52985.0 |
| 2010-11-19 13:30:00 | ES | Futures | 1178.17 | 1179.15 | 1177.92 | 1178.91 | 29638.0 |
| 2010-11-19 14:00:00 | ES | Futures | 1178.91 | 1180.63 | 1178.42 | 1179.4 | 50747.0 |
| 2010-11-19 14:30:00 | ES | Futures | 1179.4 | 1180.63 | 1178.91 | 1179.15 | 37114.0 |
| 2010-11-19 15:00:00 | ES | Futures | 1179.4 | 1180.14 | 1178.17 | 1178.66 | 43946.0 |
| 2010-11-19 15:30:00 | ES | Futures | 1178.91 | 1181.87 | 1177.68 | 1181.13 | 171527.0 |
| 2010-11-19 16:00:00 | ES | Futures | 1180.88 | 1183.1 | 1180.39 | 1181.13 | 109618.0 |
| 2010-11-19 00:00:00 | NQ | Futures | 2444.12 | 2444.12 | 2442.11 | 2443.84 | 372.0 |
| 2010-11-19 00:30:00 | NQ | Futures | 2443.55 | 2444.12 | 2441.83 | 2442.97 | 400.0 |
| 2010-11-19 01:00:00 | NQ | Futures | 2442.97 | 2448.14 | 2442.97 | 2447.57 | 566.0 |
| 2010-11-19 01:30:00 | NQ | Futures | 2447.57 | 2450.15 | 2447.57 | 2450.15 | 542.0 |
| 2010-11-19 02:00:00 | NQ | Futures | 2450.15 | 2451.87 | 2449.29 | 2449.57 | 371.0 |
| 2010-11-19 02:30:00 | NQ | Futures | 2450.15 | 2450.72 | 2449.57 | 2450.72 | 174.0 |
| 2010-11-19 03:00:00 | NQ | Futures | 2450.43 | 2450.72 | 2446.7 | 2446.99 | 739.0 |
| 2010-11-19 03:30:00 | NQ | Futures | 2447.28 | 2447.28 | 2443.26 | 2445.27 | 1751.0 |
| 2010-11-19 04:00:00 | NQ | Futures | 2445.27 | 2445.56 | 2442.11 | 2442.69 | 826.0 |
| 2010-11-19 04:30:00 | NQ | Futures | 2442.97 | 2443.84 | 2442.11 | 2443.55 | 513.0 |
| 2010-11-19 05:00:00 | NQ | Futures | 2443.26 | 2443.55 | 2441.54 | 2442.97 | 602.0 |
| 2010-11-19 05:30:00 | NQ | Futures | 2443.26 | 2446.7 | 2438.67 | 2444.12 | 4290.0 |
| 2010-11-19 06:00:00 | NQ | Futures | 2443.84 | 2445.56 | 2441.54 | 2442.11 | 1391.0 |
| 2010-11-19 06:30:00 | NQ | Futures | 2442.4 | 2444.7 | 2441.54 | 2442.97 | 1259.0 |
| 2010-11-19 07:00:00 | NQ | Futures | 2442.97 | 2443.55 | 2438.67 | 2438.96 | 1315.0 |
| 2010-11-19 07:30:00 | NQ | Futures | 2438.96 | 2439.53 | 2436.09 | 2438.38 | 2446.0 |
| 2010-11-19 08:00:00 | NQ | Futures | 2438.38 | 2440.11 | 2437.52 | 2439.53 | 1577.0 |
> showing 50 of 2,139 rows — these rows as CSV