PREVIEW / futures_30min / 2013-04-03
file: by_date/futures_30min/2013/2013-04-03.parquet size: 78 KB rows: 2,927
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-04-03 00:00:00 | ES | Futures | 1611.45 | 1611.96 | 1611.19 | 1611.19 | 720.0 |
| 2013-04-03 00:30:00 | ES | Futures | 1611.45 | 1612.22 | 1611.19 | 1611.96 | 1131.0 |
| 2013-04-03 01:00:00 | ES | Futures | 1611.96 | 1612.74 | 1611.71 | 1611.71 | 2099.0 |
| 2013-04-03 01:30:00 | ES | Futures | 1611.96 | 1612.99 | 1611.71 | 1612.74 | 2040.0 |
| 2013-04-03 02:00:00 | ES | Futures | 1612.99 | 1613.77 | 1612.48 | 1613.25 | 4449.0 |
| 2013-04-03 02:30:00 | ES | Futures | 1613.25 | 1614.02 | 1612.99 | 1613.77 | 2773.0 |
| 2013-04-03 03:00:00 | ES | Futures | 1613.77 | 1614.02 | 1611.96 | 1612.74 | 13208.0 |
| 2013-04-03 03:30:00 | ES | Futures | 1612.99 | 1613.25 | 1612.22 | 1613.25 | 6732.0 |
| 2013-04-03 04:00:00 | ES | Futures | 1613.25 | 1615.05 | 1612.99 | 1615.05 | 10388.0 |
| 2013-04-03 04:30:00 | ES | Futures | 1614.8 | 1615.05 | 1614.02 | 1614.54 | 3463.0 |
| 2013-04-03 05:00:00 | ES | Futures | 1614.54 | 1615.31 | 1614.02 | 1615.05 | 5671.0 |
| 2013-04-03 05:30:00 | ES | Futures | 1615.05 | 1615.31 | 1614.54 | 1615.05 | 5092.0 |
| 2013-04-03 06:00:00 | ES | Futures | 1615.05 | 1615.05 | 1614.02 | 1614.28 | 4410.0 |
| 2013-04-03 06:30:00 | ES | Futures | 1614.28 | 1614.54 | 1613.77 | 1614.02 | 5292.0 |
| 2013-04-03 07:00:00 | ES | Futures | 1614.02 | 1614.02 | 1612.74 | 1613.25 | 14675.0 |
| 2013-04-03 07:30:00 | ES | Futures | 1613.25 | 1614.54 | 1612.22 | 1614.28 | 15711.0 |
| 2013-04-03 08:00:00 | ES | Futures | 1614.28 | 1614.54 | 1611.71 | 1612.74 | 35299.0 |
| 2013-04-03 08:30:00 | ES | Futures | 1612.48 | 1613.25 | 1611.71 | 1612.74 | 21597.0 |
| 2013-04-03 09:00:00 | ES | Futures | 1612.74 | 1613.25 | 1612.22 | 1612.22 | 17016.0 |
| 2013-04-03 09:30:00 | ES | Futures | 1612.48 | 1613.77 | 1607.58 | 1608.1 | 247399.0 |
| 2013-04-03 10:00:00 | ES | Futures | 1608.1 | 1609.13 | 1604.49 | 1606.55 | 242074.0 |
| 2013-04-03 10:30:00 | ES | Futures | 1606.55 | 1606.55 | 1602.69 | 1603.2 | 176627.0 |
| 2013-04-03 11:00:00 | ES | Futures | 1602.95 | 1603.72 | 1600.37 | 1602.17 | 171786.0 |
| 2013-04-03 11:30:00 | ES | Futures | 1602.43 | 1603.72 | 1600.37 | 1603.46 | 105984.0 |
| 2013-04-03 12:00:00 | ES | Futures | 1603.46 | 1603.46 | 1599.86 | 1600.37 | 61268.0 |
| 2013-04-03 12:30:00 | ES | Futures | 1600.11 | 1601.66 | 1598.31 | 1599.6 | 95436.0 |
| 2013-04-03 13:00:00 | ES | Futures | 1599.34 | 1600.63 | 1598.05 | 1598.57 | 72183.0 |
| 2013-04-03 13:30:00 | ES | Futures | 1598.31 | 1598.57 | 1593.93 | 1593.93 | 148746.0 |
| 2013-04-03 14:00:00 | ES | Futures | 1593.93 | 1597.02 | 1593.16 | 1595.22 | 142448.0 |
| 2013-04-03 14:30:00 | ES | Futures | 1595.22 | 1599.08 | 1594.7 | 1598.05 | 115487.0 |
| 2013-04-03 15:00:00 | ES | Futures | 1598.05 | 1598.31 | 1594.96 | 1595.48 | 93888.0 |
| 2013-04-03 15:30:00 | ES | Futures | 1595.48 | 1597.8 | 1590.84 | 1595.48 | 291332.0 |
| 2013-04-03 16:00:00 | ES | Futures | 1595.48 | 1596.25 | 1594.19 | 1595.22 | 93622.0 |
| 2013-04-03 16:30:00 | ES | Futures | 1595.22 | 1595.99 | 1594.96 | 1595.99 | 6650.0 |
| 2013-04-03 17:00:00 | ES | Futures | 1595.99 | 1596.51 | 1595.73 | 1595.99 | 3045.0 |
| 2013-04-03 18:00:00 | ES | Futures | 1595.48 | 1595.99 | 1592.9 | 1594.96 | 6688.0 |
| 2013-04-03 18:30:00 | ES | Futures | 1594.96 | 1596.25 | 1594.19 | 1594.96 | 3987.0 |
| 2013-04-03 19:00:00 | ES | Futures | 1594.7 | 1596.25 | 1594.7 | 1595.73 | 1669.0 |
| 2013-04-03 19:30:00 | ES | Futures | 1595.73 | 1596.51 | 1595.48 | 1595.99 | 1228.0 |
| 2013-04-03 20:00:00 | ES | Futures | 1595.99 | 1595.99 | 1594.45 | 1595.22 | 3557.0 |
| 2013-04-03 20:30:00 | ES | Futures | 1595.22 | 1596.25 | 1594.7 | 1595.73 | 3635.0 |
| 2013-04-03 21:00:00 | ES | Futures | 1595.48 | 1596.77 | 1595.48 | 1595.99 | 2192.0 |
| 2013-04-03 21:30:00 | ES | Futures | 1595.99 | 1596.51 | 1594.96 | 1595.73 | 2172.0 |
| 2013-04-03 22:00:00 | ES | Futures | 1595.73 | 1595.99 | 1594.7 | 1595.48 | 2144.0 |
| 2013-04-03 22:30:00 | ES | Futures | 1595.48 | 1595.73 | 1594.19 | 1594.19 | 1481.0 |
| 2013-04-03 23:00:00 | ES | Futures | 1594.45 | 1595.22 | 1594.19 | 1595.22 | 1521.0 |
| 2013-04-03 23:30:00 | ES | Futures | 1594.96 | 1595.22 | 1594.45 | 1594.96 | 1142.0 |
| 2013-04-03 00:00:00 | NQ | Futures | 3282.72 | 3283.01 | 3282.14 | 3282.43 | 80.0 |
| 2013-04-03 00:30:00 | NQ | Futures | 3282.43 | 3283.6 | 3282.14 | 3283.6 | 119.0 |
| 2013-04-03 01:00:00 | NQ | Futures | 3283.31 | 3284.47 | 3283.31 | 3283.6 | 137.0 |
> showing 50 of 2,927 rows — these rows as CSV