PREVIEW / futures_30min / 2013-04-07
file: by_date/futures_30min/2013/2013-04-07.parquet size: 19 KB rows: 517
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-04-07 18:00:00 | ES | Futures | 1592.39 | 1595.73 | 1592.13 | 1594.7 | 7839.0 |
| 2013-04-07 18:30:00 | ES | Futures | 1594.96 | 1594.96 | 1593.93 | 1594.19 | 912.0 |
| 2013-04-07 19:00:00 | ES | Futures | 1594.19 | 1595.22 | 1593.93 | 1594.96 | 1536.0 |
| 2013-04-07 19:30:00 | ES | Futures | 1594.96 | 1595.22 | 1593.93 | 1594.96 | 2269.0 |
| 2013-04-07 20:00:00 | ES | Futures | 1594.96 | 1595.22 | 1592.39 | 1593.16 | 6796.0 |
| 2013-04-07 20:30:00 | ES | Futures | 1592.9 | 1594.45 | 1592.9 | 1592.9 | 3161.0 |
| 2013-04-07 21:00:00 | ES | Futures | 1593.16 | 1593.67 | 1591.87 | 1592.39 | 4068.0 |
| 2013-04-07 21:30:00 | ES | Futures | 1592.39 | 1592.9 | 1592.13 | 1592.39 | 3486.0 |
| 2013-04-07 22:00:00 | ES | Futures | 1592.64 | 1592.9 | 1592.13 | 1592.64 | 1461.0 |
| 2013-04-07 22:30:00 | ES | Futures | 1592.64 | 1593.67 | 1592.39 | 1593.16 | 1933.0 |
| 2013-04-07 23:00:00 | ES | Futures | 1593.16 | 1593.93 | 1592.39 | 1593.42 | 1869.0 |
| 2013-04-07 23:30:00 | ES | Futures | 1593.67 | 1594.7 | 1593.67 | 1594.45 | 1800.0 |
| 2013-04-07 18:00:00 | NQ | Futures | 3223.81 | 3228.47 | 3223.51 | 3226.72 | 730.0 |
| 2013-04-07 18:30:00 | NQ | Futures | 3226.43 | 3226.43 | 3225.26 | 3225.26 | 79.0 |
| 2013-04-07 19:00:00 | NQ | Futures | 3225.85 | 3226.43 | 3225.56 | 3226.14 | 56.0 |
| 2013-04-07 19:30:00 | NQ | Futures | 3226.14 | 3227.01 | 3224.68 | 3226.43 | 135.0 |
| 2013-04-07 20:00:00 | NQ | Futures | 3226.43 | 3226.43 | 3224.68 | 3225.56 | 646.0 |
| 2013-04-07 20:30:00 | NQ | Futures | 3225.56 | 3227.6 | 3225.56 | 3225.56 | 522.0 |
| 2013-04-07 21:00:00 | NQ | Futures | 3225.56 | 3226.43 | 3223.81 | 3224.39 | 288.0 |
| 2013-04-07 21:30:00 | NQ | Futures | 3224.39 | 3224.97 | 3223.81 | 3224.97 | 146.0 |
| 2013-04-07 22:00:00 | NQ | Futures | 3225.26 | 3225.56 | 3224.39 | 3224.97 | 96.0 |
| 2013-04-07 22:30:00 | NQ | Futures | 3224.97 | 3226.72 | 3224.97 | 3226.43 | 90.0 |
| 2013-04-07 23:00:00 | NQ | Futures | 3226.43 | 3226.72 | 3224.97 | 3226.43 | 147.0 |
| 2013-04-07 23:30:00 | NQ | Futures | 3226.72 | 3228.18 | 3226.72 | 3228.18 | 155.0 |
| 2013-04-07 18:00:00 | YM | Futures | 14637.5 | 14657.7 | 14623.3 | 14651.6 | 553.0 |
| 2013-04-07 18:30:00 | YM | Futures | 14652.6 | 14654.7 | 14648.6 | 14649.6 | 81.0 |
| 2013-04-07 19:00:00 | YM | Futures | 14650.6 | 14654.7 | 14648.6 | 14654.7 | 59.0 |
| 2013-04-07 19:30:00 | YM | Futures | 14654.7 | 14658.7 | 14650.6 | 14657.7 | 308.0 |
| 2013-04-07 20:00:00 | YM | Futures | 14657.7 | 14657.7 | 14633.4 | 14638.5 | 957.0 |
| 2013-04-07 20:30:00 | YM | Futures | 14639.5 | 14648.6 | 14636.5 | 14637.5 | 366.0 |
| 2013-04-07 21:00:00 | YM | Futures | 14637.5 | 14643.5 | 14628.4 | 14631.4 | 500.0 |
| 2013-04-07 21:30:00 | YM | Futures | 14632.4 | 14633.4 | 14628.4 | 14630.4 | 469.0 |
| 2013-04-07 22:00:00 | YM | Futures | 14630.4 | 14631.4 | 14627.4 | 14629.4 | 148.0 |
| 2013-04-07 22:30:00 | YM | Futures | 14630.4 | 14640.5 | 14630.4 | 14638.5 | 191.0 |
| 2013-04-07 23:00:00 | YM | Futures | 14637.5 | 14643.5 | 14633.4 | 14641.5 | 373.0 |
| 2013-04-07 23:30:00 | YM | Futures | 14642.5 | 14649.6 | 14642.5 | 14648.6 | 123.0 |
| 2013-04-07 18:00:00 | CL | Futures | 147.2 | 147.25 | 146.86 | 146.98 | 723.0 |
| 2013-04-07 18:30:00 | CL | Futures | 146.97 | 147.11 | 146.89 | 147.06 | 375.0 |
| 2013-04-07 19:00:00 | CL | Futures | 147.05 | 147.05 | 146.73 | 146.87 | 453.0 |
| 2013-04-07 19:30:00 | CL | Futures | 146.82 | 147.17 | 146.82 | 146.95 | 579.0 |
| 2013-04-07 20:00:00 | CL | Futures | 146.97 | 147.09 | 146.71 | 146.81 | 678.0 |
| 2013-04-07 20:30:00 | CL | Futures | 146.79 | 146.86 | 146.78 | 146.82 | 125.0 |
| 2013-04-07 21:00:00 | CL | Futures | 146.81 | 146.9 | 146.79 | 146.9 | 253.0 |
| 2013-04-07 21:30:00 | CL | Futures | 146.9 | 146.93 | 146.89 | 146.9 | 114.0 |
| 2013-04-07 22:00:00 | CL | Futures | 146.9 | 146.93 | 146.84 | 146.86 | 169.0 |
| 2013-04-07 22:30:00 | CL | Futures | 146.86 | 146.89 | 146.81 | 146.84 | 151.0 |
| 2013-04-07 23:00:00 | CL | Futures | 146.84 | 146.92 | 146.81 | 146.89 | 151.0 |
| 2013-04-07 23:30:00 | CL | Futures | 146.92 | 146.98 | 146.87 | 146.95 | 179.0 |
| 2013-04-07 18:00:00 | GC | Futures | 2171.2 | 2174.1 | 2170.6 | 2173.2 | 1235.0 |
| 2013-04-07 18:30:00 | GC | Futures | 2173.1 | 2173.4 | 2171.3 | 2171.9 | 360.0 |
> showing 50 of 517 rows — these rows as CSV