PREVIEW / futures_30min / 2013-05-29
file: by_date/futures_30min/2013/2013-05-29.parquet size: 80 KB rows: 2,862
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-05-29 00:00:00 | ES | Futures | 1704.18 | 1706.5 | 1704.18 | 1705.98 | 3036.0 |
| 2013-05-29 00:30:00 | ES | Futures | 1705.98 | 1707.01 | 1705.72 | 1706.75 | 1518.0 |
| 2013-05-29 01:00:00 | ES | Futures | 1706.75 | 1707.01 | 1705.72 | 1705.98 | 2438.0 |
| 2013-05-29 01:30:00 | ES | Futures | 1705.98 | 1706.24 | 1701.86 | 1702.12 | 6500.0 |
| 2013-05-29 02:00:00 | ES | Futures | 1701.86 | 1703.15 | 1700.57 | 1701.34 | 10649.0 |
| 2013-05-29 02:30:00 | ES | Futures | 1701.34 | 1702.63 | 1699.28 | 1699.8 | 11263.0 |
| 2013-05-29 03:00:00 | ES | Futures | 1699.8 | 1700.06 | 1696.97 | 1698.77 | 21731.0 |
| 2013-05-29 03:30:00 | ES | Futures | 1698.51 | 1698.77 | 1695.94 | 1698.0 | 16330.0 |
| 2013-05-29 04:00:00 | ES | Futures | 1698.0 | 1700.83 | 1698.0 | 1698.51 | 10363.0 |
| 2013-05-29 04:30:00 | ES | Futures | 1698.77 | 1698.77 | 1696.97 | 1697.22 | 5652.0 |
| 2013-05-29 05:00:00 | ES | Futures | 1696.97 | 1699.03 | 1696.19 | 1698.0 | 7314.0 |
| 2013-05-29 05:30:00 | ES | Futures | 1698.0 | 1699.54 | 1698.0 | 1699.54 | 6935.0 |
| 2013-05-29 06:00:00 | ES | Futures | 1699.54 | 1699.54 | 1696.71 | 1697.74 | 7511.0 |
| 2013-05-29 06:30:00 | ES | Futures | 1697.74 | 1697.74 | 1693.1 | 1693.62 | 27433.0 |
| 2013-05-29 07:00:00 | ES | Futures | 1693.62 | 1694.9 | 1691.56 | 1694.39 | 33359.0 |
| 2013-05-29 07:30:00 | ES | Futures | 1694.13 | 1695.94 | 1691.81 | 1693.1 | 21630.0 |
| 2013-05-29 08:00:00 | ES | Futures | 1693.1 | 1696.45 | 1692.59 | 1696.19 | 36515.0 |
| 2013-05-29 08:30:00 | ES | Futures | 1696.45 | 1698.0 | 1694.65 | 1696.45 | 36526.0 |
| 2013-05-29 09:00:00 | ES | Futures | 1696.71 | 1699.03 | 1696.45 | 1698.77 | 26750.0 |
| 2013-05-29 09:30:00 | ES | Futures | 1699.03 | 1701.09 | 1694.13 | 1698.0 | 247826.0 |
| 2013-05-29 10:00:00 | ES | Futures | 1697.74 | 1701.86 | 1693.87 | 1694.9 | 183324.0 |
| 2013-05-29 10:30:00 | ES | Futures | 1694.65 | 1696.45 | 1689.5 | 1689.75 | 183388.0 |
| 2013-05-29 11:00:00 | ES | Futures | 1689.75 | 1693.36 | 1687.69 | 1692.33 | 172998.0 |
| 2013-05-29 11:30:00 | ES | Futures | 1692.33 | 1696.45 | 1691.81 | 1695.42 | 114034.0 |
| 2013-05-29 12:00:00 | ES | Futures | 1695.42 | 1696.97 | 1692.59 | 1693.36 | 78049.0 |
| 2013-05-29 12:30:00 | ES | Futures | 1693.36 | 1694.65 | 1690.01 | 1691.04 | 77074.0 |
| 2013-05-29 13:00:00 | ES | Futures | 1690.78 | 1695.94 | 1689.5 | 1695.68 | 101503.0 |
| 2013-05-29 13:30:00 | ES | Futures | 1695.68 | 1701.34 | 1694.13 | 1700.31 | 114603.0 |
| 2013-05-29 14:00:00 | ES | Futures | 1700.31 | 1702.89 | 1699.28 | 1700.06 | 103680.0 |
| 2013-05-29 14:30:00 | ES | Futures | 1699.8 | 1701.6 | 1697.74 | 1697.74 | 77108.0 |
| 2013-05-29 15:00:00 | ES | Futures | 1697.74 | 1701.09 | 1696.45 | 1700.83 | 76693.0 |
| 2013-05-29 15:30:00 | ES | Futures | 1700.57 | 1701.6 | 1695.68 | 1697.22 | 149781.0 |
| 2013-05-29 16:00:00 | ES | Futures | 1697.22 | 1697.74 | 1695.68 | 1696.71 | 81911.0 |
| 2013-05-29 16:30:00 | ES | Futures | 1696.71 | 1697.74 | 1695.42 | 1695.94 | 8175.0 |
| 2013-05-29 17:00:00 | ES | Futures | 1695.68 | 1696.71 | 1695.68 | 1696.71 | 1926.0 |
| 2013-05-29 18:00:00 | ES | Futures | 1696.45 | 1696.97 | 1694.39 | 1695.42 | 4422.0 |
| 2013-05-29 18:30:00 | ES | Futures | 1695.42 | 1695.94 | 1695.16 | 1695.42 | 1124.0 |
| 2013-05-29 19:00:00 | ES | Futures | 1695.42 | 1695.68 | 1694.65 | 1695.16 | 1433.0 |
| 2013-05-29 19:30:00 | ES | Futures | 1695.16 | 1696.71 | 1694.9 | 1696.19 | 1533.0 |
| 2013-05-29 20:00:00 | ES | Futures | 1696.19 | 1697.48 | 1695.94 | 1696.97 | 4823.0 |
| 2013-05-29 20:30:00 | ES | Futures | 1696.71 | 1698.77 | 1696.45 | 1698.77 | 4129.0 |
| 2013-05-29 21:00:00 | ES | Futures | 1698.77 | 1700.57 | 1698.77 | 1698.77 | 5571.0 |
| 2013-05-29 21:30:00 | ES | Futures | 1699.03 | 1700.31 | 1698.77 | 1699.54 | 3796.0 |
| 2013-05-29 22:00:00 | ES | Futures | 1699.54 | 1700.06 | 1698.77 | 1699.03 | 1427.0 |
| 2013-05-29 22:30:00 | ES | Futures | 1698.77 | 1699.54 | 1697.22 | 1699.28 | 3952.0 |
| 2013-05-29 23:00:00 | ES | Futures | 1699.28 | 1699.54 | 1696.97 | 1698.25 | 2576.0 |
| 2013-05-29 23:30:00 | ES | Futures | 1698.0 | 1698.77 | 1697.22 | 1697.22 | 4029.0 |
| 2013-05-29 00:00:00 | NQ | Futures | 3504.97 | 3509.06 | 3504.97 | 3507.89 | 482.0 |
| 2013-05-29 00:30:00 | NQ | Futures | 3508.18 | 3510.22 | 3507.89 | 3509.35 | 168.0 |
| 2013-05-29 01:00:00 | NQ | Futures | 3509.06 | 3509.06 | 3506.72 | 3506.72 | 442.0 |
> showing 50 of 2,862 rows — these rows as CSV