PREVIEW / futures_30min / 2011-07-08
file: by_date/futures_30min/2011/2011-07-08.parquet size: 65 KB rows: 2,189
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-08 00:00:00 | ES | Futures | 1347.54 | 1347.79 | 1347.04 | 1347.29 | 1313.0 |
| 2011-07-08 00:30:00 | ES | Futures | 1347.54 | 1347.79 | 1347.04 | 1347.79 | 828.0 |
| 2011-07-08 01:00:00 | ES | Futures | 1347.79 | 1348.29 | 1347.29 | 1348.29 | 1570.0 |
| 2011-07-08 01:30:00 | ES | Futures | 1348.04 | 1348.54 | 1347.79 | 1348.04 | 2530.0 |
| 2011-07-08 02:00:00 | ES | Futures | 1348.04 | 1349.28 | 1347.79 | 1348.79 | 6907.0 |
| 2011-07-08 02:30:00 | ES | Futures | 1349.03 | 1350.28 | 1348.79 | 1349.03 | 5455.0 |
| 2011-07-08 03:00:00 | ES | Futures | 1349.28 | 1349.53 | 1347.29 | 1347.54 | 12408.0 |
| 2011-07-08 03:30:00 | ES | Futures | 1347.54 | 1348.79 | 1346.54 | 1347.79 | 10455.0 |
| 2011-07-08 04:00:00 | ES | Futures | 1347.79 | 1348.79 | 1347.29 | 1347.79 | 6897.0 |
| 2011-07-08 04:30:00 | ES | Futures | 1347.79 | 1349.03 | 1347.54 | 1348.79 | 6001.0 |
| 2011-07-08 05:00:00 | ES | Futures | 1348.79 | 1348.79 | 1346.04 | 1346.29 | 12680.0 |
| 2011-07-08 05:30:00 | ES | Futures | 1346.54 | 1346.54 | 1343.8 | 1345.54 | 21637.0 |
| 2011-07-08 06:00:00 | ES | Futures | 1345.29 | 1346.29 | 1344.55 | 1345.79 | 16033.0 |
| 2011-07-08 06:30:00 | ES | Futures | 1345.54 | 1347.79 | 1345.29 | 1347.54 | 6045.0 |
| 2011-07-08 07:00:00 | ES | Futures | 1347.29 | 1348.54 | 1346.79 | 1347.54 | 8424.0 |
| 2011-07-08 07:30:00 | ES | Futures | 1347.79 | 1348.54 | 1347.04 | 1347.54 | 11954.0 |
| 2011-07-08 08:00:00 | ES | Futures | 1347.29 | 1351.28 | 1345.54 | 1348.54 | 57590.0 |
| 2011-07-08 08:30:00 | ES | Futures | 1348.29 | 1349.78 | 1329.08 | 1330.33 | 291079.0 |
| 2011-07-08 09:00:00 | ES | Futures | 1330.33 | 1331.58 | 1327.34 | 1330.58 | 113428.0 |
| 2011-07-08 09:30:00 | ES | Futures | 1330.58 | 1334.82 | 1330.58 | 1333.07 | 257874.0 |
| 2011-07-08 10:00:00 | ES | Futures | 1333.32 | 1333.57 | 1328.08 | 1330.08 | 211584.0 |
| 2011-07-08 10:30:00 | ES | Futures | 1330.08 | 1332.07 | 1327.59 | 1329.83 | 142864.0 |
| 2011-07-08 11:00:00 | ES | Futures | 1329.83 | 1329.83 | 1326.09 | 1327.59 | 165697.0 |
| 2011-07-08 11:30:00 | ES | Futures | 1327.84 | 1331.58 | 1326.59 | 1330.58 | 119302.0 |
| 2011-07-08 12:00:00 | ES | Futures | 1330.83 | 1331.58 | 1328.58 | 1329.58 | 49854.0 |
| 2011-07-08 12:30:00 | ES | Futures | 1329.58 | 1331.83 | 1329.33 | 1330.83 | 40934.0 |
| 2011-07-08 13:00:00 | ES | Futures | 1331.08 | 1332.57 | 1329.58 | 1332.32 | 65482.0 |
| 2011-07-08 13:30:00 | ES | Futures | 1332.57 | 1334.57 | 1331.33 | 1331.58 | 94527.0 |
| 2011-07-08 14:00:00 | ES | Futures | 1331.58 | 1333.32 | 1330.08 | 1331.33 | 54808.0 |
| 2011-07-08 14:30:00 | ES | Futures | 1331.33 | 1332.82 | 1331.08 | 1332.07 | 50232.0 |
| 2011-07-08 15:00:00 | ES | Futures | 1332.07 | 1334.07 | 1331.08 | 1332.32 | 57500.0 |
| 2011-07-08 15:30:00 | ES | Futures | 1332.32 | 1336.56 | 1331.83 | 1336.56 | 198949.0 |
| 2011-07-08 16:00:00 | ES | Futures | 1336.56 | 1339.31 | 1336.07 | 1338.56 | 124343.0 |
| 2011-07-08 00:00:00 | NQ | Futures | 2780.96 | 2781.25 | 2780.39 | 2780.68 | 179.0 |
| 2011-07-08 00:30:00 | NQ | Futures | 2780.68 | 2780.68 | 2780.1 | 2780.39 | 51.0 |
| 2011-07-08 01:00:00 | NQ | Futures | 2780.96 | 2782.11 | 2780.39 | 2781.83 | 121.0 |
| 2011-07-08 01:30:00 | NQ | Futures | 2782.11 | 2782.98 | 2781.54 | 2781.54 | 258.0 |
| 2011-07-08 02:00:00 | NQ | Futures | 2781.83 | 2782.98 | 2780.39 | 2782.4 | 774.0 |
| 2011-07-08 02:30:00 | NQ | Futures | 2782.69 | 2784.99 | 2782.4 | 2784.13 | 826.0 |
| 2011-07-08 03:00:00 | NQ | Futures | 2783.84 | 2784.13 | 2780.96 | 2780.96 | 1331.0 |
| 2011-07-08 03:30:00 | NQ | Futures | 2780.96 | 2783.27 | 2779.24 | 2781.54 | 1134.0 |
| 2011-07-08 04:00:00 | NQ | Futures | 2781.83 | 2783.84 | 2780.96 | 2781.83 | 721.0 |
| 2011-07-08 04:30:00 | NQ | Futures | 2781.83 | 2784.7 | 2781.25 | 2783.84 | 806.0 |
| 2011-07-08 05:00:00 | NQ | Futures | 2783.55 | 2784.13 | 2778.66 | 2779.52 | 1843.0 |
| 2011-07-08 05:30:00 | NQ | Futures | 2779.52 | 2779.52 | 2774.35 | 2776.94 | 2452.0 |
| 2011-07-08 06:00:00 | NQ | Futures | 2776.65 | 2778.95 | 2775.78 | 2778.09 | 1875.0 |
| 2011-07-08 06:30:00 | NQ | Futures | 2777.8 | 2782.11 | 2777.8 | 2781.83 | 1204.0 |
| 2011-07-08 07:00:00 | NQ | Futures | 2781.83 | 2783.55 | 2781.25 | 2782.4 | 1182.0 |
| 2011-07-08 07:30:00 | NQ | Futures | 2782.11 | 2783.55 | 2781.83 | 2782.11 | 1937.0 |
| 2011-07-08 08:00:00 | NQ | Futures | 2782.11 | 2787.58 | 2781.54 | 2783.27 | 7039.0 |
> showing 50 of 2,189 rows — these rows as CSV