PREVIEW / futures_30min / 2013-07-21
file: by_date/futures_30min/2013/2013-07-21.parquet size: 20 KB rows: 497
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-07-21 18:00:00 | ES | Futures | 1747.42 | 1750.01 | 1747.42 | 1749.49 | 7835.0 |
| 2013-07-21 18:30:00 | ES | Futures | 1749.49 | 1749.49 | 1748.46 | 1748.72 | 1268.0 |
| 2013-07-21 19:00:00 | ES | Futures | 1748.72 | 1748.98 | 1748.2 | 1748.98 | 1348.0 |
| 2013-07-21 19:30:00 | ES | Futures | 1748.98 | 1749.75 | 1748.46 | 1748.98 | 2345.0 |
| 2013-07-21 20:00:00 | ES | Futures | 1748.72 | 1749.49 | 1747.94 | 1749.23 | 5005.0 |
| 2013-07-21 20:30:00 | ES | Futures | 1749.23 | 1749.75 | 1748.72 | 1749.49 | 1921.0 |
| 2013-07-21 21:00:00 | ES | Futures | 1749.49 | 1751.82 | 1749.23 | 1750.53 | 5889.0 |
| 2013-07-21 21:30:00 | ES | Futures | 1750.53 | 1751.04 | 1748.72 | 1748.98 | 5826.0 |
| 2013-07-21 22:00:00 | ES | Futures | 1749.23 | 1749.75 | 1748.46 | 1748.98 | 2759.0 |
| 2013-07-21 22:30:00 | ES | Futures | 1748.98 | 1749.23 | 1748.46 | 1748.98 | 1350.0 |
| 2013-07-21 23:00:00 | ES | Futures | 1748.72 | 1749.49 | 1748.2 | 1748.2 | 1480.0 |
| 2013-07-21 23:30:00 | ES | Futures | 1748.46 | 1748.98 | 1747.94 | 1748.98 | 1433.0 |
| 2013-07-21 18:00:00 | NQ | Futures | 3557.97 | 3562.36 | 3557.97 | 3560.89 | 771.0 |
| 2013-07-21 18:30:00 | NQ | Futures | 3560.6 | 3560.6 | 3559.73 | 3560.02 | 139.0 |
| 2013-07-21 19:00:00 | NQ | Futures | 3559.73 | 3561.77 | 3559.73 | 3561.48 | 230.0 |
| 2013-07-21 19:30:00 | NQ | Futures | 3560.89 | 3562.06 | 3560.6 | 3561.48 | 306.0 |
| 2013-07-21 20:00:00 | NQ | Futures | 3561.48 | 3562.65 | 3559.73 | 3562.65 | 648.0 |
| 2013-07-21 20:30:00 | NQ | Futures | 3562.36 | 3564.11 | 3560.89 | 3563.82 | 394.0 |
| 2013-07-21 21:00:00 | NQ | Futures | 3563.82 | 3567.91 | 3563.52 | 3566.74 | 833.0 |
| 2013-07-21 21:30:00 | NQ | Futures | 3566.45 | 3567.32 | 3564.4 | 3565.28 | 1230.0 |
| 2013-07-21 22:00:00 | NQ | Futures | 3565.28 | 3565.86 | 3563.82 | 3564.99 | 534.0 |
| 2013-07-21 22:30:00 | NQ | Futures | 3564.99 | 3564.99 | 3562.94 | 3564.4 | 266.0 |
| 2013-07-21 23:00:00 | NQ | Futures | 3564.11 | 3564.69 | 3561.48 | 3561.77 | 263.0 |
| 2013-07-21 23:30:00 | NQ | Futures | 3561.77 | 3563.52 | 3561.19 | 3563.23 | 258.0 |
| 2013-07-21 18:00:00 | YM | Futures | 15750.2 | 15772.5 | 15750.2 | 15767.4 | 695.0 |
| 2013-07-21 18:30:00 | YM | Futures | 15766.4 | 15766.4 | 15761.3 | 15761.3 | 94.0 |
| 2013-07-21 19:00:00 | YM | Futures | 15761.3 | 15764.4 | 15757.3 | 15762.4 | 161.0 |
| 2013-07-21 19:30:00 | YM | Futures | 15761.3 | 15768.5 | 15759.3 | 15763.4 | 140.0 |
| 2013-07-21 20:00:00 | YM | Futures | 15762.4 | 15768.5 | 15756.3 | 15765.4 | 540.0 |
| 2013-07-21 20:30:00 | YM | Futures | 15764.4 | 15767.4 | 15759.3 | 15766.4 | 256.0 |
| 2013-07-21 21:00:00 | YM | Futures | 15767.4 | 15784.7 | 15765.4 | 15775.6 | 790.0 |
| 2013-07-21 21:30:00 | YM | Futures | 15777.6 | 15780.6 | 15764.4 | 15766.4 | 791.0 |
| 2013-07-21 22:00:00 | YM | Futures | 15766.4 | 15770.5 | 15760.3 | 15765.4 | 433.0 |
| 2013-07-21 22:30:00 | YM | Futures | 15764.4 | 15766.4 | 15761.3 | 15765.4 | 100.0 |
| 2013-07-21 23:00:00 | YM | Futures | 15766.4 | 15770.5 | 15760.3 | 15760.3 | 185.0 |
| 2013-07-21 23:30:00 | YM | Futures | 15761.3 | 15768.5 | 15758.3 | 15766.4 | 164.0 |
| 2013-07-21 18:00:00 | CL | Futures | 169.87 | 170.02 | 169.58 | 169.84 | 1047.0 |
| 2013-07-21 18:30:00 | CL | Futures | 169.87 | 170.13 | 169.86 | 170.13 | 312.0 |
| 2013-07-21 19:00:00 | CL | Futures | 170.13 | 170.13 | 169.94 | 169.97 | 257.0 |
| 2013-07-21 19:30:00 | CL | Futures | 169.94 | 170.22 | 169.89 | 169.98 | 381.0 |
| 2013-07-21 20:00:00 | CL | Futures | 169.98 | 170.11 | 169.95 | 170.11 | 386.0 |
| 2013-07-21 20:30:00 | CL | Futures | 170.13 | 170.14 | 169.98 | 170.0 | 176.0 |
| 2013-07-21 21:00:00 | CL | Futures | 170.0 | 170.11 | 169.95 | 170.05 | 536.0 |
| 2013-07-21 21:30:00 | CL | Futures | 170.05 | 170.09 | 169.95 | 170.0 | 268.0 |
| 2013-07-21 22:00:00 | CL | Futures | 170.0 | 170.19 | 169.95 | 170.09 | 378.0 |
| 2013-07-21 22:30:00 | CL | Futures | 170.11 | 170.13 | 170.03 | 170.03 | 243.0 |
| 2013-07-21 23:00:00 | CL | Futures | 170.05 | 170.14 | 170.02 | 170.02 | 90.0 |
| 2013-07-21 23:30:00 | CL | Futures | 170.02 | 170.11 | 169.75 | 169.84 | 382.0 |
| 2013-07-21 18:00:00 | GC | Futures | 1777.7 | 1809.4 | 1776.6 | 1798.6 | 8337.0 |
| 2013-07-21 18:30:00 | GC | Futures | 1798.4 | 1801.6 | 1797.6 | 1800.5 | 1616.0 |
> showing 50 of 497 rows — these rows as CSV