PREVIEW / etf_1hour / 2017-03-21
file: by_date/etf_1hour/2017/2017-03-21.parquet size: 283 KB rows: 9,161
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 |
|---|---|---|---|---|---|---|---|
| 2017-03-21 04:00:00 | SPY | ETF | 237.09 | 237.35 | 237.09 | 237.29 | 2221.0 |
| 2017-03-21 05:00:00 | SPY | ETF | 237.1 | 237.1 | 237.1 | 237.1 | 350.0 |
| 2017-03-21 06:00:00 | SPY | ETF | 237.13 | 237.28 | 237.13 | 237.13 | 12933.0 |
| 2017-03-21 07:00:00 | SPY | ETF | 237.2 | 237.41 | 237.14 | 237.24 | 105492.0 |
| 2017-03-21 08:00:00 | SPY | ETF | 237.16 | 237.39 | 237.11 | 237.23 | 238171.0 |
| 2017-03-21 09:00:00 | SPY | ETF | 237.24 | 237.61 | 237.13 | 237.14 | 4921375.0 |
| 2017-03-21 10:00:00 | SPY | ETF | 237.14 | 237.14 | 235.18 | 235.41 | 17813696.0 |
| 2017-03-21 11:00:00 | SPY | ETF | 235.4 | 235.49 | 234.2401 | 235.135 | 24055175.0 |
| 2017-03-21 12:00:00 | SPY | ETF | 235.14 | 235.42 | 234.38 | 234.66 | 15859536.0 |
| 2017-03-21 13:00:00 | SPY | ETF | 234.6611 | 234.8 | 233.87 | 233.915 | 13808122.0 |
| 2017-03-21 14:00:00 | SPY | ETF | 233.915 | 235.3991 | 233.81 | 234.44 | 16991979.0 |
| 2017-03-21 15:00:00 | SPY | ETF | 234.42 | 234.65 | 233.58 | 233.78 | 25453776.0 |
| 2017-03-21 16:00:00 | SPY | ETF | 233.77 | 234.08 | 233.66 | 233.83 | 10120107.0 |
| 2017-03-21 17:00:00 | SPY | ETF | 233.83 | 233.83 | 233.69 | 233.73 | 436283.0 |
| 2017-03-21 18:00:00 | SPY | ETF | 233.75 | 233.86 | 233.4 | 233.58 | 519492.0 |
| 2017-03-21 19:00:00 | SPY | ETF | 233.59 | 233.73 | 233.5 | 233.53 | 71111.0 |
| 2017-03-21 04:00:00 | QQQ | ETF | 132.11 | 132.23 | 132.11 | 132.23 | 1800.0 |
| 2017-03-21 05:00:00 | QQQ | ETF | 132.11 | 132.16 | 132.11 | 132.16 | 1499.0 |
| 2017-03-21 06:00:00 | QQQ | ETF | 132.11 | 132.17 | 132.11 | 132.17 | 27617.0 |
| 2017-03-21 07:00:00 | QQQ | ETF | 132.12 | 132.2 | 132.12 | 132.18 | 57900.0 |
| 2017-03-21 08:00:00 | QQQ | ETF | 132.2 | 132.2 | 132.14 | 132.15 | 58536.0 |
| 2017-03-21 09:00:00 | QQQ | ETF | 132.19 | 132.43 | 132.19 | 132.32 | 1688867.0 |
| 2017-03-21 10:00:00 | QQQ | ETF | 132.31 | 132.3107 | 131.125 | 131.24 | 5016088.0 |
| 2017-03-21 11:00:00 | QQQ | ETF | 131.25 | 131.27 | 130.34 | 130.87 | 7084730.0 |
| 2017-03-21 12:00:00 | QQQ | ETF | 130.87 | 130.95 | 130.33 | 130.52 | 3794383.0 |
| 2017-03-21 13:00:00 | QQQ | ETF | 130.52 | 130.61 | 129.91 | 129.94 | 3284344.0 |
| 2017-03-21 14:00:00 | QQQ | ETF | 129.94 | 130.4432 | 129.87 | 130.34 | 4595311.0 |
| 2017-03-21 15:00:00 | QQQ | ETF | 130.32 | 130.3711 | 129.73 | 129.83 | 6672312.0 |
| 2017-03-21 16:00:00 | QQQ | ETF | 129.83 | 131.5375 | 129.79 | 129.85 | 841911.0 |
| 2017-03-21 17:00:00 | QQQ | ETF | 129.83 | 129.89 | 129.8 | 129.89 | 7090.0 |
| 2017-03-21 18:00:00 | QQQ | ETF | 129.88 | 129.88 | 129.7 | 129.74 | 12382.0 |
| 2017-03-21 19:00:00 | QQQ | ETF | 129.74 | 129.79 | 129.73 | 129.73 | 11549.0 |
| 2017-03-21 04:00:00 | IWM | ETF | 138.21 | 138.21 | 138.08 | 138.08 | 1151.0 |
| 2017-03-21 05:00:00 | IWM | ETF | 138.07 | 138.07 | 138.07 | 138.07 | 6100.0 |
| 2017-03-21 06:00:00 | IWM | ETF | 138.1 | 138.1 | 138.09 | 138.09 | 5100.0 |
| 2017-03-21 07:00:00 | IWM | ETF | 138.23 | 138.23 | 138.16 | 138.19 | 43500.0 |
| 2017-03-21 08:00:00 | IWM | ETF | 138.12 | 138.19 | 138.02 | 138.12 | 95462.0 |
| 2017-03-21 09:00:00 | IWM | ETF | 138.14 | 138.6 | 137.52 | 137.55 | 2440321.0 |
| 2017-03-21 10:00:00 | IWM | ETF | 137.55 | 137.55 | 135.75 | 135.84 | 7356750.0 |
| 2017-03-21 11:00:00 | IWM | ETF | 135.84 | 135.875 | 134.44 | 135.46 | 12403501.0 |
| 2017-03-21 12:00:00 | IWM | ETF | 135.46 | 135.65 | 134.69 | 134.995 | 5156075.0 |
| 2017-03-21 13:00:00 | IWM | ETF | 134.99 | 135.21 | 134.58 | 134.62 | 3740076.0 |
| 2017-03-21 14:00:00 | IWM | ETF | 134.6 | 135.16 | 134.57 | 134.97 | 4533629.0 |
| 2017-03-21 15:00:00 | IWM | ETF | 134.96 | 135.03 | 133.92 | 134.03 | 12316286.0 |
| 2017-03-21 16:00:00 | IWM | ETF | 134.03 | 134.23 | 133.91 | 133.98 | 4694059.0 |
| 2017-03-21 17:00:00 | IWM | ETF | 134.03 | 134.09 | 133.97 | 134.07 | 349250.0 |
| 2017-03-21 18:00:00 | IWM | ETF | 134.02 | 134.07 | 133.97 | 133.97 | 8385.0 |
| 2017-03-21 19:00:00 | IWM | ETF | 133.85 | 134.0574 | 133.85 | 133.94 | 1038848.0 |
| 2017-03-21 09:00:00 | DIA | ETF | 209.23 | 209.43 | 209.09 | 209.1 | 190214.0 |
| 2017-03-21 10:00:00 | DIA | ETF | 209.1 | 209.1 | 207.42 | 207.6101 | 975875.0 |
> showing 50 of 9,161 rows — these rows as CSV