PREVIEW / futures_30min / 2012-02-05
file: by_date/futures_30min/2012/2012-02-05.parquet size: 19 KB rows: 494
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-02-05 18:00:00 | ES | Futures | 1347.13 | 1347.88 | 1345.36 | 1346.88 | 7615.0 |
| 2012-02-05 18:30:00 | ES | Futures | 1346.62 | 1347.63 | 1346.12 | 1347.38 | 1742.0 |
| 2012-02-05 19:00:00 | ES | Futures | 1347.63 | 1348.14 | 1346.88 | 1347.63 | 2203.0 |
| 2012-02-05 19:30:00 | ES | Futures | 1347.38 | 1347.88 | 1346.88 | 1347.13 | 1326.0 |
| 2012-02-05 20:00:00 | ES | Futures | 1347.38 | 1347.63 | 1345.62 | 1346.12 | 4115.0 |
| 2012-02-05 20:30:00 | ES | Futures | 1346.12 | 1346.37 | 1345.62 | 1345.87 | 1750.0 |
| 2012-02-05 21:00:00 | ES | Futures | 1346.12 | 1346.37 | 1345.11 | 1345.36 | 2524.0 |
| 2012-02-05 21:30:00 | ES | Futures | 1345.11 | 1345.62 | 1344.61 | 1345.11 | 2100.0 |
| 2012-02-05 22:00:00 | ES | Futures | 1345.36 | 1345.62 | 1344.61 | 1345.11 | 2429.0 |
| 2012-02-05 22:30:00 | ES | Futures | 1345.11 | 1346.37 | 1344.86 | 1346.12 | 1921.0 |
| 2012-02-05 23:00:00 | ES | Futures | 1345.87 | 1346.37 | 1345.36 | 1345.62 | 1066.0 |
| 2012-02-05 23:30:00 | ES | Futures | 1345.87 | 1346.12 | 1345.36 | 1345.62 | 1378.0 |
| 2012-02-05 18:00:00 | NQ | Futures | 2910.8 | 2912.24 | 2900.11 | 2909.93 | 822.0 |
| 2012-02-05 18:30:00 | NQ | Futures | 2909.93 | 2911.95 | 2909.35 | 2911.66 | 107.0 |
| 2012-02-05 19:00:00 | NQ | Futures | 2911.66 | 2912.24 | 2910.51 | 2911.38 | 117.0 |
| 2012-02-05 19:30:00 | NQ | Futures | 2911.38 | 2912.24 | 2910.51 | 2910.51 | 88.0 |
| 2012-02-05 20:00:00 | NQ | Futures | 2910.8 | 2911.09 | 2908.78 | 2910.51 | 182.0 |
| 2012-02-05 20:30:00 | NQ | Futures | 2909.93 | 2910.51 | 2908.78 | 2909.35 | 87.0 |
| 2012-02-05 21:00:00 | NQ | Futures | 2909.93 | 2910.22 | 2907.91 | 2908.2 | 183.0 |
| 2012-02-05 21:30:00 | NQ | Futures | 2908.78 | 2909.07 | 2907.62 | 2908.2 | 138.0 |
| 2012-02-05 22:00:00 | NQ | Futures | 2908.2 | 2909.35 | 2907.62 | 2909.07 | 118.0 |
| 2012-02-05 22:30:00 | NQ | Futures | 2908.78 | 2911.38 | 2908.49 | 2910.51 | 241.0 |
| 2012-02-05 23:00:00 | NQ | Futures | 2910.51 | 2910.51 | 2909.35 | 2909.93 | 124.0 |
| 2012-02-05 23:30:00 | NQ | Futures | 2909.93 | 2910.8 | 2909.35 | 2909.93 | 126.0 |
| 2012-02-05 18:00:00 | YM | Futures | 12666.7 | 12667.7 | 12646.9 | 12655.8 | 702.0 |
| 2012-02-05 18:30:00 | YM | Futures | 12653.8 | 12662.7 | 12651.8 | 12661.8 | 103.0 |
| 2012-02-05 19:00:00 | YM | Futures | 12663.7 | 12666.7 | 12658.8 | 12661.8 | 209.0 |
| 2012-02-05 19:30:00 | YM | Futures | 12660.8 | 12667.7 | 12659.8 | 12662.7 | 131.0 |
| 2012-02-05 20:00:00 | YM | Futures | 12663.7 | 12663.7 | 12648.9 | 12656.8 | 289.0 |
| 2012-02-05 20:30:00 | YM | Futures | 12655.8 | 12655.8 | 12650.9 | 12653.8 | 67.0 |
| 2012-02-05 21:00:00 | YM | Futures | 12654.8 | 12655.8 | 12646.9 | 12646.9 | 97.0 |
| 2012-02-05 21:30:00 | YM | Futures | 12646.9 | 12649.9 | 12642.9 | 12646.9 | 136.0 |
| 2012-02-05 22:00:00 | YM | Futures | 12646.9 | 12651.8 | 12642.9 | 12649.9 | 343.0 |
| 2012-02-05 22:30:00 | YM | Futures | 12647.9 | 12657.8 | 12644.9 | 12653.8 | 203.0 |
| 2012-02-05 23:00:00 | YM | Futures | 12653.8 | 12654.8 | 12646.9 | 12649.9 | 136.0 |
| 2012-02-05 23:30:00 | YM | Futures | 12651.8 | 12655.8 | 12649.9 | 12652.8 | 193.0 |
| 2012-02-05 18:00:00 | CL | Futures | 164.8 | 164.82 | 164.58 | 164.75 | 783.0 |
| 2012-02-05 18:30:00 | CL | Futures | 164.73 | 164.73 | 164.52 | 164.72 | 305.0 |
| 2012-02-05 19:00:00 | CL | Futures | 164.7 | 164.72 | 164.53 | 164.57 | 302.0 |
| 2012-02-05 19:30:00 | CL | Futures | 164.57 | 164.63 | 164.46 | 164.53 | 281.0 |
| 2012-02-05 20:00:00 | CL | Futures | 164.55 | 164.62 | 164.41 | 164.46 | 173.0 |
| 2012-02-05 20:30:00 | CL | Futures | 164.45 | 164.5 | 164.13 | 164.14 | 420.0 |
| 2012-02-05 21:00:00 | CL | Futures | 164.13 | 164.18 | 163.89 | 163.98 | 517.0 |
| 2012-02-05 21:30:00 | CL | Futures | 163.98 | 164.13 | 163.66 | 163.81 | 634.0 |
| 2012-02-05 22:00:00 | CL | Futures | 163.81 | 164.06 | 163.72 | 164.03 | 342.0 |
| 2012-02-05 22:30:00 | CL | Futures | 164.03 | 164.31 | 163.99 | 164.25 | 441.0 |
| 2012-02-05 23:00:00 | CL | Futures | 164.23 | 164.3 | 164.13 | 164.28 | 186.0 |
| 2012-02-05 23:30:00 | CL | Futures | 164.28 | 164.38 | 164.03 | 164.06 | 492.0 |
| 2012-02-05 18:00:00 | GC | Futures | 2402.5 | 2406.7 | 2400.0 | 2405.0 | 1158.0 |
| 2012-02-05 18:30:00 | GC | Futures | 2405.3 | 2407.4 | 2404.5 | 2405.9 | 331.0 |
> showing 50 of 494 rows — these rows as CSV