PREVIEW / futures_30min / 2013-10-18
file: by_date/futures_30min/2013/2013-10-18.parquet size: 64 KB rows: 2,340
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-18 00:00:00 | ES | Futures | 1784.83 | 1785.34 | 1784.57 | 1785.34 | 1101.0 |
| 2013-10-18 00:30:00 | ES | Futures | 1785.09 | 1786.63 | 1785.09 | 1786.38 | 1422.0 |
| 2013-10-18 01:00:00 | ES | Futures | 1786.38 | 1787.67 | 1786.12 | 1787.41 | 2404.0 |
| 2013-10-18 01:30:00 | ES | Futures | 1787.67 | 1788.18 | 1786.63 | 1786.89 | 2487.0 |
| 2013-10-18 02:00:00 | ES | Futures | 1787.15 | 1788.18 | 1786.89 | 1787.92 | 3813.0 |
| 2013-10-18 02:30:00 | ES | Futures | 1787.92 | 1788.44 | 1786.12 | 1786.38 | 3925.0 |
| 2013-10-18 03:00:00 | ES | Futures | 1786.38 | 1786.89 | 1784.83 | 1785.6 | 11696.0 |
| 2013-10-18 03:30:00 | ES | Futures | 1785.86 | 1787.15 | 1785.09 | 1785.34 | 6843.0 |
| 2013-10-18 04:00:00 | ES | Futures | 1785.6 | 1786.38 | 1784.83 | 1784.83 | 8623.0 |
| 2013-10-18 04:30:00 | ES | Futures | 1784.83 | 1785.86 | 1784.57 | 1784.57 | 4970.0 |
| 2013-10-18 05:00:00 | ES | Futures | 1784.83 | 1785.86 | 1784.57 | 1785.86 | 5374.0 |
| 2013-10-18 05:30:00 | ES | Futures | 1785.6 | 1785.6 | 1783.8 | 1785.34 | 9242.0 |
| 2013-10-18 06:00:00 | ES | Futures | 1785.34 | 1785.34 | 1783.8 | 1785.34 | 6283.0 |
| 2013-10-18 06:30:00 | ES | Futures | 1785.34 | 1786.12 | 1783.8 | 1784.05 | 12877.0 |
| 2013-10-18 07:00:00 | ES | Futures | 1784.05 | 1785.6 | 1784.05 | 1785.6 | 6949.0 |
| 2013-10-18 07:30:00 | ES | Futures | 1785.34 | 1787.41 | 1785.09 | 1787.41 | 14075.0 |
| 2013-10-18 08:00:00 | ES | Futures | 1787.15 | 1788.7 | 1786.63 | 1787.41 | 20684.0 |
| 2013-10-18 08:30:00 | ES | Futures | 1787.41 | 1788.18 | 1786.63 | 1787.67 | 17115.0 |
| 2013-10-18 09:00:00 | ES | Futures | 1787.92 | 1789.99 | 1786.38 | 1788.96 | 50138.0 |
| 2013-10-18 09:30:00 | ES | Futures | 1788.7 | 1791.02 | 1785.34 | 1790.5 | 230297.0 |
| 2013-10-18 10:00:00 | ES | Futures | 1790.25 | 1791.54 | 1787.15 | 1787.41 | 125448.0 |
| 2013-10-18 10:30:00 | ES | Futures | 1787.41 | 1788.96 | 1785.34 | 1787.67 | 129716.0 |
| 2013-10-18 11:00:00 | ES | Futures | 1787.92 | 1789.73 | 1786.89 | 1789.47 | 62646.0 |
| 2013-10-18 11:30:00 | ES | Futures | 1789.47 | 1790.76 | 1788.44 | 1788.7 | 64276.0 |
| 2013-10-18 12:00:00 | ES | Futures | 1788.7 | 1790.5 | 1787.67 | 1789.73 | 63825.0 |
| 2013-10-18 12:30:00 | ES | Futures | 1789.99 | 1791.54 | 1789.73 | 1790.5 | 49195.0 |
| 2013-10-18 13:00:00 | ES | Futures | 1790.5 | 1793.08 | 1790.25 | 1792.82 | 47980.0 |
| 2013-10-18 13:30:00 | ES | Futures | 1792.57 | 1794.89 | 1791.79 | 1794.89 | 69211.0 |
| 2013-10-18 14:00:00 | ES | Futures | 1794.89 | 1795.15 | 1792.82 | 1794.37 | 61394.0 |
| 2013-10-18 14:30:00 | ES | Futures | 1794.37 | 1795.66 | 1793.6 | 1794.11 | 87712.0 |
| 2013-10-18 15:00:00 | ES | Futures | 1794.11 | 1794.37 | 1792.05 | 1793.08 | 75959.0 |
| 2013-10-18 15:30:00 | ES | Futures | 1792.82 | 1794.63 | 1791.79 | 1794.11 | 128435.0 |
| 2013-10-18 16:00:00 | ES | Futures | 1794.11 | 1794.37 | 1791.54 | 1791.79 | 89193.0 |
| 2013-10-18 16:30:00 | ES | Futures | 1792.05 | 1793.08 | 1791.79 | 1792.82 | 7338.0 |
| 2013-10-18 17:00:00 | ES | Futures | 1793.08 | 1793.6 | 1791.79 | 1792.31 | 2713.0 |
| 2013-10-18 00:00:00 | NQ | Futures | 3847.65 | 3850.84 | 3847.36 | 3850.26 | 262.0 |
| 2013-10-18 00:30:00 | NQ | Futures | 3850.26 | 3853.75 | 3850.26 | 3852.88 | 325.0 |
| 2013-10-18 01:00:00 | NQ | Futures | 3853.17 | 3855.78 | 3852.59 | 3855.2 | 464.0 |
| 2013-10-18 01:30:00 | NQ | Futures | 3855.2 | 3856.94 | 3854.62 | 3856.07 | 560.0 |
| 2013-10-18 02:00:00 | NQ | Futures | 3856.07 | 3856.94 | 3855.2 | 3856.94 | 574.0 |
| 2013-10-18 02:30:00 | NQ | Futures | 3856.36 | 3856.65 | 3851.14 | 3851.43 | 1138.0 |
| 2013-10-18 03:00:00 | NQ | Futures | 3851.43 | 3852.01 | 3846.49 | 3849.39 | 2092.0 |
| 2013-10-18 03:30:00 | NQ | Futures | 3849.68 | 3853.46 | 3848.23 | 3848.52 | 776.0 |
| 2013-10-18 04:00:00 | NQ | Futures | 3848.81 | 3852.59 | 3847.36 | 3849.39 | 1201.0 |
| 2013-10-18 04:30:00 | NQ | Futures | 3849.39 | 3852.3 | 3849.1 | 3849.97 | 818.0 |
| 2013-10-18 05:00:00 | NQ | Futures | 3850.26 | 3852.88 | 3849.68 | 3852.88 | 533.0 |
| 2013-10-18 05:30:00 | NQ | Futures | 3852.59 | 3852.59 | 3847.94 | 3851.43 | 1015.0 |
| 2013-10-18 06:00:00 | NQ | Futures | 3851.72 | 3852.01 | 3848.23 | 3851.43 | 620.0 |
| 2013-10-18 06:30:00 | NQ | Futures | 3851.14 | 3853.17 | 3848.52 | 3849.1 | 1132.0 |
| 2013-10-18 07:00:00 | NQ | Futures | 3849.1 | 3852.59 | 3849.1 | 3852.3 | 1247.0 |
> showing 50 of 2,340 rows — these rows as CSV