PREVIEW / etf_5min / 2019-12-18
file: by_date/etf_5min/2019/2019-12-18.parquet size: 1.4 MB rows: 63,914
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-12-18 04:00:00 | SPY | ETF | 319.69 | 319.69 | 319.69 | 319.69 | 351.0 |
| 2019-12-18 04:15:00 | SPY | ETF | 319.64 | 319.64 | 319.64 | 319.64 | 200.0 |
| 2019-12-18 04:20:00 | SPY | ETF | 319.67 | 319.67 | 319.67 | 319.67 | 3400.0 |
| 2019-12-18 04:25:00 | SPY | ETF | 319.75 | 319.77 | 319.75 | 319.77 | 403.0 |
| 2019-12-18 04:30:00 | SPY | ETF | 319.82 | 319.84 | 319.82 | 319.84 | 1630.0 |
| 2019-12-18 04:35:00 | SPY | ETF | 319.82 | 319.82 | 319.82 | 319.82 | 1000.0 |
| 2019-12-18 04:40:00 | SPY | ETF | 319.79 | 319.79 | 319.79 | 319.79 | 1010.0 |
| 2019-12-18 04:45:00 | SPY | ETF | 319.8 | 319.84 | 319.79 | 319.84 | 900.0 |
| 2019-12-18 04:50:00 | SPY | ETF | 319.85 | 319.85 | 319.85 | 319.85 | 1803.0 |
| 2019-12-18 04:55:00 | SPY | ETF | 319.87 | 319.87 | 319.87 | 319.87 | 600.0 |
| 2019-12-18 05:05:00 | SPY | ETF | 319.87 | 319.89 | 319.87 | 319.89 | 806.0 |
| 2019-12-18 05:10:00 | SPY | ETF | 319.83 | 319.83 | 319.83 | 319.83 | 400.0 |
| 2019-12-18 05:15:00 | SPY | ETF | 319.83 | 319.85 | 319.83 | 319.83 | 3353.0 |
| 2019-12-18 05:25:00 | SPY | ETF | 319.85 | 319.85 | 319.85 | 319.85 | 100.0 |
| 2019-12-18 05:35:00 | SPY | ETF | 319.8 | 319.8 | 319.8 | 319.8 | 500.0 |
| 2019-12-18 05:40:00 | SPY | ETF | 319.8 | 319.8 | 319.8 | 319.8 | 100.0 |
| 2019-12-18 05:55:00 | SPY | ETF | 319.88 | 319.88 | 319.87 | 319.87 | 900.0 |
| 2019-12-18 06:10:00 | SPY | ETF | 319.79 | 319.79 | 319.79 | 319.79 | 500.0 |
| 2019-12-18 06:15:00 | SPY | ETF | 319.73 | 319.73 | 319.73 | 319.73 | 400.0 |
| 2019-12-18 06:20:00 | SPY | ETF | 319.7 | 319.72 | 319.7 | 319.72 | 1250.0 |
| 2019-12-18 06:25:00 | SPY | ETF | 319.72 | 319.72 | 319.69 | 319.7 | 1800.0 |
| 2019-12-18 06:30:00 | SPY | ETF | 319.7 | 319.74 | 319.7 | 319.7 | 1403.0 |
| 2019-12-18 06:35:00 | SPY | ETF | 319.77 | 319.77 | 319.77 | 319.77 | 3703.0 |
| 2019-12-18 06:40:00 | SPY | ETF | 319.69 | 319.69 | 319.69 | 319.69 | 400.0 |
| 2019-12-18 06:45:00 | SPY | ETF | 319.63 | 319.65 | 319.63 | 319.65 | 653.0 |
| 2019-12-18 06:50:00 | SPY | ETF | 319.62 | 319.64 | 319.59 | 319.64 | 2944.0 |
| 2019-12-18 06:55:00 | SPY | ETF | 319.64 | 319.64 | 319.62 | 319.64 | 903.0 |
| 2019-12-18 07:00:00 | SPY | ETF | 319.69 | 319.69 | 319.65 | 319.65 | 1735.0 |
| 2019-12-18 07:05:00 | SPY | ETF | 319.64 | 319.67 | 319.62 | 319.62 | 4452.0 |
| 2019-12-18 07:10:00 | SPY | ETF | 319.66 | 319.66 | 319.6 | 319.6 | 4102.0 |
| 2019-12-18 07:15:00 | SPY | ETF | 319.57 | 319.57 | 319.5 | 319.57 | 1364.0 |
| 2019-12-18 07:20:00 | SPY | ETF | 319.57 | 319.6 | 319.57 | 319.6 | 2928.0 |
| 2019-12-18 07:25:00 | SPY | ETF | 319.61 | 319.68 | 319.61 | 319.68 | 2644.0 |
| 2019-12-18 07:30:00 | SPY | ETF | 319.71 | 319.72 | 319.71 | 319.72 | 4245.0 |
| 2019-12-18 07:35:00 | SPY | ETF | 319.75 | 319.78 | 319.73 | 319.78 | 36838.0 |
| 2019-12-18 07:40:00 | SPY | ETF | 319.73 | 319.79 | 319.73 | 319.79 | 10393.0 |
| 2019-12-18 07:45:00 | SPY | ETF | 319.79 | 319.82 | 319.77 | 319.8 | 8299.0 |
| 2019-12-18 07:50:00 | SPY | ETF | 319.79 | 319.79 | 319.76 | 319.77 | 1137.0 |
| 2019-12-18 07:55:00 | SPY | ETF | 319.74 | 319.75 | 319.73 | 319.73 | 963.0 |
| 2019-12-18 08:00:00 | SPY | ETF | 319.77 | 319.81 | 319.37 | 319.68 | 17012.0 |
| 2019-12-18 08:05:00 | SPY | ETF | 319.71 | 319.73 | 319.69 | 319.72 | 6152.0 |
| 2019-12-18 08:10:00 | SPY | ETF | 319.72 | 319.72 | 319.51 | 319.66 | 2261.0 |
| 2019-12-18 08:15:00 | SPY | ETF | 319.69 | 319.75 | 319.69 | 319.74 | 909.0 |
| 2019-12-18 08:20:00 | SPY | ETF | 319.77 | 319.82 | 319.77 | 319.78 | 7173.0 |
| 2019-12-18 08:25:00 | SPY | ETF | 319.8399 | 319.85 | 319.82 | 319.83 | 17809.0 |
| 2019-12-18 08:30:00 | SPY | ETF | 319.84 | 319.84 | 319.81 | 319.81 | 17978.0 |
| 2019-12-18 08:35:00 | SPY | ETF | 319.78 | 319.88 | 319.78 | 319.88 | 2564.0 |
| 2019-12-18 08:40:00 | SPY | ETF | 319.85 | 319.88 | 319.75 | 319.75 | 2753.0 |
| 2019-12-18 08:45:00 | SPY | ETF | 319.76 | 319.76 | 319.75 | 319.75 | 2813.0 |
| 2019-12-18 08:50:00 | SPY | ETF | 319.75 | 319.75 | 319.65 | 319.7 | 5107.0 |
> showing 50 of 63,914 rows — these rows as CSV