PREVIEW / futures_30min / 2008-06-19
file: by_date/futures_30min/2008/2008-06-19.parquet size: 67 KB rows: 2,254
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-19 00:00:00 | ES | Futures | 1243.65 | 1244.12 | 1242.49 | 1242.72 | 605.0 |
| 2008-06-19 00:30:00 | ES | Futures | 1242.72 | 1243.65 | 1242.49 | 1242.96 | 549.0 |
| 2008-06-19 01:00:00 | ES | Futures | 1242.96 | 1243.65 | 1242.03 | 1242.72 | 1107.0 |
| 2008-06-19 01:30:00 | ES | Futures | 1242.72 | 1243.89 | 1242.03 | 1243.42 | 837.0 |
| 2008-06-19 02:00:00 | ES | Futures | 1243.89 | 1244.12 | 1241.1 | 1242.49 | 2502.0 |
| 2008-06-19 02:30:00 | ES | Futures | 1242.72 | 1242.96 | 1241.1 | 1242.49 | 2169.0 |
| 2008-06-19 03:00:00 | ES | Futures | 1242.49 | 1245.05 | 1241.56 | 1244.35 | 9703.0 |
| 2008-06-19 03:30:00 | ES | Futures | 1244.35 | 1244.58 | 1240.17 | 1241.8 | 8696.0 |
| 2008-06-19 04:00:00 | ES | Futures | 1241.8 | 1242.49 | 1241.33 | 1242.03 | 3145.0 |
| 2008-06-19 04:30:00 | ES | Futures | 1242.03 | 1246.68 | 1241.8 | 1245.51 | 9394.0 |
| 2008-06-19 05:00:00 | ES | Futures | 1245.51 | 1246.21 | 1244.35 | 1245.51 | 4522.0 |
| 2008-06-19 05:30:00 | ES | Futures | 1245.51 | 1246.91 | 1244.82 | 1245.98 | 5633.0 |
| 2008-06-19 06:00:00 | ES | Futures | 1245.98 | 1246.21 | 1244.12 | 1244.35 | 3716.0 |
| 2008-06-19 06:30:00 | ES | Futures | 1244.35 | 1245.51 | 1244.12 | 1245.05 | 3276.0 |
| 2008-06-19 07:00:00 | ES | Futures | 1244.82 | 1247.37 | 1244.58 | 1246.68 | 9907.0 |
| 2008-06-19 07:30:00 | ES | Futures | 1246.68 | 1248.54 | 1246.21 | 1248.3 | 12277.0 |
| 2008-06-19 08:00:00 | ES | Futures | 1248.07 | 1248.77 | 1247.14 | 1247.14 | 10065.0 |
| 2008-06-19 08:30:00 | ES | Futures | 1247.14 | 1249.0 | 1245.28 | 1245.98 | 26150.0 |
| 2008-06-19 09:00:00 | ES | Futures | 1245.98 | 1246.21 | 1244.12 | 1244.35 | 24081.0 |
| 2008-06-19 09:30:00 | ES | Futures | 1244.58 | 1249.46 | 1241.56 | 1243.89 | 235889.0 |
| 2008-06-19 10:00:00 | ES | Futures | 1244.12 | 1244.35 | 1238.77 | 1243.42 | 238835.0 |
| 2008-06-19 10:30:00 | ES | Futures | 1243.65 | 1247.14 | 1242.72 | 1246.44 | 156419.0 |
| 2008-06-19 11:00:00 | ES | Futures | 1246.44 | 1248.54 | 1238.54 | 1241.1 | 233366.0 |
| 2008-06-19 11:30:00 | ES | Futures | 1241.1 | 1242.72 | 1239.94 | 1241.33 | 113114.0 |
| 2008-06-19 12:00:00 | ES | Futures | 1241.33 | 1248.54 | 1240.87 | 1245.51 | 162652.0 |
| 2008-06-19 12:30:00 | ES | Futures | 1245.75 | 1248.3 | 1244.35 | 1245.28 | 98112.0 |
| 2008-06-19 13:00:00 | ES | Futures | 1245.05 | 1247.61 | 1244.35 | 1247.37 | 54809.0 |
| 2008-06-19 13:30:00 | ES | Futures | 1247.37 | 1248.54 | 1242.96 | 1245.05 | 87289.0 |
| 2008-06-19 14:00:00 | ES | Futures | 1245.05 | 1249.23 | 1242.96 | 1248.07 | 95691.0 |
| 2008-06-19 14:30:00 | ES | Futures | 1247.84 | 1252.72 | 1247.84 | 1251.79 | 148504.0 |
| 2008-06-19 15:00:00 | ES | Futures | 1252.02 | 1254.81 | 1250.63 | 1251.32 | 143994.0 |
| 2008-06-19 15:30:00 | ES | Futures | 1251.32 | 1252.95 | 1249.0 | 1249.93 | 138091.0 |
| 2008-06-19 16:00:00 | ES | Futures | 1249.93 | 1250.16 | 1246.91 | 1247.14 | 76651.0 |
| 2008-06-19 16:30:00 | ES | Futures | 1248.07 | 1248.3 | 1247.37 | 1248.07 | 3922.0 |
| 2008-06-19 17:00:00 | ES | Futures | 1248.07 | 1249.0 | 1247.84 | 1249.0 | 2208.0 |
| 2008-06-19 18:00:00 | ES | Futures | 1248.54 | 1248.77 | 1246.68 | 1247.14 | 3649.0 |
| 2008-06-19 18:30:00 | ES | Futures | 1247.14 | 1247.37 | 1246.68 | 1247.14 | 1243.0 |
| 2008-06-19 19:00:00 | ES | Futures | 1246.91 | 1247.14 | 1245.51 | 1245.51 | 1656.0 |
| 2008-06-19 19:30:00 | ES | Futures | 1245.75 | 1245.75 | 1243.89 | 1244.58 | 2854.0 |
| 2008-06-19 20:00:00 | ES | Futures | 1244.58 | 1244.82 | 1244.12 | 1244.82 | 869.0 |
| 2008-06-19 20:30:00 | ES | Futures | 1244.82 | 1244.82 | 1244.12 | 1244.58 | 433.0 |
| 2008-06-19 21:00:00 | ES | Futures | 1244.58 | 1244.58 | 1243.42 | 1243.65 | 1446.0 |
| 2008-06-19 21:30:00 | ES | Futures | 1243.89 | 1244.82 | 1243.19 | 1244.58 | 2154.0 |
| 2008-06-19 22:00:00 | ES | Futures | 1244.58 | 1246.21 | 1244.35 | 1245.75 | 1687.0 |
| 2008-06-19 22:30:00 | ES | Futures | 1245.75 | 1246.68 | 1245.75 | 1246.21 | 968.0 |
| 2008-06-19 23:00:00 | ES | Futures | 1246.21 | 1246.44 | 1244.82 | 1245.51 | 1055.0 |
| 2008-06-19 23:30:00 | ES | Futures | 1245.51 | 1245.98 | 1244.58 | 1244.82 | 767.0 |
| 2008-06-19 00:00:00 | NQ | Futures | 2199.68 | 2199.68 | 2195.18 | 2197.43 | 317.0 |
| 2008-06-19 00:30:00 | NQ | Futures | 2197.15 | 2199.68 | 2196.58 | 2199.12 | 36.0 |
| 2008-06-19 01:00:00 | NQ | Futures | 2199.12 | 2201.08 | 2198.55 | 2198.83 | 86.0 |
> showing 50 of 2,254 rows — these rows as CSV