PREVIEW / futures_30min / 2013-05-30
file: by_date/futures_30min/2013/2013-05-30.parquet size: 79 KB rows: 2,875
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-30 00:00:00 | ES | Futures | 1697.48 | 1698.51 | 1697.22 | 1698.0 | 1992.0 |
| 2013-05-30 00:30:00 | ES | Futures | 1698.0 | 1698.51 | 1697.22 | 1697.74 | 1164.0 |
| 2013-05-30 01:00:00 | ES | Futures | 1698.0 | 1698.0 | 1695.94 | 1695.94 | 4644.0 |
| 2013-05-30 01:30:00 | ES | Futures | 1695.94 | 1695.94 | 1692.59 | 1693.87 | 12776.0 |
| 2013-05-30 02:00:00 | ES | Futures | 1693.87 | 1694.13 | 1692.33 | 1692.84 | 9781.0 |
| 2013-05-30 02:30:00 | ES | Futures | 1692.84 | 1692.84 | 1690.78 | 1692.33 | 9743.0 |
| 2013-05-30 03:00:00 | ES | Futures | 1692.59 | 1695.68 | 1691.56 | 1695.16 | 15915.0 |
| 2013-05-30 03:30:00 | ES | Futures | 1694.9 | 1697.74 | 1693.87 | 1696.45 | 12348.0 |
| 2013-05-30 04:00:00 | ES | Futures | 1696.45 | 1697.22 | 1693.1 | 1693.87 | 9699.0 |
| 2013-05-30 04:30:00 | ES | Futures | 1693.87 | 1695.42 | 1692.33 | 1692.84 | 5809.0 |
| 2013-05-30 05:00:00 | ES | Futures | 1693.1 | 1695.16 | 1692.33 | 1694.65 | 6935.0 |
| 2013-05-30 05:30:00 | ES | Futures | 1694.39 | 1696.45 | 1693.87 | 1694.39 | 6951.0 |
| 2013-05-30 06:00:00 | ES | Futures | 1694.39 | 1698.0 | 1693.1 | 1696.97 | 17253.0 |
| 2013-05-30 06:30:00 | ES | Futures | 1697.22 | 1700.83 | 1696.97 | 1700.06 | 25286.0 |
| 2013-05-30 07:00:00 | ES | Futures | 1700.06 | 1704.95 | 1699.8 | 1703.41 | 33681.0 |
| 2013-05-30 07:30:00 | ES | Futures | 1703.41 | 1703.92 | 1701.6 | 1701.6 | 18594.0 |
| 2013-05-30 08:00:00 | ES | Futures | 1701.6 | 1703.92 | 1701.34 | 1702.89 | 17248.0 |
| 2013-05-30 08:30:00 | ES | Futures | 1703.41 | 1704.95 | 1699.28 | 1700.06 | 55914.0 |
| 2013-05-30 09:00:00 | ES | Futures | 1700.06 | 1701.34 | 1697.22 | 1698.0 | 38212.0 |
| 2013-05-30 09:30:00 | ES | Futures | 1698.0 | 1708.3 | 1696.71 | 1706.75 | 274116.0 |
| 2013-05-30 10:00:00 | ES | Futures | 1706.75 | 1708.81 | 1702.89 | 1703.92 | 198240.0 |
| 2013-05-30 10:30:00 | ES | Futures | 1703.92 | 1707.27 | 1703.66 | 1707.01 | 104547.0 |
| 2013-05-30 11:00:00 | ES | Futures | 1706.75 | 1707.53 | 1702.63 | 1705.21 | 95914.0 |
| 2013-05-30 11:30:00 | ES | Futures | 1704.95 | 1707.78 | 1704.69 | 1707.78 | 65982.0 |
| 2013-05-30 12:00:00 | ES | Futures | 1707.53 | 1709.59 | 1706.24 | 1706.5 | 79535.0 |
| 2013-05-30 12:30:00 | ES | Futures | 1706.5 | 1707.01 | 1704.69 | 1707.01 | 61062.0 |
| 2013-05-30 13:00:00 | ES | Futures | 1706.75 | 1708.04 | 1705.21 | 1707.78 | 50984.0 |
| 2013-05-30 13:30:00 | ES | Futures | 1707.78 | 1709.59 | 1707.27 | 1708.56 | 64629.0 |
| 2013-05-30 14:00:00 | ES | Futures | 1708.56 | 1710.36 | 1707.27 | 1710.36 | 58709.0 |
| 2013-05-30 14:30:00 | ES | Futures | 1710.36 | 1711.13 | 1708.56 | 1710.36 | 69181.0 |
| 2013-05-30 15:00:00 | ES | Futures | 1710.36 | 1710.36 | 1706.5 | 1706.75 | 64499.0 |
| 2013-05-30 15:30:00 | ES | Futures | 1706.75 | 1707.53 | 1702.63 | 1703.15 | 161945.0 |
| 2013-05-30 16:00:00 | ES | Futures | 1702.89 | 1704.18 | 1702.89 | 1703.66 | 68459.0 |
| 2013-05-30 16:30:00 | ES | Futures | 1703.41 | 1703.92 | 1702.89 | 1703.92 | 7847.0 |
| 2013-05-30 17:00:00 | ES | Futures | 1703.92 | 1704.18 | 1703.66 | 1703.92 | 2111.0 |
| 2013-05-30 18:00:00 | ES | Futures | 1703.92 | 1704.18 | 1700.83 | 1701.6 | 5678.0 |
| 2013-05-30 18:30:00 | ES | Futures | 1701.6 | 1702.63 | 1701.34 | 1702.63 | 978.0 |
| 2013-05-30 19:00:00 | ES | Futures | 1702.63 | 1703.15 | 1702.12 | 1702.63 | 1026.0 |
| 2013-05-30 19:30:00 | ES | Futures | 1702.63 | 1703.41 | 1702.37 | 1703.41 | 1041.0 |
| 2013-05-30 20:00:00 | ES | Futures | 1703.15 | 1705.98 | 1703.15 | 1704.69 | 5335.0 |
| 2013-05-30 20:30:00 | ES | Futures | 1704.69 | 1706.24 | 1704.44 | 1705.72 | 3223.0 |
| 2013-05-30 21:00:00 | ES | Futures | 1705.72 | 1706.24 | 1705.21 | 1705.21 | 2129.0 |
| 2013-05-30 21:30:00 | ES | Futures | 1705.21 | 1705.98 | 1704.44 | 1704.44 | 1723.0 |
| 2013-05-30 22:00:00 | ES | Futures | 1704.44 | 1704.69 | 1703.66 | 1704.18 | 1950.0 |
| 2013-05-30 22:30:00 | ES | Futures | 1704.18 | 1704.69 | 1703.92 | 1704.18 | 834.0 |
| 2013-05-30 23:00:00 | ES | Futures | 1704.18 | 1704.69 | 1704.18 | 1704.44 | 898.0 |
| 2013-05-30 23:30:00 | ES | Futures | 1704.69 | 1704.95 | 1703.92 | 1704.44 | 2205.0 |
| 2013-05-30 00:00:00 | NQ | Futures | 3491.56 | 3494.18 | 3491.27 | 3493.89 | 385.0 |
| 2013-05-30 00:30:00 | NQ | Futures | 3493.6 | 3494.77 | 3491.85 | 3493.6 | 259.0 |
| 2013-05-30 01:00:00 | NQ | Futures | 3493.6 | 3493.89 | 3487.77 | 3487.77 | 883.0 |
> showing 50 of 2,875 rows — these rows as CSV