PREVIEW / futures_30min / 2008-06-18
file: by_date/futures_30min/2008/2008-06-18.parquet size: 65 KB rows: 2,195
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-18 00:00:00 | ES | Futures | 1258.3 | 1259.23 | 1258.3 | 1258.99 | 911.0 |
| 2008-06-18 00:30:00 | ES | Futures | 1258.99 | 1259.69 | 1258.99 | 1259.46 | 823.0 |
| 2008-06-18 01:00:00 | ES | Futures | 1259.46 | 1259.69 | 1259.23 | 1259.23 | 196.0 |
| 2008-06-18 01:30:00 | ES | Futures | 1259.23 | 1259.92 | 1259.23 | 1259.23 | 756.0 |
| 2008-06-18 02:00:00 | ES | Futures | 1259.46 | 1260.16 | 1258.99 | 1259.69 | 1596.0 |
| 2008-06-18 02:30:00 | ES | Futures | 1259.69 | 1259.92 | 1258.76 | 1259.23 | 1229.0 |
| 2008-06-18 03:00:00 | ES | Futures | 1259.46 | 1259.92 | 1258.53 | 1258.76 | 4136.0 |
| 2008-06-18 03:30:00 | ES | Futures | 1258.76 | 1259.23 | 1258.3 | 1258.53 | 4262.0 |
| 2008-06-18 04:00:00 | ES | Futures | 1258.53 | 1258.53 | 1255.97 | 1255.97 | 5521.0 |
| 2008-06-18 04:30:00 | ES | Futures | 1255.97 | 1258.76 | 1255.97 | 1258.76 | 4761.0 |
| 2008-06-18 05:00:00 | ES | Futures | 1258.53 | 1259.46 | 1257.83 | 1258.06 | 2672.0 |
| 2008-06-18 05:30:00 | ES | Futures | 1258.06 | 1258.53 | 1256.21 | 1256.67 | 4171.0 |
| 2008-06-18 06:00:00 | ES | Futures | 1256.67 | 1256.67 | 1252.49 | 1253.18 | 10295.0 |
| 2008-06-18 06:30:00 | ES | Futures | 1253.18 | 1254.35 | 1252.49 | 1254.11 | 4791.0 |
| 2008-06-18 07:00:00 | ES | Futures | 1254.11 | 1254.11 | 1250.39 | 1252.02 | 12647.0 |
| 2008-06-18 07:30:00 | ES | Futures | 1252.25 | 1252.95 | 1247.84 | 1248.77 | 17499.0 |
| 2008-06-18 08:00:00 | ES | Futures | 1248.77 | 1250.39 | 1246.91 | 1249.7 | 32047.0 |
| 2008-06-18 08:30:00 | ES | Futures | 1249.93 | 1250.16 | 1248.77 | 1249.93 | 13538.0 |
| 2008-06-18 09:00:00 | ES | Futures | 1249.93 | 1250.39 | 1248.54 | 1250.16 | 23619.0 |
| 2008-06-18 09:30:00 | ES | Futures | 1250.16 | 1253.65 | 1248.07 | 1248.54 | 228457.0 |
| 2008-06-18 10:00:00 | ES | Futures | 1248.54 | 1250.86 | 1247.37 | 1248.07 | 141598.0 |
| 2008-06-18 10:30:00 | ES | Futures | 1248.07 | 1248.3 | 1242.49 | 1244.35 | 257194.0 |
| 2008-06-18 11:00:00 | ES | Futures | 1244.58 | 1248.3 | 1243.89 | 1246.44 | 144712.0 |
| 2008-06-18 11:30:00 | ES | Futures | 1246.44 | 1253.18 | 1246.21 | 1251.09 | 137932.0 |
| 2008-06-18 12:00:00 | ES | Futures | 1250.86 | 1251.56 | 1248.54 | 1248.77 | 58400.0 |
| 2008-06-18 12:30:00 | ES | Futures | 1248.77 | 1250.63 | 1245.75 | 1246.91 | 78281.0 |
| 2008-06-18 13:00:00 | ES | Futures | 1247.14 | 1247.14 | 1241.1 | 1242.96 | 127917.0 |
| 2008-06-18 13:30:00 | ES | Futures | 1242.96 | 1245.75 | 1241.8 | 1244.58 | 90862.0 |
| 2008-06-18 14:00:00 | ES | Futures | 1244.35 | 1247.14 | 1240.63 | 1242.49 | 151499.0 |
| 2008-06-18 14:30:00 | ES | Futures | 1242.72 | 1248.07 | 1241.56 | 1246.91 | 106952.0 |
| 2008-06-18 15:00:00 | ES | Futures | 1246.91 | 1251.79 | 1245.28 | 1249.46 | 131601.0 |
| 2008-06-18 15:30:00 | ES | Futures | 1249.23 | 1249.7 | 1243.89 | 1246.21 | 171835.0 |
| 2008-06-18 16:00:00 | ES | Futures | 1246.44 | 1246.68 | 1244.35 | 1244.58 | 63042.0 |
| 2008-06-18 16:30:00 | ES | Futures | 1244.58 | 1245.05 | 1243.89 | 1243.89 | 7091.0 |
| 2008-06-18 17:00:00 | ES | Futures | 1244.12 | 1244.12 | 1243.19 | 1243.42 | 1373.0 |
| 2008-06-18 18:00:00 | ES | Futures | 1243.65 | 1243.89 | 1242.96 | 1243.19 | 1157.0 |
| 2008-06-18 18:30:00 | ES | Futures | 1243.19 | 1243.65 | 1242.96 | 1243.65 | 265.0 |
| 2008-06-18 19:00:00 | ES | Futures | 1243.42 | 1243.65 | 1242.72 | 1242.96 | 814.0 |
| 2008-06-18 19:30:00 | ES | Futures | 1242.96 | 1244.35 | 1242.49 | 1243.65 | 952.0 |
| 2008-06-18 20:00:00 | ES | Futures | 1243.89 | 1244.82 | 1243.65 | 1244.35 | 909.0 |
| 2008-06-18 20:30:00 | ES | Futures | 1244.58 | 1244.58 | 1244.12 | 1244.35 | 209.0 |
| 2008-06-18 21:00:00 | ES | Futures | 1244.58 | 1245.05 | 1244.35 | 1244.58 | 624.0 |
| 2008-06-18 21:30:00 | ES | Futures | 1244.82 | 1245.05 | 1243.89 | 1244.12 | 618.0 |
| 2008-06-18 22:00:00 | ES | Futures | 1244.35 | 1245.05 | 1243.89 | 1244.35 | 478.0 |
| 2008-06-18 22:30:00 | ES | Futures | 1244.35 | 1244.82 | 1243.65 | 1243.65 | 409.0 |
| 2008-06-18 23:00:00 | ES | Futures | 1243.89 | 1244.12 | 1242.96 | 1243.42 | 599.0 |
| 2008-06-18 23:30:00 | ES | Futures | 1243.65 | 1244.58 | 1243.19 | 1243.42 | 573.0 |
| 2008-06-18 00:00:00 | NQ | Futures | 2234.28 | 2236.81 | 2234.28 | 2236.81 | 132.0 |
| 2008-06-18 00:30:00 | NQ | Futures | 2236.81 | 2237.93 | 2236.81 | 2237.93 | 42.0 |
| 2008-06-18 01:00:00 | NQ | Futures | 2237.37 | 2238.21 | 2237.09 | 2237.37 | 31.0 |
> showing 50 of 2,195 rows — these rows as CSV