PREVIEW / etf_5min / 2014-03-25
file: by_date/etf_5min/2014/2014-03-25.parquet size: 1005 KB rows: 42,778
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-03-25 04:00:00 | SPY | ETF | 185.38 | 185.38 | 185.38 | 185.38 | 600.0 |
| 2014-03-25 04:05:00 | SPY | ETF | 185.45 | 185.49 | 185.45 | 185.49 | 2500.0 |
| 2014-03-25 04:10:00 | SPY | ETF | 185.74 | 185.74 | 185.73 | 185.73 | 200.0 |
| 2014-03-25 04:15:00 | SPY | ETF | 185.7 | 185.74 | 185.7 | 185.74 | 525.0 |
| 2014-03-25 04:45:00 | SPY | ETF | 185.59 | 185.6 | 185.56 | 185.56 | 1800.0 |
| 2014-03-25 04:50:00 | SPY | ETF | 185.53 | 185.53 | 185.52 | 185.52 | 1200.0 |
| 2014-03-25 04:55:00 | SPY | ETF | 185.48 | 185.48 | 185.48 | 185.48 | 400.0 |
| 2014-03-25 05:00:00 | SPY | ETF | 185.46 | 185.52 | 185.46 | 185.5 | 2669.0 |
| 2014-03-25 05:05:00 | SPY | ETF | 185.56 | 185.68 | 185.56 | 185.68 | 3200.0 |
| 2014-03-25 05:10:00 | SPY | ETF | 185.72 | 185.72 | 185.64 | 185.64 | 687.0 |
| 2014-03-25 05:15:00 | SPY | ETF | 185.6 | 185.6 | 185.6 | 185.6 | 400.0 |
| 2014-03-25 05:20:00 | SPY | ETF | 185.56 | 185.6 | 185.54 | 185.6 | 1120.0 |
| 2014-03-25 05:25:00 | SPY | ETF | 185.64 | 185.69 | 185.64 | 185.69 | 1347.0 |
| 2014-03-25 05:30:00 | SPY | ETF | 185.72 | 185.8 | 185.72 | 185.8 | 3394.0 |
| 2014-03-25 05:35:00 | SPY | ETF | 185.76 | 185.76 | 185.76 | 185.76 | 414.0 |
| 2014-03-25 05:40:00 | SPY | ETF | 185.79 | 185.79 | 185.68 | 185.68 | 4543.0 |
| 2014-03-25 05:45:00 | SPY | ETF | 185.72 | 185.72 | 185.72 | 185.72 | 200.0 |
| 2014-03-25 05:50:00 | SPY | ETF | 185.76 | 185.76 | 185.72 | 185.72 | 800.0 |
| 2014-03-25 05:55:00 | SPY | ETF | 185.76 | 185.76 | 185.76 | 185.76 | 1000.0 |
| 2014-03-25 06:00:00 | SPY | ETF | 185.74 | 185.74 | 185.7 | 185.7 | 1959.0 |
| 2014-03-25 06:05:00 | SPY | ETF | 185.68 | 185.69 | 185.64 | 185.68 | 12200.0 |
| 2014-03-25 06:20:00 | SPY | ETF | 185.7 | 185.72 | 185.69 | 185.69 | 756.0 |
| 2014-03-25 06:25:00 | SPY | ETF | 185.7 | 185.7 | 185.7 | 185.7 | 200.0 |
| 2014-03-25 06:35:00 | SPY | ETF | 185.72 | 185.72 | 185.68 | 185.68 | 500.0 |
| 2014-03-25 06:40:00 | SPY | ETF | 185.67 | 185.67 | 185.67 | 185.67 | 1000.0 |
| 2014-03-25 06:45:00 | SPY | ETF | 185.7 | 185.7 | 185.69 | 185.69 | 750.0 |
| 2014-03-25 06:50:00 | SPY | ETF | 185.71 | 185.8 | 185.71 | 185.8 | 3000.0 |
| 2014-03-25 06:55:00 | SPY | ETF | 185.8 | 185.8 | 185.75 | 185.75 | 32975.0 |
| 2014-03-25 07:00:00 | SPY | ETF | 185.78 | 185.78 | 185.72 | 185.73 | 16011.0 |
| 2014-03-25 07:05:00 | SPY | ETF | 185.72 | 185.72 | 185.68 | 185.68 | 8100.0 |
| 2014-03-25 07:10:00 | SPY | ETF | 185.72 | 185.75 | 185.71 | 185.74 | 8760.0 |
| 2014-03-25 07:15:00 | SPY | ETF | 185.73 | 185.78 | 185.73 | 185.78 | 43790.0 |
| 2014-03-25 07:20:00 | SPY | ETF | 185.78 | 185.87 | 185.78 | 185.87 | 13036.0 |
| 2014-03-25 07:25:00 | SPY | ETF | 185.87 | 185.94 | 185.87 | 185.91 | 4757.0 |
| 2014-03-25 07:30:00 | SPY | ETF | 185.91 | 186.02 | 185.91 | 186.02 | 70243.0 |
| 2014-03-25 07:35:00 | SPY | ETF | 186.02 | 186.12 | 185.98 | 185.98 | 30053.0 |
| 2014-03-25 07:40:00 | SPY | ETF | 186.03 | 186.03 | 186.0 | 186.0 | 11000.0 |
| 2014-03-25 07:45:00 | SPY | ETF | 185.98 | 186.01 | 185.96 | 186.01 | 16194.0 |
| 2014-03-25 07:50:00 | SPY | ETF | 186.03 | 186.03 | 186.01 | 186.01 | 13000.0 |
| 2014-03-25 07:55:00 | SPY | ETF | 186.03 | 186.05 | 185.98 | 186.0 | 19736.0 |
| 2014-03-25 08:00:00 | SPY | ETF | 186.01 | 186.1 | 185.98 | 186.08 | 29648.0 |
| 2014-03-25 08:05:00 | SPY | ETF | 186.08 | 186.09 | 186.03 | 186.04 | 26117.0 |
| 2014-03-25 08:10:00 | SPY | ETF | 186.05 | 186.11 | 186.03 | 186.1 | 29624.0 |
| 2014-03-25 08:15:00 | SPY | ETF | 186.11 | 186.13 | 186.06 | 186.08 | 32493.0 |
| 2014-03-25 08:20:00 | SPY | ETF | 186.08 | 186.11 | 186.04 | 186.08 | 75103.0 |
| 2014-03-25 08:25:00 | SPY | ETF | 186.12 | 186.14 | 186.08 | 186.131 | 55628.0 |
| 2014-03-25 08:30:00 | SPY | ETF | 186.14 | 186.24 | 186.14 | 186.19 | 57635.0 |
| 2014-03-25 08:35:00 | SPY | ETF | 186.18 | 186.22 | 186.18 | 186.2 | 21366.0 |
| 2014-03-25 08:40:00 | SPY | ETF | 186.19 | 186.21 | 186.14 | 186.14 | 29759.0 |
| 2014-03-25 08:45:00 | SPY | ETF | 186.15 | 186.19 | 186.13 | 186.16 | 28495.0 |
> showing 50 of 42,778 rows — these rows as CSV