PREVIEW / etf_1hour / 2015-03-03
file: by_date/etf_1hour/2015/2015-03-03.parquet size: 239 KB rows: 7,594
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-03 04:00:00 | SPY | ETF | 211.8 | 211.8 | 211.65 | 211.65 | 900.0 |
| 2015-03-03 05:00:00 | SPY | ETF | 211.69 | 211.77 | 211.69 | 211.77 | 4250.0 |
| 2015-03-03 06:00:00 | SPY | ETF | 211.75 | 211.75 | 211.65 | 211.65 | 52055.0 |
| 2015-03-03 07:00:00 | SPY | ETF | 211.69 | 211.69 | 211.47 | 211.5 | 207064.0 |
| 2015-03-03 08:00:00 | SPY | ETF | 211.5 | 211.99 | 211.28 | 211.41 | 1490744.0 |
| 2015-03-03 09:00:00 | SPY | ETF | 211.38 | 211.59 | 210.77 | 210.9 | 12261398.0 |
| 2015-03-03 10:00:00 | SPY | ETF | 210.9 | 211.2 | 210.82 | 210.9 | 13576557.0 |
| 2015-03-03 11:00:00 | SPY | ETF | 210.89 | 210.97 | 210.19 | 210.5 | 20061835.0 |
| 2015-03-03 12:00:00 | SPY | ETF | 210.49 | 210.76 | 210.08 | 210.73 | 12010845.0 |
| 2015-03-03 13:00:00 | SPY | ETF | 210.74 | 210.92 | 210.63 | 210.745 | 8374287.0 |
| 2015-03-03 14:00:00 | SPY | ETF | 210.7465 | 212.054 | 210.74 | 211.005 | 10481661.0 |
| 2015-03-03 15:00:00 | SPY | ETF | 211.0 | 211.21 | 210.82 | 211.14 | 19667250.0 |
| 2015-03-03 16:00:00 | SPY | ETF | 211.15 | 212.0539 | 210.7311 | 211.01 | 8838833.0 |
| 2015-03-03 17:00:00 | SPY | ETF | 211.02 | 212.0539 | 210.92 | 210.94 | 611262.0 |
| 2015-03-03 18:00:00 | SPY | ETF | 210.94 | 210.95 | 210.83 | 210.87 | 55019.0 |
| 2015-03-03 19:00:00 | SPY | ETF | 210.87 | 210.87 | 210.7 | 210.72 | 63756.0 |
| 2015-03-03 06:00:00 | QQQ | ETF | 109.3 | 109.3 | 109.22 | 109.23 | 20300.0 |
| 2015-03-03 07:00:00 | QQQ | ETF | 109.18 | 109.18 | 109.12 | 109.12 | 10434.0 |
| 2015-03-03 08:00:00 | QQQ | ETF | 109.12 | 109.14 | 109.02 | 109.05 | 62833.0 |
| 2015-03-03 09:00:00 | QQQ | ETF | 109.04 | 109.16 | 108.7 | 108.78 | 2952882.0 |
| 2015-03-03 10:00:00 | QQQ | ETF | 108.79 | 108.96 | 108.59 | 108.65 | 3211524.0 |
| 2015-03-03 11:00:00 | QQQ | ETF | 108.64 | 108.66 | 108.3 | 108.46 | 3074230.0 |
| 2015-03-03 12:00:00 | QQQ | ETF | 108.47 | 108.57 | 108.18 | 108.56 | 2401801.0 |
| 2015-03-03 13:00:00 | QQQ | ETF | 108.56 | 108.68 | 108.49 | 108.6 | 1463157.0 |
| 2015-03-03 14:00:00 | QQQ | ETF | 108.595 | 108.905 | 108.58 | 108.78 | 2124211.0 |
| 2015-03-03 15:00:00 | QQQ | ETF | 108.77 | 108.88 | 108.67 | 108.84 | 3635496.0 |
| 2015-03-03 16:00:00 | QQQ | ETF | 108.84 | 108.88 | 108.74 | 108.8 | 537086.0 |
| 2015-03-03 17:00:00 | QQQ | ETF | 108.8 | 108.8809 | 108.3945 | 108.8809 | 54955.0 |
| 2015-03-03 18:00:00 | QQQ | ETF | 108.78 | 108.78 | 108.69 | 108.74 | 17039.0 |
| 2015-03-03 19:00:00 | QQQ | ETF | 108.73 | 108.73 | 108.65 | 108.65 | 6800.0 |
| 2015-03-03 07:00:00 | IWM | ETF | 123.1 | 123.1 | 123.1 | 123.1 | 9999.0 |
| 2015-03-03 08:00:00 | IWM | ETF | 123.25 | 123.47 | 122.99 | 123.05 | 21756.0 |
| 2015-03-03 09:00:00 | IWM | ETF | 123.05 | 123.2 | 122.26 | 122.48 | 2780136.0 |
| 2015-03-03 10:00:00 | IWM | ETF | 122.48 | 122.92 | 122.42 | 122.6 | 2418291.0 |
| 2015-03-03 11:00:00 | IWM | ETF | 122.6 | 122.72 | 122.29 | 122.52 | 3126547.0 |
| 2015-03-03 12:00:00 | IWM | ETF | 122.53 | 122.74 | 122.36 | 122.74 | 1649808.0 |
| 2015-03-03 13:00:00 | IWM | ETF | 122.75 | 122.8 | 122.52 | 122.57 | 1632748.0 |
| 2015-03-03 14:00:00 | IWM | ETF | 122.57 | 122.9452 | 122.55 | 122.84 | 2097093.0 |
| 2015-03-03 15:00:00 | IWM | ETF | 122.85 | 122.9 | 122.64 | 122.76 | 3546034.0 |
| 2015-03-03 16:00:00 | IWM | ETF | 122.76 | 122.78 | 122.68 | 122.71 | 1540218.0 |
| 2015-03-03 17:00:00 | IWM | ETF | 122.64 | 122.64 | 122.6 | 122.6 | 40400.0 |
| 2015-03-03 18:00:00 | IWM | ETF | 122.67 | 122.67 | 122.67 | 122.67 | 150.0 |
| 2015-03-03 19:00:00 | IWM | ETF | 122.6 | 122.6 | 122.41 | 122.41 | 2444.0 |
| 2015-03-03 06:00:00 | DIA | ETF | 182.37 | 182.37 | 182.33 | 182.33 | 9500.0 |
| 2015-03-03 07:00:00 | DIA | ETF | 182.33 | 182.34 | 182.22 | 182.22 | 32000.0 |
| 2015-03-03 08:00:00 | DIA | ETF | 182.22 | 182.25 | 182.05 | 182.08 | 7258.0 |
| 2015-03-03 09:00:00 | DIA | ETF | 182.12 | 182.39 | 181.77 | 181.87 | 462937.0 |
| 2015-03-03 10:00:00 | DIA | ETF | 181.85 | 182.1001 | 181.78 | 181.83 | 361347.0 |
| 2015-03-03 11:00:00 | DIA | ETF | 181.82 | 181.84 | 181.19 | 181.44 | 589915.0 |
| 2015-03-03 12:00:00 | DIA | ETF | 181.45 | 181.7 | 181.19 | 181.68 | 314427.0 |
> showing 50 of 7,594 rows — these rows as CSV