PREVIEW / etf_1hour / 2015-03-17
file: by_date/etf_1hour/2015/2015-03-17.parquet size: 237 KB rows: 7,530
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 |
|---|---|---|---|---|---|---|---|
| 2015-03-17 04:00:00 | SPY | ETF | 208.12 | 208.31 | 208.01 | 208.01 | 4100.0 |
| 2015-03-17 05:00:00 | SPY | ETF | 208.01 | 208.01 | 207.78 | 207.84 | 9021.0 |
| 2015-03-17 06:00:00 | SPY | ETF | 207.7 | 207.7 | 207.48 | 207.48 | 26703.0 |
| 2015-03-17 07:00:00 | SPY | ETF | 207.49 | 207.61 | 207.43 | 207.54 | 398045.0 |
| 2015-03-17 08:00:00 | SPY | ETF | 207.39 | 207.85 | 207.39 | 207.76 | 1425968.0 |
| 2015-03-17 09:00:00 | SPY | ETF | 207.75 | 208.05 | 207.25 | 207.571 | 13274191.0 |
| 2015-03-17 10:00:00 | SPY | ETF | 207.57 | 207.86 | 207.435 | 207.65 | 12480310.0 |
| 2015-03-17 11:00:00 | SPY | ETF | 207.65 | 207.65 | 206.98 | 207.47 | 14740106.0 |
| 2015-03-17 12:00:00 | SPY | ETF | 207.47 | 207.86 | 207.14 | 207.85 | 9705499.0 |
| 2015-03-17 13:00:00 | SPY | ETF | 207.85 | 208.15 | 207.72 | 208.1 | 7860043.0 |
| 2015-03-17 14:00:00 | SPY | ETF | 208.09 | 208.25 | 207.69 | 207.99 | 7679116.0 |
| 2015-03-17 15:00:00 | SPY | ETF | 207.99 | 208.42 | 207.89 | 207.98 | 19494584.0 |
| 2015-03-17 16:00:00 | SPY | ETF | 207.99 | 208.06 | 207.6044 | 207.96 | 6055990.0 |
| 2015-03-17 17:00:00 | SPY | ETF | 207.99 | 208.01 | 207.96 | 207.97 | 139436.0 |
| 2015-03-17 18:00:00 | SPY | ETF | 207.98 | 208.05 | 207.97 | 207.98 | 17943.0 |
| 2015-03-17 19:00:00 | SPY | ETF | 208.01 | 208.09 | 208.0 | 208.05 | 41754.0 |
| 2015-03-17 04:00:00 | QQQ | ETF | 106.58 | 106.58 | 106.45 | 106.45 | 1108.0 |
| 2015-03-17 05:00:00 | QQQ | ETF | 106.3 | 106.3 | 106.3 | 106.3 | 3000.0 |
| 2015-03-17 06:00:00 | QQQ | ETF | 106.3 | 106.3 | 106.14 | 106.18 | 13000.0 |
| 2015-03-17 07:00:00 | QQQ | ETF | 106.24 | 106.29 | 106.18 | 106.27 | 52520.0 |
| 2015-03-17 08:00:00 | QQQ | ETF | 106.3 | 106.45 | 106.3 | 106.45 | 129990.0 |
| 2015-03-17 09:00:00 | QQQ | ETF | 106.44 | 106.62 | 106.26 | 106.55 | 3333555.0 |
| 2015-03-17 10:00:00 | QQQ | ETF | 106.54 | 106.57 | 106.395 | 106.47 | 2580545.0 |
| 2015-03-17 11:00:00 | QQQ | ETF | 106.46 | 106.54 | 106.16 | 106.53 | 2493388.0 |
| 2015-03-17 12:00:00 | QQQ | ETF | 106.528 | 106.7 | 106.4 | 106.695 | 1825609.0 |
| 2015-03-17 13:00:00 | QQQ | ETF | 106.7 | 106.905 | 106.65 | 106.87 | 1663902.0 |
| 2015-03-17 14:00:00 | QQQ | ETF | 106.86 | 106.96 | 106.7 | 106.85 | 1673066.0 |
| 2015-03-17 15:00:00 | QQQ | ETF | 106.84 | 107.04 | 106.8 | 106.8299 | 3752149.0 |
| 2015-03-17 16:00:00 | QQQ | ETF | 106.84 | 106.89 | 106.78 | 106.88 | 515455.0 |
| 2015-03-17 17:00:00 | QQQ | ETF | 106.87 | 106.88 | 106.81 | 106.87 | 46700.0 |
| 2015-03-17 18:00:00 | QQQ | ETF | 106.89 | 106.9 | 106.89 | 106.89 | 6400.0 |
| 2015-03-17 19:00:00 | QQQ | ETF | 106.87 | 106.91 | 106.87 | 106.91 | 9685.0 |
| 2015-03-17 04:00:00 | IWM | ETF | 123.21 | 123.21 | 123.21 | 123.21 | 345.0 |
| 2015-03-17 05:00:00 | IWM | ETF | 123.06 | 123.06 | 123.06 | 123.06 | 100.0 |
| 2015-03-17 07:00:00 | IWM | ETF | 122.9 | 122.9 | 122.78 | 122.87 | 71972.0 |
| 2015-03-17 08:00:00 | IWM | ETF | 122.85 | 123.04 | 122.84 | 122.99 | 112635.0 |
| 2015-03-17 09:00:00 | IWM | ETF | 122.99 | 123.25 | 122.77 | 123.195 | 2795217.0 |
| 2015-03-17 10:00:00 | IWM | ETF | 123.19 | 123.33 | 122.89 | 123.26 | 2545953.0 |
| 2015-03-17 11:00:00 | IWM | ETF | 123.25 | 123.25 | 122.89 | 123.01 | 2782242.0 |
| 2015-03-17 12:00:00 | IWM | ETF | 123.01 | 123.16 | 122.77 | 123.12 | 1821663.0 |
| 2015-03-17 13:00:00 | IWM | ETF | 123.11 | 123.2951 | 123.04 | 123.265 | 1642461.0 |
| 2015-03-17 14:00:00 | IWM | ETF | 123.26 | 123.43 | 123.21 | 123.4 | 1178499.0 |
| 2015-03-17 15:00:00 | IWM | ETF | 123.41 | 123.78 | 123.4 | 123.63 | 4774512.0 |
| 2015-03-17 16:00:00 | IWM | ETF | 123.63 | 123.69 | 123.3769 | 123.67 | 1967818.0 |
| 2015-03-17 17:00:00 | IWM | ETF | 123.73 | 123.75 | 123.73 | 123.73 | 32500.0 |
| 2015-03-17 19:00:00 | IWM | ETF | 123.66 | 123.66 | 123.66 | 123.66 | 300.0 |
| 2015-03-17 06:00:00 | DIA | ETF | 179.0 | 179.0 | 179.0 | 179.0 | 100.0 |
| 2015-03-17 07:00:00 | DIA | ETF | 178.8 | 178.9 | 178.8 | 178.85 | 5100.0 |
| 2015-03-17 08:00:00 | DIA | ETF | 179.11 | 179.11 | 178.85 | 178.95 | 5160.0 |
| 2015-03-17 09:00:00 | DIA | ETF | 178.89 | 178.94 | 178.0 | 178.23 | 909984.0 |
> showing 50 of 7,530 rows — these rows as CSV