PREVIEW / futures_30min / 2013-09-22
file: by_date/futures_30min/2013/2013-09-22.parquet size: 19 KB rows: 472
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-09-22 18:00:00 | ES | Futures | 1760.84 | 1761.1 | 1756.71 | 1756.97 | 11239.0 |
| 2013-09-22 18:30:00 | ES | Futures | 1756.71 | 1758.52 | 1755.94 | 1758.52 | 2588.0 |
| 2013-09-22 19:00:00 | ES | Futures | 1758.52 | 1758.77 | 1757.74 | 1758.0 | 474.0 |
| 2013-09-22 19:30:00 | ES | Futures | 1757.74 | 1758.0 | 1755.68 | 1756.19 | 2598.0 |
| 2013-09-22 20:00:00 | ES | Futures | 1755.94 | 1756.97 | 1755.16 | 1756.45 | 2995.0 |
| 2013-09-22 20:30:00 | ES | Futures | 1756.45 | 1756.71 | 1755.42 | 1755.94 | 1683.0 |
| 2013-09-22 21:00:00 | ES | Futures | 1755.68 | 1756.19 | 1755.42 | 1756.19 | 2577.0 |
| 2013-09-22 21:30:00 | ES | Futures | 1756.19 | 1757.48 | 1755.94 | 1757.48 | 3863.0 |
| 2013-09-22 22:00:00 | ES | Futures | 1757.48 | 1758.77 | 1757.48 | 1758.52 | 1947.0 |
| 2013-09-22 22:30:00 | ES | Futures | 1758.52 | 1758.77 | 1758.26 | 1758.52 | 1522.0 |
| 2013-09-22 23:00:00 | ES | Futures | 1758.26 | 1759.55 | 1758.26 | 1759.55 | 1308.0 |
| 2013-09-22 23:30:00 | ES | Futures | 1759.29 | 1759.55 | 1758.52 | 1758.77 | 672.0 |
| 2013-09-22 18:00:00 | NQ | Futures | 3743.97 | 3746.87 | 3737.58 | 3737.58 | 895.0 |
| 2013-09-22 18:30:00 | NQ | Futures | 3737.58 | 3741.64 | 3736.12 | 3740.77 | 410.0 |
| 2013-09-22 19:00:00 | NQ | Futures | 3741.06 | 3741.64 | 3739.9 | 3739.9 | 58.0 |
| 2013-09-22 19:30:00 | NQ | Futures | 3740.19 | 3740.77 | 3736.12 | 3737.58 | 310.0 |
| 2013-09-22 20:00:00 | NQ | Futures | 3737.0 | 3739.9 | 3735.83 | 3738.16 | 398.0 |
| 2013-09-22 20:30:00 | NQ | Futures | 3737.58 | 3739.32 | 3736.41 | 3737.0 | 211.0 |
| 2013-09-22 21:00:00 | NQ | Futures | 3736.7 | 3739.32 | 3736.41 | 3739.03 | 454.0 |
| 2013-09-22 21:30:00 | NQ | Futures | 3738.74 | 3742.51 | 3738.45 | 3741.93 | 514.0 |
| 2013-09-22 22:00:00 | NQ | Futures | 3741.93 | 3744.26 | 3741.93 | 3743.68 | 315.0 |
| 2013-09-22 22:30:00 | NQ | Futures | 3743.97 | 3744.26 | 3742.51 | 3742.8 | 161.0 |
| 2013-09-22 23:00:00 | NQ | Futures | 3743.09 | 3745.13 | 3742.8 | 3745.13 | 170.0 |
| 2013-09-22 23:30:00 | NQ | Futures | 3745.13 | 3745.13 | 3743.09 | 3743.09 | 157.0 |
| 2013-09-22 18:00:00 | YM | Futures | 15757.8 | 15770.1 | 15735.4 | 15737.4 | 1579.0 |
| 2013-09-22 18:30:00 | YM | Futures | 15738.4 | 15750.7 | 15729.2 | 15749.7 | 358.0 |
| 2013-09-22 19:00:00 | YM | Futures | 15749.7 | 15752.7 | 15744.6 | 15745.6 | 114.0 |
| 2013-09-22 19:30:00 | YM | Futures | 15744.6 | 15745.6 | 15730.3 | 15732.3 | 301.0 |
| 2013-09-22 20:00:00 | YM | Futures | 15732.3 | 15739.5 | 15728.2 | 15734.4 | 453.0 |
| 2013-09-22 20:30:00 | YM | Futures | 15735.4 | 15736.4 | 15727.2 | 15730.3 | 420.0 |
| 2013-09-22 21:00:00 | YM | Futures | 15731.3 | 15735.4 | 15729.2 | 15733.3 | 318.0 |
| 2013-09-22 21:30:00 | YM | Futures | 15733.3 | 15748.7 | 15733.3 | 15746.6 | 893.0 |
| 2013-09-22 22:00:00 | YM | Futures | 15746.6 | 15757.8 | 15746.6 | 15754.8 | 301.0 |
| 2013-09-22 22:30:00 | YM | Futures | 15754.8 | 15755.8 | 15751.7 | 15752.7 | 170.0 |
| 2013-09-22 23:00:00 | YM | Futures | 15753.8 | 15761.9 | 15752.7 | 15761.9 | 132.0 |
| 2013-09-22 23:30:00 | YM | Futures | 15759.9 | 15759.9 | 15754.8 | 15754.8 | 98.0 |
| 2013-09-22 18:00:00 | CL | Futures | 166.78 | 166.78 | 166.19 | 166.25 | 748.0 |
| 2013-09-22 18:30:00 | CL | Futures | 166.28 | 166.28 | 166.03 | 166.19 | 855.0 |
| 2013-09-22 19:00:00 | CL | Futures | 166.2 | 166.36 | 166.2 | 166.28 | 257.0 |
| 2013-09-22 19:30:00 | CL | Futures | 166.28 | 166.3 | 166.16 | 166.2 | 111.0 |
| 2013-09-22 20:00:00 | CL | Futures | 166.19 | 166.52 | 166.19 | 166.46 | 344.0 |
| 2013-09-22 20:30:00 | CL | Futures | 166.44 | 166.47 | 166.23 | 166.27 | 311.0 |
| 2013-09-22 21:00:00 | CL | Futures | 166.27 | 166.44 | 166.25 | 166.31 | 457.0 |
| 2013-09-22 21:30:00 | CL | Futures | 166.33 | 166.7 | 166.28 | 166.54 | 922.0 |
| 2013-09-22 22:00:00 | CL | Futures | 166.54 | 166.65 | 166.44 | 166.54 | 432.0 |
| 2013-09-22 22:30:00 | CL | Futures | 166.52 | 166.52 | 166.36 | 166.38 | 260.0 |
| 2013-09-22 23:00:00 | CL | Futures | 166.38 | 166.58 | 166.38 | 166.57 | 319.0 |
| 2013-09-22 23:30:00 | CL | Futures | 166.58 | 166.58 | 166.47 | 166.57 | 194.0 |
| 2013-09-22 18:00:00 | GC | Futures | 1819.0 | 1821.6 | 1816.3 | 1817.4 | 2932.0 |
| 2013-09-22 18:30:00 | GC | Futures | 1817.4 | 1818.3 | 1814.3 | 1817.6 | 1348.0 |
> showing 50 of 472 rows — these rows as CSV