PREVIEW / etf_5min / 2014-05-08
file: by_date/etf_5min/2014/2014-05-08.parquet size: 1012 KB rows: 43,035
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-08 04:00:00 | SPY | ETF | 188.13 | 188.13 | 188.08 | 188.08 | 742.0 |
| 2014-05-08 04:05:00 | SPY | ETF | 188.04 | 188.04 | 188.04 | 188.04 | 244.0 |
| 2014-05-08 04:15:00 | SPY | ETF | 187.99 | 187.99 | 187.99 | 187.99 | 100.0 |
| 2014-05-08 04:20:00 | SPY | ETF | 188.02 | 188.02 | 188.02 | 188.02 | 150.0 |
| 2014-05-08 04:35:00 | SPY | ETF | 188.08 | 188.08 | 188.08 | 188.08 | 189.0 |
| 2014-05-08 04:40:00 | SPY | ETF | 188.08 | 188.08 | 188.01 | 188.01 | 200.0 |
| 2014-05-08 04:55:00 | SPY | ETF | 188.07 | 188.09 | 188.07 | 188.09 | 738.0 |
| 2014-05-08 05:20:00 | SPY | ETF | 188.05 | 188.05 | 187.98 | 187.98 | 600.0 |
| 2014-05-08 05:35:00 | SPY | ETF | 188.02 | 188.15 | 188.02 | 188.15 | 5100.0 |
| 2014-05-08 05:45:00 | SPY | ETF | 188.1 | 188.1 | 188.06 | 188.06 | 998.0 |
| 2014-05-08 05:50:00 | SPY | ETF | 188.09 | 188.09 | 188.02 | 188.02 | 500.0 |
| 2014-05-08 05:55:00 | SPY | ETF | 187.98 | 188.03 | 187.98 | 188.03 | 1800.0 |
| 2014-05-08 06:00:00 | SPY | ETF | 187.99 | 187.99 | 187.94 | 187.94 | 875.0 |
| 2014-05-08 06:05:00 | SPY | ETF | 187.98 | 187.98 | 187.98 | 187.98 | 700.0 |
| 2014-05-08 06:10:00 | SPY | ETF | 188.02 | 188.06 | 188.02 | 188.06 | 674.0 |
| 2014-05-08 06:15:00 | SPY | ETF | 188.06 | 188.06 | 188.03 | 188.03 | 305.0 |
| 2014-05-08 06:20:00 | SPY | ETF | 188.02 | 188.02 | 188.02 | 188.02 | 399.0 |
| 2014-05-08 06:25:00 | SPY | ETF | 187.99 | 188.01 | 187.98 | 188.01 | 600.0 |
| 2014-05-08 06:30:00 | SPY | ETF | 188.02 | 188.02 | 188.02 | 188.02 | 436.0 |
| 2014-05-08 06:50:00 | SPY | ETF | 188.05 | 188.05 | 188.05 | 188.05 | 1400.0 |
| 2014-05-08 06:55:00 | SPY | ETF | 188.01 | 188.01 | 188.0 | 188.0 | 2100.0 |
| 2014-05-08 07:00:00 | SPY | ETF | 188.03 | 188.06 | 188.01 | 188.04 | 1990.0 |
| 2014-05-08 07:05:00 | SPY | ETF | 188.06 | 188.2 | 188.06 | 188.08 | 26334.0 |
| 2014-05-08 07:10:00 | SPY | ETF | 188.1 | 188.13 | 188.1 | 188.13 | 738.0 |
| 2014-05-08 07:15:00 | SPY | ETF | 188.13 | 188.14 | 188.13 | 188.14 | 1908.0 |
| 2014-05-08 07:20:00 | SPY | ETF | 188.1 | 188.13 | 188.1 | 188.13 | 3915.0 |
| 2014-05-08 07:25:00 | SPY | ETF | 188.13 | 188.13 | 188.1 | 188.1 | 1200.0 |
| 2014-05-08 07:30:00 | SPY | ETF | 188.08 | 188.1 | 188.06 | 188.1 | 515.0 |
| 2014-05-08 07:35:00 | SPY | ETF | 188.1 | 188.1 | 188.1 | 188.1 | 35078.0 |
| 2014-05-08 07:40:00 | SPY | ETF | 188.08 | 188.13 | 188.01 | 188.01 | 32765.0 |
| 2014-05-08 07:45:00 | SPY | ETF | 188.01 | 188.01 | 187.76 | 187.77 | 47287.0 |
| 2014-05-08 07:50:00 | SPY | ETF | 187.76 | 187.82 | 187.71 | 187.8 | 32400.0 |
| 2014-05-08 07:55:00 | SPY | ETF | 187.81 | 187.82 | 187.77 | 187.8 | 12150.0 |
| 2014-05-08 08:00:00 | SPY | ETF | 187.75 | 188.14 | 187.7 | 187.71 | 69268.0 |
| 2014-05-08 08:05:00 | SPY | ETF | 187.7 | 187.74 | 187.63 | 187.66 | 91795.0 |
| 2014-05-08 08:10:00 | SPY | ETF | 187.66 | 187.72 | 187.65 | 187.72 | 62982.0 |
| 2014-05-08 08:15:00 | SPY | ETF | 187.73 | 187.79 | 187.68 | 187.68 | 59127.0 |
| 2014-05-08 08:20:00 | SPY | ETF | 187.69 | 187.69 | 187.62 | 187.65 | 46200.0 |
| 2014-05-08 08:25:00 | SPY | ETF | 187.67 | 187.71 | 187.66 | 187.67 | 31525.0 |
| 2014-05-08 08:30:00 | SPY | ETF | 187.66 | 187.84 | 187.54 | 187.61 | 151274.0 |
| 2014-05-08 08:35:00 | SPY | ETF | 187.6 | 187.6 | 187.39 | 187.52 | 192473.0 |
| 2014-05-08 08:40:00 | SPY | ETF | 187.48 | 187.57 | 187.48 | 187.5 | 40337.0 |
| 2014-05-08 08:45:00 | SPY | ETF | 187.52 | 187.55 | 187.44 | 187.55 | 200030.0 |
| 2014-05-08 08:50:00 | SPY | ETF | 187.54 | 187.85 | 187.48 | 187.81 | 208656.0 |
| 2014-05-08 08:55:00 | SPY | ETF | 187.81 | 187.89 | 187.58 | 187.64 | 170162.0 |
| 2014-05-08 09:00:00 | SPY | ETF | 187.65 | 187.72 | 187.59 | 187.65 | 120515.0 |
| 2014-05-08 09:05:00 | SPY | ETF | 187.65 | 187.68 | 187.59 | 187.66 | 71192.0 |
| 2014-05-08 09:10:00 | SPY | ETF | 187.63 | 187.63 | 187.53 | 187.63 | 92076.0 |
| 2014-05-08 09:15:00 | SPY | ETF | 187.64 | 187.65 | 187.56 | 187.6 | 74049.0 |
| 2014-05-08 09:20:00 | SPY | ETF | 187.6 | 187.6 | 187.48 | 187.54 | 102271.0 |
> showing 50 of 43,035 rows — these rows as CSV