PREVIEW / futures_30min / 2013-06-26
file: by_date/futures_30min/2013/2013-06-26.parquet size: 80 KB rows: 2,878
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-26 00:00:00 | ES | Futures | 1629.29 | 1631.62 | 1629.03 | 1630.59 | 2807.0 |
| 2013-06-26 00:30:00 | ES | Futures | 1630.59 | 1631.1 | 1628.52 | 1629.55 | 2259.0 |
| 2013-06-26 01:00:00 | ES | Futures | 1629.55 | 1631.88 | 1629.29 | 1630.59 | 2650.0 |
| 2013-06-26 01:30:00 | ES | Futures | 1630.84 | 1631.1 | 1629.03 | 1630.59 | 2811.0 |
| 2013-06-26 02:00:00 | ES | Futures | 1630.33 | 1632.14 | 1630.07 | 1631.88 | 4294.0 |
| 2013-06-26 02:30:00 | ES | Futures | 1632.14 | 1633.43 | 1631.88 | 1633.17 | 5718.0 |
| 2013-06-26 03:00:00 | ES | Futures | 1633.43 | 1634.2 | 1630.07 | 1632.91 | 16726.0 |
| 2013-06-26 03:30:00 | ES | Futures | 1633.17 | 1637.56 | 1632.39 | 1637.31 | 19303.0 |
| 2013-06-26 04:00:00 | ES | Futures | 1637.31 | 1639.37 | 1636.79 | 1639.12 | 15697.0 |
| 2013-06-26 04:30:00 | ES | Futures | 1639.12 | 1640.93 | 1638.6 | 1638.6 | 16705.0 |
| 2013-06-26 05:00:00 | ES | Futures | 1638.6 | 1641.18 | 1638.6 | 1640.93 | 7802.0 |
| 2013-06-26 05:30:00 | ES | Futures | 1640.93 | 1642.48 | 1639.89 | 1642.48 | 9481.0 |
| 2013-06-26 06:00:00 | ES | Futures | 1642.48 | 1643.77 | 1641.7 | 1642.22 | 17472.0 |
| 2013-06-26 06:30:00 | ES | Futures | 1642.48 | 1643.25 | 1640.93 | 1641.18 | 7450.0 |
| 2013-06-26 07:00:00 | ES | Futures | 1641.18 | 1643.51 | 1640.93 | 1643.25 | 10678.0 |
| 2013-06-26 07:30:00 | ES | Futures | 1643.25 | 1645.84 | 1643.25 | 1645.32 | 22445.0 |
| 2013-06-26 08:00:00 | ES | Futures | 1645.58 | 1645.58 | 1643.51 | 1644.54 | 18982.0 |
| 2013-06-26 08:30:00 | ES | Futures | 1644.29 | 1645.58 | 1641.7 | 1645.32 | 49564.0 |
| 2013-06-26 09:00:00 | ES | Futures | 1645.32 | 1649.46 | 1644.29 | 1648.94 | 52958.0 |
| 2013-06-26 09:30:00 | ES | Futures | 1649.2 | 1652.04 | 1647.9 | 1649.97 | 198143.0 |
| 2013-06-26 10:00:00 | ES | Futures | 1649.97 | 1651.78 | 1645.84 | 1646.61 | 145001.0 |
| 2013-06-26 10:30:00 | ES | Futures | 1646.61 | 1649.2 | 1644.8 | 1645.84 | 116184.0 |
| 2013-06-26 11:00:00 | ES | Futures | 1645.84 | 1647.39 | 1642.48 | 1644.54 | 124506.0 |
| 2013-06-26 11:30:00 | ES | Futures | 1644.29 | 1646.35 | 1642.99 | 1644.03 | 72360.0 |
| 2013-06-26 12:00:00 | ES | Futures | 1644.03 | 1648.68 | 1643.77 | 1648.16 | 59331.0 |
| 2013-06-26 12:30:00 | ES | Futures | 1648.16 | 1649.2 | 1646.61 | 1647.13 | 50866.0 |
| 2013-06-26 13:00:00 | ES | Futures | 1647.13 | 1652.04 | 1646.35 | 1651.78 | 74631.0 |
| 2013-06-26 13:30:00 | ES | Futures | 1651.78 | 1652.56 | 1649.46 | 1651.01 | 61312.0 |
| 2013-06-26 14:00:00 | ES | Futures | 1651.01 | 1653.07 | 1649.71 | 1652.82 | 60188.0 |
| 2013-06-26 14:30:00 | ES | Futures | 1652.82 | 1654.11 | 1651.01 | 1652.82 | 61060.0 |
| 2013-06-26 15:00:00 | ES | Futures | 1652.56 | 1655.66 | 1652.56 | 1653.85 | 98547.0 |
| 2013-06-26 15:30:00 | ES | Futures | 1654.11 | 1655.14 | 1651.01 | 1651.52 | 152785.0 |
| 2013-06-26 16:00:00 | ES | Futures | 1651.78 | 1652.04 | 1649.2 | 1649.46 | 94425.0 |
| 2013-06-26 16:30:00 | ES | Futures | 1649.71 | 1650.75 | 1649.71 | 1650.75 | 5074.0 |
| 2013-06-26 17:00:00 | ES | Futures | 1650.49 | 1651.52 | 1650.49 | 1651.26 | 2709.0 |
| 2013-06-26 18:00:00 | ES | Futures | 1651.01 | 1651.26 | 1649.46 | 1649.71 | 2251.0 |
| 2013-06-26 18:30:00 | ES | Futures | 1649.97 | 1650.23 | 1649.46 | 1649.97 | 1216.0 |
| 2013-06-26 19:00:00 | ES | Futures | 1649.97 | 1650.49 | 1649.2 | 1649.2 | 1132.0 |
| 2013-06-26 19:30:00 | ES | Futures | 1649.46 | 1650.23 | 1648.94 | 1648.94 | 1607.0 |
| 2013-06-26 20:00:00 | ES | Futures | 1649.2 | 1650.49 | 1649.2 | 1650.49 | 2595.0 |
| 2013-06-26 20:30:00 | ES | Futures | 1650.49 | 1650.75 | 1648.94 | 1650.75 | 2192.0 |
| 2013-06-26 21:00:00 | ES | Futures | 1650.75 | 1652.82 | 1650.49 | 1652.82 | 3904.0 |
| 2013-06-26 21:30:00 | ES | Futures | 1652.82 | 1654.63 | 1652.3 | 1654.63 | 8584.0 |
| 2013-06-26 22:00:00 | ES | Futures | 1654.37 | 1655.4 | 1654.11 | 1655.14 | 3455.0 |
| 2013-06-26 22:30:00 | ES | Futures | 1654.88 | 1655.4 | 1654.11 | 1654.11 | 2156.0 |
| 2013-06-26 23:00:00 | ES | Futures | 1654.11 | 1654.63 | 1654.11 | 1654.37 | 900.0 |
| 2013-06-26 23:30:00 | ES | Futures | 1654.11 | 1654.37 | 1649.97 | 1649.97 | 6435.0 |
| 2013-06-26 00:00:00 | NQ | Futures | 3332.37 | 3337.33 | 3332.07 | 3335.58 | 542.0 |
| 2013-06-26 00:30:00 | NQ | Futures | 3335.58 | 3336.16 | 3332.37 | 3334.12 | 548.0 |
| 2013-06-26 01:00:00 | NQ | Futures | 3334.41 | 3338.5 | 3333.53 | 3336.46 | 322.0 |
> showing 50 of 2,878 rows — these rows as CSV