PREVIEW / futures_30min / 2013-06-14
file: by_date/futures_30min/2013/2013-06-14.parquet size: 66 KB rows: 2,272
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-06-14 00:00:00 | ES | Futures | 1682.03 | 1683.84 | 1681.25 | 1683.84 | 1882.0 |
| 2013-06-14 00:30:00 | ES | Futures | 1683.84 | 1685.13 | 1683.32 | 1685.13 | 1156.0 |
| 2013-06-14 01:00:00 | ES | Futures | 1685.13 | 1685.64 | 1684.87 | 1685.13 | 977.0 |
| 2013-06-14 01:30:00 | ES | Futures | 1685.13 | 1685.64 | 1683.32 | 1683.84 | 1474.0 |
| 2013-06-14 02:00:00 | ES | Futures | 1683.84 | 1686.68 | 1683.32 | 1685.13 | 3610.0 |
| 2013-06-14 02:30:00 | ES | Futures | 1684.87 | 1686.16 | 1684.09 | 1685.9 | 1971.0 |
| 2013-06-14 03:00:00 | ES | Futures | 1686.16 | 1686.16 | 1681.77 | 1685.13 | 10972.0 |
| 2013-06-14 03:30:00 | ES | Futures | 1684.87 | 1687.2 | 1683.84 | 1687.2 | 4961.0 |
| 2013-06-14 04:00:00 | ES | Futures | 1687.2 | 1687.2 | 1685.64 | 1686.42 | 9002.0 |
| 2013-06-14 04:30:00 | ES | Futures | 1686.42 | 1687.71 | 1685.13 | 1687.71 | 6312.0 |
| 2013-06-14 05:00:00 | ES | Futures | 1687.71 | 1688.23 | 1683.84 | 1684.61 | 6397.0 |
| 2013-06-14 05:30:00 | ES | Futures | 1684.61 | 1686.42 | 1682.8 | 1682.8 | 6232.0 |
| 2013-06-14 06:00:00 | ES | Futures | 1682.8 | 1684.35 | 1682.03 | 1683.58 | 4655.0 |
| 2013-06-14 06:30:00 | ES | Futures | 1683.84 | 1683.84 | 1681.77 | 1682.8 | 7638.0 |
| 2013-06-14 07:00:00 | ES | Futures | 1682.54 | 1686.16 | 1682.54 | 1685.39 | 10405.0 |
| 2013-06-14 07:30:00 | ES | Futures | 1685.39 | 1685.9 | 1684.35 | 1684.35 | 12536.0 |
| 2013-06-14 08:00:00 | ES | Futures | 1684.61 | 1684.61 | 1681.77 | 1682.28 | 14640.0 |
| 2013-06-14 08:30:00 | ES | Futures | 1682.28 | 1685.13 | 1682.28 | 1684.35 | 20050.0 |
| 2013-06-14 09:00:00 | ES | Futures | 1684.09 | 1685.39 | 1682.8 | 1684.35 | 17616.0 |
| 2013-06-14 09:30:00 | ES | Futures | 1684.35 | 1688.75 | 1682.54 | 1688.49 | 168191.0 |
| 2013-06-14 10:00:00 | ES | Futures | 1688.49 | 1690.56 | 1684.61 | 1685.13 | 93246.0 |
| 2013-06-14 10:30:00 | ES | Futures | 1685.39 | 1686.68 | 1678.15 | 1679.18 | 119104.0 |
| 2013-06-14 11:00:00 | ES | Futures | 1679.18 | 1682.28 | 1677.11 | 1681.25 | 96080.0 |
| 2013-06-14 11:30:00 | ES | Futures | 1681.51 | 1682.8 | 1676.6 | 1680.22 | 104628.0 |
| 2013-06-14 12:00:00 | ES | Futures | 1680.22 | 1681.25 | 1677.37 | 1679.96 | 56033.0 |
| 2013-06-14 12:30:00 | ES | Futures | 1679.7 | 1682.03 | 1676.86 | 1677.63 | 59286.0 |
| 2013-06-14 13:00:00 | ES | Futures | 1677.63 | 1677.89 | 1672.72 | 1673.5 | 68458.0 |
| 2013-06-14 13:30:00 | ES | Futures | 1673.5 | 1675.3 | 1672.46 | 1674.53 | 59174.0 |
| 2013-06-14 14:00:00 | ES | Futures | 1674.53 | 1679.96 | 1672.2 | 1678.67 | 84979.0 |
| 2013-06-14 14:30:00 | ES | Futures | 1678.41 | 1679.7 | 1674.53 | 1675.3 | 57708.0 |
| 2013-06-14 15:00:00 | ES | Futures | 1675.05 | 1680.73 | 1674.79 | 1677.63 | 62700.0 |
| 2013-06-14 15:30:00 | ES | Futures | 1677.89 | 1679.18 | 1673.24 | 1675.3 | 104002.0 |
| 2013-06-14 16:00:00 | ES | Futures | 1675.3 | 1675.82 | 1672.98 | 1673.5 | 67646.0 |
| 2013-06-14 16:30:00 | ES | Futures | 1673.5 | 1674.01 | 1672.98 | 1673.24 | 5755.0 |
| 2013-06-14 17:00:00 | ES | Futures | 1672.98 | 1673.5 | 1672.72 | 1672.72 | 1179.0 |
| 2013-06-14 00:00:00 | NQ | Futures | 3452.18 | 3455.98 | 3451.01 | 3455.98 | 174.0 |
| 2013-06-14 00:30:00 | NQ | Futures | 3455.1 | 3458.61 | 3454.23 | 3458.03 | 154.0 |
| 2013-06-14 01:00:00 | NQ | Futures | 3458.03 | 3458.9 | 3457.15 | 3457.15 | 161.0 |
| 2013-06-14 01:30:00 | NQ | Futures | 3458.03 | 3459.2 | 3454.52 | 3454.52 | 165.0 |
| 2013-06-14 02:00:00 | NQ | Futures | 3454.81 | 3460.36 | 3454.81 | 3457.73 | 271.0 |
| 2013-06-14 02:30:00 | NQ | Futures | 3457.73 | 3460.66 | 3456.27 | 3460.07 | 202.0 |
| 2013-06-14 03:00:00 | NQ | Futures | 3460.07 | 3460.36 | 3451.6 | 3457.44 | 2318.0 |
| 2013-06-14 03:30:00 | NQ | Futures | 3457.15 | 3459.78 | 3454.52 | 3459.49 | 1048.0 |
| 2013-06-14 04:00:00 | NQ | Futures | 3459.49 | 3460.66 | 3456.86 | 3459.2 | 1049.0 |
| 2013-06-14 04:30:00 | NQ | Futures | 3459.49 | 3461.24 | 3456.57 | 3460.66 | 658.0 |
| 2013-06-14 05:00:00 | NQ | Futures | 3460.95 | 3462.41 | 3454.23 | 3455.98 | 1343.0 |
| 2013-06-14 05:30:00 | NQ | Futures | 3456.27 | 3459.78 | 3452.18 | 3452.18 | 1330.0 |
| 2013-06-14 06:00:00 | NQ | Futures | 3452.18 | 3454.52 | 3451.01 | 3452.77 | 833.0 |
| 2013-06-14 06:30:00 | NQ | Futures | 3452.77 | 3452.77 | 3449.26 | 3451.89 | 1033.0 |
| 2013-06-14 07:00:00 | NQ | Futures | 3451.31 | 3457.15 | 3451.01 | 3455.69 | 1703.0 |
> showing 50 of 2,272 rows — these rows as CSV