PREVIEW / futures_30min / 2011-07-07
file: by_date/futures_30min/2011/2011-07-07.parquet size: 73 KB rows: 2,678
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-07-07 00:00:00 | ES | Futures | 1338.06 | 1338.81 | 1337.81 | 1338.56 | 1189.0 |
| 2011-07-07 00:30:00 | ES | Futures | 1338.56 | 1339.56 | 1337.56 | 1339.31 | 2875.0 |
| 2011-07-07 01:00:00 | ES | Futures | 1339.31 | 1340.31 | 1338.56 | 1338.81 | 2819.0 |
| 2011-07-07 01:30:00 | ES | Futures | 1339.06 | 1339.06 | 1337.81 | 1337.81 | 3356.0 |
| 2011-07-07 02:00:00 | ES | Futures | 1337.81 | 1339.06 | 1337.56 | 1338.31 | 4607.0 |
| 2011-07-07 02:30:00 | ES | Futures | 1338.31 | 1338.81 | 1337.06 | 1337.31 | 4175.0 |
| 2011-07-07 03:00:00 | ES | Futures | 1337.56 | 1337.81 | 1334.82 | 1336.07 | 24048.0 |
| 2011-07-07 03:30:00 | ES | Futures | 1335.82 | 1336.07 | 1334.07 | 1335.57 | 14836.0 |
| 2011-07-07 04:00:00 | ES | Futures | 1335.32 | 1336.81 | 1335.32 | 1335.57 | 7357.0 |
| 2011-07-07 04:30:00 | ES | Futures | 1335.82 | 1337.31 | 1335.57 | 1336.81 | 6771.0 |
| 2011-07-07 05:00:00 | ES | Futures | 1336.56 | 1338.31 | 1336.31 | 1336.56 | 8518.0 |
| 2011-07-07 05:30:00 | ES | Futures | 1336.56 | 1337.31 | 1335.82 | 1336.56 | 3766.0 |
| 2011-07-07 06:00:00 | ES | Futures | 1336.31 | 1336.81 | 1336.07 | 1336.07 | 3241.0 |
| 2011-07-07 06:30:00 | ES | Futures | 1336.07 | 1337.06 | 1335.32 | 1336.81 | 4155.0 |
| 2011-07-07 07:00:00 | ES | Futures | 1336.56 | 1337.81 | 1336.31 | 1337.31 | 9467.0 |
| 2011-07-07 07:30:00 | ES | Futures | 1337.06 | 1338.31 | 1336.56 | 1337.31 | 17363.0 |
| 2011-07-07 08:00:00 | ES | Futures | 1337.31 | 1344.3 | 1336.31 | 1342.55 | 78307.0 |
| 2011-07-07 08:30:00 | ES | Futures | 1342.55 | 1346.54 | 1341.05 | 1344.79 | 82043.0 |
| 2011-07-07 09:00:00 | ES | Futures | 1344.79 | 1345.29 | 1343.3 | 1343.8 | 42450.0 |
| 2011-07-07 09:30:00 | ES | Futures | 1343.8 | 1344.05 | 1341.05 | 1342.8 | 181342.0 |
| 2011-07-07 10:00:00 | ES | Futures | 1342.8 | 1344.3 | 1341.8 | 1343.55 | 132604.0 |
| 2011-07-07 10:30:00 | ES | Futures | 1343.55 | 1345.29 | 1342.8 | 1344.79 | 159032.0 |
| 2011-07-07 11:00:00 | ES | Futures | 1344.55 | 1344.79 | 1342.8 | 1343.3 | 107783.0 |
| 2011-07-07 11:30:00 | ES | Futures | 1343.3 | 1343.8 | 1342.3 | 1343.55 | 63568.0 |
| 2011-07-07 12:00:00 | ES | Futures | 1343.55 | 1345.54 | 1342.8 | 1344.79 | 54852.0 |
| 2011-07-07 12:30:00 | ES | Futures | 1344.55 | 1345.54 | 1344.3 | 1344.55 | 36474.0 |
| 2011-07-07 13:00:00 | ES | Futures | 1344.55 | 1347.29 | 1344.05 | 1346.79 | 68581.0 |
| 2011-07-07 13:30:00 | ES | Futures | 1346.79 | 1347.29 | 1345.79 | 1346.29 | 52259.0 |
| 2011-07-07 14:00:00 | ES | Futures | 1346.04 | 1349.28 | 1346.04 | 1348.79 | 75360.0 |
| 2011-07-07 14:30:00 | ES | Futures | 1348.79 | 1349.53 | 1348.04 | 1348.54 | 53057.0 |
| 2011-07-07 15:00:00 | ES | Futures | 1348.54 | 1349.28 | 1347.54 | 1347.54 | 45058.0 |
| 2011-07-07 15:30:00 | ES | Futures | 1347.54 | 1348.04 | 1345.54 | 1346.29 | 172125.0 |
| 2011-07-07 16:00:00 | ES | Futures | 1346.54 | 1349.03 | 1346.04 | 1348.79 | 91832.0 |
| 2011-07-07 16:30:00 | ES | Futures | 1348.29 | 1349.03 | 1348.04 | 1348.04 | 5715.0 |
| 2011-07-07 17:00:00 | ES | Futures | 1348.04 | 1349.03 | 1347.54 | 1348.54 | 3217.0 |
| 2011-07-07 18:00:00 | ES | Futures | 1348.29 | 1348.54 | 1347.29 | 1347.79 | 1360.0 |
| 2011-07-07 18:30:00 | ES | Futures | 1347.54 | 1348.04 | 1347.54 | 1347.54 | 289.0 |
| 2011-07-07 19:00:00 | ES | Futures | 1347.54 | 1347.79 | 1347.04 | 1347.54 | 1656.0 |
| 2011-07-07 19:30:00 | ES | Futures | 1347.54 | 1348.04 | 1347.54 | 1347.79 | 980.0 |
| 2011-07-07 20:00:00 | ES | Futures | 1347.79 | 1348.29 | 1346.79 | 1347.04 | 3087.0 |
| 2011-07-07 20:30:00 | ES | Futures | 1346.79 | 1347.79 | 1346.79 | 1347.29 | 1272.0 |
| 2011-07-07 21:00:00 | ES | Futures | 1347.29 | 1348.29 | 1347.29 | 1348.04 | 2003.0 |
| 2011-07-07 21:30:00 | ES | Futures | 1348.29 | 1348.54 | 1347.79 | 1348.29 | 1535.0 |
| 2011-07-07 22:00:00 | ES | Futures | 1348.04 | 1348.29 | 1347.79 | 1348.29 | 527.0 |
| 2011-07-07 22:30:00 | ES | Futures | 1348.29 | 1348.54 | 1347.29 | 1347.54 | 1181.0 |
| 2011-07-07 23:00:00 | ES | Futures | 1347.54 | 1347.79 | 1347.29 | 1347.54 | 743.0 |
| 2011-07-07 23:30:00 | ES | Futures | 1347.54 | 1348.29 | 1347.54 | 1347.79 | 660.0 |
| 2011-07-07 00:00:00 | NQ | Futures | 2746.72 | 2748.73 | 2746.72 | 2747.58 | 244.0 |
| 2011-07-07 00:30:00 | NQ | Futures | 2747.87 | 2748.73 | 2745.28 | 2748.45 | 285.0 |
| 2011-07-07 01:00:00 | NQ | Futures | 2748.16 | 2749.89 | 2747.58 | 2747.58 | 176.0 |
> showing 50 of 2,678 rows — these rows as CSV