PREVIEW / futures_30min / 2011-06-16
file: by_date/futures_30min/2011/2011-06-16.parquet size: 77 KB rows: 2,766
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-16 00:00:00 | ES | Futures | 1260.25 | 1261.24 | 1259.25 | 1259.5 | 1951.0 |
| 2011-06-16 00:30:00 | ES | Futures | 1259.5 | 1259.75 | 1257.75 | 1258.0 | 5363.0 |
| 2011-06-16 01:00:00 | ES | Futures | 1258.0 | 1259.0 | 1257.5 | 1257.75 | 3911.0 |
| 2011-06-16 01:30:00 | ES | Futures | 1257.5 | 1257.75 | 1255.26 | 1256.75 | 8032.0 |
| 2011-06-16 02:00:00 | ES | Futures | 1256.51 | 1257.0 | 1254.51 | 1256.01 | 10901.0 |
| 2011-06-16 02:30:00 | ES | Futures | 1256.01 | 1257.5 | 1255.51 | 1257.5 | 9661.0 |
| 2011-06-16 03:00:00 | ES | Futures | 1257.25 | 1257.75 | 1254.51 | 1257.25 | 21790.0 |
| 2011-06-16 03:30:00 | ES | Futures | 1257.25 | 1259.0 | 1255.76 | 1258.75 | 15410.0 |
| 2011-06-16 04:00:00 | ES | Futures | 1258.75 | 1261.24 | 1257.75 | 1260.5 | 20785.0 |
| 2011-06-16 04:30:00 | ES | Futures | 1260.5 | 1260.99 | 1258.75 | 1258.75 | 14935.0 |
| 2011-06-16 05:00:00 | ES | Futures | 1258.75 | 1259.25 | 1254.76 | 1255.26 | 22852.0 |
| 2011-06-16 05:30:00 | ES | Futures | 1255.51 | 1256.51 | 1253.26 | 1256.01 | 25786.0 |
| 2011-06-16 06:00:00 | ES | Futures | 1255.76 | 1256.01 | 1253.51 | 1254.26 | 19840.0 |
| 2011-06-16 06:30:00 | ES | Futures | 1254.26 | 1257.0 | 1254.26 | 1256.26 | 21242.0 |
| 2011-06-16 07:00:00 | ES | Futures | 1256.26 | 1257.5 | 1253.76 | 1254.51 | 22583.0 |
| 2011-06-16 07:30:00 | ES | Futures | 1254.51 | 1254.51 | 1250.77 | 1251.02 | 35347.0 |
| 2011-06-16 08:00:00 | ES | Futures | 1251.02 | 1252.51 | 1250.52 | 1251.77 | 42856.0 |
| 2011-06-16 08:30:00 | ES | Futures | 1251.77 | 1258.5 | 1251.77 | 1258.0 | 95140.0 |
| 2011-06-16 09:00:00 | ES | Futures | 1258.0 | 1260.0 | 1255.26 | 1257.0 | 83495.0 |
| 2011-06-16 09:30:00 | ES | Futures | 1257.0 | 1261.49 | 1255.76 | 1258.75 | 253241.0 |
| 2011-06-16 10:00:00 | ES | Futures | 1258.75 | 1263.74 | 1252.76 | 1260.25 | 373407.0 |
| 2011-06-16 10:30:00 | ES | Futures | 1260.5 | 1264.98 | 1259.75 | 1262.74 | 184964.0 |
| 2011-06-16 11:00:00 | ES | Futures | 1262.74 | 1265.73 | 1259.0 | 1264.24 | 253294.0 |
| 2011-06-16 11:30:00 | ES | Futures | 1264.24 | 1265.98 | 1261.49 | 1262.24 | 145998.0 |
| 2011-06-16 12:00:00 | ES | Futures | 1262.24 | 1264.74 | 1261.74 | 1264.49 | 88449.0 |
| 2011-06-16 12:30:00 | ES | Futures | 1264.49 | 1264.74 | 1261.74 | 1261.74 | 63843.0 |
| 2011-06-16 13:00:00 | ES | Futures | 1261.74 | 1263.24 | 1260.5 | 1260.74 | 91514.0 |
| 2011-06-16 13:30:00 | ES | Futures | 1260.74 | 1260.99 | 1254.76 | 1254.76 | 159819.0 |
| 2011-06-16 14:00:00 | ES | Futures | 1254.76 | 1256.51 | 1253.01 | 1255.01 | 145729.0 |
| 2011-06-16 14:30:00 | ES | Futures | 1254.76 | 1255.01 | 1249.27 | 1253.51 | 188889.0 |
| 2011-06-16 15:00:00 | ES | Futures | 1253.26 | 1256.75 | 1252.76 | 1255.76 | 145312.0 |
| 2011-06-16 15:30:00 | ES | Futures | 1255.51 | 1260.25 | 1255.26 | 1259.0 | 287173.0 |
| 2011-06-16 16:00:00 | ES | Futures | 1259.25 | 1260.99 | 1258.5 | 1260.74 | 97044.0 |
| 2011-06-16 16:30:00 | ES | Futures | 1260.74 | 1262.49 | 1259.75 | 1261.74 | 13809.0 |
| 2011-06-16 17:00:00 | ES | Futures | 1261.99 | 1262.24 | 1260.99 | 1261.24 | 4496.0 |
| 2011-06-16 18:00:00 | ES | Futures | 1261.49 | 1262.74 | 1261.24 | 1261.99 | 2669.0 |
| 2011-06-16 18:30:00 | ES | Futures | 1261.99 | 1264.24 | 1261.99 | 1263.74 | 3975.0 |
| 2011-06-16 19:00:00 | ES | Futures | 1263.99 | 1265.23 | 1263.49 | 1264.24 | 3958.0 |
| 2011-06-16 19:30:00 | ES | Futures | 1264.49 | 1264.74 | 1263.99 | 1264.49 | 1161.0 |
| 2011-06-16 20:00:00 | ES | Futures | 1264.74 | 1264.74 | 1263.24 | 1263.74 | 3656.0 |
| 2011-06-16 20:30:00 | ES | Futures | 1263.74 | 1265.23 | 1263.49 | 1263.74 | 2672.0 |
| 2011-06-16 21:00:00 | ES | Futures | 1263.74 | 1264.74 | 1263.49 | 1263.49 | 1639.0 |
| 2011-06-16 21:30:00 | ES | Futures | 1263.74 | 1263.74 | 1262.24 | 1263.24 | 2604.0 |
| 2011-06-16 22:00:00 | ES | Futures | 1262.99 | 1263.24 | 1262.49 | 1262.74 | 1053.0 |
| 2011-06-16 22:30:00 | ES | Futures | 1262.74 | 1262.74 | 1261.24 | 1262.49 | 3586.0 |
| 2011-06-16 23:00:00 | ES | Futures | 1262.24 | 1262.99 | 1261.74 | 1262.99 | 2148.0 |
| 2011-06-16 23:30:00 | ES | Futures | 1262.99 | 1262.99 | 1261.74 | 1261.99 | 998.0 |
| 2011-06-16 00:00:00 | NQ | Futures | 2545.57 | 2548.45 | 2545.57 | 2546.15 | 787.0 |
| 2011-06-16 00:30:00 | NQ | Futures | 2546.44 | 2546.44 | 2539.24 | 2539.53 | 1040.0 |
| 2011-06-16 01:00:00 | NQ | Futures | 2539.82 | 2541.54 | 2536.65 | 2538.09 | 1090.0 |
> showing 50 of 2,766 rows — these rows as CSV