PREVIEW / etf_5min / 2014-06-16
file: by_date/etf_5min/2014/2014-06-16.parquet size: 948 KB rows: 40,727
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-06-16 04:15:00 | SPY | ETF | 193.7 | 193.7 | 193.7 | 193.7 | 100.0 |
| 2014-06-16 04:25:00 | SPY | ETF | 193.53 | 193.53 | 193.53 | 193.53 | 435.0 |
| 2014-06-16 06:00:00 | SPY | ETF | 193.99 | 194.42 | 193.53 | 193.6 | 24919.0 |
| 2014-06-16 06:05:00 | SPY | ETF | 193.62 | 193.63 | 193.62 | 193.63 | 500.0 |
| 2014-06-16 06:10:00 | SPY | ETF | 193.65 | 193.67 | 193.6 | 193.67 | 2300.0 |
| 2014-06-16 06:15:00 | SPY | ETF | 193.71 | 193.71 | 193.65 | 193.7 | 38610.0 |
| 2014-06-16 06:20:00 | SPY | ETF | 193.7 | 193.72 | 193.67 | 193.72 | 4202.0 |
| 2014-06-16 06:30:00 | SPY | ETF | 193.71 | 193.74 | 193.7 | 193.74 | 13500.0 |
| 2014-06-16 06:35:00 | SPY | ETF | 193.75 | 193.78 | 193.75 | 193.78 | 650.0 |
| 2014-06-16 06:40:00 | SPY | ETF | 193.74 | 193.74 | 193.7 | 193.7 | 1500.0 |
| 2014-06-16 06:50:00 | SPY | ETF | 193.7 | 193.7 | 193.7 | 193.7 | 125.0 |
| 2014-06-16 06:55:00 | SPY | ETF | 193.7 | 193.72 | 193.65 | 193.67 | 15300.0 |
| 2014-06-16 07:00:00 | SPY | ETF | 193.71 | 193.72 | 193.7 | 193.7 | 1539.0 |
| 2014-06-16 07:05:00 | SPY | ETF | 193.74 | 193.76 | 193.74 | 193.76 | 5408.0 |
| 2014-06-16 07:10:00 | SPY | ETF | 193.76 | 193.77 | 193.65 | 193.65 | 23053.0 |
| 2014-06-16 07:15:00 | SPY | ETF | 193.65 | 193.7 | 193.65 | 193.69 | 1725.0 |
| 2014-06-16 07:20:00 | SPY | ETF | 193.69 | 193.69 | 193.62 | 193.65 | 15350.0 |
| 2014-06-16 07:25:00 | SPY | ETF | 193.67 | 193.7 | 193.6 | 193.62 | 30700.0 |
| 2014-06-16 07:30:00 | SPY | ETF | 193.66 | 193.7 | 193.66 | 193.7 | 20600.0 |
| 2014-06-16 07:35:00 | SPY | ETF | 193.7 | 193.74 | 193.67 | 193.67 | 4850.0 |
| 2014-06-16 07:40:00 | SPY | ETF | 193.69 | 193.71 | 193.69 | 193.71 | 10100.0 |
| 2014-06-16 07:45:00 | SPY | ETF | 193.73 | 193.75 | 193.68 | 193.75 | 57848.0 |
| 2014-06-16 07:50:00 | SPY | ETF | 193.73 | 193.73 | 193.68 | 193.69 | 7988.0 |
| 2014-06-16 07:55:00 | SPY | ETF | 193.7 | 193.77 | 193.7 | 193.73 | 13600.0 |
| 2014-06-16 08:00:00 | SPY | ETF | 193.777 | 193.777 | 193.64 | 193.64 | 243029.0 |
| 2014-06-16 08:05:00 | SPY | ETF | 193.66 | 193.71 | 193.66 | 193.71 | 58776.0 |
| 2014-06-16 08:10:00 | SPY | ETF | 193.69 | 193.69 | 193.64 | 193.64 | 23100.0 |
| 2014-06-16 08:15:00 | SPY | ETF | 193.64 | 193.67 | 193.64 | 193.67 | 5000.0 |
| 2014-06-16 08:20:00 | SPY | ETF | 193.7 | 193.73 | 193.7 | 193.73 | 5245.0 |
| 2014-06-16 08:25:00 | SPY | ETF | 193.72 | 193.78 | 193.71 | 193.78 | 15955.0 |
| 2014-06-16 08:30:00 | SPY | ETF | 193.78 | 193.8 | 193.76 | 193.79 | 52154.0 |
| 2014-06-16 08:35:00 | SPY | ETF | 193.8 | 193.81 | 193.76 | 193.81 | 61771.0 |
| 2014-06-16 08:40:00 | SPY | ETF | 193.83 | 193.9 | 193.83 | 193.84 | 254023.0 |
| 2014-06-16 08:45:00 | SPY | ETF | 193.84 | 193.88 | 193.82 | 193.88 | 252990.0 |
| 2014-06-16 08:50:00 | SPY | ETF | 193.84 | 193.88 | 193.82 | 193.86 | 59806.0 |
| 2014-06-16 08:55:00 | SPY | ETF | 193.85 | 193.85 | 193.82 | 193.85 | 5403.0 |
| 2014-06-16 09:00:00 | SPY | ETF | 193.86 | 193.87 | 193.8 | 193.83 | 83389.0 |
| 2014-06-16 09:05:00 | SPY | ETF | 193.83 | 193.9 | 193.83 | 193.86 | 24465.0 |
| 2014-06-16 09:10:00 | SPY | ETF | 193.87 | 193.88 | 193.8 | 193.8 | 45420.0 |
| 2014-06-16 09:15:00 | SPY | ETF | 193.82 | 193.93 | 193.82 | 193.93 | 75188.0 |
| 2014-06-16 09:20:00 | SPY | ETF | 193.925 | 193.98 | 193.9 | 193.94 | 212275.0 |
| 2014-06-16 09:25:00 | SPY | ETF | 193.94 | 193.96 | 193.88 | 193.9 | 1189727.0 |
| 2014-06-16 09:30:00 | SPY | ETF | 193.89 | 193.96 | 193.73 | 193.85 | 2492049.0 |
| 2014-06-16 09:35:00 | SPY | ETF | 193.84 | 194.28 | 193.82 | 194.25 | 1881744.0 |
| 2014-06-16 09:40:00 | SPY | ETF | 194.25 | 194.36 | 194.22 | 194.3 | 1350666.0 |
| 2014-06-16 09:45:00 | SPY | ETF | 194.31 | 194.4 | 194.3001 | 194.38 | 2629851.0 |
| 2014-06-16 09:50:00 | SPY | ETF | 194.38 | 194.41 | 194.32 | 194.37 | 1780626.0 |
| 2014-06-16 09:55:00 | SPY | ETF | 194.36 | 194.42 | 194.26 | 194.27 | 1493064.0 |
| 2014-06-16 10:00:00 | SPY | ETF | 194.28 | 194.56 | 194.25 | 194.55 | 1231692.0 |
| 2014-06-16 10:05:00 | SPY | ETF | 194.56 | 194.62 | 194.49 | 194.5 | 2187263.0 |
> showing 50 of 40,727 rows — these rows as CSV