PREVIEW / futures_30min / 2013-01-17
file: by_date/futures_30min/2013/2013-01-17.parquet size: 83 KB rows: 2,974
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-01-17 00:00:00 | ES | Futures | 1500.8 | 1501.06 | 1500.29 | 1500.54 | 2851.0 |
| 2013-01-17 00:30:00 | ES | Futures | 1500.29 | 1502.34 | 1499.77 | 1502.08 | 4320.0 |
| 2013-01-17 01:00:00 | ES | Futures | 1502.08 | 1503.11 | 1502.08 | 1502.6 | 3045.0 |
| 2013-01-17 01:30:00 | ES | Futures | 1502.34 | 1503.11 | 1502.34 | 1502.85 | 967.0 |
| 2013-01-17 02:00:00 | ES | Futures | 1502.85 | 1503.88 | 1501.83 | 1502.6 | 3849.0 |
| 2013-01-17 02:30:00 | ES | Futures | 1502.6 | 1502.6 | 1501.31 | 1502.34 | 4084.0 |
| 2013-01-17 03:00:00 | ES | Futures | 1502.08 | 1504.65 | 1502.08 | 1504.65 | 11155.0 |
| 2013-01-17 03:30:00 | ES | Futures | 1504.65 | 1504.65 | 1503.62 | 1504.65 | 8707.0 |
| 2013-01-17 04:00:00 | ES | Futures | 1504.65 | 1505.68 | 1504.14 | 1504.39 | 10735.0 |
| 2013-01-17 04:30:00 | ES | Futures | 1504.65 | 1504.65 | 1503.62 | 1504.14 | 7785.0 |
| 2013-01-17 05:00:00 | ES | Futures | 1504.14 | 1505.16 | 1503.62 | 1503.88 | 9910.0 |
| 2013-01-17 05:30:00 | ES | Futures | 1504.14 | 1505.42 | 1504.14 | 1505.16 | 7255.0 |
| 2013-01-17 06:00:00 | ES | Futures | 1504.91 | 1505.16 | 1504.14 | 1504.65 | 9416.0 |
| 2013-01-17 06:30:00 | ES | Futures | 1504.39 | 1506.7 | 1504.14 | 1506.45 | 10603.0 |
| 2013-01-17 07:00:00 | ES | Futures | 1506.45 | 1507.47 | 1505.93 | 1506.7 | 14458.0 |
| 2013-01-17 07:30:00 | ES | Futures | 1506.7 | 1507.73 | 1506.45 | 1506.7 | 12885.0 |
| 2013-01-17 08:00:00 | ES | Futures | 1506.96 | 1509.53 | 1505.68 | 1508.5 | 35741.0 |
| 2013-01-17 08:30:00 | ES | Futures | 1508.24 | 1514.91 | 1508.24 | 1512.6 | 107570.0 |
| 2013-01-17 09:00:00 | ES | Futures | 1512.6 | 1513.37 | 1511.32 | 1512.09 | 47004.0 |
| 2013-01-17 09:30:00 | ES | Futures | 1512.35 | 1512.35 | 1509.27 | 1511.58 | 151194.0 |
| 2013-01-17 10:00:00 | ES | Futures | 1511.58 | 1513.63 | 1509.01 | 1513.37 | 194288.0 |
| 2013-01-17 10:30:00 | ES | Futures | 1513.37 | 1513.63 | 1510.81 | 1511.58 | 93221.0 |
| 2013-01-17 11:00:00 | ES | Futures | 1511.32 | 1513.37 | 1511.32 | 1513.12 | 50627.0 |
| 2013-01-17 11:30:00 | ES | Futures | 1513.37 | 1514.91 | 1512.86 | 1513.37 | 89242.0 |
| 2013-01-17 12:00:00 | ES | Futures | 1513.12 | 1516.2 | 1513.12 | 1515.94 | 104939.0 |
| 2013-01-17 12:30:00 | ES | Futures | 1515.68 | 1516.71 | 1515.17 | 1515.43 | 84134.0 |
| 2013-01-17 13:00:00 | ES | Futures | 1515.68 | 1515.94 | 1514.91 | 1515.43 | 49529.0 |
| 2013-01-17 13:30:00 | ES | Futures | 1515.17 | 1518.25 | 1514.91 | 1517.99 | 74213.0 |
| 2013-01-17 14:00:00 | ES | Futures | 1517.74 | 1519.53 | 1517.74 | 1518.25 | 77565.0 |
| 2013-01-17 14:30:00 | ES | Futures | 1518.51 | 1519.53 | 1517.22 | 1517.74 | 66893.0 |
| 2013-01-17 15:00:00 | ES | Futures | 1517.74 | 1518.25 | 1516.45 | 1517.22 | 60982.0 |
| 2013-01-17 15:30:00 | ES | Futures | 1517.22 | 1517.99 | 1514.4 | 1514.66 | 174008.0 |
| 2013-01-17 16:00:00 | ES | Futures | 1514.66 | 1515.94 | 1514.14 | 1515.43 | 90362.0 |
| 2013-01-17 16:30:00 | ES | Futures | 1515.43 | 1515.43 | 1513.89 | 1513.89 | 9975.0 |
| 2013-01-17 17:00:00 | ES | Futures | 1513.89 | 1514.91 | 1513.89 | 1514.91 | 1477.0 |
| 2013-01-17 18:00:00 | ES | Futures | 1514.4 | 1514.4 | 1513.12 | 1513.63 | 4602.0 |
| 2013-01-17 18:30:00 | ES | Futures | 1513.63 | 1513.89 | 1513.37 | 1513.37 | 1488.0 |
| 2013-01-17 19:00:00 | ES | Futures | 1513.37 | 1514.4 | 1513.12 | 1514.14 | 4193.0 |
| 2013-01-17 19:30:00 | ES | Futures | 1513.89 | 1514.14 | 1513.37 | 1513.89 | 2269.0 |
| 2013-01-17 20:00:00 | ES | Futures | 1514.14 | 1514.66 | 1513.63 | 1514.14 | 3067.0 |
| 2013-01-17 20:30:00 | ES | Futures | 1514.14 | 1514.91 | 1514.14 | 1514.91 | 2440.0 |
| 2013-01-17 21:00:00 | ES | Futures | 1514.91 | 1515.43 | 1513.37 | 1513.89 | 4728.0 |
| 2013-01-17 21:30:00 | ES | Futures | 1513.89 | 1514.66 | 1513.63 | 1514.4 | 1452.0 |
| 2013-01-17 22:00:00 | ES | Futures | 1514.14 | 1515.43 | 1514.14 | 1514.91 | 1503.0 |
| 2013-01-17 22:30:00 | ES | Futures | 1514.66 | 1514.91 | 1513.89 | 1514.4 | 1759.0 |
| 2013-01-17 23:00:00 | ES | Futures | 1514.4 | 1514.4 | 1513.12 | 1513.89 | 2508.0 |
| 2013-01-17 23:30:00 | ES | Futures | 1513.89 | 1514.4 | 1513.63 | 1513.63 | 1864.0 |
| 2013-01-17 00:00:00 | NQ | Futures | 3166.54 | 3167.12 | 3165.67 | 3165.96 | 346.0 |
| 2013-01-17 00:30:00 | NQ | Futures | 3165.96 | 3168.0 | 3162.76 | 3168.0 | 1232.0 |
| 2013-01-17 01:00:00 | NQ | Futures | 3168.29 | 3171.49 | 3168.0 | 3170.03 | 521.0 |
> showing 50 of 2,974 rows — these rows as CSV