PREVIEW / futures_30min / 2012-10-21
file: by_date/futures_30min/2012/2012-10-21.parquet size: 20 KB rows: 516
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-21 18:00:00 | ES | Futures | 1455.63 | 1457.16 | 1454.61 | 1455.12 | 7992.0 |
| 2012-10-21 18:30:00 | ES | Futures | 1455.38 | 1456.4 | 1455.12 | 1455.38 | 1826.0 |
| 2012-10-21 19:00:00 | ES | Futures | 1455.12 | 1455.63 | 1452.31 | 1452.31 | 5476.0 |
| 2012-10-21 19:30:00 | ES | Futures | 1452.31 | 1453.84 | 1451.8 | 1453.59 | 4912.0 |
| 2012-10-21 20:00:00 | ES | Futures | 1453.84 | 1456.4 | 1453.84 | 1456.14 | 5558.0 |
| 2012-10-21 20:30:00 | ES | Futures | 1455.89 | 1456.91 | 1455.89 | 1456.4 | 3938.0 |
| 2012-10-21 21:00:00 | ES | Futures | 1456.4 | 1457.16 | 1456.14 | 1456.65 | 4759.0 |
| 2012-10-21 21:30:00 | ES | Futures | 1456.65 | 1457.16 | 1455.63 | 1456.65 | 3274.0 |
| 2012-10-21 22:00:00 | ES | Futures | 1456.65 | 1456.65 | 1455.38 | 1455.38 | 1172.0 |
| 2012-10-21 22:30:00 | ES | Futures | 1455.38 | 1456.91 | 1455.38 | 1456.65 | 1407.0 |
| 2012-10-21 23:00:00 | ES | Futures | 1456.4 | 1457.68 | 1456.14 | 1456.4 | 3727.0 |
| 2012-10-21 23:30:00 | ES | Futures | 1456.4 | 1457.16 | 1455.63 | 1455.89 | 4756.0 |
| 2012-10-21 18:00:00 | NQ | Futures | 3096.96 | 3101.32 | 3095.51 | 3096.67 | 888.0 |
| 2012-10-21 18:30:00 | NQ | Futures | 3097.25 | 3099.0 | 3096.67 | 3097.83 | 212.0 |
| 2012-10-21 19:00:00 | NQ | Futures | 3097.54 | 3098.71 | 3089.7 | 3090.57 | 670.0 |
| 2012-10-21 19:30:00 | NQ | Futures | 3089.7 | 3093.48 | 3088.83 | 3093.19 | 406.0 |
| 2012-10-21 20:00:00 | NQ | Futures | 3093.48 | 3100.45 | 3093.19 | 3099.58 | 663.0 |
| 2012-10-21 20:30:00 | NQ | Futures | 3099.58 | 3101.32 | 3099.29 | 3101.32 | 440.0 |
| 2012-10-21 21:00:00 | NQ | Futures | 3101.32 | 3104.52 | 3101.03 | 3103.94 | 892.0 |
| 2012-10-21 21:30:00 | NQ | Futures | 3103.65 | 3104.52 | 3101.32 | 3103.07 | 619.0 |
| 2012-10-21 22:00:00 | NQ | Futures | 3103.07 | 3103.36 | 3101.32 | 3101.32 | 212.0 |
| 2012-10-21 22:30:00 | NQ | Futures | 3101.32 | 3105.39 | 3101.32 | 3104.81 | 710.0 |
| 2012-10-21 23:00:00 | NQ | Futures | 3105.1 | 3107.71 | 3104.52 | 3105.39 | 969.0 |
| 2012-10-21 23:30:00 | NQ | Futures | 3105.1 | 3106.55 | 3103.36 | 3103.36 | 440.0 |
| 2012-10-21 18:00:00 | YM | Futures | 13257.8 | 13276.8 | 13256.8 | 13264.8 | 657.0 |
| 2012-10-21 18:30:00 | YM | Futures | 13264.8 | 13271.8 | 13263.8 | 13263.8 | 166.0 |
| 2012-10-21 19:00:00 | YM | Futures | 13262.8 | 13266.8 | 13239.8 | 13239.8 | 339.0 |
| 2012-10-21 19:30:00 | YM | Futures | 13240.8 | 13253.8 | 13238.8 | 13253.8 | 457.0 |
| 2012-10-21 20:00:00 | YM | Futures | 13253.8 | 13271.8 | 13253.8 | 13269.8 | 613.0 |
| 2012-10-21 20:30:00 | YM | Futures | 13268.8 | 13274.8 | 13267.8 | 13270.8 | 537.0 |
| 2012-10-21 21:00:00 | YM | Futures | 13269.8 | 13278.8 | 13269.8 | 13274.8 | 493.0 |
| 2012-10-21 21:30:00 | YM | Futures | 13273.8 | 13276.8 | 13266.8 | 13271.8 | 415.0 |
| 2012-10-21 22:00:00 | YM | Futures | 13272.8 | 13272.8 | 13264.8 | 13265.8 | 170.0 |
| 2012-10-21 22:30:00 | YM | Futures | 13264.8 | 13275.8 | 13264.8 | 13274.8 | 147.0 |
| 2012-10-21 23:00:00 | YM | Futures | 13273.8 | 13280.8 | 13271.8 | 13273.8 | 275.0 |
| 2012-10-21 23:30:00 | YM | Futures | 13272.8 | 13277.8 | 13266.8 | 13268.8 | 439.0 |
| 2012-10-21 18:00:00 | CL | Futures | 146.33 | 146.85 | 146.13 | 146.13 | 1581.0 |
| 2012-10-21 18:30:00 | CL | Futures | 146.15 | 146.49 | 146.02 | 146.13 | 664.0 |
| 2012-10-21 19:00:00 | CL | Futures | 146.12 | 146.26 | 146.0 | 146.08 | 330.0 |
| 2012-10-21 19:30:00 | CL | Futures | 146.08 | 146.15 | 146.0 | 146.12 | 160.0 |
| 2012-10-21 20:00:00 | CL | Futures | 146.08 | 146.51 | 146.08 | 146.47 | 611.0 |
| 2012-10-21 20:30:00 | CL | Futures | 146.47 | 146.72 | 146.47 | 146.68 | 488.0 |
| 2012-10-21 21:00:00 | CL | Futures | 146.72 | 146.99 | 146.67 | 146.88 | 765.0 |
| 2012-10-21 21:30:00 | CL | Futures | 146.86 | 147.03 | 146.77 | 146.93 | 619.0 |
| 2012-10-21 22:00:00 | CL | Futures | 146.94 | 146.96 | 146.77 | 146.77 | 319.0 |
| 2012-10-21 22:30:00 | CL | Futures | 146.78 | 147.27 | 146.78 | 147.14 | 774.0 |
| 2012-10-21 23:00:00 | CL | Futures | 147.12 | 147.48 | 147.12 | 147.33 | 743.0 |
| 2012-10-21 23:30:00 | CL | Futures | 147.32 | 147.42 | 147.2 | 147.27 | 324.0 |
| 2012-10-21 18:00:00 | GC | Futures | 2376.5 | 2376.5 | 2365.1 | 2367.0 | 2775.0 |
| 2012-10-21 18:30:00 | GC | Futures | 2367.0 | 2370.3 | 2366.2 | 2366.9 | 920.0 |
> showing 50 of 516 rows — these rows as CSV