PREVIEW / futures_30min / 2013-08-11
file: by_date/futures_30min/2013/2013-08-11.parquet size: 19 KB rows: 493
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-08-11 18:00:00 | ES | Futures | 1742.26 | 1742.77 | 1740.7 | 1740.7 | 4736.0 |
| 2013-08-11 18:30:00 | ES | Futures | 1741.22 | 1741.22 | 1739.67 | 1740.19 | 3343.0 |
| 2013-08-11 19:00:00 | ES | Futures | 1740.19 | 1741.48 | 1739.93 | 1740.7 | 1562.0 |
| 2013-08-11 19:30:00 | ES | Futures | 1740.7 | 1741.22 | 1740.19 | 1740.7 | 1711.0 |
| 2013-08-11 20:00:00 | ES | Futures | 1740.45 | 1741.74 | 1740.19 | 1741.48 | 3629.0 |
| 2013-08-11 20:30:00 | ES | Futures | 1741.48 | 1741.74 | 1740.7 | 1740.96 | 2268.0 |
| 2013-08-11 21:00:00 | ES | Futures | 1740.96 | 1741.22 | 1740.19 | 1740.7 | 2733.0 |
| 2013-08-11 21:30:00 | ES | Futures | 1740.7 | 1741.74 | 1739.93 | 1741.74 | 2850.0 |
| 2013-08-11 22:00:00 | ES | Futures | 1741.74 | 1742.77 | 1741.48 | 1742.51 | 4308.0 |
| 2013-08-11 22:30:00 | ES | Futures | 1742.26 | 1742.77 | 1742.0 | 1742.26 | 1740.0 |
| 2013-08-11 23:00:00 | ES | Futures | 1742.51 | 1742.77 | 1741.74 | 1742.26 | 1799.0 |
| 2013-08-11 23:30:00 | ES | Futures | 1742.0 | 1742.77 | 1741.74 | 1742.26 | 982.0 |
| 2013-08-11 18:00:00 | NQ | Futures | 3639.51 | 3640.38 | 3634.54 | 3636.29 | 744.0 |
| 2013-08-11 18:30:00 | NQ | Futures | 3636.0 | 3636.29 | 3634.25 | 3634.25 | 479.0 |
| 2013-08-11 19:00:00 | NQ | Futures | 3634.54 | 3637.46 | 3634.54 | 3636.0 | 96.0 |
| 2013-08-11 19:30:00 | NQ | Futures | 3636.29 | 3637.46 | 3635.71 | 3636.0 | 345.0 |
| 2013-08-11 20:00:00 | NQ | Futures | 3636.29 | 3639.51 | 3635.41 | 3638.92 | 951.0 |
| 2013-08-11 20:30:00 | NQ | Futures | 3638.92 | 3639.21 | 3637.46 | 3638.04 | 503.0 |
| 2013-08-11 21:00:00 | NQ | Futures | 3638.34 | 3638.63 | 3636.29 | 3637.17 | 496.0 |
| 2013-08-11 21:30:00 | NQ | Futures | 3636.88 | 3640.09 | 3636.0 | 3640.09 | 428.0 |
| 2013-08-11 22:00:00 | NQ | Futures | 3640.09 | 3641.84 | 3639.51 | 3640.67 | 716.0 |
| 2013-08-11 22:30:00 | NQ | Futures | 3640.67 | 3641.55 | 3639.8 | 3641.55 | 222.0 |
| 2013-08-11 23:00:00 | NQ | Futures | 3641.26 | 3641.55 | 3639.8 | 3640.38 | 296.0 |
| 2013-08-11 23:30:00 | NQ | Futures | 3640.38 | 3641.26 | 3639.51 | 3640.67 | 158.0 |
| 2013-08-11 18:00:00 | YM | Futures | 15614.1 | 15614.1 | 15592.7 | 15596.8 | 490.0 |
| 2013-08-11 18:30:00 | YM | Futures | 15597.8 | 15598.8 | 15589.7 | 15589.7 | 268.0 |
| 2013-08-11 19:00:00 | YM | Futures | 15589.7 | 15599.8 | 15589.7 | 15597.8 | 125.0 |
| 2013-08-11 19:30:00 | YM | Futures | 15596.8 | 15600.9 | 15591.7 | 15592.7 | 195.0 |
| 2013-08-11 20:00:00 | YM | Futures | 15592.7 | 15601.9 | 15590.7 | 15600.9 | 498.0 |
| 2013-08-11 20:30:00 | YM | Futures | 15599.8 | 15600.9 | 15592.7 | 15593.8 | 586.0 |
| 2013-08-11 21:00:00 | YM | Futures | 15594.8 | 15596.8 | 15588.7 | 15591.7 | 388.0 |
| 2013-08-11 21:30:00 | YM | Futures | 15591.7 | 15603.9 | 15588.7 | 15603.9 | 555.0 |
| 2013-08-11 22:00:00 | YM | Futures | 15603.9 | 15611.0 | 15601.9 | 15607.0 | 591.0 |
| 2013-08-11 22:30:00 | YM | Futures | 15608.0 | 15613.1 | 15604.9 | 15611.0 | 328.0 |
| 2013-08-11 23:00:00 | YM | Futures | 15611.0 | 15611.0 | 15602.9 | 15605.9 | 258.0 |
| 2013-08-11 23:30:00 | YM | Futures | 15607.0 | 15609.0 | 15601.9 | 15604.9 | 381.0 |
| 2013-08-11 18:00:00 | CL | Futures | 166.37 | 166.68 | 166.32 | 166.59 | 951.0 |
| 2013-08-11 18:30:00 | CL | Futures | 166.57 | 166.59 | 166.46 | 166.57 | 257.0 |
| 2013-08-11 19:00:00 | CL | Futures | 166.57 | 166.57 | 166.29 | 166.35 | 393.0 |
| 2013-08-11 19:30:00 | CL | Futures | 166.34 | 166.39 | 166.23 | 166.35 | 359.0 |
| 2013-08-11 20:00:00 | CL | Futures | 166.37 | 166.37 | 166.26 | 166.31 | 347.0 |
| 2013-08-11 20:30:00 | CL | Futures | 166.31 | 166.37 | 166.28 | 166.29 | 286.0 |
| 2013-08-11 21:00:00 | CL | Futures | 166.29 | 166.29 | 166.09 | 166.12 | 586.0 |
| 2013-08-11 21:30:00 | CL | Futures | 166.12 | 166.54 | 166.09 | 166.43 | 437.0 |
| 2013-08-11 22:00:00 | CL | Futures | 166.46 | 166.54 | 166.42 | 166.45 | 430.0 |
| 2013-08-11 22:30:00 | CL | Futures | 166.46 | 166.83 | 166.43 | 166.75 | 981.0 |
| 2013-08-11 23:00:00 | CL | Futures | 166.76 | 166.98 | 166.7 | 166.95 | 522.0 |
| 2013-08-11 23:30:00 | CL | Futures | 166.95 | 167.25 | 166.89 | 167.08 | 1168.0 |
| 2013-08-11 18:00:00 | GC | Futures | 1800.5 | 1808.3 | 1800.5 | 1807.6 | 1862.0 |
| 2013-08-11 18:30:00 | GC | Futures | 1807.4 | 1827.2 | 1807.4 | 1821.2 | 5404.0 |
> showing 50 of 493 rows — these rows as CSV