PREVIEW / etf_5min / 2019-03-07
file: by_date/etf_5min/2019/2019-03-07.parquet size: 1.4 MB rows: 65,306
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 |
|---|---|---|---|---|---|---|---|
| 2019-03-07 04:00:00 | SPY | ETF | 276.65 | 276.65 | 276.56 | 276.64 | 9296.0 |
| 2019-03-07 04:05:00 | SPY | ETF | 276.69 | 276.7 | 276.66 | 276.66 | 6705.0 |
| 2019-03-07 04:10:00 | SPY | ETF | 276.66 | 276.67 | 276.66 | 276.67 | 500.0 |
| 2019-03-07 04:15:00 | SPY | ETF | 276.69 | 276.69 | 276.69 | 276.69 | 300.0 |
| 2019-03-07 04:20:00 | SPY | ETF | 276.62 | 276.66 | 276.62 | 276.66 | 300.0 |
| 2019-03-07 04:25:00 | SPY | ETF | 276.67 | 276.67 | 276.67 | 276.67 | 436.0 |
| 2019-03-07 04:30:00 | SPY | ETF | 276.65 | 276.7 | 276.65 | 276.7 | 924.0 |
| 2019-03-07 04:40:00 | SPY | ETF | 276.7 | 276.7 | 276.7 | 276.7 | 3400.0 |
| 2019-03-07 04:45:00 | SPY | ETF | 276.74 | 276.74 | 276.7 | 276.7 | 2700.0 |
| 2019-03-07 04:50:00 | SPY | ETF | 276.66 | 276.66 | 276.66 | 276.66 | 1000.0 |
| 2019-03-07 04:55:00 | SPY | ETF | 276.62 | 276.62 | 276.62 | 276.62 | 800.0 |
| 2019-03-07 05:05:00 | SPY | ETF | 276.78 | 276.78 | 276.74 | 276.74 | 200.0 |
| 2019-03-07 05:10:00 | SPY | ETF | 276.69 | 276.72 | 276.69 | 276.72 | 600.0 |
| 2019-03-07 05:15:00 | SPY | ETF | 276.64 | 276.64 | 276.59 | 276.59 | 700.0 |
| 2019-03-07 05:20:00 | SPY | ETF | 276.61 | 276.63 | 276.61 | 276.63 | 1010.0 |
| 2019-03-07 05:25:00 | SPY | ETF | 276.67 | 276.67 | 276.67 | 276.67 | 300.0 |
| 2019-03-07 05:30:00 | SPY | ETF | 276.64 | 276.64 | 276.64 | 276.64 | 550.0 |
| 2019-03-07 05:35:00 | SPY | ETF | 276.69 | 276.69 | 276.66 | 276.66 | 1160.0 |
| 2019-03-07 05:40:00 | SPY | ETF | 276.64 | 276.64 | 276.64 | 276.64 | 300.0 |
| 2019-03-07 05:45:00 | SPY | ETF | 276.68 | 276.69 | 276.68 | 276.69 | 3950.0 |
| 2019-03-07 05:50:00 | SPY | ETF | 276.68 | 276.69 | 276.68 | 276.69 | 1500.0 |
| 2019-03-07 05:55:00 | SPY | ETF | 276.69 | 276.76 | 276.69 | 276.76 | 4100.0 |
| 2019-03-07 06:05:00 | SPY | ETF | 276.71 | 276.71 | 276.71 | 276.71 | 2070.0 |
| 2019-03-07 06:10:00 | SPY | ETF | 276.68 | 276.68 | 276.68 | 276.68 | 100.0 |
| 2019-03-07 06:15:00 | SPY | ETF | 276.74 | 276.77 | 276.74 | 276.77 | 2530.0 |
| 2019-03-07 06:20:00 | SPY | ETF | 276.74 | 276.76 | 276.74 | 276.74 | 2050.0 |
| 2019-03-07 06:25:00 | SPY | ETF | 276.76 | 276.78 | 276.74 | 276.78 | 500.0 |
| 2019-03-07 06:30:00 | SPY | ETF | 276.78 | 276.78 | 276.78 | 276.78 | 870.0 |
| 2019-03-07 06:35:00 | SPY | ETF | 276.78 | 276.78 | 276.73 | 276.73 | 4542.0 |
| 2019-03-07 06:40:00 | SPY | ETF | 276.78 | 276.78 | 276.77 | 276.77 | 1150.0 |
| 2019-03-07 06:45:00 | SPY | ETF | 276.72 | 276.72 | 276.65 | 276.65 | 2069.0 |
| 2019-03-07 06:50:00 | SPY | ETF | 276.57 | 276.76 | 276.57 | 276.76 | 44610.0 |
| 2019-03-07 06:55:00 | SPY | ETF | 276.66 | 276.67 | 276.65 | 276.65 | 3338.0 |
| 2019-03-07 07:00:00 | SPY | ETF | 276.63 | 276.68 | 276.62 | 276.67 | 4178.0 |
| 2019-03-07 07:05:00 | SPY | ETF | 276.67 | 276.89 | 276.65 | 276.89 | 47287.0 |
| 2019-03-07 07:10:00 | SPY | ETF | 276.85 | 276.97 | 276.85 | 276.95 | 5516.0 |
| 2019-03-07 07:15:00 | SPY | ETF | 276.98 | 276.99 | 276.92 | 276.92 | 32142.0 |
| 2019-03-07 07:20:00 | SPY | ETF | 276.93 | 276.96 | 276.93 | 276.93 | 12211.0 |
| 2019-03-07 07:25:00 | SPY | ETF | 276.93 | 276.93 | 276.9 | 276.9 | 500.0 |
| 2019-03-07 07:30:00 | SPY | ETF | 276.92 | 276.92 | 276.85 | 276.87 | 18486.0 |
| 2019-03-07 07:35:00 | SPY | ETF | 276.87 | 276.89 | 276.85 | 276.89 | 7587.0 |
| 2019-03-07 07:40:00 | SPY | ETF | 276.89 | 276.92 | 276.88 | 276.92 | 27832.0 |
| 2019-03-07 07:45:00 | SPY | ETF | 276.9 | 277.25 | 276.9 | 276.96 | 302611.0 |
| 2019-03-07 07:50:00 | SPY | ETF | 276.95 | 277.05 | 276.93 | 277.05 | 6450.0 |
| 2019-03-07 07:55:00 | SPY | ETF | 277.06 | 277.49 | 277.06 | 277.48 | 44247.0 |
| 2019-03-07 08:00:00 | SPY | ETF | 277.51 | 277.51 | 276.62 | 277.5 | 119081.0 |
| 2019-03-07 08:05:00 | SPY | ETF | 277.51 | 277.69 | 277.51 | 277.68 | 70050.0 |
| 2019-03-07 08:10:00 | SPY | ETF | 277.69 | 277.72 | 277.55 | 277.59 | 42989.0 |
| 2019-03-07 08:15:00 | SPY | ETF | 277.62 | 277.62 | 277.45 | 277.53 | 8167.0 |
| 2019-03-07 08:20:00 | SPY | ETF | 277.52 | 277.72 | 277.52 | 277.65 | 32778.0 |
> showing 50 of 65,306 rows — these rows as CSV