PREVIEW / futures_30min / 2012-04-29
file: by_date/futures_30min/2012/2012-04-29.parquet size: 18 KB rows: 465
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-04-29 18:00:00 | ES | Futures | 1416.97 | 1419.24 | 1416.46 | 1418.99 | 5219.0 |
| 2012-04-29 18:30:00 | ES | Futures | 1418.99 | 1418.99 | 1416.46 | 1416.97 | 1677.0 |
| 2012-04-29 19:00:00 | ES | Futures | 1416.71 | 1417.47 | 1416.21 | 1417.22 | 895.0 |
| 2012-04-29 19:30:00 | ES | Futures | 1417.22 | 1417.98 | 1416.71 | 1416.97 | 1447.0 |
| 2012-04-29 20:00:00 | ES | Futures | 1416.71 | 1417.22 | 1414.69 | 1415.45 | 3446.0 |
| 2012-04-29 20:30:00 | ES | Futures | 1415.45 | 1415.95 | 1414.94 | 1415.7 | 1414.0 |
| 2012-04-29 21:00:00 | ES | Futures | 1415.7 | 1416.71 | 1415.19 | 1416.46 | 2074.0 |
| 2012-04-29 21:30:00 | ES | Futures | 1416.71 | 1417.47 | 1415.95 | 1417.47 | 1902.0 |
| 2012-04-29 22:00:00 | ES | Futures | 1417.22 | 1417.72 | 1416.21 | 1416.46 | 1862.0 |
| 2012-04-29 22:30:00 | ES | Futures | 1416.46 | 1417.47 | 1416.21 | 1416.97 | 821.0 |
| 2012-04-29 23:00:00 | ES | Futures | 1416.71 | 1417.47 | 1416.71 | 1417.22 | 274.0 |
| 2012-04-29 23:30:00 | ES | Futures | 1417.22 | 1417.72 | 1416.97 | 1416.97 | 632.0 |
| 2012-04-29 18:00:00 | NQ | Futures | 3170.79 | 3174.55 | 3169.35 | 3173.98 | 904.0 |
| 2012-04-29 18:30:00 | NQ | Futures | 3173.98 | 3173.98 | 3168.77 | 3170.22 | 123.0 |
| 2012-04-29 19:00:00 | NQ | Futures | 3170.22 | 3170.79 | 3169.35 | 3169.93 | 142.0 |
| 2012-04-29 19:30:00 | NQ | Futures | 3170.22 | 3171.95 | 3169.35 | 3169.93 | 129.0 |
| 2012-04-29 20:00:00 | NQ | Futures | 3169.35 | 3170.22 | 3166.17 | 3166.75 | 340.0 |
| 2012-04-29 20:30:00 | NQ | Futures | 3166.75 | 3168.19 | 3166.46 | 3168.19 | 97.0 |
| 2012-04-29 21:00:00 | NQ | Futures | 3168.19 | 3170.51 | 3167.04 | 3169.93 | 279.0 |
| 2012-04-29 21:30:00 | NQ | Futures | 3169.93 | 3171.66 | 3168.19 | 3170.22 | 384.0 |
| 2012-04-29 22:00:00 | NQ | Futures | 3170.22 | 3170.51 | 3168.19 | 3168.48 | 290.0 |
| 2012-04-29 22:30:00 | NQ | Futures | 3168.48 | 3169.93 | 3168.48 | 3169.64 | 67.0 |
| 2012-04-29 23:00:00 | NQ | Futures | 3169.64 | 3170.51 | 3169.64 | 3170.51 | 34.0 |
| 2012-04-29 23:30:00 | NQ | Futures | 3170.51 | 3171.66 | 3170.22 | 3170.79 | 100.0 |
| 2012-04-29 18:00:00 | YM | Futures | 13128.2 | 13144.2 | 13125.3 | 13141.2 | 359.0 |
| 2012-04-29 18:30:00 | YM | Futures | 13140.2 | 13141.2 | 13127.2 | 13130.2 | 111.0 |
| 2012-04-29 19:00:00 | YM | Futures | 13130.2 | 13134.2 | 13126.2 | 13131.2 | 54.0 |
| 2012-04-29 19:30:00 | YM | Futures | 13129.2 | 13137.2 | 13127.2 | 13130.2 | 58.0 |
| 2012-04-29 20:00:00 | YM | Futures | 13130.2 | 13130.2 | 13115.3 | 13119.3 | 194.0 |
| 2012-04-29 20:30:00 | YM | Futures | 13119.3 | 13123.3 | 13118.3 | 13122.3 | 150.0 |
| 2012-04-29 21:00:00 | YM | Futures | 13122.3 | 13132.2 | 13118.3 | 13129.2 | 206.0 |
| 2012-04-29 21:30:00 | YM | Futures | 13129.2 | 13135.2 | 13125.3 | 13133.2 | 168.0 |
| 2012-04-29 22:00:00 | YM | Futures | 13133.2 | 13135.2 | 13126.2 | 13128.2 | 92.0 |
| 2012-04-29 22:30:00 | YM | Futures | 13127.2 | 13133.2 | 13125.3 | 13131.2 | 36.0 |
| 2012-04-29 23:00:00 | YM | Futures | 13130.2 | 13135.2 | 13130.2 | 13134.2 | 14.0 |
| 2012-04-29 23:30:00 | YM | Futures | 13133.2 | 13138.2 | 13133.2 | 13134.2 | 61.0 |
| 2012-04-29 18:00:00 | CL | Futures | 174.44 | 174.51 | 174.12 | 174.21 | 346.0 |
| 2012-04-29 18:30:00 | CL | Futures | 174.21 | 174.27 | 173.99 | 174.09 | 158.0 |
| 2012-04-29 19:00:00 | CL | Futures | 174.12 | 174.21 | 174.09 | 174.09 | 110.0 |
| 2012-04-29 19:30:00 | CL | Futures | 174.14 | 174.22 | 174.07 | 174.22 | 121.0 |
| 2012-04-29 20:00:00 | CL | Futures | 174.22 | 174.22 | 173.99 | 174.04 | 143.0 |
| 2012-04-29 20:30:00 | CL | Futures | 174.06 | 174.09 | 173.99 | 173.99 | 64.0 |
| 2012-04-29 21:00:00 | CL | Futures | 174.04 | 174.16 | 173.99 | 174.16 | 100.0 |
| 2012-04-29 21:30:00 | CL | Futures | 174.14 | 174.19 | 174.09 | 174.19 | 70.0 |
| 2012-04-29 22:00:00 | CL | Futures | 174.17 | 174.19 | 174.07 | 174.09 | 124.0 |
| 2012-04-29 22:30:00 | CL | Futures | 174.12 | 174.14 | 174.09 | 174.12 | 33.0 |
| 2012-04-29 23:00:00 | CL | Futures | 174.11 | 174.19 | 174.09 | 174.17 | 50.0 |
| 2012-04-29 23:30:00 | CL | Futures | 174.17 | 174.21 | 174.16 | 174.19 | 66.0 |
| 2012-04-29 18:00:00 | GC | Futures | 2304.7 | 2308.3 | 2304.4 | 2306.9 | 515.0 |
| 2012-04-29 18:30:00 | GC | Futures | 2306.8 | 2307.2 | 2306.1 | 2306.5 | 98.0 |
> showing 50 of 465 rows — these rows as CSV