PREVIEW / etf_5min / 2013-11-12
file: by_date/etf_5min/2013/2013-11-12.parquet size: 938 KB rows: 39,683
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-12 04:00:00 | SPY | ETF | 177.12 | 177.12 | 176.99 | 176.99 | 2039.0 |
| 2013-11-12 04:05:00 | SPY | ETF | 177.0 | 177.04 | 177.0 | 177.04 | 200.0 |
| 2013-11-12 04:10:00 | SPY | ETF | 177.05 | 177.05 | 177.01 | 177.01 | 10400.0 |
| 2013-11-12 04:15:00 | SPY | ETF | 176.98 | 177.05 | 176.9 | 176.91 | 25680.0 |
| 2013-11-12 04:20:00 | SPY | ETF | 176.9 | 176.9 | 176.85 | 176.85 | 6250.0 |
| 2013-11-12 04:25:00 | SPY | ETF | 176.86 | 176.86 | 176.82 | 176.83 | 300.0 |
| 2013-11-12 04:30:00 | SPY | ETF | 176.85 | 176.85 | 176.85 | 176.85 | 200.0 |
| 2013-11-12 04:35:00 | SPY | ETF | 176.81 | 176.81 | 176.81 | 176.81 | 1200.0 |
| 2013-11-12 04:40:00 | SPY | ETF | 176.83 | 176.83 | 176.83 | 176.83 | 100.0 |
| 2013-11-12 04:45:00 | SPY | ETF | 176.87 | 176.92 | 176.87 | 176.92 | 511.0 |
| 2013-11-12 04:50:00 | SPY | ETF | 176.91 | 176.91 | 176.91 | 176.91 | 309.0 |
| 2013-11-12 04:55:00 | SPY | ETF | 176.91 | 176.91 | 176.91 | 176.91 | 100.0 |
| 2013-11-12 05:10:00 | SPY | ETF | 176.89 | 176.96 | 176.89 | 176.96 | 1600.0 |
| 2013-11-12 05:20:00 | SPY | ETF | 176.95 | 176.95 | 176.95 | 176.95 | 1000.0 |
| 2013-11-12 05:25:00 | SPY | ETF | 176.95 | 176.97 | 176.95 | 176.96 | 5400.0 |
| 2013-11-12 05:30:00 | SPY | ETF | 176.95 | 176.95 | 176.95 | 176.95 | 100.0 |
| 2013-11-12 05:40:00 | SPY | ETF | 176.97 | 176.97 | 176.97 | 176.97 | 100.0 |
| 2013-11-12 05:45:00 | SPY | ETF | 176.93 | 176.93 | 176.93 | 176.93 | 200.0 |
| 2013-11-12 05:55:00 | SPY | ETF | 176.91 | 176.94 | 176.91 | 176.94 | 4100.0 |
| 2013-11-12 06:00:00 | SPY | ETF | 176.94 | 176.94 | 176.94 | 176.94 | 15000.0 |
| 2013-11-12 06:05:00 | SPY | ETF | 176.89 | 176.89 | 176.89 | 176.89 | 3400.0 |
| 2013-11-12 06:10:00 | SPY | ETF | 176.87 | 176.91 | 176.87 | 176.91 | 500.0 |
| 2013-11-12 06:15:00 | SPY | ETF | 176.95 | 176.95 | 176.89 | 176.89 | 4900.0 |
| 2013-11-12 06:20:00 | SPY | ETF | 176.91 | 177.01 | 176.91 | 177.01 | 1500.0 |
| 2013-11-12 06:25:00 | SPY | ETF | 177.02 | 177.02 | 177.02 | 177.02 | 200.0 |
| 2013-11-12 06:35:00 | SPY | ETF | 176.98 | 176.98 | 176.97 | 176.97 | 400.0 |
| 2013-11-12 06:40:00 | SPY | ETF | 176.95 | 176.95 | 176.88 | 176.91 | 42700.0 |
| 2013-11-12 06:45:00 | SPY | ETF | 176.9 | 176.9 | 176.89 | 176.9 | 32300.0 |
| 2013-11-12 06:50:00 | SPY | ETF | 176.89 | 176.94 | 176.85 | 176.85 | 10500.0 |
| 2013-11-12 06:55:00 | SPY | ETF | 176.87 | 176.95 | 176.87 | 176.93 | 14000.0 |
| 2013-11-12 07:00:00 | SPY | ETF | 176.94 | 176.96 | 176.92 | 176.96 | 18000.0 |
| 2013-11-12 07:05:00 | SPY | ETF | 176.94 | 176.94 | 176.94 | 176.94 | 2700.0 |
| 2013-11-12 07:10:00 | SPY | ETF | 176.96 | 176.96 | 176.94 | 176.94 | 2200.0 |
| 2013-11-12 07:15:00 | SPY | ETF | 176.95 | 177.0 | 176.95 | 177.0 | 2200.0 |
| 2013-11-12 07:20:00 | SPY | ETF | 176.98 | 177.04 | 176.98 | 177.01 | 7072.0 |
| 2013-11-12 07:25:00 | SPY | ETF | 177.01 | 177.01 | 176.99 | 176.99 | 12158.0 |
| 2013-11-12 07:30:00 | SPY | ETF | 176.97 | 177.03 | 176.97 | 177.0 | 14200.0 |
| 2013-11-12 07:35:00 | SPY | ETF | 177.03 | 177.03 | 177.03 | 177.03 | 600.0 |
| 2013-11-12 07:40:00 | SPY | ETF | 177.04 | 177.06 | 177.03 | 177.03 | 3145.0 |
| 2013-11-12 07:45:00 | SPY | ETF | 177.04 | 177.09 | 177.04 | 177.09 | 11200.0 |
| 2013-11-12 07:50:00 | SPY | ETF | 177.07 | 177.07 | 176.99 | 176.99 | 2900.0 |
| 2013-11-12 07:55:00 | SPY | ETF | 177.01 | 177.01 | 176.94 | 176.94 | 18600.0 |
| 2013-11-12 08:00:00 | SPY | ETF | 176.99 | 177.03 | 176.94 | 177.0 | 23875.0 |
| 2013-11-12 08:05:00 | SPY | ETF | 177.02 | 177.04 | 176.98 | 176.99 | 5665.0 |
| 2013-11-12 08:10:00 | SPY | ETF | 176.98 | 176.98 | 176.78 | 176.84 | 106720.0 |
| 2013-11-12 08:15:00 | SPY | ETF | 176.85 | 176.86 | 176.75 | 176.78 | 220338.0 |
| 2013-11-12 08:20:00 | SPY | ETF | 176.79 | 177.29 | 176.79 | 176.86 | 91100.0 |
| 2013-11-12 08:25:00 | SPY | ETF | 176.86 | 176.91 | 176.83 | 176.83 | 24936.0 |
| 2013-11-12 08:30:00 | SPY | ETF | 176.83 | 176.84 | 176.81 | 176.83 | 20543.0 |
| 2013-11-12 08:35:00 | SPY | ETF | 176.83 | 176.89 | 176.81 | 176.88 | 39450.0 |
> showing 50 of 39,683 rows — these rows as CSV