PREVIEW / futures_30min / 2014-07-13
file: by_date/futures_30min/2014/2014-07-13.parquet size: 18 KB rows: 490
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 |
|---|---|---|---|---|---|---|---|
| 2014-07-13 18:00:00 | ES | Futures | 2046.08 | 2048.69 | 2045.82 | 2048.17 | 4423.0 |
| 2014-07-13 18:30:00 | ES | Futures | 2047.9 | 2048.17 | 2047.12 | 2047.38 | 1028.0 |
| 2014-07-13 19:00:00 | ES | Futures | 2047.38 | 2047.38 | 2046.6 | 2047.12 | 700.0 |
| 2014-07-13 19:30:00 | ES | Futures | 2046.86 | 2047.9 | 2046.86 | 2047.38 | 1227.0 |
| 2014-07-13 20:00:00 | ES | Futures | 2047.38 | 2048.43 | 2047.12 | 2048.17 | 1344.0 |
| 2014-07-13 20:30:00 | ES | Futures | 2047.9 | 2048.95 | 2047.9 | 2048.69 | 2306.0 |
| 2014-07-13 21:00:00 | ES | Futures | 2048.69 | 2048.69 | 2047.9 | 2048.17 | 606.0 |
| 2014-07-13 21:30:00 | ES | Futures | 2048.17 | 2049.21 | 2047.9 | 2048.69 | 1345.0 |
| 2014-07-13 22:00:00 | ES | Futures | 2048.95 | 2048.95 | 2048.69 | 2048.69 | 590.0 |
| 2014-07-13 22:30:00 | ES | Futures | 2048.69 | 2048.95 | 2048.17 | 2048.17 | 417.0 |
| 2014-07-13 23:00:00 | ES | Futures | 2048.43 | 2048.69 | 2047.64 | 2047.64 | 847.0 |
| 2014-07-13 23:30:00 | ES | Futures | 2047.9 | 2048.43 | 2047.64 | 2047.64 | 1019.0 |
| 2014-07-13 18:00:00 | NQ | Futures | 4553.09 | 4559.23 | 4552.8 | 4558.64 | 693.0 |
| 2014-07-13 18:30:00 | NQ | Futures | 4558.64 | 4558.64 | 4556.89 | 4557.77 | 89.0 |
| 2014-07-13 19:00:00 | NQ | Futures | 4557.47 | 4557.47 | 4555.72 | 4556.6 | 122.0 |
| 2014-07-13 19:30:00 | NQ | Futures | 4556.89 | 4558.64 | 4556.31 | 4557.77 | 118.0 |
| 2014-07-13 20:00:00 | NQ | Futures | 4557.77 | 4559.52 | 4557.47 | 4559.52 | 241.0 |
| 2014-07-13 20:30:00 | NQ | Futures | 4559.81 | 4562.44 | 4559.23 | 4561.56 | 519.0 |
| 2014-07-13 21:00:00 | NQ | Futures | 4561.56 | 4562.15 | 4560.39 | 4560.69 | 172.0 |
| 2014-07-13 21:30:00 | NQ | Futures | 4560.69 | 4562.44 | 4560.69 | 4561.85 | 412.0 |
| 2014-07-13 22:00:00 | NQ | Futures | 4561.85 | 4561.85 | 4560.39 | 4560.69 | 276.0 |
| 2014-07-13 22:30:00 | NQ | Futures | 4560.39 | 4560.69 | 4558.64 | 4559.23 | 200.0 |
| 2014-07-13 23:00:00 | NQ | Futures | 4559.23 | 4560.1 | 4558.35 | 4558.35 | 99.0 |
| 2014-07-13 23:30:00 | NQ | Futures | 4558.35 | 4559.23 | 4557.77 | 4558.06 | 182.0 |
| 2014-07-13 18:00:00 | YM | Futures | 17460.4 | 17486.3 | 17459.4 | 17482.1 | 485.0 |
| 2014-07-13 18:30:00 | YM | Futures | 17481.1 | 17483.2 | 17473.8 | 17473.8 | 109.0 |
| 2014-07-13 19:00:00 | YM | Futures | 17475.9 | 17475.9 | 17471.8 | 17471.8 | 61.0 |
| 2014-07-13 19:30:00 | YM | Futures | 17473.8 | 17482.1 | 17471.8 | 17474.9 | 150.0 |
| 2014-07-13 20:00:00 | YM | Futures | 17475.9 | 17483.2 | 17473.8 | 17480.0 | 208.0 |
| 2014-07-13 20:30:00 | YM | Futures | 17481.1 | 17489.4 | 17479.0 | 17486.3 | 283.0 |
| 2014-07-13 21:00:00 | YM | Futures | 17485.2 | 17485.2 | 17481.1 | 17483.2 | 135.0 |
| 2014-07-13 21:30:00 | YM | Futures | 17483.2 | 17491.4 | 17483.2 | 17489.4 | 311.0 |
| 2014-07-13 22:00:00 | YM | Futures | 17489.4 | 17490.4 | 17487.3 | 17487.3 | 49.0 |
| 2014-07-13 22:30:00 | YM | Futures | 17487.3 | 17488.3 | 17482.1 | 17483.2 | 84.0 |
| 2014-07-13 23:00:00 | YM | Futures | 17484.2 | 17488.3 | 17478.0 | 17478.0 | 261.0 |
| 2014-07-13 23:30:00 | YM | Futures | 17479.0 | 17482.1 | 17476.9 | 17478.0 | 158.0 |
| 2014-07-13 18:00:00 | CL | Futures | 163.4 | 164.2 | 163.37 | 164.07 | 1709.0 |
| 2014-07-13 18:30:00 | CL | Futures | 164.07 | 164.1 | 163.79 | 164.02 | 642.0 |
| 2014-07-13 19:00:00 | CL | Futures | 164.05 | 164.07 | 163.86 | 164.05 | 394.0 |
| 2014-07-13 19:30:00 | CL | Futures | 164.05 | 164.07 | 163.99 | 163.99 | 102.0 |
| 2014-07-13 20:00:00 | CL | Futures | 163.97 | 164.05 | 163.91 | 164.02 | 285.0 |
| 2014-07-13 20:30:00 | CL | Futures | 164.01 | 164.09 | 163.96 | 164.04 | 319.0 |
| 2014-07-13 21:00:00 | CL | Futures | 164.04 | 164.05 | 163.88 | 163.96 | 368.0 |
| 2014-07-13 21:30:00 | CL | Futures | 163.96 | 164.15 | 163.94 | 164.07 | 551.0 |
| 2014-07-13 22:00:00 | CL | Futures | 164.05 | 164.09 | 163.96 | 164.04 | 264.0 |
| 2014-07-13 22:30:00 | CL | Futures | 164.02 | 164.07 | 163.97 | 164.07 | 290.0 |
| 2014-07-13 23:00:00 | CL | Futures | 164.07 | 164.1 | 164.01 | 164.04 | 252.0 |
| 2014-07-13 23:30:00 | CL | Futures | 164.04 | 164.05 | 163.73 | 163.84 | 979.0 |
| 2014-07-13 18:00:00 | GC | Futures | 1834.7 | 1836.6 | 1834.3 | 1834.7 | 851.0 |
| 2014-07-13 18:30:00 | GC | Futures | 1834.7 | 1835.8 | 1834.7 | 1835.4 | 221.0 |
> showing 50 of 490 rows — these rows as CSV