PREVIEW / etf_1hour / 2015-03-24
file: by_date/etf_1hour/2015/2015-03-24.parquet size: 238 KB rows: 7,558
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-24 04:00:00 | SPY | ETF | 209.92 | 210.21 | 209.92 | 210.05 | 1075.0 |
| 2015-03-24 05:00:00 | SPY | ETF | 210.04 | 210.28 | 209.94 | 210.17 | 4893.0 |
| 2015-03-24 06:00:00 | SPY | ETF | 210.28 | 210.49 | 210.17 | 210.23 | 59750.0 |
| 2015-03-24 07:00:00 | SPY | ETF | 210.27 | 210.46 | 210.15 | 210.4 | 152673.0 |
| 2015-03-24 08:00:00 | SPY | ETF | 210.38 | 210.42 | 210.04 | 210.19 | 776478.0 |
| 2015-03-24 09:00:00 | SPY | ETF | 210.18 | 210.18 | 209.45 | 209.98 | 8401171.0 |
| 2015-03-24 10:00:00 | SPY | ETF | 209.98 | 210.23 | 209.84 | 210.0041 | 8677838.0 |
| 2015-03-24 11:00:00 | SPY | ETF | 210.01 | 210.4 | 209.86 | 210.14 | 7476704.0 |
| 2015-03-24 12:00:00 | SPY | ETF | 210.14 | 210.27 | 209.52 | 209.54 | 7999139.0 |
| 2015-03-24 13:00:00 | SPY | ETF | 209.54 | 209.74 | 209.22 | 209.51 | 7223383.0 |
| 2015-03-24 14:00:00 | SPY | ETF | 209.51 | 209.52 | 208.98 | 209.22 | 7787123.0 |
| 2015-03-24 15:00:00 | SPY | ETF | 209.22 | 209.9699 | 208.74 | 208.81 | 18438849.0 |
| 2015-03-24 16:00:00 | SPY | ETF | 208.8 | 210.1887 | 208.72 | 208.92 | 6182063.0 |
| 2015-03-24 17:00:00 | SPY | ETF | 208.92 | 209.53 | 208.7574 | 208.9 | 2027437.0 |
| 2015-03-24 18:00:00 | SPY | ETF | 208.91 | 208.97 | 208.9 | 208.95 | 47040.0 |
| 2015-03-24 19:00:00 | SPY | ETF | 208.94 | 209.0 | 208.92 | 208.99 | 39208.0 |
| 2015-03-24 04:00:00 | QQQ | ETF | 108.32 | 108.32 | 108.32 | 108.32 | 1000.0 |
| 2015-03-24 07:00:00 | QQQ | ETF | 108.48 | 108.54 | 108.4 | 108.52 | 35824.0 |
| 2015-03-24 08:00:00 | QQQ | ETF | 108.51 | 108.51 | 108.36 | 108.41 | 94307.0 |
| 2015-03-24 09:00:00 | QQQ | ETF | 108.37 | 108.43 | 108.11 | 108.43 | 2942995.0 |
| 2015-03-24 10:00:00 | QQQ | ETF | 108.43 | 108.7 | 108.42 | 108.66 | 2652608.0 |
| 2015-03-24 11:00:00 | QQQ | ETF | 108.66 | 108.81 | 108.58 | 108.74 | 1359448.0 |
| 2015-03-24 12:00:00 | QQQ | ETF | 108.73 | 108.775 | 108.36 | 108.365 | 1219381.0 |
| 2015-03-24 13:00:00 | QQQ | ETF | 108.36 | 108.49 | 108.15 | 108.33 | 1604401.0 |
| 2015-03-24 14:00:00 | QQQ | ETF | 108.32 | 108.32 | 107.99 | 108.14 | 2048686.0 |
| 2015-03-24 15:00:00 | QQQ | ETF | 108.14 | 108.2999 | 107.91 | 107.93 | 3749760.0 |
| 2015-03-24 16:00:00 | QQQ | ETF | 107.93 | 108.2583 | 107.8838 | 108.04 | 1875343.0 |
| 2015-03-24 17:00:00 | QQQ | ETF | 108.03 | 108.07 | 107.93 | 108.03 | 902644.0 |
| 2015-03-24 18:00:00 | QQQ | ETF | 108.06 | 108.07 | 108.05 | 108.07 | 1200.0 |
| 2015-03-24 19:00:00 | QQQ | ETF | 108.06 | 108.12 | 108.06 | 108.12 | 17950.0 |
| 2015-03-24 07:00:00 | IWM | ETF | 125.92 | 125.92 | 125.86 | 125.89 | 75499.0 |
| 2015-03-24 08:00:00 | IWM | ETF | 125.91 | 125.91 | 125.74 | 125.85 | 68740.0 |
| 2015-03-24 09:00:00 | IWM | ETF | 125.82 | 125.96 | 125.63 | 125.95 | 2275859.0 |
| 2015-03-24 10:00:00 | IWM | ETF | 125.94 | 126.19 | 125.94 | 126.11 | 2086336.0 |
| 2015-03-24 11:00:00 | IWM | ETF | 126.11 | 126.31 | 126.04 | 126.18 | 1468880.0 |
| 2015-03-24 12:00:00 | IWM | ETF | 126.175 | 126.25 | 125.86 | 125.875 | 2025753.0 |
| 2015-03-24 13:00:00 | IWM | ETF | 125.87 | 125.97 | 125.69 | 125.9 | 2312933.0 |
| 2015-03-24 14:00:00 | IWM | ETF | 125.89 | 125.94 | 125.67 | 125.87 | 1741870.0 |
| 2015-03-24 15:00:00 | IWM | ETF | 125.87 | 126.13 | 125.73 | 125.82 | 4547112.0 |
| 2015-03-24 16:00:00 | IWM | ETF | 125.82 | 125.98 | 125.76 | 125.94 | 2598708.0 |
| 2015-03-24 17:00:00 | IWM | ETF | 125.95 | 125.99 | 125.85 | 125.99 | 633237.0 |
| 2015-03-24 18:00:00 | IWM | ETF | 125.9 | 125.9 | 125.9 | 125.9 | 350.0 |
| 2015-03-24 19:00:00 | IWM | ETF | 126.01 | 126.06 | 125.96 | 126.06 | 6200.0 |
| 2015-03-24 07:00:00 | DIA | ETF | 181.1 | 181.1 | 181.1 | 181.1 | 1735.0 |
| 2015-03-24 08:00:00 | DIA | ETF | 181.1 | 181.23 | 181.0 | 181.22 | 1700.0 |
| 2015-03-24 09:00:00 | DIA | ETF | 180.95 | 180.95 | 180.22 | 180.74 | 429888.0 |
| 2015-03-24 10:00:00 | DIA | ETF | 180.76 | 181.0099 | 180.67 | 180.85 | 542278.0 |
| 2015-03-24 11:00:00 | DIA | ETF | 180.86 | 181.19 | 180.71 | 180.89 | 343727.0 |
| 2015-03-24 12:00:00 | DIA | ETF | 180.89 | 180.985 | 180.36 | 180.37 | 445166.0 |
| 2015-03-24 13:00:00 | DIA | ETF | 180.34 | 180.5299 | 180.11 | 180.38 | 467857.0 |
> showing 50 of 7,558 rows — these rows as CSV