PREVIEW / futures_30min / 2013-02-22
file: by_date/futures_30min/2013/2013-02-22.parquet size: 66 KB rows: 2,353
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-02-22 00:00:00 | ES | Futures | 1545.19 | 1545.45 | 1543.91 | 1543.91 | 2851.0 |
| 2013-02-22 00:30:00 | ES | Futures | 1543.91 | 1545.19 | 1543.91 | 1544.68 | 1381.0 |
| 2013-02-22 01:00:00 | ES | Futures | 1544.93 | 1545.45 | 1544.42 | 1545.19 | 2114.0 |
| 2013-02-22 01:30:00 | ES | Futures | 1545.19 | 1545.7 | 1545.19 | 1545.45 | 2814.0 |
| 2013-02-22 02:00:00 | ES | Futures | 1545.45 | 1545.96 | 1544.42 | 1544.68 | 5107.0 |
| 2013-02-22 02:30:00 | ES | Futures | 1544.68 | 1545.19 | 1543.65 | 1544.93 | 4598.0 |
| 2013-02-22 03:00:00 | ES | Futures | 1544.93 | 1546.47 | 1544.17 | 1546.22 | 18397.0 |
| 2013-02-22 03:30:00 | ES | Futures | 1546.22 | 1546.73 | 1545.19 | 1545.96 | 12275.0 |
| 2013-02-22 04:00:00 | ES | Futures | 1545.96 | 1547.24 | 1545.7 | 1546.73 | 24954.0 |
| 2013-02-22 04:30:00 | ES | Futures | 1546.73 | 1546.73 | 1544.93 | 1545.7 | 10320.0 |
| 2013-02-22 05:00:00 | ES | Futures | 1545.7 | 1546.22 | 1544.17 | 1545.96 | 16152.0 |
| 2013-02-22 05:30:00 | ES | Futures | 1546.22 | 1546.22 | 1545.7 | 1545.96 | 6363.0 |
| 2013-02-22 06:00:00 | ES | Futures | 1545.96 | 1547.24 | 1544.93 | 1546.73 | 23303.0 |
| 2013-02-22 06:30:00 | ES | Futures | 1546.99 | 1548.01 | 1546.73 | 1547.24 | 23564.0 |
| 2013-02-22 07:00:00 | ES | Futures | 1547.5 | 1549.3 | 1547.24 | 1548.27 | 22445.0 |
| 2013-02-22 07:30:00 | ES | Futures | 1548.27 | 1549.04 | 1548.01 | 1548.78 | 14377.0 |
| 2013-02-22 08:00:00 | ES | Futures | 1548.78 | 1549.55 | 1548.01 | 1548.78 | 21173.0 |
| 2013-02-22 08:30:00 | ES | Futures | 1548.78 | 1549.3 | 1548.01 | 1548.27 | 16009.0 |
| 2013-02-22 09:00:00 | ES | Futures | 1548.27 | 1548.53 | 1546.22 | 1546.99 | 45750.0 |
| 2013-02-22 09:30:00 | ES | Futures | 1547.24 | 1549.3 | 1544.17 | 1545.45 | 269486.0 |
| 2013-02-22 10:00:00 | ES | Futures | 1545.7 | 1546.73 | 1543.65 | 1545.19 | 152292.0 |
| 2013-02-22 10:30:00 | ES | Futures | 1544.93 | 1547.5 | 1543.91 | 1544.93 | 114699.0 |
| 2013-02-22 11:00:00 | ES | Futures | 1544.93 | 1546.47 | 1542.88 | 1546.22 | 116610.0 |
| 2013-02-22 11:30:00 | ES | Futures | 1546.22 | 1548.53 | 1545.7 | 1547.5 | 97978.0 |
| 2013-02-22 12:00:00 | ES | Futures | 1547.76 | 1548.78 | 1546.73 | 1548.01 | 55183.0 |
| 2013-02-22 12:30:00 | ES | Futures | 1548.27 | 1551.86 | 1548.01 | 1551.09 | 85650.0 |
| 2013-02-22 13:00:00 | ES | Futures | 1551.35 | 1551.86 | 1549.04 | 1549.81 | 61580.0 |
| 2013-02-22 13:30:00 | ES | Futures | 1549.55 | 1551.35 | 1549.3 | 1550.84 | 33919.0 |
| 2013-02-22 14:00:00 | ES | Futures | 1550.58 | 1550.84 | 1548.53 | 1549.3 | 52316.0 |
| 2013-02-22 14:30:00 | ES | Futures | 1549.04 | 1550.58 | 1548.78 | 1550.07 | 31429.0 |
| 2013-02-22 15:00:00 | ES | Futures | 1550.07 | 1551.61 | 1549.55 | 1550.84 | 63012.0 |
| 2013-02-22 15:30:00 | ES | Futures | 1550.84 | 1554.17 | 1550.32 | 1554.17 | 173710.0 |
| 2013-02-22 16:00:00 | ES | Futures | 1554.17 | 1554.94 | 1553.66 | 1554.69 | 104912.0 |
| 2013-02-22 16:30:00 | ES | Futures | 1554.69 | 1554.69 | 1552.89 | 1553.15 | 15371.0 |
| 2013-02-22 17:00:00 | ES | Futures | 1553.4 | 1554.17 | 1553.15 | 1553.92 | 1125.0 |
| 2013-02-22 00:00:00 | NQ | Futures | 3168.29 | 3168.29 | 3165.67 | 3165.67 | 217.0 |
| 2013-02-22 00:30:00 | NQ | Futures | 3165.67 | 3167.12 | 3165.67 | 3167.12 | 155.0 |
| 2013-02-22 01:00:00 | NQ | Futures | 3166.83 | 3168.29 | 3166.54 | 3168.29 | 151.0 |
| 2013-02-22 01:30:00 | NQ | Futures | 3168.0 | 3168.87 | 3168.0 | 3168.29 | 98.0 |
| 2013-02-22 02:00:00 | NQ | Futures | 3168.0 | 3169.16 | 3166.54 | 3166.83 | 371.0 |
| 2013-02-22 02:30:00 | NQ | Futures | 3166.83 | 3168.58 | 3165.67 | 3168.58 | 345.0 |
| 2013-02-22 03:00:00 | NQ | Futures | 3168.29 | 3170.91 | 3166.25 | 3170.62 | 1795.0 |
| 2013-02-22 03:30:00 | NQ | Futures | 3170.62 | 3173.24 | 3170.03 | 3170.62 | 1495.0 |
| 2013-02-22 04:00:00 | NQ | Futures | 3170.91 | 3172.36 | 3170.03 | 3171.2 | 1327.0 |
| 2013-02-22 04:30:00 | NQ | Futures | 3171.49 | 3171.49 | 3169.16 | 3169.74 | 486.0 |
| 2013-02-22 05:00:00 | NQ | Futures | 3170.03 | 3171.2 | 3167.41 | 3171.2 | 681.0 |
| 2013-02-22 05:30:00 | NQ | Futures | 3170.91 | 3172.07 | 3170.32 | 3170.91 | 603.0 |
| 2013-02-22 06:00:00 | NQ | Futures | 3171.2 | 3172.07 | 3168.58 | 3171.2 | 1646.0 |
| 2013-02-22 06:30:00 | NQ | Futures | 3171.2 | 3173.24 | 3171.2 | 3171.78 | 1201.0 |
| 2013-02-22 07:00:00 | NQ | Futures | 3172.07 | 3174.4 | 3171.2 | 3172.94 | 1437.0 |
> showing 50 of 2,353 rows — these rows as CSV