PREVIEW / futures_30min / 2014-12-02
file: by_date/futures_30min/2014/2014-12-02.parquet size: 78 KB rows: 2,862
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 |
|---|---|---|---|---|---|---|---|
| 2014-12-02 00:00:00 | ES | Futures | 2151.28 | 2151.8 | 2150.75 | 2151.54 | 1484.0 |
| 2014-12-02 00:30:00 | ES | Futures | 2151.54 | 2152.59 | 2151.01 | 2151.01 | 3977.0 |
| 2014-12-02 01:00:00 | ES | Futures | 2151.01 | 2152.32 | 2150.75 | 2151.8 | 1325.0 |
| 2014-12-02 01:30:00 | ES | Futures | 2152.06 | 2153.63 | 2151.8 | 2153.63 | 5166.0 |
| 2014-12-02 02:00:00 | ES | Futures | 2153.9 | 2155.99 | 2153.63 | 2154.68 | 7824.0 |
| 2014-12-02 02:30:00 | ES | Futures | 2154.94 | 2155.21 | 2153.63 | 2154.16 | 4501.0 |
| 2014-12-02 03:00:00 | ES | Futures | 2154.42 | 2154.42 | 2152.59 | 2152.85 | 11805.0 |
| 2014-12-02 03:30:00 | ES | Futures | 2152.85 | 2157.56 | 2152.85 | 2156.52 | 12653.0 |
| 2014-12-02 04:00:00 | ES | Futures | 2156.25 | 2157.56 | 2155.73 | 2156.52 | 7045.0 |
| 2014-12-02 04:30:00 | ES | Futures | 2156.78 | 2156.78 | 2153.63 | 2154.16 | 7976.0 |
| 2014-12-02 05:00:00 | ES | Futures | 2154.16 | 2154.94 | 2152.59 | 2152.85 | 6451.0 |
| 2014-12-02 05:30:00 | ES | Futures | 2153.11 | 2153.11 | 2149.7 | 2151.28 | 10593.0 |
| 2014-12-02 06:00:00 | ES | Futures | 2151.28 | 2152.85 | 2150.75 | 2151.54 | 8331.0 |
| 2014-12-02 06:30:00 | ES | Futures | 2151.54 | 2153.63 | 2151.28 | 2153.11 | 8567.0 |
| 2014-12-02 07:00:00 | ES | Futures | 2153.11 | 2154.94 | 2152.06 | 2153.63 | 9592.0 |
| 2014-12-02 07:30:00 | ES | Futures | 2153.63 | 2155.99 | 2153.37 | 2154.42 | 14331.0 |
| 2014-12-02 08:00:00 | ES | Futures | 2154.42 | 2154.94 | 2152.32 | 2153.63 | 14652.0 |
| 2014-12-02 08:30:00 | ES | Futures | 2153.63 | 2153.9 | 2151.54 | 2153.37 | 15517.0 |
| 2014-12-02 09:00:00 | ES | Futures | 2153.37 | 2153.63 | 2150.75 | 2151.01 | 14476.0 |
| 2014-12-02 09:30:00 | ES | Futures | 2150.75 | 2157.3 | 2150.75 | 2155.99 | 165427.0 |
| 2014-12-02 10:00:00 | ES | Futures | 2156.25 | 2160.18 | 2155.99 | 2158.61 | 114766.0 |
| 2014-12-02 10:30:00 | ES | Futures | 2158.61 | 2160.97 | 2156.78 | 2160.97 | 86052.0 |
| 2014-12-02 11:00:00 | ES | Futures | 2160.97 | 2162.02 | 2159.66 | 2160.71 | 74972.0 |
| 2014-12-02 11:30:00 | ES | Futures | 2160.44 | 2162.02 | 2159.14 | 2161.49 | 55640.0 |
| 2014-12-02 12:00:00 | ES | Futures | 2161.49 | 2161.75 | 2159.92 | 2160.71 | 38578.0 |
| 2014-12-02 12:30:00 | ES | Futures | 2160.71 | 2160.97 | 2158.61 | 2160.18 | 39778.0 |
| 2014-12-02 13:00:00 | ES | Futures | 2160.44 | 2164.11 | 2159.92 | 2163.33 | 49843.0 |
| 2014-12-02 13:30:00 | ES | Futures | 2163.59 | 2164.11 | 2162.02 | 2162.8 | 43854.0 |
| 2014-12-02 14:00:00 | ES | Futures | 2162.54 | 2163.85 | 2162.02 | 2163.33 | 28495.0 |
| 2014-12-02 14:30:00 | ES | Futures | 2163.33 | 2166.99 | 2162.54 | 2166.47 | 57774.0 |
| 2014-12-02 15:00:00 | ES | Futures | 2166.47 | 2166.73 | 2163.85 | 2164.37 | 37523.0 |
| 2014-12-02 15:30:00 | ES | Futures | 2164.37 | 2165.16 | 2162.8 | 2164.37 | 86351.0 |
| 2014-12-02 16:00:00 | ES | Futures | 2164.37 | 2165.16 | 2163.33 | 2164.9 | 64430.0 |
| 2014-12-02 16:30:00 | ES | Futures | 2165.16 | 2165.68 | 2164.9 | 2165.16 | 6098.0 |
| 2014-12-02 17:00:00 | ES | Futures | 2165.42 | 2165.68 | 2165.16 | 2165.42 | 1347.0 |
| 2014-12-02 18:00:00 | ES | Futures | 2165.42 | 2165.68 | 2164.9 | 2165.42 | 1873.0 |
| 2014-12-02 18:30:00 | ES | Futures | 2165.42 | 2165.95 | 2165.16 | 2165.95 | 2192.0 |
| 2014-12-02 19:00:00 | ES | Futures | 2165.68 | 2166.21 | 2165.42 | 2166.21 | 1301.0 |
| 2014-12-02 19:30:00 | ES | Futures | 2165.95 | 2166.73 | 2165.42 | 2166.73 | 1587.0 |
| 2014-12-02 20:00:00 | ES | Futures | 2166.73 | 2166.73 | 2165.95 | 2166.21 | 1241.0 |
| 2014-12-02 20:30:00 | ES | Futures | 2166.21 | 2166.47 | 2165.68 | 2165.95 | 1097.0 |
| 2014-12-02 21:00:00 | ES | Futures | 2165.95 | 2166.47 | 2165.95 | 2166.21 | 780.0 |
| 2014-12-02 21:30:00 | ES | Futures | 2165.95 | 2166.21 | 2165.95 | 2165.95 | 534.0 |
| 2014-12-02 22:00:00 | ES | Futures | 2166.21 | 2166.21 | 2165.42 | 2165.95 | 806.0 |
| 2014-12-02 22:30:00 | ES | Futures | 2165.95 | 2165.95 | 2164.9 | 2165.16 | 2590.0 |
| 2014-12-02 23:00:00 | ES | Futures | 2165.16 | 2166.21 | 2164.64 | 2164.9 | 2895.0 |
| 2014-12-02 23:30:00 | ES | Futures | 2165.16 | 2165.42 | 2164.64 | 2164.9 | 1692.0 |
| 2014-12-02 00:00:00 | NQ | Futures | 5029.44 | 5029.74 | 5026.22 | 5029.15 | 817.0 |
| 2014-12-02 00:30:00 | NQ | Futures | 5029.74 | 5032.67 | 5028.27 | 5029.15 | 571.0 |
| 2014-12-02 01:00:00 | NQ | Futures | 5028.86 | 5032.08 | 5028.27 | 5031.2 | 260.0 |
> showing 50 of 2,862 rows — these rows as CSV