PREVIEW / futures_30min / 2013-09-02
file: by_date/futures_30min/2013/2013-09-02.parquet size: 51 KB rows: 1,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-09-02 00:00:00 | ES | Futures | 1698.57 | 1699.86 | 1698.57 | 1698.57 | 1728.0 |
| 2013-09-02 00:30:00 | ES | Futures | 1698.83 | 1698.83 | 1698.57 | 1698.83 | 410.0 |
| 2013-09-02 01:00:00 | ES | Futures | 1698.83 | 1699.34 | 1698.05 | 1698.83 | 1383.0 |
| 2013-09-02 01:30:00 | ES | Futures | 1698.83 | 1699.09 | 1697.79 | 1698.57 | 2099.0 |
| 2013-09-02 02:00:00 | ES | Futures | 1698.57 | 1699.86 | 1698.57 | 1699.86 | 5373.0 |
| 2013-09-02 02:30:00 | ES | Futures | 1699.86 | 1700.38 | 1698.05 | 1698.31 | 2735.0 |
| 2013-09-02 03:00:00 | ES | Futures | 1698.05 | 1700.9 | 1698.05 | 1699.86 | 15067.0 |
| 2013-09-02 03:30:00 | ES | Futures | 1700.12 | 1701.93 | 1699.6 | 1700.38 | 10404.0 |
| 2013-09-02 04:00:00 | ES | Futures | 1700.38 | 1701.93 | 1700.12 | 1701.41 | 6925.0 |
| 2013-09-02 04:30:00 | ES | Futures | 1701.15 | 1703.22 | 1701.15 | 1702.71 | 8923.0 |
| 2013-09-02 05:00:00 | ES | Futures | 1702.45 | 1702.45 | 1701.15 | 1701.15 | 6117.0 |
| 2013-09-02 05:30:00 | ES | Futures | 1701.41 | 1702.19 | 1701.15 | 1702.19 | 4193.0 |
| 2013-09-02 06:00:00 | ES | Futures | 1701.93 | 1702.96 | 1701.67 | 1702.71 | 3693.0 |
| 2013-09-02 06:30:00 | ES | Futures | 1702.71 | 1702.96 | 1701.93 | 1702.71 | 4492.0 |
| 2013-09-02 07:00:00 | ES | Futures | 1702.71 | 1703.48 | 1702.19 | 1702.96 | 6215.0 |
| 2013-09-02 07:30:00 | ES | Futures | 1702.71 | 1704.51 | 1701.93 | 1703.22 | 12492.0 |
| 2013-09-02 08:00:00 | ES | Futures | 1703.22 | 1704.26 | 1703.22 | 1703.48 | 5457.0 |
| 2013-09-02 08:30:00 | ES | Futures | 1703.74 | 1704.26 | 1702.71 | 1702.96 | 6207.0 |
| 2013-09-02 09:00:00 | ES | Futures | 1703.22 | 1703.22 | 1702.19 | 1702.96 | 4665.0 |
| 2013-09-02 09:30:00 | ES | Futures | 1702.96 | 1703.22 | 1701.15 | 1701.67 | 8957.0 |
| 2013-09-02 10:00:00 | ES | Futures | 1701.93 | 1702.71 | 1701.41 | 1702.71 | 4134.0 |
| 2013-09-02 10:30:00 | ES | Futures | 1702.71 | 1704.26 | 1702.19 | 1703.74 | 9207.0 |
| 2013-09-02 11:00:00 | ES | Futures | 1704.0 | 1704.26 | 1702.45 | 1703.48 | 10663.0 |
| 2013-09-02 18:00:00 | ES | Futures | 1703.48 | 1704.51 | 1702.45 | 1702.71 | 4113.0 |
| 2013-09-02 18:30:00 | ES | Futures | 1702.96 | 1702.96 | 1701.15 | 1701.41 | 1655.0 |
| 2013-09-02 19:00:00 | ES | Futures | 1701.41 | 1702.19 | 1701.15 | 1701.93 | 775.0 |
| 2013-09-02 19:30:00 | ES | Futures | 1701.93 | 1702.45 | 1701.15 | 1701.41 | 1064.0 |
| 2013-09-02 20:00:00 | ES | Futures | 1701.15 | 1703.22 | 1701.15 | 1702.71 | 2899.0 |
| 2013-09-02 20:30:00 | ES | Futures | 1702.71 | 1703.22 | 1702.19 | 1703.22 | 3411.0 |
| 2013-09-02 21:00:00 | ES | Futures | 1703.22 | 1703.22 | 1702.45 | 1702.45 | 1295.0 |
| 2013-09-02 21:30:00 | ES | Futures | 1702.45 | 1702.96 | 1701.93 | 1702.71 | 1269.0 |
| 2013-09-02 22:00:00 | ES | Futures | 1702.71 | 1703.48 | 1702.45 | 1702.71 | 2177.0 |
| 2013-09-02 22:30:00 | ES | Futures | 1702.71 | 1703.22 | 1702.19 | 1702.45 | 1711.0 |
| 2013-09-02 23:00:00 | ES | Futures | 1702.71 | 1703.22 | 1702.45 | 1702.96 | 567.0 |
| 2013-09-02 23:30:00 | ES | Futures | 1703.22 | 1704.26 | 1702.96 | 1704.0 | 4705.0 |
| 2013-09-02 00:00:00 | NQ | Futures | 3621.68 | 3624.02 | 3621.68 | 3623.14 | 210.0 |
| 2013-09-02 00:30:00 | NQ | Futures | 3622.85 | 3623.14 | 3622.26 | 3622.56 | 75.0 |
| 2013-09-02 01:00:00 | NQ | Futures | 3622.56 | 3624.31 | 3621.97 | 3624.02 | 272.0 |
| 2013-09-02 01:30:00 | NQ | Futures | 3624.02 | 3624.31 | 3622.56 | 3623.72 | 174.0 |
| 2013-09-02 02:00:00 | NQ | Futures | 3623.72 | 3626.65 | 3623.43 | 3626.35 | 472.0 |
| 2013-09-02 02:30:00 | NQ | Futures | 3626.65 | 3627.82 | 3624.6 | 3624.6 | 526.0 |
| 2013-09-02 03:00:00 | NQ | Futures | 3624.89 | 3628.98 | 3624.02 | 3627.23 | 2374.0 |
| 2013-09-02 03:30:00 | NQ | Futures | 3627.23 | 3630.74 | 3626.65 | 3628.11 | 1412.0 |
| 2013-09-02 04:00:00 | NQ | Futures | 3628.11 | 3630.74 | 3626.94 | 3629.57 | 1162.0 |
| 2013-09-02 04:30:00 | NQ | Futures | 3629.28 | 3631.91 | 3629.28 | 3630.74 | 874.0 |
| 2013-09-02 05:00:00 | NQ | Futures | 3630.45 | 3630.74 | 3628.11 | 3628.4 | 461.0 |
| 2013-09-02 05:30:00 | NQ | Futures | 3628.69 | 3630.15 | 3628.11 | 3629.86 | 432.0 |
| 2013-09-02 06:00:00 | NQ | Futures | 3629.57 | 3633.08 | 3628.4 | 3631.91 | 740.0 |
| 2013-09-02 06:30:00 | NQ | Futures | 3631.62 | 3633.66 | 3631.32 | 3633.66 | 540.0 |
| 2013-09-02 07:00:00 | NQ | Futures | 3633.37 | 3633.95 | 3632.2 | 3632.78 | 528.0 |
> showing 50 of 1,875 rows — these rows as CSV