PREVIEW / futures_30min / 2013-10-21
file: by_date/futures_30min/2013/2013-10-21.parquet size: 69 KB rows: 2,813
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-21 00:00:00 | ES | Futures | 1793.6 | 1794.63 | 1793.6 | 1794.37 | 1124.0 |
| 2013-10-21 00:30:00 | ES | Futures | 1794.63 | 1794.63 | 1794.11 | 1794.11 | 284.0 |
| 2013-10-21 01:00:00 | ES | Futures | 1794.11 | 1794.63 | 1794.11 | 1794.11 | 960.0 |
| 2013-10-21 01:30:00 | ES | Futures | 1794.11 | 1795.15 | 1793.6 | 1794.89 | 1986.0 |
| 2013-10-21 02:00:00 | ES | Futures | 1794.89 | 1796.69 | 1794.37 | 1795.4 | 7026.0 |
| 2013-10-21 02:30:00 | ES | Futures | 1795.15 | 1795.66 | 1794.37 | 1794.37 | 2679.0 |
| 2013-10-21 03:00:00 | ES | Futures | 1794.63 | 1794.63 | 1792.05 | 1792.31 | 13791.0 |
| 2013-10-21 03:30:00 | ES | Futures | 1792.05 | 1793.08 | 1791.79 | 1793.08 | 5654.0 |
| 2013-10-21 04:00:00 | ES | Futures | 1792.82 | 1793.86 | 1792.57 | 1793.6 | 3527.0 |
| 2013-10-21 04:30:00 | ES | Futures | 1793.6 | 1793.86 | 1792.57 | 1793.08 | 3493.0 |
| 2013-10-21 05:00:00 | ES | Futures | 1793.34 | 1793.34 | 1792.05 | 1792.57 | 4478.0 |
| 2013-10-21 05:30:00 | ES | Futures | 1792.31 | 1793.34 | 1792.05 | 1792.31 | 4084.0 |
| 2013-10-21 06:00:00 | ES | Futures | 1792.31 | 1792.82 | 1792.31 | 1792.57 | 1965.0 |
| 2013-10-21 06:30:00 | ES | Futures | 1792.57 | 1792.82 | 1791.02 | 1791.54 | 7048.0 |
| 2013-10-21 07:00:00 | ES | Futures | 1791.28 | 1793.08 | 1790.5 | 1792.57 | 6005.0 |
| 2013-10-21 07:30:00 | ES | Futures | 1792.57 | 1793.34 | 1792.31 | 1792.57 | 5721.0 |
| 2013-10-21 08:00:00 | ES | Futures | 1792.82 | 1794.37 | 1792.31 | 1793.6 | 11851.0 |
| 2013-10-21 08:30:00 | ES | Futures | 1793.6 | 1794.11 | 1793.08 | 1794.11 | 9165.0 |
| 2013-10-21 09:00:00 | ES | Futures | 1794.11 | 1795.15 | 1793.34 | 1794.63 | 16412.0 |
| 2013-10-21 09:30:00 | ES | Futures | 1794.63 | 1797.21 | 1792.57 | 1796.18 | 147739.0 |
| 2013-10-21 10:00:00 | ES | Futures | 1796.44 | 1797.98 | 1793.6 | 1793.6 | 113145.0 |
| 2013-10-21 10:30:00 | ES | Futures | 1793.6 | 1794.37 | 1791.28 | 1792.31 | 92004.0 |
| 2013-10-21 11:00:00 | ES | Futures | 1792.31 | 1793.6 | 1791.79 | 1793.34 | 71024.0 |
| 2013-10-21 11:30:00 | ES | Futures | 1793.6 | 1794.37 | 1791.79 | 1793.86 | 56287.0 |
| 2013-10-21 12:00:00 | ES | Futures | 1793.86 | 1794.63 | 1793.34 | 1793.86 | 39840.0 |
| 2013-10-21 12:30:00 | ES | Futures | 1794.11 | 1795.15 | 1793.6 | 1795.15 | 39806.0 |
| 2013-10-21 13:00:00 | ES | Futures | 1794.89 | 1795.4 | 1793.86 | 1794.11 | 44067.0 |
| 2013-10-21 13:30:00 | ES | Futures | 1794.11 | 1794.89 | 1793.6 | 1794.63 | 36159.0 |
| 2013-10-21 14:00:00 | ES | Futures | 1794.63 | 1794.63 | 1789.99 | 1791.28 | 72505.0 |
| 2013-10-21 14:30:00 | ES | Futures | 1791.54 | 1792.31 | 1790.76 | 1791.02 | 43379.0 |
| 2013-10-21 15:00:00 | ES | Futures | 1791.02 | 1793.86 | 1790.76 | 1792.57 | 55450.0 |
| 2013-10-21 15:30:00 | ES | Futures | 1792.57 | 1794.63 | 1791.79 | 1794.37 | 96752.0 |
| 2013-10-21 16:00:00 | ES | Futures | 1794.37 | 1795.15 | 1793.08 | 1793.34 | 61393.0 |
| 2013-10-21 16:30:00 | ES | Futures | 1793.08 | 1793.6 | 1792.57 | 1793.34 | 5854.0 |
| 2013-10-21 17:00:00 | ES | Futures | 1793.34 | 1793.34 | 1792.82 | 1793.08 | 493.0 |
| 2013-10-21 18:00:00 | ES | Futures | 1793.08 | 1793.34 | 1792.57 | 1793.34 | 1937.0 |
| 2013-10-21 18:30:00 | ES | Futures | 1793.34 | 1793.6 | 1792.57 | 1792.82 | 757.0 |
| 2013-10-21 19:00:00 | ES | Futures | 1792.82 | 1793.34 | 1792.31 | 1793.08 | 915.0 |
| 2013-10-21 19:30:00 | ES | Futures | 1793.08 | 1793.6 | 1792.82 | 1793.6 | 739.0 |
| 2013-10-21 20:00:00 | ES | Futures | 1793.6 | 1793.6 | 1792.05 | 1792.05 | 2702.0 |
| 2013-10-21 20:30:00 | ES | Futures | 1792.05 | 1793.08 | 1792.05 | 1792.05 | 1205.0 |
| 2013-10-21 21:00:00 | ES | Futures | 1792.05 | 1792.57 | 1792.05 | 1792.57 | 894.0 |
| 2013-10-21 21:30:00 | ES | Futures | 1792.31 | 1792.57 | 1791.28 | 1791.54 | 3368.0 |
| 2013-10-21 22:00:00 | ES | Futures | 1791.54 | 1792.31 | 1791.54 | 1792.05 | 784.0 |
| 2013-10-21 22:30:00 | ES | Futures | 1792.31 | 1792.82 | 1791.79 | 1792.82 | 1366.0 |
| 2013-10-21 23:00:00 | ES | Futures | 1792.82 | 1792.82 | 1791.54 | 1791.79 | 1444.0 |
| 2013-10-21 23:30:00 | ES | Futures | 1791.54 | 1792.31 | 1791.54 | 1792.31 | 1297.0 |
| 2013-10-21 00:00:00 | NQ | Futures | 3888.31 | 3890.34 | 3888.02 | 3890.05 | 154.0 |
| 2013-10-21 00:30:00 | NQ | Futures | 3890.34 | 3890.92 | 3889.76 | 3890.05 | 203.0 |
| 2013-10-21 01:00:00 | NQ | Futures | 3890.34 | 3891.21 | 3889.76 | 3890.63 | 164.0 |
> showing 50 of 2,813 rows — these rows as CSV