PREVIEW / futures_30min / 2012-11-05
file: by_date/futures_30min/2012/2012-11-05.parquet size: 70 KB rows: 2,786
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-11-05 00:00:00 | ES | Futures | 1438.77 | 1439.79 | 1438.52 | 1439.54 | 1576.0 |
| 2012-11-05 00:30:00 | ES | Futures | 1439.79 | 1440.05 | 1439.03 | 1439.28 | 1161.0 |
| 2012-11-05 01:00:00 | ES | Futures | 1439.28 | 1439.54 | 1438.26 | 1438.52 | 1452.0 |
| 2012-11-05 01:30:00 | ES | Futures | 1438.52 | 1438.77 | 1438.26 | 1438.77 | 671.0 |
| 2012-11-05 02:00:00 | ES | Futures | 1438.52 | 1439.54 | 1438.01 | 1438.52 | 2002.0 |
| 2012-11-05 02:30:00 | ES | Futures | 1438.77 | 1439.54 | 1436.73 | 1437.24 | 4838.0 |
| 2012-11-05 03:00:00 | ES | Futures | 1437.24 | 1438.26 | 1434.43 | 1434.94 | 18478.0 |
| 2012-11-05 03:30:00 | ES | Futures | 1434.68 | 1438.26 | 1434.43 | 1436.22 | 11662.0 |
| 2012-11-05 04:00:00 | ES | Futures | 1435.96 | 1436.73 | 1435.45 | 1436.47 | 7616.0 |
| 2012-11-05 04:30:00 | ES | Futures | 1436.22 | 1437.49 | 1435.2 | 1435.2 | 6002.0 |
| 2012-11-05 05:00:00 | ES | Futures | 1435.2 | 1435.71 | 1434.43 | 1435.2 | 5650.0 |
| 2012-11-05 05:30:00 | ES | Futures | 1435.2 | 1437.75 | 1435.2 | 1437.49 | 12195.0 |
| 2012-11-05 06:00:00 | ES | Futures | 1437.49 | 1438.52 | 1435.71 | 1435.96 | 9336.0 |
| 2012-11-05 06:30:00 | ES | Futures | 1435.96 | 1437.49 | 1435.2 | 1436.98 | 7858.0 |
| 2012-11-05 07:00:00 | ES | Futures | 1436.73 | 1436.98 | 1434.68 | 1435.45 | 9083.0 |
| 2012-11-05 07:30:00 | ES | Futures | 1435.2 | 1435.45 | 1433.66 | 1435.2 | 12116.0 |
| 2012-11-05 08:00:00 | ES | Futures | 1435.2 | 1435.96 | 1433.92 | 1434.43 | 14466.0 |
| 2012-11-05 08:30:00 | ES | Futures | 1434.68 | 1438.26 | 1434.43 | 1437.49 | 27191.0 |
| 2012-11-05 09:00:00 | ES | Futures | 1437.49 | 1438.26 | 1436.47 | 1438.01 | 21171.0 |
| 2012-11-05 09:30:00 | ES | Futures | 1437.75 | 1438.52 | 1433.66 | 1435.71 | 173967.0 |
| 2012-11-05 10:00:00 | ES | Futures | 1435.45 | 1437.24 | 1433.66 | 1435.71 | 111191.0 |
| 2012-11-05 10:30:00 | ES | Futures | 1435.71 | 1441.07 | 1434.94 | 1440.56 | 141038.0 |
| 2012-11-05 11:00:00 | ES | Futures | 1440.56 | 1441.84 | 1439.28 | 1440.05 | 100912.0 |
| 2012-11-05 11:30:00 | ES | Futures | 1440.05 | 1440.05 | 1437.75 | 1438.77 | 63105.0 |
| 2012-11-05 12:00:00 | ES | Futures | 1439.03 | 1439.54 | 1437.49 | 1437.75 | 43920.0 |
| 2012-11-05 12:30:00 | ES | Futures | 1437.75 | 1437.75 | 1435.45 | 1436.22 | 78125.0 |
| 2012-11-05 13:00:00 | ES | Futures | 1436.47 | 1439.28 | 1435.96 | 1438.52 | 52047.0 |
| 2012-11-05 13:30:00 | ES | Futures | 1438.52 | 1439.79 | 1438.01 | 1438.77 | 32320.0 |
| 2012-11-05 14:00:00 | ES | Futures | 1439.03 | 1440.82 | 1438.77 | 1440.3 | 40261.0 |
| 2012-11-05 14:30:00 | ES | Futures | 1440.3 | 1442.6 | 1440.3 | 1441.33 | 47790.0 |
| 2012-11-05 15:00:00 | ES | Futures | 1441.33 | 1442.6 | 1440.82 | 1442.09 | 45958.0 |
| 2012-11-05 15:30:00 | ES | Futures | 1442.09 | 1446.44 | 1440.82 | 1443.63 | 173951.0 |
| 2012-11-05 16:00:00 | ES | Futures | 1443.37 | 1443.63 | 1442.09 | 1442.6 | 61306.0 |
| 2012-11-05 16:30:00 | ES | Futures | 1441.84 | 1442.6 | 1441.07 | 1441.58 | 5047.0 |
| 2012-11-05 17:00:00 | ES | Futures | 1441.58 | 1442.09 | 1440.56 | 1441.33 | 3748.0 |
| 2012-11-05 18:00:00 | ES | Futures | 1441.58 | 1442.35 | 1441.33 | 1441.84 | 1815.0 |
| 2012-11-05 18:30:00 | ES | Futures | 1442.09 | 1442.09 | 1441.33 | 1441.58 | 1070.0 |
| 2012-11-05 19:00:00 | ES | Futures | 1441.58 | 1441.84 | 1441.07 | 1441.33 | 1238.0 |
| 2012-11-05 19:30:00 | ES | Futures | 1441.07 | 1441.33 | 1440.82 | 1441.07 | 1428.0 |
| 2012-11-05 20:00:00 | ES | Futures | 1441.07 | 1441.84 | 1440.82 | 1441.58 | 1103.0 |
| 2012-11-05 20:30:00 | ES | Futures | 1441.33 | 1441.84 | 1441.07 | 1441.84 | 1432.0 |
| 2012-11-05 21:00:00 | ES | Futures | 1441.84 | 1441.84 | 1441.07 | 1441.33 | 1112.0 |
| 2012-11-05 21:30:00 | ES | Futures | 1441.33 | 1442.09 | 1441.33 | 1442.09 | 1035.0 |
| 2012-11-05 22:00:00 | ES | Futures | 1442.35 | 1442.86 | 1441.58 | 1441.58 | 1977.0 |
| 2012-11-05 22:30:00 | ES | Futures | 1441.58 | 1444.39 | 1441.33 | 1444.39 | 4923.0 |
| 2012-11-05 23:00:00 | ES | Futures | 1444.14 | 1444.65 | 1443.88 | 1444.39 | 1025.0 |
| 2012-11-05 23:30:00 | ES | Futures | 1444.14 | 1444.65 | 1443.88 | 1444.39 | 1871.0 |
| 2012-11-05 00:00:00 | NQ | Futures | 3078.37 | 3079.53 | 3077.79 | 3079.24 | 156.0 |
| 2012-11-05 00:30:00 | NQ | Futures | 3079.53 | 3079.82 | 3078.08 | 3078.95 | 108.0 |
| 2012-11-05 01:00:00 | NQ | Futures | 3078.37 | 3078.37 | 3076.33 | 3076.91 | 109.0 |
> showing 50 of 2,786 rows — these rows as CSV