PREVIEW / futures_30min / 2011-07-01
file: by_date/futures_30min/2011/2011-07-01.parquet size: 63 KB rows: 2,158
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-01 00:00:00 | ES | Futures | 1310.63 | 1311.62 | 1310.38 | 1311.37 | 1194.0 |
| 2011-07-01 00:30:00 | ES | Futures | 1311.37 | 1311.62 | 1310.88 | 1311.37 | 736.0 |
| 2011-07-01 01:00:00 | ES | Futures | 1311.37 | 1312.12 | 1310.88 | 1310.88 | 1751.0 |
| 2011-07-01 01:30:00 | ES | Futures | 1311.12 | 1311.62 | 1310.38 | 1311.62 | 2715.0 |
| 2011-07-01 02:00:00 | ES | Futures | 1311.62 | 1312.37 | 1310.88 | 1312.12 | 4585.0 |
| 2011-07-01 02:30:00 | ES | Futures | 1311.87 | 1312.62 | 1311.37 | 1311.37 | 9387.0 |
| 2011-07-01 03:00:00 | ES | Futures | 1311.62 | 1312.37 | 1309.63 | 1310.13 | 15198.0 |
| 2011-07-01 03:30:00 | ES | Futures | 1310.13 | 1310.63 | 1309.38 | 1309.88 | 11624.0 |
| 2011-07-01 04:00:00 | ES | Futures | 1309.88 | 1311.37 | 1309.88 | 1310.38 | 7152.0 |
| 2011-07-01 04:30:00 | ES | Futures | 1310.38 | 1312.87 | 1309.88 | 1312.37 | 8244.0 |
| 2011-07-01 05:00:00 | ES | Futures | 1312.12 | 1313.37 | 1311.87 | 1312.87 | 8728.0 |
| 2011-07-01 05:30:00 | ES | Futures | 1312.87 | 1313.12 | 1310.88 | 1312.12 | 7925.0 |
| 2011-07-01 06:00:00 | ES | Futures | 1312.12 | 1313.87 | 1311.87 | 1313.37 | 14923.0 |
| 2011-07-01 06:30:00 | ES | Futures | 1313.62 | 1314.37 | 1312.37 | 1312.62 | 11365.0 |
| 2011-07-01 07:00:00 | ES | Futures | 1312.62 | 1313.37 | 1311.62 | 1312.37 | 7879.0 |
| 2011-07-01 07:30:00 | ES | Futures | 1312.37 | 1313.37 | 1311.37 | 1312.12 | 11036.0 |
| 2011-07-01 08:00:00 | ES | Futures | 1312.37 | 1313.87 | 1311.37 | 1313.12 | 15622.0 |
| 2011-07-01 08:30:00 | ES | Futures | 1313.12 | 1314.12 | 1311.87 | 1312.37 | 18185.0 |
| 2011-07-01 09:00:00 | ES | Futures | 1312.37 | 1312.87 | 1311.37 | 1312.62 | 21878.0 |
| 2011-07-01 09:30:00 | ES | Futures | 1312.37 | 1313.87 | 1310.13 | 1313.37 | 147199.0 |
| 2011-07-01 10:00:00 | ES | Futures | 1313.62 | 1323.1 | 1313.37 | 1322.35 | 387340.0 |
| 2011-07-01 10:30:00 | ES | Futures | 1322.35 | 1324.84 | 1321.6 | 1322.1 | 182324.0 |
| 2011-07-01 11:00:00 | ES | Futures | 1322.35 | 1324.59 | 1321.85 | 1324.34 | 102562.0 |
| 2011-07-01 11:30:00 | ES | Futures | 1324.34 | 1325.34 | 1323.35 | 1324.34 | 83721.0 |
| 2011-07-01 12:00:00 | ES | Futures | 1324.34 | 1326.59 | 1323.6 | 1325.84 | 66604.0 |
| 2011-07-01 12:30:00 | ES | Futures | 1325.84 | 1326.34 | 1324.84 | 1326.09 | 48709.0 |
| 2011-07-01 13:00:00 | ES | Futures | 1326.09 | 1328.58 | 1325.59 | 1328.08 | 93222.0 |
| 2011-07-01 13:30:00 | ES | Futures | 1328.08 | 1329.83 | 1327.59 | 1329.08 | 73725.0 |
| 2011-07-01 14:00:00 | ES | Futures | 1329.08 | 1330.08 | 1328.33 | 1329.83 | 58793.0 |
| 2011-07-01 14:30:00 | ES | Futures | 1329.83 | 1332.57 | 1329.33 | 1332.07 | 84852.0 |
| 2011-07-01 15:00:00 | ES | Futures | 1332.07 | 1332.57 | 1329.83 | 1330.58 | 90508.0 |
| 2011-07-01 15:30:00 | ES | Futures | 1330.33 | 1333.32 | 1329.83 | 1331.58 | 202209.0 |
| 2011-07-01 16:00:00 | ES | Futures | 1331.58 | 1332.57 | 1331.08 | 1332.07 | 112011.0 |
| 2011-07-01 00:00:00 | NQ | Futures | 2668.16 | 2669.6 | 2668.16 | 2669.6 | 226.0 |
| 2011-07-01 00:30:00 | NQ | Futures | 2669.6 | 2670.17 | 2669.02 | 2669.89 | 167.0 |
| 2011-07-01 01:00:00 | NQ | Futures | 2670.17 | 2671.61 | 2669.31 | 2670.46 | 160.0 |
| 2011-07-01 01:30:00 | NQ | Futures | 2670.46 | 2670.75 | 2669.31 | 2670.17 | 305.0 |
| 2011-07-01 02:00:00 | NQ | Futures | 2670.17 | 2671.61 | 2669.89 | 2671.61 | 531.0 |
| 2011-07-01 02:30:00 | NQ | Futures | 2671.61 | 2672.76 | 2671.33 | 2671.61 | 426.0 |
| 2011-07-01 03:00:00 | NQ | Futures | 2671.33 | 2673.63 | 2668.16 | 2668.74 | 1924.0 |
| 2011-07-01 03:30:00 | NQ | Futures | 2668.74 | 2670.46 | 2667.01 | 2668.16 | 1267.0 |
| 2011-07-01 04:00:00 | NQ | Futures | 2668.16 | 2671.33 | 2667.58 | 2669.02 | 1056.0 |
| 2011-07-01 04:30:00 | NQ | Futures | 2668.74 | 2674.2 | 2667.58 | 2672.76 | 790.0 |
| 2011-07-01 05:00:00 | NQ | Futures | 2672.48 | 2676.22 | 2671.61 | 2675.35 | 1325.0 |
| 2011-07-01 05:30:00 | NQ | Futures | 2675.07 | 2675.93 | 2671.61 | 2673.63 | 1032.0 |
| 2011-07-01 06:00:00 | NQ | Futures | 2673.34 | 2677.08 | 2673.05 | 2676.5 | 1301.0 |
| 2011-07-01 06:30:00 | NQ | Futures | 2676.79 | 2677.94 | 2673.92 | 2674.78 | 1193.0 |
| 2011-07-01 07:00:00 | NQ | Futures | 2674.78 | 2675.64 | 2672.48 | 2673.92 | 1537.0 |
| 2011-07-01 07:30:00 | NQ | Futures | 2674.2 | 2675.35 | 2671.61 | 2672.76 | 1262.0 |
| 2011-07-01 08:00:00 | NQ | Futures | 2673.05 | 2675.64 | 2671.9 | 2674.49 | 1983.0 |
> showing 50 of 2,158 rows — these rows as CSV