PREVIEW / futures_30min / 2013-08-02
file: by_date/futures_30min/2013/2013-08-02.parquet size: 67 KB rows: 2,334
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-08-02 00:00:00 | ES | Futures | 1759.06 | 1759.57 | 1758.54 | 1759.32 | 754.0 |
| 2013-08-02 00:30:00 | ES | Futures | 1759.32 | 1759.83 | 1758.8 | 1759.57 | 895.0 |
| 2013-08-02 01:00:00 | ES | Futures | 1759.57 | 1760.35 | 1759.06 | 1759.57 | 1855.0 |
| 2013-08-02 01:30:00 | ES | Futures | 1759.83 | 1761.13 | 1759.57 | 1761.13 | 3725.0 |
| 2013-08-02 02:00:00 | ES | Futures | 1760.87 | 1761.13 | 1760.09 | 1760.09 | 2589.0 |
| 2013-08-02 02:30:00 | ES | Futures | 1760.35 | 1761.13 | 1759.83 | 1760.61 | 3302.0 |
| 2013-08-02 03:00:00 | ES | Futures | 1760.87 | 1760.87 | 1758.28 | 1759.57 | 13168.0 |
| 2013-08-02 03:30:00 | ES | Futures | 1759.57 | 1760.09 | 1759.06 | 1759.32 | 6400.0 |
| 2013-08-02 04:00:00 | ES | Futures | 1759.32 | 1760.35 | 1758.8 | 1760.09 | 5779.0 |
| 2013-08-02 04:30:00 | ES | Futures | 1760.09 | 1760.35 | 1759.06 | 1759.32 | 5385.0 |
| 2013-08-02 05:00:00 | ES | Futures | 1759.32 | 1759.57 | 1758.54 | 1758.54 | 5934.0 |
| 2013-08-02 05:30:00 | ES | Futures | 1758.8 | 1759.57 | 1758.02 | 1758.54 | 6764.0 |
| 2013-08-02 06:00:00 | ES | Futures | 1758.54 | 1760.09 | 1758.28 | 1759.57 | 5272.0 |
| 2013-08-02 06:30:00 | ES | Futures | 1759.57 | 1760.61 | 1759.32 | 1759.32 | 4982.0 |
| 2013-08-02 07:00:00 | ES | Futures | 1759.32 | 1760.61 | 1759.06 | 1760.09 | 6093.0 |
| 2013-08-02 07:30:00 | ES | Futures | 1760.35 | 1760.35 | 1759.32 | 1759.83 | 6586.0 |
| 2013-08-02 08:00:00 | ES | Futures | 1759.57 | 1761.38 | 1759.57 | 1760.87 | 19246.0 |
| 2013-08-02 08:30:00 | ES | Futures | 1761.13 | 1761.64 | 1753.63 | 1755.96 | 103739.0 |
| 2013-08-02 09:00:00 | ES | Futures | 1755.96 | 1758.02 | 1754.15 | 1755.7 | 41272.0 |
| 2013-08-02 09:30:00 | ES | Futures | 1755.7 | 1756.99 | 1753.37 | 1755.18 | 159822.0 |
| 2013-08-02 10:00:00 | ES | Futures | 1755.44 | 1758.54 | 1754.15 | 1758.02 | 88287.0 |
| 2013-08-02 10:30:00 | ES | Futures | 1758.02 | 1758.54 | 1754.92 | 1755.44 | 94000.0 |
| 2013-08-02 11:00:00 | ES | Futures | 1755.44 | 1757.25 | 1754.15 | 1756.99 | 76322.0 |
| 2013-08-02 11:30:00 | ES | Futures | 1756.99 | 1758.28 | 1756.73 | 1757.51 | 48573.0 |
| 2013-08-02 12:00:00 | ES | Futures | 1757.51 | 1758.54 | 1757.25 | 1758.02 | 39663.0 |
| 2013-08-02 12:30:00 | ES | Futures | 1758.02 | 1760.09 | 1757.51 | 1759.32 | 42519.0 |
| 2013-08-02 13:00:00 | ES | Futures | 1759.32 | 1760.61 | 1758.28 | 1759.57 | 45313.0 |
| 2013-08-02 13:30:00 | ES | Futures | 1759.32 | 1759.57 | 1757.76 | 1758.28 | 43750.0 |
| 2013-08-02 14:00:00 | ES | Futures | 1758.28 | 1759.83 | 1758.28 | 1759.06 | 25206.0 |
| 2013-08-02 14:30:00 | ES | Futures | 1759.06 | 1760.35 | 1757.51 | 1759.32 | 44812.0 |
| 2013-08-02 15:00:00 | ES | Futures | 1759.57 | 1760.87 | 1758.8 | 1760.61 | 38025.0 |
| 2013-08-02 15:30:00 | ES | Futures | 1760.61 | 1762.93 | 1760.09 | 1762.42 | 130196.0 |
| 2013-08-02 16:00:00 | ES | Futures | 1762.42 | 1762.93 | 1761.9 | 1762.16 | 61800.0 |
| 2013-08-02 16:30:00 | ES | Futures | 1761.9 | 1762.42 | 1761.13 | 1761.13 | 8259.0 |
| 2013-08-02 17:00:00 | ES | Futures | 1761.38 | 1761.64 | 1761.13 | 1761.13 | 1595.0 |
| 2013-08-02 00:00:00 | NQ | Futures | 3644.77 | 3645.93 | 3643.89 | 3645.64 | 109.0 |
| 2013-08-02 00:30:00 | NQ | Futures | 3645.64 | 3647.4 | 3644.77 | 3646.23 | 260.0 |
| 2013-08-02 01:00:00 | NQ | Futures | 3646.52 | 3647.98 | 3645.93 | 3646.81 | 152.0 |
| 2013-08-02 01:30:00 | NQ | Futures | 3646.52 | 3648.86 | 3646.52 | 3648.56 | 387.0 |
| 2013-08-02 02:00:00 | NQ | Futures | 3648.27 | 3649.15 | 3647.1 | 3647.4 | 286.0 |
| 2013-08-02 02:30:00 | NQ | Futures | 3647.69 | 3648.86 | 3646.81 | 3647.98 | 330.0 |
| 2013-08-02 03:00:00 | NQ | Futures | 3648.27 | 3648.27 | 3643.6 | 3645.35 | 1717.0 |
| 2013-08-02 03:30:00 | NQ | Futures | 3645.35 | 3646.81 | 3644.47 | 3645.06 | 776.0 |
| 2013-08-02 04:00:00 | NQ | Futures | 3645.06 | 3647.69 | 3643.89 | 3647.4 | 1082.0 |
| 2013-08-02 04:30:00 | NQ | Futures | 3647.4 | 3647.4 | 3645.35 | 3645.35 | 778.0 |
| 2013-08-02 05:00:00 | NQ | Futures | 3645.64 | 3645.93 | 3644.18 | 3644.47 | 594.0 |
| 2013-08-02 05:30:00 | NQ | Futures | 3644.47 | 3646.23 | 3643.89 | 3645.35 | 847.0 |
| 2013-08-02 06:00:00 | NQ | Futures | 3645.35 | 3647.4 | 3645.06 | 3646.23 | 939.0 |
| 2013-08-02 06:30:00 | NQ | Futures | 3646.52 | 3648.27 | 3646.23 | 3646.52 | 817.0 |
| 2013-08-02 07:00:00 | NQ | Futures | 3646.23 | 3648.56 | 3645.93 | 3647.4 | 959.0 |
> showing 50 of 2,334 rows — these rows as CSV