PREVIEW / futures_30min / 2011-12-08
file: by_date/futures_30min/2011/2011-12-08.parquet size: 77 KB rows: 2,684
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-12-08 00:00:00 | ES | Futures | 1269.09 | 1269.34 | 1266.33 | 1266.83 | 2065.0 |
| 2011-12-08 00:30:00 | ES | Futures | 1266.83 | 1268.08 | 1266.58 | 1267.08 | 1048.0 |
| 2011-12-08 01:00:00 | ES | Futures | 1266.83 | 1267.33 | 1266.08 | 1266.33 | 1205.0 |
| 2011-12-08 01:30:00 | ES | Futures | 1266.33 | 1267.58 | 1266.33 | 1267.58 | 839.0 |
| 2011-12-08 02:00:00 | ES | Futures | 1267.58 | 1268.58 | 1266.08 | 1267.33 | 4650.0 |
| 2011-12-08 02:30:00 | ES | Futures | 1267.33 | 1269.34 | 1266.83 | 1266.83 | 4408.0 |
| 2011-12-08 03:00:00 | ES | Futures | 1266.83 | 1268.84 | 1265.58 | 1267.08 | 12823.0 |
| 2011-12-08 03:30:00 | ES | Futures | 1267.08 | 1268.33 | 1266.08 | 1267.58 | 8263.0 |
| 2011-12-08 04:00:00 | ES | Futures | 1267.33 | 1267.83 | 1263.82 | 1264.32 | 12261.0 |
| 2011-12-08 04:30:00 | ES | Futures | 1264.32 | 1265.58 | 1262.57 | 1265.07 | 9667.0 |
| 2011-12-08 05:00:00 | ES | Futures | 1265.07 | 1266.83 | 1264.32 | 1265.58 | 7704.0 |
| 2011-12-08 05:30:00 | ES | Futures | 1265.58 | 1266.33 | 1261.06 | 1261.31 | 22127.0 |
| 2011-12-08 06:00:00 | ES | Futures | 1261.31 | 1264.32 | 1261.06 | 1264.07 | 17349.0 |
| 2011-12-08 06:30:00 | ES | Futures | 1264.07 | 1266.83 | 1262.82 | 1265.58 | 14175.0 |
| 2011-12-08 07:00:00 | ES | Futures | 1265.83 | 1266.83 | 1264.82 | 1266.58 | 10874.0 |
| 2011-12-08 07:30:00 | ES | Futures | 1266.58 | 1269.09 | 1263.82 | 1267.33 | 33181.0 |
| 2011-12-08 08:00:00 | ES | Futures | 1267.58 | 1268.08 | 1263.82 | 1267.33 | 31227.0 |
| 2011-12-08 08:30:00 | ES | Futures | 1267.33 | 1275.86 | 1259.81 | 1262.82 | 179478.0 |
| 2011-12-08 09:00:00 | ES | Futures | 1262.82 | 1263.07 | 1253.29 | 1257.05 | 177633.0 |
| 2011-12-08 09:30:00 | ES | Futures | 1257.05 | 1260.06 | 1254.54 | 1255.8 | 169260.0 |
| 2011-12-08 10:00:00 | ES | Futures | 1255.8 | 1257.3 | 1250.03 | 1251.03 | 170767.0 |
| 2011-12-08 10:30:00 | ES | Futures | 1251.03 | 1256.55 | 1250.78 | 1252.03 | 117271.0 |
| 2011-12-08 11:00:00 | ES | Futures | 1252.03 | 1252.29 | 1247.02 | 1248.02 | 129196.0 |
| 2011-12-08 11:30:00 | ES | Futures | 1248.02 | 1249.53 | 1244.51 | 1248.52 | 93177.0 |
| 2011-12-08 12:00:00 | ES | Futures | 1248.78 | 1250.53 | 1246.27 | 1248.02 | 57654.0 |
| 2011-12-08 12:30:00 | ES | Futures | 1247.77 | 1248.27 | 1245.52 | 1246.52 | 44075.0 |
| 2011-12-08 13:00:00 | ES | Futures | 1246.52 | 1246.52 | 1240.5 | 1243.01 | 99815.0 |
| 2011-12-08 13:30:00 | ES | Futures | 1243.01 | 1244.76 | 1241.25 | 1244.26 | 48423.0 |
| 2011-12-08 14:00:00 | ES | Futures | 1244.26 | 1246.02 | 1241.0 | 1244.01 | 47797.0 |
| 2011-12-08 14:30:00 | ES | Futures | 1243.76 | 1245.01 | 1239.25 | 1240.5 | 60833.0 |
| 2011-12-08 15:00:00 | ES | Futures | 1240.75 | 1247.27 | 1239.75 | 1245.77 | 90528.0 |
| 2011-12-08 15:30:00 | ES | Futures | 1246.02 | 1250.28 | 1234.48 | 1237.74 | 226220.0 |
| 2011-12-08 16:00:00 | ES | Futures | 1237.99 | 1240.75 | 1237.24 | 1239.0 | 62260.0 |
| 2011-12-08 16:30:00 | ES | Futures | 1239.25 | 1239.5 | 1236.24 | 1236.24 | 5294.0 |
| 2011-12-08 17:00:00 | ES | Futures | 1236.49 | 1237.24 | 1235.48 | 1235.48 | 1868.0 |
| 2011-12-08 18:00:00 | ES | Futures | 1237.24 | 1239.0 | 1236.74 | 1238.74 | 3527.0 |
| 2011-12-08 18:30:00 | ES | Futures | 1239.0 | 1240.0 | 1238.24 | 1239.5 | 1748.0 |
| 2011-12-08 19:00:00 | ES | Futures | 1239.75 | 1241.5 | 1238.49 | 1240.5 | 2155.0 |
| 2011-12-08 19:30:00 | ES | Futures | 1240.75 | 1240.75 | 1239.0 | 1239.25 | 1087.0 |
| 2011-12-08 20:00:00 | ES | Futures | 1239.25 | 1242.76 | 1239.25 | 1242.76 | 2790.0 |
| 2011-12-08 20:30:00 | ES | Futures | 1242.76 | 1245.01 | 1241.75 | 1245.01 | 5327.0 |
| 2011-12-08 21:00:00 | ES | Futures | 1245.01 | 1246.77 | 1243.76 | 1245.26 | 3852.0 |
| 2011-12-08 21:30:00 | ES | Futures | 1245.01 | 1246.02 | 1241.75 | 1242.26 | 3951.0 |
| 2011-12-08 22:00:00 | ES | Futures | 1242.0 | 1242.0 | 1234.98 | 1236.49 | 6424.0 |
| 2011-12-08 22:30:00 | ES | Futures | 1236.74 | 1237.74 | 1235.48 | 1235.48 | 4001.0 |
| 2011-12-08 23:00:00 | ES | Futures | 1235.48 | 1245.52 | 1235.48 | 1242.76 | 7689.0 |
| 2011-12-08 23:30:00 | ES | Futures | 1243.01 | 1243.76 | 1240.75 | 1241.5 | 2457.0 |
| 2011-12-08 00:00:00 | NQ | Futures | 2682.84 | 2683.42 | 2677.94 | 2678.8 | 102.0 |
| 2011-12-08 00:30:00 | NQ | Futures | 2679.09 | 2681.11 | 2678.52 | 2678.8 | 64.0 |
| 2011-12-08 01:00:00 | NQ | Futures | 2678.8 | 2679.96 | 2677.36 | 2678.8 | 70.0 |
> showing 50 of 2,684 rows — these rows as CSV