PREVIEW / futures_30min / 2013-10-13
file: by_date/futures_30min/2013/2013-10-13.parquet size: 19 KB rows: 485
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-10-13 18:00:00 | ES | Futures | 1737.62 | 1740.72 | 1736.59 | 1738.65 | 41602.0 |
| 2013-10-13 18:30:00 | ES | Futures | 1738.65 | 1738.91 | 1734.78 | 1735.3 | 13092.0 |
| 2013-10-13 19:00:00 | ES | Futures | 1735.3 | 1738.4 | 1734.27 | 1738.14 | 7286.0 |
| 2013-10-13 19:30:00 | ES | Futures | 1738.14 | 1741.75 | 1737.88 | 1741.75 | 3790.0 |
| 2013-10-13 20:00:00 | ES | Futures | 1741.75 | 1741.75 | 1738.91 | 1738.91 | 4925.0 |
| 2013-10-13 20:30:00 | ES | Futures | 1739.17 | 1740.72 | 1737.36 | 1738.4 | 5993.0 |
| 2013-10-13 21:00:00 | ES | Futures | 1738.65 | 1740.2 | 1737.88 | 1739.17 | 3413.0 |
| 2013-10-13 21:30:00 | ES | Futures | 1739.17 | 1742.01 | 1739.17 | 1740.97 | 2166.0 |
| 2013-10-13 22:00:00 | ES | Futures | 1740.97 | 1741.75 | 1740.2 | 1740.2 | 1618.0 |
| 2013-10-13 22:30:00 | ES | Futures | 1740.2 | 1740.46 | 1738.65 | 1739.69 | 3168.0 |
| 2013-10-13 23:00:00 | ES | Futures | 1739.43 | 1740.46 | 1739.43 | 1740.46 | 611.0 |
| 2013-10-13 23:30:00 | ES | Futures | 1740.2 | 1741.49 | 1740.2 | 1741.23 | 987.0 |
| 2013-10-13 18:00:00 | NQ | Futures | 3723.34 | 3724.51 | 3711.73 | 3722.76 | 4918.0 |
| 2013-10-13 18:30:00 | NQ | Futures | 3722.76 | 3722.76 | 3713.76 | 3715.21 | 1158.0 |
| 2013-10-13 19:00:00 | NQ | Futures | 3715.21 | 3722.18 | 3714.05 | 3721.31 | 627.0 |
| 2013-10-13 19:30:00 | NQ | Futures | 3721.6 | 3729.44 | 3720.73 | 3729.44 | 799.0 |
| 2013-10-13 20:00:00 | NQ | Futures | 3729.44 | 3729.44 | 3723.64 | 3723.93 | 583.0 |
| 2013-10-13 20:30:00 | NQ | Futures | 3724.51 | 3728.28 | 3721.31 | 3723.64 | 805.0 |
| 2013-10-13 21:00:00 | NQ | Futures | 3723.93 | 3726.83 | 3721.02 | 3724.51 | 781.0 |
| 2013-10-13 21:30:00 | NQ | Futures | 3724.8 | 3732.35 | 3724.51 | 3729.44 | 955.0 |
| 2013-10-13 22:00:00 | NQ | Futures | 3729.44 | 3730.9 | 3727.99 | 3728.57 | 323.0 |
| 2013-10-13 22:30:00 | NQ | Futures | 3728.28 | 3728.57 | 3724.8 | 3727.12 | 490.0 |
| 2013-10-13 23:00:00 | NQ | Futures | 3727.12 | 3729.44 | 3726.83 | 3728.86 | 186.0 |
| 2013-10-13 23:30:00 | NQ | Futures | 3728.86 | 3730.9 | 3728.28 | 3730.9 | 136.0 |
| 2013-10-13 18:00:00 | YM | Futures | 15398.4 | 15404.5 | 15367.7 | 15397.3 | 2714.0 |
| 2013-10-13 18:30:00 | YM | Futures | 15396.3 | 15396.3 | 15358.5 | 15362.6 | 1713.0 |
| 2013-10-13 19:00:00 | YM | Futures | 15363.6 | 15389.2 | 15356.5 | 15385.1 | 744.0 |
| 2013-10-13 19:30:00 | YM | Futures | 15385.1 | 15412.7 | 15382.0 | 15412.7 | 536.0 |
| 2013-10-13 20:00:00 | YM | Futures | 15411.6 | 15412.7 | 15393.3 | 15395.3 | 898.0 |
| 2013-10-13 20:30:00 | YM | Futures | 15396.3 | 15409.6 | 15381.0 | 15387.1 | 1174.0 |
| 2013-10-13 21:00:00 | YM | Futures | 15387.1 | 15399.4 | 15383.0 | 15391.2 | 815.0 |
| 2013-10-13 21:30:00 | YM | Futures | 15391.2 | 15413.7 | 15391.2 | 15404.5 | 744.0 |
| 2013-10-13 22:00:00 | YM | Futures | 15404.5 | 15410.6 | 15398.4 | 15399.4 | 289.0 |
| 2013-10-13 22:30:00 | YM | Futures | 15399.4 | 15400.4 | 15386.1 | 15394.3 | 463.0 |
| 2013-10-13 23:00:00 | YM | Futures | 15395.3 | 15399.4 | 15393.3 | 15398.4 | 134.0 |
| 2013-10-13 23:30:00 | YM | Futures | 15397.3 | 15404.5 | 15396.3 | 15404.5 | 131.0 |
| 2013-10-13 18:00:00 | CL | Futures | 161.18 | 161.45 | 160.92 | 161.26 | 865.0 |
| 2013-10-13 18:30:00 | CL | Futures | 161.24 | 161.37 | 161.23 | 161.24 | 132.0 |
| 2013-10-13 19:00:00 | CL | Futures | 161.24 | 161.39 | 161.23 | 161.34 | 121.0 |
| 2013-10-13 19:30:00 | CL | Futures | 161.32 | 161.37 | 161.29 | 161.29 | 63.0 |
| 2013-10-13 20:00:00 | CL | Futures | 161.31 | 161.46 | 161.29 | 161.43 | 179.0 |
| 2013-10-13 20:30:00 | CL | Futures | 161.43 | 161.54 | 161.43 | 161.5 | 165.0 |
| 2013-10-13 21:00:00 | CL | Futures | 161.5 | 161.78 | 161.48 | 161.73 | 546.0 |
| 2013-10-13 21:30:00 | CL | Futures | 161.77 | 161.97 | 161.73 | 161.78 | 394.0 |
| 2013-10-13 22:00:00 | CL | Futures | 161.78 | 162.13 | 161.78 | 162.1 | 697.0 |
| 2013-10-13 22:30:00 | CL | Futures | 162.07 | 162.08 | 161.85 | 161.89 | 284.0 |
| 2013-10-13 23:00:00 | CL | Futures | 161.89 | 162.02 | 161.88 | 161.97 | 182.0 |
| 2013-10-13 23:30:00 | CL | Futures | 161.97 | 162.02 | 161.94 | 162.01 | 108.0 |
| 2013-10-13 18:00:00 | GC | Futures | 1748.4 | 1753.6 | 1744.0 | 1747.2 | 3372.0 |
| 2013-10-13 18:30:00 | GC | Futures | 1747.0 | 1747.5 | 1745.4 | 1747.0 | 415.0 |
> showing 50 of 485 rows — these rows as CSV