PREVIEW / futures_30min / 2011-06-13
file: by_date/futures_30min/2011/2011-06-13.parquet size: 71 KB rows: 2,577
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-13 00:00:00 | ES | Futures | 1262.77 | 1262.77 | 1262.03 | 1262.52 | 207.0 |
| 2011-06-13 00:30:00 | ES | Futures | 1262.28 | 1262.28 | 1261.78 | 1261.78 | 272.0 |
| 2011-06-13 01:00:00 | ES | Futures | 1262.03 | 1262.28 | 1261.78 | 1262.03 | 449.0 |
| 2011-06-13 01:30:00 | ES | Futures | 1261.78 | 1263.27 | 1261.78 | 1263.27 | 1438.0 |
| 2011-06-13 02:00:00 | ES | Futures | 1263.02 | 1264.01 | 1262.52 | 1263.77 | 2146.0 |
| 2011-06-13 02:30:00 | ES | Futures | 1263.77 | 1265.01 | 1263.77 | 1264.51 | 1149.0 |
| 2011-06-13 03:00:00 | ES | Futures | 1264.51 | 1265.01 | 1262.77 | 1264.26 | 3112.0 |
| 2011-06-13 03:30:00 | ES | Futures | 1264.26 | 1265.75 | 1264.26 | 1265.01 | 3309.0 |
| 2011-06-13 04:00:00 | ES | Futures | 1264.76 | 1265.75 | 1264.51 | 1264.51 | 5149.0 |
| 2011-06-13 04:30:00 | ES | Futures | 1264.51 | 1265.51 | 1261.53 | 1261.78 | 3876.0 |
| 2011-06-13 05:00:00 | ES | Futures | 1261.53 | 1262.52 | 1260.78 | 1262.03 | 2696.0 |
| 2011-06-13 05:30:00 | ES | Futures | 1262.03 | 1262.77 | 1261.28 | 1262.52 | 1999.0 |
| 2011-06-13 06:00:00 | ES | Futures | 1262.52 | 1264.26 | 1261.78 | 1264.01 | 1478.0 |
| 2011-06-13 06:30:00 | ES | Futures | 1264.01 | 1264.76 | 1263.52 | 1264.51 | 3537.0 |
| 2011-06-13 07:00:00 | ES | Futures | 1264.26 | 1266.25 | 1264.26 | 1265.75 | 6457.0 |
| 2011-06-13 07:30:00 | ES | Futures | 1265.75 | 1265.75 | 1263.77 | 1264.26 | 3293.0 |
| 2011-06-13 08:00:00 | ES | Futures | 1264.26 | 1266.25 | 1264.26 | 1265.51 | 6586.0 |
| 2011-06-13 08:30:00 | ES | Futures | 1265.75 | 1267.49 | 1265.26 | 1267.0 | 7343.0 |
| 2011-06-13 09:00:00 | ES | Futures | 1267.0 | 1267.49 | 1265.26 | 1265.51 | 5370.0 |
| 2011-06-13 09:30:00 | ES | Futures | 1265.51 | 1268.98 | 1264.51 | 1267.74 | 35093.0 |
| 2011-06-13 10:00:00 | ES | Futures | 1267.74 | 1268.73 | 1265.01 | 1267.74 | 24070.0 |
| 2011-06-13 10:30:00 | ES | Futures | 1267.99 | 1267.99 | 1264.26 | 1265.51 | 17991.0 |
| 2011-06-13 11:00:00 | ES | Futures | 1265.26 | 1266.5 | 1263.02 | 1265.75 | 21120.0 |
| 2011-06-13 11:30:00 | ES | Futures | 1265.75 | 1266.5 | 1262.28 | 1262.77 | 20323.0 |
| 2011-06-13 12:00:00 | ES | Futures | 1263.02 | 1264.26 | 1260.78 | 1261.53 | 16059.0 |
| 2011-06-13 12:30:00 | ES | Futures | 1261.53 | 1263.52 | 1260.29 | 1260.78 | 8971.0 |
| 2011-06-13 13:00:00 | ES | Futures | 1260.78 | 1262.52 | 1257.06 | 1261.78 | 26438.0 |
| 2011-06-13 13:30:00 | ES | Futures | 1261.78 | 1267.0 | 1261.03 | 1266.75 | 18617.0 |
| 2011-06-13 14:00:00 | ES | Futures | 1266.75 | 1269.23 | 1265.75 | 1267.0 | 20083.0 |
| 2011-06-13 14:30:00 | ES | Futures | 1267.0 | 1268.98 | 1264.51 | 1265.51 | 17517.0 |
| 2011-06-13 15:00:00 | ES | Futures | 1265.51 | 1267.74 | 1263.77 | 1266.0 | 14093.0 |
| 2011-06-13 15:30:00 | ES | Futures | 1266.25 | 1266.25 | 1262.03 | 1263.52 | 25102.0 |
| 2011-06-13 16:00:00 | ES | Futures | 1263.77 | 1264.76 | 1262.52 | 1263.77 | 12567.0 |
| 2011-06-13 16:30:00 | ES | Futures | 1264.01 | 1265.75 | 1264.01 | 1265.01 | 1254.0 |
| 2011-06-13 17:00:00 | ES | Futures | 1264.76 | 1265.01 | 1264.51 | 1265.01 | 141.0 |
| 2011-06-13 18:00:00 | ES | Futures | 1264.76 | 1265.51 | 1264.76 | 1264.76 | 265.0 |
| 2011-06-13 18:30:00 | ES | Futures | 1264.76 | 1265.51 | 1264.76 | 1265.26 | 522.0 |
| 2011-06-13 19:00:00 | ES | Futures | 1265.51 | 1265.51 | 1264.76 | 1265.26 | 177.0 |
| 2011-06-13 19:30:00 | ES | Futures | 1265.26 | 1265.51 | 1265.01 | 1265.01 | 148.0 |
| 2011-06-13 20:00:00 | ES | Futures | 1265.51 | 1265.75 | 1265.01 | 1265.51 | 719.0 |
| 2011-06-13 20:30:00 | ES | Futures | 1265.51 | 1265.51 | 1264.26 | 1264.26 | 410.0 |
| 2011-06-13 21:00:00 | ES | Futures | 1264.01 | 1264.01 | 1262.52 | 1262.77 | 1198.0 |
| 2011-06-13 21:30:00 | ES | Futures | 1262.77 | 1265.26 | 1262.77 | 1265.26 | 821.0 |
| 2011-06-13 22:00:00 | ES | Futures | 1265.26 | 1270.97 | 1265.26 | 1269.98 | 5822.0 |
| 2011-06-13 22:30:00 | ES | Futures | 1269.73 | 1270.97 | 1269.48 | 1269.98 | 1517.0 |
| 2011-06-13 23:00:00 | ES | Futures | 1270.23 | 1270.72 | 1269.23 | 1270.23 | 491.0 |
| 2011-06-13 23:30:00 | ES | Futures | 1269.98 | 1272.21 | 1269.98 | 1270.97 | 1239.0 |
| 2011-06-13 00:00:00 | NQ | Futures | 2555.09 | 2555.09 | 2554.23 | 2555.09 | 8.0 |
| 2011-06-13 00:30:00 | NQ | Futures | 2554.52 | 2554.52 | 2553.65 | 2553.94 | 6.0 |
| 2011-06-13 01:00:00 | NQ | Futures | 2553.65 | 2553.94 | 2553.37 | 2553.37 | 11.0 |
> showing 50 of 2,577 rows — these rows as CSV