PREVIEW / futures_30min / 2014-09-28
file: by_date/futures_30min/2014/2014-09-28.parquet size: 20 KB rows: 533
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-09-28 18:00:00 | ES | Futures | 2069.28 | 2069.8 | 2066.92 | 2067.18 | 4041.0 |
| 2014-09-28 18:30:00 | ES | Futures | 2067.18 | 2068.76 | 2067.18 | 2067.97 | 1427.0 |
| 2014-09-28 19:00:00 | ES | Futures | 2068.23 | 2068.23 | 2066.4 | 2066.92 | 1970.0 |
| 2014-09-28 19:30:00 | ES | Futures | 2066.92 | 2067.71 | 2065.87 | 2066.14 | 2393.0 |
| 2014-09-28 20:00:00 | ES | Futures | 2066.4 | 2067.97 | 2066.14 | 2067.71 | 2793.0 |
| 2014-09-28 20:30:00 | ES | Futures | 2067.45 | 2068.49 | 2066.92 | 2067.97 | 2933.0 |
| 2014-09-28 21:00:00 | ES | Futures | 2067.97 | 2069.28 | 2067.45 | 2069.02 | 2352.0 |
| 2014-09-28 21:30:00 | ES | Futures | 2069.02 | 2071.64 | 2068.49 | 2070.33 | 5345.0 |
| 2014-09-28 22:00:00 | ES | Futures | 2070.33 | 2070.33 | 2065.09 | 2066.14 | 7174.0 |
| 2014-09-28 22:30:00 | ES | Futures | 2066.14 | 2066.92 | 2065.61 | 2066.14 | 1242.0 |
| 2014-09-28 23:00:00 | ES | Futures | 2066.14 | 2066.92 | 2066.14 | 2066.4 | 875.0 |
| 2014-09-28 23:30:00 | ES | Futures | 2066.4 | 2066.4 | 2064.56 | 2064.83 | 3855.0 |
| 2014-09-28 18:00:00 | NQ | Futures | 4741.71 | 4742.0 | 4734.68 | 4734.97 | 776.0 |
| 2014-09-28 18:30:00 | NQ | Futures | 4734.68 | 4738.78 | 4734.09 | 4736.44 | 179.0 |
| 2014-09-28 19:00:00 | NQ | Futures | 4736.73 | 4737.02 | 4734.09 | 4734.09 | 155.0 |
| 2014-09-28 19:30:00 | NQ | Futures | 4734.39 | 4736.14 | 4732.92 | 4733.21 | 364.0 |
| 2014-09-28 20:00:00 | NQ | Futures | 4733.8 | 4737.32 | 4733.8 | 4736.14 | 290.0 |
| 2014-09-28 20:30:00 | NQ | Futures | 4735.85 | 4738.2 | 4734.09 | 4736.73 | 394.0 |
| 2014-09-28 21:00:00 | NQ | Futures | 4736.44 | 4740.54 | 4735.85 | 4740.54 | 385.0 |
| 2014-09-28 21:30:00 | NQ | Futures | 4740.25 | 4748.16 | 4738.49 | 4743.76 | 983.0 |
| 2014-09-28 22:00:00 | NQ | Futures | 4743.76 | 4743.76 | 4732.04 | 4734.39 | 1178.0 |
| 2014-09-28 22:30:00 | NQ | Futures | 4734.39 | 4735.56 | 4732.34 | 4734.09 | 280.0 |
| 2014-09-28 23:00:00 | NQ | Futures | 4734.09 | 4735.85 | 4733.21 | 4734.09 | 122.0 |
| 2014-09-28 23:30:00 | NQ | Futures | 4734.09 | 4734.09 | 4729.99 | 4730.28 | 810.0 |
| 2014-09-28 18:00:00 | YM | Futures | 17716.5 | 17716.5 | 17686.4 | 17687.4 | 515.0 |
| 2014-09-28 18:30:00 | YM | Futures | 17689.5 | 17698.8 | 17687.4 | 17692.6 | 188.0 |
| 2014-09-28 19:00:00 | YM | Futures | 17693.7 | 17693.7 | 17683.3 | 17685.3 | 124.0 |
| 2014-09-28 19:30:00 | YM | Futures | 17685.3 | 17691.6 | 17680.1 | 17680.1 | 268.0 |
| 2014-09-28 20:00:00 | YM | Futures | 17680.1 | 17690.5 | 17679.1 | 17687.4 | 382.0 |
| 2014-09-28 20:30:00 | YM | Futures | 17686.4 | 17694.7 | 17682.2 | 17684.3 | 830.0 |
| 2014-09-28 21:00:00 | YM | Futures | 17685.3 | 17695.7 | 17682.2 | 17692.6 | 537.0 |
| 2014-09-28 21:30:00 | YM | Futures | 17693.7 | 17713.4 | 17689.5 | 17703.0 | 1167.0 |
| 2014-09-28 22:00:00 | YM | Futures | 17703.0 | 17703.0 | 17660.4 | 17665.6 | 1499.0 |
| 2014-09-28 22:30:00 | YM | Futures | 17665.6 | 17671.8 | 17663.5 | 17669.7 | 234.0 |
| 2014-09-28 23:00:00 | YM | Futures | 17668.7 | 17672.9 | 17666.6 | 17667.7 | 170.0 |
| 2014-09-28 23:30:00 | YM | Futures | 17668.7 | 17668.7 | 17655.2 | 17657.3 | 282.0 |
| 2014-09-28 18:00:00 | CL | Futures | 155.51 | 155.63 | 154.86 | 155.01 | 1244.0 |
| 2014-09-28 18:30:00 | CL | Futures | 155.01 | 155.09 | 154.93 | 155.04 | 304.0 |
| 2014-09-28 19:00:00 | CL | Futures | 155.03 | 155.04 | 154.89 | 154.94 | 324.0 |
| 2014-09-28 19:30:00 | CL | Futures | 154.94 | 155.01 | 154.79 | 154.86 | 518.0 |
| 2014-09-28 20:00:00 | CL | Futures | 154.86 | 154.98 | 154.84 | 154.94 | 600.0 |
| 2014-09-28 20:30:00 | CL | Futures | 154.93 | 154.99 | 154.81 | 154.89 | 557.0 |
| 2014-09-28 21:00:00 | CL | Futures | 154.88 | 154.96 | 154.84 | 154.89 | 266.0 |
| 2014-09-28 21:30:00 | CL | Futures | 154.88 | 155.06 | 154.78 | 154.94 | 793.0 |
| 2014-09-28 22:00:00 | CL | Futures | 154.94 | 154.99 | 154.78 | 154.91 | 676.0 |
| 2014-09-28 22:30:00 | CL | Futures | 154.89 | 154.89 | 154.79 | 154.83 | 249.0 |
| 2014-09-28 23:00:00 | CL | Futures | 154.81 | 154.96 | 154.81 | 154.89 | 335.0 |
| 2014-09-28 23:30:00 | CL | Futures | 154.88 | 154.88 | 154.81 | 154.86 | 149.0 |
| 2014-09-28 18:00:00 | GC | Futures | 1668.9 | 1669.7 | 1665.1 | 1667.5 | 894.0 |
| 2014-09-28 18:30:00 | GC | Futures | 1667.7 | 1668.6 | 1666.0 | 1666.7 | 357.0 |
> showing 50 of 533 rows — these rows as CSV