PREVIEW / etf_5min / 2013-11-21
file: by_date/etf_5min/2013/2013-11-21.parquet size: 964 KB rows: 40,832
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-21 04:00:00 | SPY | ETF | 178.47 | 178.47 | 178.38 | 178.4 | 10194.0 |
| 2013-11-21 04:05:00 | SPY | ETF | 178.39 | 178.39 | 178.34 | 178.34 | 600.0 |
| 2013-11-21 04:10:00 | SPY | ETF | 178.39 | 178.42 | 178.39 | 178.42 | 200.0 |
| 2013-11-21 04:15:00 | SPY | ETF | 178.45 | 178.52 | 178.42 | 178.47 | 56200.0 |
| 2013-11-21 04:20:00 | SPY | ETF | 178.49 | 178.58 | 178.49 | 178.57 | 30200.0 |
| 2013-11-21 04:25:00 | SPY | ETF | 178.54 | 178.6 | 178.54 | 178.57 | 25500.0 |
| 2013-11-21 04:30:00 | SPY | ETF | 178.6 | 178.66 | 178.6 | 178.66 | 5950.0 |
| 2013-11-21 04:35:00 | SPY | ETF | 178.69 | 178.69 | 178.6 | 178.69 | 3200.0 |
| 2013-11-21 04:40:00 | SPY | ETF | 178.66 | 178.71 | 178.66 | 178.71 | 2296.0 |
| 2013-11-21 04:45:00 | SPY | ETF | 178.71 | 178.72 | 178.66 | 178.66 | 1321.0 |
| 2013-11-21 04:50:00 | SPY | ETF | 178.71 | 178.8 | 178.71 | 178.75 | 15700.0 |
| 2013-11-21 04:55:00 | SPY | ETF | 178.72 | 178.72 | 178.71 | 178.71 | 1600.0 |
| 2013-11-21 05:00:00 | SPY | ETF | 178.69 | 178.69 | 178.66 | 178.68 | 6855.0 |
| 2013-11-21 05:05:00 | SPY | ETF | 178.66 | 178.71 | 178.66 | 178.71 | 2000.0 |
| 2013-11-21 05:10:00 | SPY | ETF | 178.72 | 178.78 | 178.72 | 178.78 | 1027.0 |
| 2013-11-21 05:15:00 | SPY | ETF | 178.75 | 178.79 | 178.74 | 178.79 | 11500.0 |
| 2013-11-21 05:20:00 | SPY | ETF | 178.81 | 178.83 | 178.81 | 178.83 | 1200.0 |
| 2013-11-21 05:25:00 | SPY | ETF | 178.84 | 178.84 | 178.84 | 178.84 | 1700.0 |
| 2013-11-21 05:30:00 | SPY | ETF | 178.84 | 178.85 | 178.82 | 178.83 | 400.0 |
| 2013-11-21 05:35:00 | SPY | ETF | 178.86 | 178.87 | 178.85 | 178.86 | 1700.0 |
| 2013-11-21 05:40:00 | SPY | ETF | 178.84 | 178.84 | 178.84 | 178.84 | 1800.0 |
| 2013-11-21 05:45:00 | SPY | ETF | 178.86 | 178.87 | 178.84 | 178.84 | 1400.0 |
| 2013-11-21 05:50:00 | SPY | ETF | 178.81 | 178.81 | 178.81 | 178.81 | 1400.0 |
| 2013-11-21 05:55:00 | SPY | ETF | 178.83 | 178.89 | 178.82 | 178.89 | 610.0 |
| 2013-11-21 06:00:00 | SPY | ETF | 178.84 | 178.87 | 178.83 | 178.87 | 3380.0 |
| 2013-11-21 06:05:00 | SPY | ETF | 178.87 | 178.87 | 178.81 | 178.81 | 7500.0 |
| 2013-11-21 06:10:00 | SPY | ETF | 178.84 | 178.84 | 178.84 | 178.84 | 100.0 |
| 2013-11-21 06:15:00 | SPY | ETF | 178.87 | 178.88 | 178.86 | 178.88 | 4600.0 |
| 2013-11-21 06:20:00 | SPY | ETF | 178.84 | 178.87 | 178.84 | 178.84 | 400.0 |
| 2013-11-21 06:25:00 | SPY | ETF | 178.87 | 178.89 | 178.86 | 178.86 | 3600.0 |
| 2013-11-21 06:30:00 | SPY | ETF | 178.84 | 178.84 | 178.84 | 178.84 | 100.0 |
| 2013-11-21 06:35:00 | SPY | ETF | 178.82 | 178.82 | 178.8 | 178.8 | 609.0 |
| 2013-11-21 06:40:00 | SPY | ETF | 178.83 | 178.83 | 178.78 | 178.78 | 4051.0 |
| 2013-11-21 06:45:00 | SPY | ETF | 178.78 | 178.78 | 178.69 | 178.69 | 800.0 |
| 2013-11-21 06:50:00 | SPY | ETF | 178.69 | 178.72 | 178.68 | 178.72 | 3500.0 |
| 2013-11-21 06:55:00 | SPY | ETF | 178.71 | 178.75 | 178.71 | 178.75 | 600.0 |
| 2013-11-21 07:00:00 | SPY | ETF | 178.76 | 178.76 | 178.73 | 178.73 | 3000.0 |
| 2013-11-21 07:05:00 | SPY | ETF | 178.76 | 178.76 | 178.73 | 178.73 | 1199.0 |
| 2013-11-21 07:10:00 | SPY | ETF | 178.74 | 178.74 | 178.74 | 178.74 | 5100.0 |
| 2013-11-21 07:15:00 | SPY | ETF | 178.76 | 178.77 | 178.76 | 178.76 | 900.0 |
| 2013-11-21 07:20:00 | SPY | ETF | 178.76 | 178.76 | 178.72 | 178.75 | 9800.0 |
| 2013-11-21 07:25:00 | SPY | ETF | 178.75 | 178.75 | 178.7 | 178.7 | 8000.0 |
| 2013-11-21 07:30:00 | SPY | ETF | 178.74 | 178.74 | 178.72 | 178.72 | 9500.0 |
| 2013-11-21 07:35:00 | SPY | ETF | 178.73 | 178.77 | 178.73 | 178.77 | 4500.0 |
| 2013-11-21 07:40:00 | SPY | ETF | 178.76 | 178.84 | 178.76 | 178.82 | 17000.0 |
| 2013-11-21 07:45:00 | SPY | ETF | 178.81 | 178.85 | 178.81 | 178.84 | 19625.0 |
| 2013-11-21 07:50:00 | SPY | ETF | 178.83 | 178.86 | 178.83 | 178.84 | 3400.0 |
| 2013-11-21 07:55:00 | SPY | ETF | 178.84 | 178.96 | 178.84 | 178.88 | 31256.0 |
| 2013-11-21 08:00:00 | SPY | ETF | 178.88 | 178.96 | 178.82 | 178.93 | 183725.0 |
| 2013-11-21 08:05:00 | SPY | ETF | 178.96 | 178.97 | 178.91 | 178.91 | 10740.0 |
> showing 50 of 40,832 rows — these rows as CSV