PREVIEW / futures_30min / 2011-07-04
file: by_date/futures_30min/2011/2011-07-04.parquet size: 48 KB rows: 1,754
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-04 00:00:00 | ES | Futures | 1330.83 | 1331.08 | 1329.58 | 1329.83 | 1345.0 |
| 2011-07-04 00:30:00 | ES | Futures | 1329.83 | 1330.83 | 1329.83 | 1330.58 | 1319.0 |
| 2011-07-04 01:00:00 | ES | Futures | 1330.58 | 1330.83 | 1326.34 | 1326.84 | 8626.0 |
| 2011-07-04 01:30:00 | ES | Futures | 1326.84 | 1327.59 | 1325.09 | 1327.09 | 7672.0 |
| 2011-07-04 02:00:00 | ES | Futures | 1327.09 | 1329.33 | 1326.84 | 1328.08 | 6432.0 |
| 2011-07-04 02:30:00 | ES | Futures | 1328.33 | 1329.83 | 1328.08 | 1328.08 | 5163.0 |
| 2011-07-04 03:00:00 | ES | Futures | 1328.33 | 1328.33 | 1326.84 | 1327.34 | 7387.0 |
| 2011-07-04 03:30:00 | ES | Futures | 1327.59 | 1328.33 | 1326.84 | 1327.34 | 6293.0 |
| 2011-07-04 04:00:00 | ES | Futures | 1327.34 | 1329.33 | 1327.09 | 1329.08 | 5664.0 |
| 2011-07-04 04:30:00 | ES | Futures | 1329.08 | 1329.83 | 1328.08 | 1329.08 | 4217.0 |
| 2011-07-04 05:00:00 | ES | Futures | 1329.33 | 1329.83 | 1328.58 | 1329.33 | 3213.0 |
| 2011-07-04 05:30:00 | ES | Futures | 1329.08 | 1329.33 | 1328.33 | 1329.08 | 1685.0 |
| 2011-07-04 06:00:00 | ES | Futures | 1329.08 | 1329.33 | 1327.59 | 1328.58 | 3741.0 |
| 2011-07-04 06:30:00 | ES | Futures | 1328.58 | 1329.08 | 1327.84 | 1328.58 | 2340.0 |
| 2011-07-04 07:00:00 | ES | Futures | 1328.83 | 1328.83 | 1327.84 | 1328.33 | 2797.0 |
| 2011-07-04 07:30:00 | ES | Futures | 1328.33 | 1328.58 | 1327.09 | 1327.34 | 3993.0 |
| 2011-07-04 08:00:00 | ES | Futures | 1327.59 | 1328.33 | 1327.34 | 1327.59 | 3915.0 |
| 2011-07-04 08:30:00 | ES | Futures | 1327.59 | 1329.33 | 1327.34 | 1328.58 | 4050.0 |
| 2011-07-04 09:00:00 | ES | Futures | 1328.83 | 1329.58 | 1328.58 | 1329.08 | 4861.0 |
| 2011-07-04 09:30:00 | ES | Futures | 1329.33 | 1330.08 | 1329.08 | 1329.58 | 5916.0 |
| 2011-07-04 10:00:00 | ES | Futures | 1329.58 | 1330.83 | 1329.58 | 1330.08 | 5974.0 |
| 2011-07-04 10:30:00 | ES | Futures | 1330.33 | 1330.83 | 1329.83 | 1330.33 | 4335.0 |
| 2011-07-04 11:00:00 | ES | Futures | 1330.33 | 1331.33 | 1330.08 | 1330.58 | 6244.0 |
| 2011-07-04 18:00:00 | ES | Futures | 1330.83 | 1331.33 | 1330.08 | 1330.83 | 2470.0 |
| 2011-07-04 18:30:00 | ES | Futures | 1330.58 | 1331.58 | 1330.33 | 1331.58 | 2250.0 |
| 2011-07-04 19:00:00 | ES | Futures | 1331.58 | 1331.83 | 1331.08 | 1331.83 | 1543.0 |
| 2011-07-04 19:30:00 | ES | Futures | 1331.58 | 1332.32 | 1331.58 | 1332.07 | 2039.0 |
| 2011-07-04 20:00:00 | ES | Futures | 1331.83 | 1332.32 | 1330.83 | 1332.32 | 3382.0 |
| 2011-07-04 20:30:00 | ES | Futures | 1332.07 | 1332.82 | 1331.83 | 1332.57 | 3556.0 |
| 2011-07-04 21:00:00 | ES | Futures | 1332.57 | 1332.82 | 1332.07 | 1332.32 | 2375.0 |
| 2011-07-04 21:30:00 | ES | Futures | 1332.32 | 1332.57 | 1329.33 | 1329.58 | 7307.0 |
| 2011-07-04 22:00:00 | ES | Futures | 1329.58 | 1330.58 | 1328.58 | 1330.58 | 4396.0 |
| 2011-07-04 22:30:00 | ES | Futures | 1330.58 | 1330.83 | 1329.33 | 1330.33 | 2689.0 |
| 2011-07-04 23:00:00 | ES | Futures | 1330.33 | 1331.08 | 1330.08 | 1330.83 | 1148.0 |
| 2011-07-04 23:30:00 | ES | Futures | 1331.08 | 1331.83 | 1330.08 | 1331.08 | 1954.0 |
| 2011-07-04 00:00:00 | NQ | Futures | 2714.78 | 2715.64 | 2713.05 | 2713.63 | 133.0 |
| 2011-07-04 00:30:00 | NQ | Futures | 2713.63 | 2715.07 | 2713.63 | 2715.07 | 98.0 |
| 2011-07-04 01:00:00 | NQ | Futures | 2714.78 | 2714.78 | 2707.87 | 2708.73 | 716.0 |
| 2011-07-04 01:30:00 | NQ | Futures | 2708.45 | 2710.46 | 2707.01 | 2708.73 | 397.0 |
| 2011-07-04 02:00:00 | NQ | Futures | 2709.31 | 2712.48 | 2709.31 | 2710.75 | 387.0 |
| 2011-07-04 02:30:00 | NQ | Futures | 2711.61 | 2714.2 | 2709.6 | 2710.17 | 265.0 |
| 2011-07-04 03:00:00 | NQ | Futures | 2710.17 | 2710.46 | 2706.72 | 2708.73 | 1369.0 |
| 2011-07-04 03:30:00 | NQ | Futures | 2709.02 | 2711.32 | 2707.87 | 2709.6 | 905.0 |
| 2011-07-04 04:00:00 | NQ | Futures | 2709.89 | 2711.04 | 2709.02 | 2710.46 | 879.0 |
| 2011-07-04 04:30:00 | NQ | Futures | 2710.75 | 2713.34 | 2709.02 | 2711.61 | 681.0 |
| 2011-07-04 05:00:00 | NQ | Futures | 2711.61 | 2712.48 | 2710.17 | 2711.04 | 343.0 |
| 2011-07-04 05:30:00 | NQ | Futures | 2711.04 | 2711.32 | 2710.17 | 2710.75 | 178.0 |
| 2011-07-04 06:00:00 | NQ | Futures | 2711.04 | 2711.9 | 2709.89 | 2711.61 | 359.0 |
| 2011-07-04 06:30:00 | NQ | Futures | 2711.61 | 2712.19 | 2710.75 | 2711.9 | 321.0 |
| 2011-07-04 07:00:00 | NQ | Futures | 2711.9 | 2712.48 | 2711.04 | 2711.32 | 338.0 |
> showing 50 of 1,754 rows — these rows as CSV