PREVIEW / futures_30min / 2013-12-29
file: by_date/futures_30min/2013/2013-12-29.parquet size: 18 KB rows: 478
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-12-29 18:00:00 | ES | Futures | 1899.55 | 1900.07 | 1898.52 | 1899.81 | 2010.0 |
| 2013-12-29 18:30:00 | ES | Futures | 1900.07 | 1900.33 | 1899.55 | 1899.81 | 830.0 |
| 2013-12-29 19:00:00 | ES | Futures | 1900.07 | 1900.07 | 1899.03 | 1899.03 | 833.0 |
| 2013-12-29 19:30:00 | ES | Futures | 1899.03 | 1899.29 | 1898.77 | 1898.77 | 1016.0 |
| 2013-12-29 20:00:00 | ES | Futures | 1899.03 | 1899.55 | 1898.77 | 1899.29 | 768.0 |
| 2013-12-29 20:30:00 | ES | Futures | 1899.29 | 1899.55 | 1899.03 | 1899.03 | 960.0 |
| 2013-12-29 21:00:00 | ES | Futures | 1899.03 | 1899.29 | 1898.52 | 1899.29 | 797.0 |
| 2013-12-29 21:30:00 | ES | Futures | 1899.03 | 1899.29 | 1898.77 | 1899.29 | 322.0 |
| 2013-12-29 22:00:00 | ES | Futures | 1899.03 | 1899.55 | 1899.03 | 1899.29 | 457.0 |
| 2013-12-29 22:30:00 | ES | Futures | 1899.29 | 1899.55 | 1899.03 | 1899.55 | 320.0 |
| 2013-12-29 23:00:00 | ES | Futures | 1899.55 | 1899.55 | 1899.29 | 1899.55 | 309.0 |
| 2013-12-29 23:30:00 | ES | Futures | 1899.55 | 1899.81 | 1899.29 | 1899.55 | 523.0 |
| 2013-12-29 18:00:00 | NQ | Futures | 4150.69 | 4152.43 | 4148.65 | 4151.27 | 252.0 |
| 2013-12-29 18:30:00 | NQ | Futures | 4151.27 | 4152.14 | 4150.98 | 4151.27 | 85.0 |
| 2013-12-29 19:00:00 | NQ | Futures | 4151.27 | 4151.56 | 4150.4 | 4150.98 | 75.0 |
| 2013-12-29 19:30:00 | NQ | Futures | 4150.98 | 4151.27 | 4149.82 | 4150.69 | 121.0 |
| 2013-12-29 20:00:00 | NQ | Futures | 4150.69 | 4150.98 | 4149.82 | 4150.11 | 146.0 |
| 2013-12-29 20:30:00 | NQ | Futures | 4150.69 | 4152.14 | 4150.11 | 4151.85 | 208.0 |
| 2013-12-29 21:00:00 | NQ | Futures | 4151.56 | 4152.43 | 4150.98 | 4152.14 | 182.0 |
| 2013-12-29 21:30:00 | NQ | Futures | 4152.43 | 4152.43 | 4151.56 | 4152.43 | 23.0 |
| 2013-12-29 22:00:00 | NQ | Futures | 4152.14 | 4153.3 | 4152.14 | 4153.01 | 116.0 |
| 2013-12-29 22:30:00 | NQ | Futures | 4153.3 | 4153.59 | 4151.56 | 4153.01 | 160.0 |
| 2013-12-29 23:00:00 | NQ | Futures | 4153.01 | 4153.3 | 4152.43 | 4153.01 | 45.0 |
| 2013-12-29 23:30:00 | NQ | Futures | 4153.01 | 4153.59 | 4152.43 | 4153.3 | 89.0 |
| 2013-12-29 18:00:00 | YM | Futures | 16834.0 | 16837.1 | 16822.8 | 16837.1 | 212.0 |
| 2013-12-29 18:30:00 | YM | Futures | 16837.1 | 16838.1 | 16834.0 | 16836.1 | 81.0 |
| 2013-12-29 19:00:00 | YM | Futures | 16837.1 | 16837.1 | 16831.0 | 16832.0 | 138.0 |
| 2013-12-29 19:30:00 | YM | Futures | 16832.0 | 16834.0 | 16828.9 | 16829.9 | 111.0 |
| 2013-12-29 20:00:00 | YM | Futures | 16831.0 | 16837.1 | 16829.9 | 16834.0 | 140.0 |
| 2013-12-29 20:30:00 | YM | Futures | 16835.1 | 16836.1 | 16833.0 | 16835.1 | 121.0 |
| 2013-12-29 21:00:00 | YM | Futures | 16834.0 | 16836.1 | 16832.0 | 16834.0 | 135.0 |
| 2013-12-29 21:30:00 | YM | Futures | 16833.0 | 16835.1 | 16833.0 | 16835.1 | 71.0 |
| 2013-12-29 22:00:00 | YM | Futures | 16834.0 | 16836.1 | 16834.0 | 16834.0 | 81.0 |
| 2013-12-29 22:30:00 | YM | Futures | 16833.0 | 16836.1 | 16829.9 | 16833.0 | 160.0 |
| 2013-12-29 23:00:00 | YM | Futures | 16833.0 | 16834.0 | 16832.0 | 16833.0 | 68.0 |
| 2013-12-29 23:30:00 | YM | Futures | 16833.0 | 16836.1 | 16832.0 | 16834.0 | 72.0 |
| 2013-12-29 18:00:00 | CL | Futures | 157.71 | 157.83 | 157.68 | 157.8 | 244.0 |
| 2013-12-29 18:30:00 | CL | Futures | 157.8 | 157.86 | 157.8 | 157.85 | 163.0 |
| 2013-12-29 19:00:00 | CL | Futures | 157.86 | 157.97 | 157.83 | 157.93 | 239.0 |
| 2013-12-29 19:30:00 | CL | Futures | 157.91 | 157.93 | 157.75 | 157.85 | 341.0 |
| 2013-12-29 20:00:00 | CL | Futures | 157.86 | 157.94 | 157.8 | 157.91 | 180.0 |
| 2013-12-29 20:30:00 | CL | Futures | 157.93 | 157.96 | 157.85 | 157.88 | 241.0 |
| 2013-12-29 21:00:00 | CL | Futures | 157.88 | 157.91 | 157.85 | 157.85 | 148.0 |
| 2013-12-29 21:30:00 | CL | Futures | 157.85 | 157.86 | 157.79 | 157.8 | 172.0 |
| 2013-12-29 22:00:00 | CL | Futures | 157.82 | 157.88 | 157.8 | 157.8 | 101.0 |
| 2013-12-29 22:30:00 | CL | Futures | 157.8 | 157.82 | 157.69 | 157.71 | 141.0 |
| 2013-12-29 23:00:00 | CL | Futures | 157.71 | 157.91 | 157.69 | 157.9 | 202.0 |
| 2013-12-29 23:30:00 | CL | Futures | 157.91 | 158.08 | 157.91 | 158.08 | 208.0 |
| 2013-12-29 18:00:00 | GC | Futures | 1663.8 | 1666.6 | 1663.0 | 1666.3 | 683.0 |
| 2013-12-29 18:30:00 | GC | Futures | 1666.0 | 1666.2 | 1662.5 | 1662.5 | 422.0 |
> showing 50 of 478 rows — these rows as CSV