PREVIEW / futures_30min / 2008-06-12
file: by_date/futures_30min/2008/2008-06-12.parquet size: 65 KB rows: 2,178
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-12 00:00:00 | ES | Futures | 1246.18 | 1246.41 | 1245.48 | 1245.95 | 583.0 |
| 2008-06-12 00:30:00 | ES | Futures | 1245.95 | 1246.41 | 1245.71 | 1245.71 | 590.0 |
| 2008-06-12 01:00:00 | ES | Futures | 1245.71 | 1246.18 | 1245.02 | 1245.25 | 381.0 |
| 2008-06-12 01:30:00 | ES | Futures | 1245.25 | 1246.41 | 1245.02 | 1246.18 | 809.0 |
| 2008-06-12 02:00:00 | ES | Futures | 1246.18 | 1247.34 | 1245.95 | 1247.34 | 2639.0 |
| 2008-06-12 02:30:00 | ES | Futures | 1247.34 | 1248.28 | 1246.65 | 1247.34 | 3320.0 |
| 2008-06-12 03:00:00 | ES | Futures | 1247.58 | 1249.9 | 1247.34 | 1249.44 | 9912.0 |
| 2008-06-12 03:30:00 | ES | Futures | 1249.44 | 1250.14 | 1248.51 | 1249.67 | 5256.0 |
| 2008-06-12 04:00:00 | ES | Futures | 1249.67 | 1251.3 | 1249.67 | 1250.84 | 7464.0 |
| 2008-06-12 04:30:00 | ES | Futures | 1250.84 | 1251.07 | 1247.34 | 1247.81 | 6928.0 |
| 2008-06-12 05:00:00 | ES | Futures | 1247.81 | 1249.21 | 1247.81 | 1248.28 | 3087.0 |
| 2008-06-12 05:30:00 | ES | Futures | 1248.04 | 1249.44 | 1247.81 | 1248.74 | 7226.0 |
| 2008-06-12 06:00:00 | ES | Futures | 1248.74 | 1250.6 | 1248.28 | 1250.37 | 5131.0 |
| 2008-06-12 06:30:00 | ES | Futures | 1250.6 | 1252.47 | 1249.44 | 1252.23 | 11520.0 |
| 2008-06-12 07:00:00 | ES | Futures | 1252.23 | 1252.7 | 1251.07 | 1251.77 | 10925.0 |
| 2008-06-12 07:30:00 | ES | Futures | 1251.77 | 1253.63 | 1251.53 | 1253.4 | 19103.0 |
| 2008-06-12 08:00:00 | ES | Futures | 1253.4 | 1254.1 | 1251.77 | 1251.77 | 21587.0 |
| 2008-06-12 08:30:00 | ES | Futures | 1251.53 | 1256.89 | 1248.28 | 1253.4 | 95671.0 |
| 2008-06-12 09:00:00 | ES | Futures | 1253.63 | 1253.86 | 1249.21 | 1249.44 | 36288.0 |
| 2008-06-12 09:30:00 | ES | Futures | 1249.44 | 1259.68 | 1248.97 | 1257.36 | 147051.0 |
| 2008-06-12 10:00:00 | ES | Futures | 1257.59 | 1260.62 | 1253.4 | 1255.49 | 98835.0 |
| 2008-06-12 10:30:00 | ES | Futures | 1255.26 | 1258.29 | 1254.33 | 1257.12 | 50400.0 |
| 2008-06-12 11:00:00 | ES | Futures | 1257.12 | 1260.15 | 1256.89 | 1258.52 | 41911.0 |
| 2008-06-12 11:30:00 | ES | Futures | 1258.52 | 1259.68 | 1255.03 | 1255.73 | 27087.0 |
| 2008-06-12 12:00:00 | ES | Futures | 1255.73 | 1258.52 | 1255.49 | 1257.36 | 24370.0 |
| 2008-06-12 12:30:00 | ES | Futures | 1257.36 | 1258.29 | 1254.56 | 1255.26 | 27813.0 |
| 2008-06-12 13:00:00 | ES | Futures | 1255.03 | 1256.89 | 1252.7 | 1254.33 | 30475.0 |
| 2008-06-12 13:30:00 | ES | Futures | 1254.33 | 1254.79 | 1249.21 | 1250.6 | 37522.0 |
| 2008-06-12 14:00:00 | ES | Futures | 1250.84 | 1252.23 | 1248.28 | 1249.21 | 38060.0 |
| 2008-06-12 14:30:00 | ES | Futures | 1249.21 | 1251.07 | 1245.25 | 1248.97 | 46444.0 |
| 2008-06-12 15:00:00 | ES | Futures | 1248.74 | 1248.97 | 1239.66 | 1241.52 | 63035.0 |
| 2008-06-12 15:30:00 | ES | Futures | 1241.52 | 1249.44 | 1241.29 | 1248.28 | 105893.0 |
| 2008-06-12 16:00:00 | ES | Futures | 1248.51 | 1250.37 | 1247.81 | 1248.74 | 23590.0 |
| 2008-06-12 16:30:00 | ES | Futures | 1248.74 | 1250.37 | 1247.11 | 1249.67 | 3471.0 |
| 2008-06-12 17:00:00 | ES | Futures | 1249.44 | 1251.53 | 1249.21 | 1249.44 | 2039.0 |
| 2008-06-12 18:00:00 | ES | Futures | 1249.44 | 1250.37 | 1249.21 | 1249.9 | 472.0 |
| 2008-06-12 18:30:00 | ES | Futures | 1250.14 | 1250.84 | 1249.9 | 1250.37 | 364.0 |
| 2008-06-12 19:00:00 | ES | Futures | 1250.6 | 1251.07 | 1250.37 | 1250.37 | 180.0 |
| 2008-06-12 19:30:00 | ES | Futures | 1250.37 | 1250.84 | 1248.97 | 1249.9 | 496.0 |
| 2008-06-12 20:00:00 | ES | Futures | 1249.9 | 1251.77 | 1249.67 | 1250.14 | 766.0 |
| 2008-06-12 20:30:00 | ES | Futures | 1250.14 | 1250.6 | 1249.21 | 1249.67 | 206.0 |
| 2008-06-12 21:00:00 | ES | Futures | 1249.67 | 1250.6 | 1248.51 | 1248.97 | 705.0 |
| 2008-06-12 21:30:00 | ES | Futures | 1248.97 | 1249.21 | 1248.04 | 1248.51 | 433.0 |
| 2008-06-12 22:00:00 | ES | Futures | 1248.51 | 1248.74 | 1247.58 | 1248.04 | 251.0 |
| 2008-06-12 22:30:00 | ES | Futures | 1248.04 | 1248.28 | 1247.81 | 1248.04 | 126.0 |
| 2008-06-12 23:00:00 | ES | Futures | 1248.04 | 1248.74 | 1247.81 | 1248.28 | 200.0 |
| 2008-06-12 23:30:00 | ES | Futures | 1248.28 | 1248.97 | 1248.28 | 1248.51 | 189.0 |
| 2008-06-12 00:00:00 | NQ | Futures | 2180.61 | 2181.17 | 2180.04 | 2180.04 | 23.0 |
| 2008-06-12 00:30:00 | NQ | Futures | 2180.61 | 2183.15 | 2180.61 | 2182.02 | 182.0 |
| 2008-06-12 01:00:00 | NQ | Futures | 2182.59 | 2183.15 | 2180.61 | 2181.46 | 62.0 |
> showing 50 of 2,178 rows — these rows as CSV