PREVIEW / futures_30min / 2013-06-07
file: by_date/futures_30min/2013/2013-06-07.parquet size: 69 KB rows: 2,318
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-07 00:00:00 | ES | Futures | 1669.66 | 1671.72 | 1669.15 | 1671.21 | 5023.0 |
| 2013-06-07 00:30:00 | ES | Futures | 1671.46 | 1673.01 | 1671.46 | 1672.24 | 3931.0 |
| 2013-06-07 01:00:00 | ES | Futures | 1672.24 | 1672.24 | 1670.18 | 1671.46 | 3393.0 |
| 2013-06-07 01:30:00 | ES | Futures | 1671.21 | 1673.01 | 1670.43 | 1670.69 | 4080.0 |
| 2013-06-07 02:00:00 | ES | Futures | 1670.43 | 1671.72 | 1668.12 | 1668.63 | 13248.0 |
| 2013-06-07 02:30:00 | ES | Futures | 1668.63 | 1672.75 | 1667.09 | 1671.72 | 13827.0 |
| 2013-06-07 03:00:00 | ES | Futures | 1671.46 | 1672.24 | 1668.37 | 1669.15 | 21285.0 |
| 2013-06-07 03:30:00 | ES | Futures | 1668.89 | 1669.66 | 1667.34 | 1669.15 | 12136.0 |
| 2013-06-07 04:00:00 | ES | Futures | 1669.15 | 1671.72 | 1668.37 | 1669.4 | 11280.0 |
| 2013-06-07 04:30:00 | ES | Futures | 1669.15 | 1671.21 | 1668.63 | 1670.69 | 9416.0 |
| 2013-06-07 05:00:00 | ES | Futures | 1670.43 | 1671.21 | 1669.92 | 1670.43 | 5737.0 |
| 2013-06-07 05:30:00 | ES | Futures | 1670.18 | 1672.24 | 1669.15 | 1671.46 | 11142.0 |
| 2013-06-07 06:00:00 | ES | Futures | 1671.72 | 1672.24 | 1667.6 | 1668.12 | 12638.0 |
| 2013-06-07 06:30:00 | ES | Futures | 1668.12 | 1672.24 | 1667.86 | 1671.72 | 23963.0 |
| 2013-06-07 07:00:00 | ES | Futures | 1671.72 | 1672.24 | 1670.18 | 1670.95 | 19056.0 |
| 2013-06-07 07:30:00 | ES | Futures | 1670.95 | 1672.5 | 1670.18 | 1671.21 | 19502.0 |
| 2013-06-07 08:00:00 | ES | Futures | 1671.21 | 1676.62 | 1670.69 | 1675.33 | 36499.0 |
| 2013-06-07 08:30:00 | ES | Futures | 1675.59 | 1682.8 | 1668.37 | 1680.74 | 201086.0 |
| 2013-06-07 09:00:00 | ES | Futures | 1680.74 | 1683.06 | 1677.65 | 1682.54 | 63079.0 |
| 2013-06-07 09:30:00 | ES | Futures | 1682.54 | 1683.06 | 1675.07 | 1682.28 | 318884.0 |
| 2013-06-07 10:00:00 | ES | Futures | 1682.03 | 1688.72 | 1682.03 | 1686.92 | 271870.0 |
| 2013-06-07 10:30:00 | ES | Futures | 1687.18 | 1689.24 | 1685.63 | 1686.4 | 153149.0 |
| 2013-06-07 11:00:00 | ES | Futures | 1686.4 | 1691.56 | 1686.4 | 1690.27 | 142397.0 |
| 2013-06-07 11:30:00 | ES | Futures | 1690.53 | 1692.07 | 1687.18 | 1688.21 | 141608.0 |
| 2013-06-07 12:00:00 | ES | Futures | 1688.21 | 1688.72 | 1686.15 | 1688.47 | 56277.0 |
| 2013-06-07 12:30:00 | ES | Futures | 1688.47 | 1688.47 | 1684.09 | 1687.18 | 66831.0 |
| 2013-06-07 13:00:00 | ES | Futures | 1687.18 | 1688.47 | 1685.89 | 1687.18 | 42484.0 |
| 2013-06-07 13:30:00 | ES | Futures | 1687.18 | 1688.21 | 1685.12 | 1685.37 | 68609.0 |
| 2013-06-07 14:00:00 | ES | Futures | 1685.63 | 1686.92 | 1681.25 | 1683.06 | 77397.0 |
| 2013-06-07 14:30:00 | ES | Futures | 1683.06 | 1688.47 | 1681.77 | 1687.69 | 83910.0 |
| 2013-06-07 15:00:00 | ES | Futures | 1687.43 | 1689.5 | 1686.15 | 1687.95 | 78860.0 |
| 2013-06-07 15:30:00 | ES | Futures | 1687.69 | 1693.87 | 1687.69 | 1692.33 | 186465.0 |
| 2013-06-07 16:00:00 | ES | Futures | 1692.33 | 1692.33 | 1687.95 | 1689.24 | 94837.0 |
| 2013-06-07 16:30:00 | ES | Futures | 1689.24 | 1690.01 | 1688.72 | 1689.75 | 10067.0 |
| 2013-06-07 17:00:00 | ES | Futures | 1689.5 | 1689.5 | 1688.72 | 1688.72 | 1653.0 |
| 2013-06-07 00:00:00 | NQ | Futures | 3437.31 | 3440.52 | 3435.85 | 3440.22 | 575.0 |
| 2013-06-07 00:30:00 | NQ | Futures | 3440.22 | 3443.43 | 3440.22 | 3441.1 | 510.0 |
| 2013-06-07 01:00:00 | NQ | Futures | 3440.52 | 3441.39 | 3437.02 | 3439.93 | 490.0 |
| 2013-06-07 01:30:00 | NQ | Futures | 3440.22 | 3443.43 | 3437.89 | 3437.89 | 511.0 |
| 2013-06-07 02:00:00 | NQ | Futures | 3437.6 | 3439.93 | 3433.81 | 3434.39 | 1212.0 |
| 2013-06-07 02:30:00 | NQ | Futures | 3434.1 | 3441.97 | 3431.77 | 3439.64 | 1109.0 |
| 2013-06-07 03:00:00 | NQ | Futures | 3439.64 | 3440.52 | 3435.27 | 3437.31 | 3318.0 |
| 2013-06-07 03:30:00 | NQ | Futures | 3437.02 | 3439.64 | 3434.39 | 3439.35 | 1651.0 |
| 2013-06-07 04:00:00 | NQ | Futures | 3439.35 | 3444.02 | 3436.43 | 3436.43 | 2070.0 |
| 2013-06-07 04:30:00 | NQ | Futures | 3436.43 | 3439.93 | 3435.27 | 3439.64 | 1561.0 |
| 2013-06-07 05:00:00 | NQ | Futures | 3439.64 | 3440.52 | 3437.02 | 3437.31 | 727.0 |
| 2013-06-07 05:30:00 | NQ | Futures | 3437.89 | 3443.14 | 3435.27 | 3441.39 | 1513.0 |
| 2013-06-07 06:00:00 | NQ | Futures | 3441.68 | 3442.85 | 3432.64 | 3433.22 | 1701.0 |
| 2013-06-07 06:30:00 | NQ | Futures | 3432.93 | 3440.52 | 3432.64 | 3439.64 | 1408.0 |
| 2013-06-07 07:00:00 | NQ | Futures | 3439.64 | 3441.1 | 3436.72 | 3438.18 | 1327.0 |
> showing 50 of 2,318 rows — these rows as CSV