PREVIEW / futures_30min / 2012-06-10
file: by_date/futures_30min/2012/2012-06-10.parquet size: 19 KB rows: 499
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-06-10 18:00:00 | ES | Futures | 1358.02 | 1365.1 | 1358.02 | 1362.07 | 15712.0 |
| 2012-06-10 18:30:00 | ES | Futures | 1362.07 | 1362.07 | 1360.04 | 1360.55 | 3370.0 |
| 2012-06-10 19:00:00 | ES | Futures | 1360.55 | 1360.8 | 1359.28 | 1359.79 | 1442.0 |
| 2012-06-10 19:30:00 | ES | Futures | 1359.54 | 1360.3 | 1357.77 | 1360.3 | 3527.0 |
| 2012-06-10 20:00:00 | ES | Futures | 1360.04 | 1360.3 | 1357.26 | 1359.54 | 3191.0 |
| 2012-06-10 20:30:00 | ES | Futures | 1359.79 | 1360.3 | 1358.78 | 1360.04 | 1364.0 |
| 2012-06-10 21:00:00 | ES | Futures | 1360.04 | 1361.06 | 1360.04 | 1360.3 | 1432.0 |
| 2012-06-10 21:30:00 | ES | Futures | 1360.3 | 1361.31 | 1360.04 | 1360.3 | 1708.0 |
| 2012-06-10 22:00:00 | ES | Futures | 1360.3 | 1360.55 | 1358.53 | 1359.03 | 1066.0 |
| 2012-06-10 22:30:00 | ES | Futures | 1359.03 | 1359.28 | 1358.53 | 1358.78 | 936.0 |
| 2012-06-10 23:00:00 | ES | Futures | 1358.78 | 1359.03 | 1358.27 | 1358.53 | 1041.0 |
| 2012-06-10 23:30:00 | ES | Futures | 1358.53 | 1359.54 | 1358.53 | 1358.78 | 1410.0 |
| 2012-06-10 18:00:00 | NQ | Futures | 2992.65 | 3012.31 | 2989.76 | 3004.79 | 903.0 |
| 2012-06-10 18:30:00 | NQ | Futures | 3004.22 | 3005.37 | 3001.03 | 3001.9 | 94.0 |
| 2012-06-10 19:00:00 | NQ | Futures | 3002.19 | 3003.06 | 2998.72 | 2999.59 | 127.0 |
| 2012-06-10 19:30:00 | NQ | Futures | 3000.17 | 3000.74 | 2996.7 | 3000.74 | 134.0 |
| 2012-06-10 20:00:00 | NQ | Futures | 3001.61 | 3001.61 | 2996.12 | 2999.88 | 162.0 |
| 2012-06-10 20:30:00 | NQ | Futures | 2999.01 | 3001.9 | 2998.43 | 3001.32 | 122.0 |
| 2012-06-10 21:00:00 | NQ | Futures | 3002.48 | 3002.77 | 3001.03 | 3001.9 | 78.0 |
| 2012-06-10 21:30:00 | NQ | Futures | 3002.19 | 3003.35 | 3001.03 | 3001.03 | 84.0 |
| 2012-06-10 22:00:00 | NQ | Futures | 3001.03 | 3001.32 | 2997.56 | 2998.72 | 64.0 |
| 2012-06-10 22:30:00 | NQ | Futures | 2998.72 | 2998.72 | 2996.41 | 2997.56 | 224.0 |
| 2012-06-10 23:00:00 | NQ | Futures | 2997.56 | 2997.56 | 2997.27 | 2997.56 | 16.0 |
| 2012-06-10 23:30:00 | NQ | Futures | 2998.43 | 2998.43 | 2996.41 | 2996.41 | 48.0 |
| 2012-06-10 18:00:00 | YM | Futures | 12534.4 | 12643.8 | 12519.5 | 12580.2 | 1835.0 |
| 2012-06-10 18:30:00 | YM | Futures | 12579.2 | 12591.1 | 12570.2 | 12580.2 | 887.0 |
| 2012-06-10 19:00:00 | YM | Futures | 12580.2 | 12582.2 | 12566.3 | 12571.2 | 328.0 |
| 2012-06-10 19:30:00 | YM | Futures | 12569.2 | 12577.2 | 12556.3 | 12574.2 | 256.0 |
| 2012-06-10 20:00:00 | YM | Futures | 12576.2 | 12577.2 | 12554.3 | 12569.2 | 480.0 |
| 2012-06-10 20:30:00 | YM | Futures | 12569.2 | 12576.2 | 12564.3 | 12572.2 | 144.0 |
| 2012-06-10 21:00:00 | YM | Futures | 12573.2 | 12581.2 | 12573.2 | 12577.2 | 102.0 |
| 2012-06-10 21:30:00 | YM | Futures | 12578.2 | 12583.2 | 12574.2 | 12574.2 | 310.0 |
| 2012-06-10 22:00:00 | YM | Futures | 12573.2 | 12575.2 | 12565.3 | 12566.3 | 180.0 |
| 2012-06-10 22:30:00 | YM | Futures | 12565.3 | 12568.3 | 12563.3 | 12565.3 | 132.0 |
| 2012-06-10 23:00:00 | YM | Futures | 12564.3 | 12564.3 | 12559.3 | 12561.3 | 108.0 |
| 2012-06-10 23:30:00 | YM | Futures | 12562.3 | 12567.3 | 12559.3 | 12562.3 | 197.0 |
| 2012-06-10 18:00:00 | CL | Futures | 141.94 | 142.64 | 141.58 | 142.49 | 3307.0 |
| 2012-06-10 18:30:00 | CL | Futures | 142.47 | 142.65 | 142.27 | 142.44 | 1226.0 |
| 2012-06-10 19:00:00 | CL | Futures | 142.47 | 143.46 | 142.4 | 143.08 | 2627.0 |
| 2012-06-10 19:30:00 | CL | Futures | 143.1 | 143.15 | 142.98 | 143.15 | 522.0 |
| 2012-06-10 20:00:00 | CL | Futures | 143.15 | 143.15 | 142.75 | 142.77 | 956.0 |
| 2012-06-10 20:30:00 | CL | Futures | 142.78 | 143.03 | 142.65 | 142.97 | 564.0 |
| 2012-06-10 21:00:00 | CL | Futures | 143.0 | 143.23 | 142.75 | 142.85 | 670.0 |
| 2012-06-10 21:30:00 | CL | Futures | 142.85 | 142.92 | 142.52 | 142.59 | 424.0 |
| 2012-06-10 22:00:00 | CL | Futures | 142.57 | 142.65 | 142.4 | 142.45 | 490.0 |
| 2012-06-10 22:30:00 | CL | Futures | 142.47 | 142.64 | 142.44 | 142.44 | 277.0 |
| 2012-06-10 23:00:00 | CL | Futures | 142.45 | 142.49 | 142.14 | 142.4 | 590.0 |
| 2012-06-10 23:30:00 | CL | Futures | 142.4 | 142.5 | 142.3 | 142.4 | 238.0 |
| 2012-06-10 18:00:00 | GC | Futures | 2217.9 | 2226.9 | 2216.8 | 2223.0 | 2389.0 |
| 2012-06-10 18:30:00 | GC | Futures | 2223.4 | 2226.9 | 2222.3 | 2225.5 | 616.0 |
> showing 50 of 499 rows — these rows as CSV