PREVIEW / futures_30min / 2012-03-08
file: by_date/futures_30min/2012/2012-03-08.parquet size: 76 KB rows: 2,745
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 |
|---|---|---|---|---|---|---|---|
| 2012-03-08 00:00:00 | ES | Futures | 1365.77 | 1365.77 | 1364.77 | 1364.77 | 1408.0 |
| 2012-03-08 00:30:00 | ES | Futures | 1364.77 | 1365.52 | 1364.77 | 1365.02 | 1236.0 |
| 2012-03-08 01:00:00 | ES | Futures | 1365.27 | 1365.52 | 1364.77 | 1365.52 | 1693.0 |
| 2012-03-08 01:30:00 | ES | Futures | 1365.27 | 1365.27 | 1364.26 | 1364.77 | 1211.0 |
| 2012-03-08 02:00:00 | ES | Futures | 1364.77 | 1366.53 | 1364.52 | 1365.77 | 6059.0 |
| 2012-03-08 02:30:00 | ES | Futures | 1365.77 | 1367.29 | 1365.27 | 1366.78 | 8395.0 |
| 2012-03-08 03:00:00 | ES | Futures | 1366.78 | 1368.04 | 1366.28 | 1367.79 | 19195.0 |
| 2012-03-08 03:30:00 | ES | Futures | 1367.79 | 1368.55 | 1367.29 | 1368.55 | 10406.0 |
| 2012-03-08 04:00:00 | ES | Futures | 1368.55 | 1373.33 | 1367.79 | 1372.07 | 45406.0 |
| 2012-03-08 04:30:00 | ES | Futures | 1372.33 | 1374.09 | 1372.07 | 1372.58 | 18170.0 |
| 2012-03-08 05:00:00 | ES | Futures | 1372.58 | 1374.59 | 1372.33 | 1373.59 | 14526.0 |
| 2012-03-08 05:30:00 | ES | Futures | 1373.33 | 1375.35 | 1373.33 | 1374.59 | 16815.0 |
| 2012-03-08 06:00:00 | ES | Futures | 1374.34 | 1376.61 | 1374.34 | 1375.35 | 20716.0 |
| 2012-03-08 06:30:00 | ES | Futures | 1375.6 | 1376.36 | 1374.85 | 1375.85 | 9561.0 |
| 2012-03-08 07:00:00 | ES | Futures | 1375.85 | 1376.61 | 1374.85 | 1375.35 | 20863.0 |
| 2012-03-08 07:30:00 | ES | Futures | 1375.6 | 1375.6 | 1373.84 | 1374.59 | 22259.0 |
| 2012-03-08 08:00:00 | ES | Futures | 1374.59 | 1375.35 | 1373.33 | 1373.84 | 22632.0 |
| 2012-03-08 08:30:00 | ES | Futures | 1373.84 | 1374.85 | 1371.82 | 1372.07 | 37284.0 |
| 2012-03-08 09:00:00 | ES | Futures | 1372.07 | 1373.08 | 1370.81 | 1371.07 | 39204.0 |
| 2012-03-08 09:30:00 | ES | Futures | 1371.07 | 1373.59 | 1370.06 | 1371.07 | 146154.0 |
| 2012-03-08 10:00:00 | ES | Futures | 1370.81 | 1371.57 | 1368.29 | 1369.3 | 99722.0 |
| 2012-03-08 10:30:00 | ES | Futures | 1369.3 | 1371.82 | 1369.05 | 1371.82 | 89167.0 |
| 2012-03-08 11:00:00 | ES | Futures | 1371.82 | 1374.09 | 1371.32 | 1373.08 | 108594.0 |
| 2012-03-08 11:30:00 | ES | Futures | 1373.33 | 1374.09 | 1372.83 | 1373.84 | 55300.0 |
| 2012-03-08 12:00:00 | ES | Futures | 1373.84 | 1375.6 | 1373.59 | 1375.1 | 60876.0 |
| 2012-03-08 12:30:00 | ES | Futures | 1374.85 | 1376.36 | 1374.85 | 1375.85 | 39106.0 |
| 2012-03-08 13:00:00 | ES | Futures | 1375.85 | 1376.11 | 1374.85 | 1375.35 | 30161.0 |
| 2012-03-08 13:30:00 | ES | Futures | 1375.1 | 1376.11 | 1374.34 | 1374.85 | 22416.0 |
| 2012-03-08 14:00:00 | ES | Futures | 1374.85 | 1375.35 | 1373.84 | 1374.59 | 40392.0 |
| 2012-03-08 14:30:00 | ES | Futures | 1374.59 | 1378.63 | 1373.84 | 1378.12 | 63214.0 |
| 2012-03-08 15:00:00 | ES | Futures | 1378.12 | 1379.38 | 1377.37 | 1378.12 | 48109.0 |
| 2012-03-08 15:30:00 | ES | Futures | 1378.37 | 1378.63 | 1375.85 | 1376.36 | 90205.0 |
| 2012-03-08 16:00:00 | ES | Futures | 1376.36 | 1377.87 | 1375.6 | 1377.11 | 61237.0 |
| 2012-03-08 16:30:00 | ES | Futures | 1377.11 | 1377.11 | 1376.11 | 1376.36 | 6484.0 |
| 2012-03-08 17:00:00 | ES | Futures | 1376.36 | 1377.11 | 1376.11 | 1377.11 | 1069.0 |
| 2012-03-08 18:00:00 | ES | Futures | 1376.11 | 1377.11 | 1376.11 | 1376.86 | 2366.0 |
| 2012-03-08 18:30:00 | ES | Futures | 1376.86 | 1377.11 | 1376.36 | 1376.61 | 626.0 |
| 2012-03-08 19:00:00 | ES | Futures | 1376.61 | 1376.86 | 1375.85 | 1376.11 | 2372.0 |
| 2012-03-08 19:30:00 | ES | Futures | 1376.36 | 1376.36 | 1374.59 | 1375.35 | 3096.0 |
| 2012-03-08 20:00:00 | ES | Futures | 1375.1 | 1375.85 | 1374.59 | 1375.6 | 2146.0 |
| 2012-03-08 20:30:00 | ES | Futures | 1375.6 | 1376.11 | 1374.59 | 1375.1 | 1301.0 |
| 2012-03-08 21:00:00 | ES | Futures | 1375.35 | 1376.36 | 1375.35 | 1375.85 | 1641.0 |
| 2012-03-08 21:30:00 | ES | Futures | 1375.85 | 1376.86 | 1375.6 | 1376.61 | 696.0 |
| 2012-03-08 22:00:00 | ES | Futures | 1376.86 | 1377.11 | 1376.61 | 1376.86 | 694.0 |
| 2012-03-08 22:30:00 | ES | Futures | 1376.86 | 1377.11 | 1376.61 | 1376.86 | 930.0 |
| 2012-03-08 23:00:00 | ES | Futures | 1377.11 | 1377.87 | 1376.86 | 1377.37 | 1423.0 |
| 2012-03-08 23:30:00 | ES | Futures | 1377.11 | 1378.37 | 1377.11 | 1378.12 | 1059.0 |
| 2012-03-08 00:00:00 | NQ | Futures | 3016.79 | 3017.37 | 3014.48 | 3014.48 | 118.0 |
| 2012-03-08 00:30:00 | NQ | Futures | 3014.19 | 3015.92 | 3014.19 | 3015.63 | 55.0 |
| 2012-03-08 01:00:00 | NQ | Futures | 3015.34 | 3016.5 | 3015.05 | 3016.21 | 118.0 |
> showing 50 of 2,745 rows — these rows as CSV