PREVIEW / futures_30min / 2013-06-03
file: by_date/futures_30min/2013/2013-06-03.parquet size: 81 KB rows: 2,800
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-03 00:00:00 | ES | Futures | 1682.54 | 1682.54 | 1681.51 | 1681.77 | 1152.0 |
| 2013-06-03 00:30:00 | ES | Futures | 1681.77 | 1682.03 | 1680.74 | 1681.0 | 2267.0 |
| 2013-06-03 01:00:00 | ES | Futures | 1681.0 | 1682.03 | 1681.0 | 1681.77 | 2034.0 |
| 2013-06-03 01:30:00 | ES | Futures | 1681.51 | 1682.8 | 1680.74 | 1682.8 | 3261.0 |
| 2013-06-03 02:00:00 | ES | Futures | 1682.54 | 1682.8 | 1679.71 | 1680.74 | 7445.0 |
| 2013-06-03 02:30:00 | ES | Futures | 1680.74 | 1682.54 | 1679.71 | 1681.77 | 8134.0 |
| 2013-06-03 03:00:00 | ES | Futures | 1681.77 | 1683.06 | 1677.39 | 1679.19 | 32626.0 |
| 2013-06-03 03:30:00 | ES | Futures | 1679.19 | 1681.77 | 1678.16 | 1680.74 | 15975.0 |
| 2013-06-03 04:00:00 | ES | Futures | 1680.74 | 1680.74 | 1676.36 | 1678.93 | 19473.0 |
| 2013-06-03 04:30:00 | ES | Futures | 1678.68 | 1679.45 | 1677.39 | 1678.93 | 8407.0 |
| 2013-06-03 05:00:00 | ES | Futures | 1678.93 | 1682.03 | 1678.16 | 1681.0 | 12052.0 |
| 2013-06-03 05:30:00 | ES | Futures | 1681.0 | 1683.31 | 1680.22 | 1682.03 | 10298.0 |
| 2013-06-03 06:00:00 | ES | Futures | 1682.03 | 1683.06 | 1681.0 | 1682.54 | 6612.0 |
| 2013-06-03 06:30:00 | ES | Futures | 1682.54 | 1686.15 | 1682.54 | 1686.15 | 24850.0 |
| 2013-06-03 07:00:00 | ES | Futures | 1686.15 | 1688.21 | 1685.12 | 1686.92 | 32617.0 |
| 2013-06-03 07:30:00 | ES | Futures | 1687.18 | 1687.95 | 1685.12 | 1685.37 | 20606.0 |
| 2013-06-03 08:00:00 | ES | Futures | 1685.37 | 1686.15 | 1683.06 | 1683.31 | 18402.0 |
| 2013-06-03 08:30:00 | ES | Futures | 1683.57 | 1684.34 | 1681.77 | 1683.57 | 31100.0 |
| 2013-06-03 09:00:00 | ES | Futures | 1683.31 | 1684.09 | 1682.28 | 1682.54 | 24138.0 |
| 2013-06-03 09:30:00 | ES | Futures | 1682.28 | 1682.8 | 1676.1 | 1677.13 | 285716.0 |
| 2013-06-03 10:00:00 | ES | Futures | 1677.13 | 1685.89 | 1674.56 | 1681.0 | 357165.0 |
| 2013-06-03 10:30:00 | ES | Futures | 1680.74 | 1681.25 | 1672.5 | 1677.65 | 236735.0 |
| 2013-06-03 11:00:00 | ES | Futures | 1677.39 | 1678.16 | 1670.18 | 1671.46 | 209760.0 |
| 2013-06-03 11:30:00 | ES | Futures | 1671.46 | 1675.59 | 1669.92 | 1674.81 | 125696.0 |
| 2013-06-03 12:00:00 | ES | Futures | 1674.81 | 1677.13 | 1672.24 | 1675.33 | 103982.0 |
| 2013-06-03 12:30:00 | ES | Futures | 1675.33 | 1677.65 | 1672.75 | 1676.36 | 76206.0 |
| 2013-06-03 13:00:00 | ES | Futures | 1676.36 | 1678.93 | 1675.07 | 1675.84 | 72825.0 |
| 2013-06-03 13:30:00 | ES | Futures | 1676.1 | 1678.68 | 1674.3 | 1677.65 | 73756.0 |
| 2013-06-03 14:00:00 | ES | Futures | 1677.65 | 1681.51 | 1676.36 | 1678.68 | 97565.0 |
| 2013-06-03 14:30:00 | ES | Futures | 1678.68 | 1683.31 | 1677.65 | 1681.25 | 98736.0 |
| 2013-06-03 15:00:00 | ES | Futures | 1681.25 | 1683.57 | 1679.97 | 1683.06 | 95141.0 |
| 2013-06-03 15:30:00 | ES | Futures | 1683.06 | 1688.72 | 1681.77 | 1687.95 | 207130.0 |
| 2013-06-03 16:00:00 | ES | Futures | 1687.95 | 1687.95 | 1685.12 | 1685.37 | 84972.0 |
| 2013-06-03 16:30:00 | ES | Futures | 1685.37 | 1686.4 | 1685.12 | 1686.15 | 8936.0 |
| 2013-06-03 17:00:00 | ES | Futures | 1686.15 | 1686.15 | 1684.86 | 1685.37 | 1793.0 |
| 2013-06-03 18:00:00 | ES | Futures | 1685.37 | 1685.89 | 1684.86 | 1685.63 | 2186.0 |
| 2013-06-03 18:30:00 | ES | Futures | 1685.37 | 1685.63 | 1679.71 | 1681.77 | 12823.0 |
| 2013-06-03 19:00:00 | ES | Futures | 1681.77 | 1683.57 | 1681.77 | 1683.57 | 1289.0 |
| 2013-06-03 19:30:00 | ES | Futures | 1683.57 | 1684.6 | 1683.06 | 1684.09 | 2128.0 |
| 2013-06-03 20:00:00 | ES | Futures | 1683.83 | 1684.86 | 1683.06 | 1683.31 | 3384.0 |
| 2013-06-03 20:30:00 | ES | Futures | 1683.31 | 1683.57 | 1682.03 | 1682.8 | 2691.0 |
| 2013-06-03 21:00:00 | ES | Futures | 1682.8 | 1684.09 | 1682.28 | 1682.8 | 3108.0 |
| 2013-06-03 21:30:00 | ES | Futures | 1682.8 | 1684.09 | 1681.77 | 1683.83 | 3416.0 |
| 2013-06-03 22:00:00 | ES | Futures | 1683.83 | 1684.09 | 1682.54 | 1683.06 | 2365.0 |
| 2013-06-03 22:30:00 | ES | Futures | 1683.31 | 1683.31 | 1681.77 | 1682.03 | 2368.0 |
| 2013-06-03 23:00:00 | ES | Futures | 1682.03 | 1683.31 | 1681.51 | 1682.54 | 3140.0 |
| 2013-06-03 23:30:00 | ES | Futures | 1682.54 | 1683.83 | 1682.54 | 1683.83 | 3413.0 |
| 2013-06-03 00:00:00 | NQ | Futures | 3484.85 | 3485.14 | 3483.68 | 3483.97 | 181.0 |
| 2013-06-03 00:30:00 | NQ | Futures | 3484.27 | 3484.27 | 3482.52 | 3483.68 | 165.0 |
| 2013-06-03 01:00:00 | NQ | Futures | 3483.68 | 3484.85 | 3483.1 | 3484.27 | 121.0 |
> showing 50 of 2,800 rows — these rows as CSV