PREVIEW / futures_30min / 2013-07-14
file: by_date/futures_30min/2013/2013-07-14.parquet size: 19 KB rows: 488
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-07-14 18:00:00 | ES | Futures | 1726.75 | 1728.81 | 1726.49 | 1728.04 | 3903.0 |
| 2013-07-14 18:30:00 | ES | Futures | 1728.3 | 1728.3 | 1727.26 | 1728.04 | 985.0 |
| 2013-07-14 19:00:00 | ES | Futures | 1728.04 | 1728.3 | 1727.78 | 1727.78 | 372.0 |
| 2013-07-14 19:30:00 | ES | Futures | 1727.78 | 1728.81 | 1727.78 | 1728.81 | 1542.0 |
| 2013-07-14 20:00:00 | ES | Futures | 1728.81 | 1728.81 | 1727.52 | 1728.55 | 1337.0 |
| 2013-07-14 20:30:00 | ES | Futures | 1728.3 | 1728.81 | 1728.04 | 1728.55 | 887.0 |
| 2013-07-14 21:00:00 | ES | Futures | 1728.3 | 1729.07 | 1728.04 | 1728.3 | 1331.0 |
| 2013-07-14 21:30:00 | ES | Futures | 1728.55 | 1729.59 | 1728.55 | 1729.33 | 1430.0 |
| 2013-07-14 22:00:00 | ES | Futures | 1729.33 | 1731.66 | 1728.55 | 1731.14 | 4814.0 |
| 2013-07-14 22:30:00 | ES | Futures | 1731.4 | 1731.4 | 1730.36 | 1730.88 | 1367.0 |
| 2013-07-14 23:00:00 | ES | Futures | 1730.88 | 1731.66 | 1730.36 | 1731.14 | 1218.0 |
| 2013-07-14 23:30:00 | ES | Futures | 1730.88 | 1731.14 | 1730.88 | 1730.88 | 427.0 |
| 2013-07-14 18:00:00 | NQ | Futures | 3580.18 | 3584.57 | 3580.18 | 3583.4 | 473.0 |
| 2013-07-14 18:30:00 | NQ | Futures | 3583.4 | 3583.98 | 3582.81 | 3583.4 | 101.0 |
| 2013-07-14 19:00:00 | NQ | Futures | 3583.4 | 3584.27 | 3582.23 | 3582.52 | 137.0 |
| 2013-07-14 19:30:00 | NQ | Futures | 3582.52 | 3583.98 | 3582.52 | 3583.98 | 117.0 |
| 2013-07-14 20:00:00 | NQ | Futures | 3583.98 | 3584.86 | 3582.81 | 3583.98 | 115.0 |
| 2013-07-14 20:30:00 | NQ | Futures | 3584.27 | 3584.27 | 3583.4 | 3584.27 | 94.0 |
| 2013-07-14 21:00:00 | NQ | Futures | 3584.27 | 3585.15 | 3583.69 | 3583.98 | 113.0 |
| 2013-07-14 21:30:00 | NQ | Futures | 3584.27 | 3586.61 | 3584.27 | 3586.32 | 334.0 |
| 2013-07-14 22:00:00 | NQ | Futures | 3586.03 | 3591.58 | 3584.86 | 3590.99 | 715.0 |
| 2013-07-14 22:30:00 | NQ | Futures | 3590.7 | 3591.29 | 3589.24 | 3589.83 | 232.0 |
| 2013-07-14 23:00:00 | NQ | Futures | 3589.83 | 3590.7 | 3588.95 | 3590.12 | 165.0 |
| 2013-07-14 23:30:00 | NQ | Futures | 3590.12 | 3590.7 | 3589.53 | 3590.41 | 87.0 |
| 2013-07-14 18:00:00 | YM | Futures | 15608.0 | 15622.2 | 15601.9 | 15620.2 | 309.0 |
| 2013-07-14 18:30:00 | YM | Futures | 15619.1 | 15620.2 | 15615.1 | 15620.2 | 115.0 |
| 2013-07-14 19:00:00 | YM | Futures | 15620.2 | 15620.2 | 15617.1 | 15618.1 | 35.0 |
| 2013-07-14 19:30:00 | YM | Futures | 15618.1 | 15624.2 | 15617.1 | 15624.2 | 127.0 |
| 2013-07-14 20:00:00 | YM | Futures | 15622.2 | 15624.2 | 15615.1 | 15620.2 | 145.0 |
| 2013-07-14 20:30:00 | YM | Futures | 15622.2 | 15623.2 | 15619.1 | 15622.2 | 120.0 |
| 2013-07-14 21:00:00 | YM | Futures | 15622.2 | 15626.3 | 15621.2 | 15622.2 | 161.0 |
| 2013-07-14 21:30:00 | YM | Futures | 15624.2 | 15630.3 | 15624.2 | 15628.3 | 369.0 |
| 2013-07-14 22:00:00 | YM | Futures | 15628.3 | 15649.6 | 15624.2 | 15647.6 | 899.0 |
| 2013-07-14 22:30:00 | YM | Futures | 15646.6 | 15649.6 | 15638.4 | 15643.5 | 252.0 |
| 2013-07-14 23:00:00 | YM | Futures | 15643.5 | 15648.6 | 15639.5 | 15646.6 | 253.0 |
| 2013-07-14 23:30:00 | YM | Futures | 15646.6 | 15647.6 | 15643.5 | 15645.6 | 51.0 |
| 2013-07-14 18:00:00 | CL | Futures | 166.1 | 166.2 | 165.43 | 165.61 | 260.0 |
| 2013-07-14 18:30:00 | CL | Futures | 165.61 | 165.8 | 165.61 | 165.74 | 24.0 |
| 2013-07-14 19:00:00 | CL | Futures | 165.74 | 165.74 | 165.49 | 165.52 | 35.0 |
| 2013-07-14 19:30:00 | CL | Futures | 165.52 | 165.72 | 165.49 | 165.57 | 29.0 |
| 2013-07-14 20:00:00 | CL | Futures | 165.63 | 165.68 | 165.5 | 165.55 | 57.0 |
| 2013-07-14 20:30:00 | CL | Futures | 165.55 | 165.57 | 165.3 | 165.38 | 97.0 |
| 2013-07-14 21:00:00 | CL | Futures | 165.35 | 165.41 | 165.25 | 165.32 | 175.0 |
| 2013-07-14 21:30:00 | CL | Futures | 165.35 | 165.6 | 165.3 | 165.44 | 163.0 |
| 2013-07-14 22:00:00 | CL | Futures | 165.46 | 165.85 | 165.44 | 165.8 | 127.0 |
| 2013-07-14 22:30:00 | CL | Futures | 165.82 | 166.09 | 165.71 | 166.05 | 333.0 |
| 2013-07-14 23:00:00 | CL | Futures | 165.99 | 166.1 | 165.83 | 166.05 | 105.0 |
| 2013-07-14 23:30:00 | CL | Futures | 166.05 | 166.09 | 165.87 | 165.87 | 69.0 |
| 2013-07-14 18:00:00 | GC | Futures | 1760.8 | 1772.8 | 1760.2 | 1772.5 | 2644.0 |
| 2013-07-14 18:30:00 | GC | Futures | 1772.6 | 1774.2 | 1769.6 | 1770.0 | 1083.0 |
> showing 50 of 488 rows — these rows as CSV