PREVIEW / etf_5min / 2020-06-02
file: by_date/etf_5min/2020/2020-06-02.parquet size: 1.6 MB rows: 74,915
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 |
|---|---|---|---|---|---|---|---|
| 2020-06-02 04:00:00 | SPY | ETF | 305.53 | 305.91 | 305.52 | 305.91 | 13375.0 |
| 2020-06-02 04:05:00 | SPY | ETF | 305.92 | 306.09 | 305.92 | 306.03 | 5651.0 |
| 2020-06-02 04:10:00 | SPY | ETF | 306.15 | 306.2 | 306.15 | 306.2 | 710.0 |
| 2020-06-02 04:15:00 | SPY | ETF | 306.21 | 306.52 | 306.21 | 306.52 | 9009.0 |
| 2020-06-02 04:20:00 | SPY | ETF | 306.5 | 306.55 | 306.47 | 306.53 | 910.0 |
| 2020-06-02 04:25:00 | SPY | ETF | 306.58 | 306.58 | 306.56 | 306.58 | 478.0 |
| 2020-06-02 04:30:00 | SPY | ETF | 306.56 | 306.75 | 306.56 | 306.71 | 6577.0 |
| 2020-06-02 04:35:00 | SPY | ETF | 306.73 | 306.94 | 306.73 | 306.93 | 3983.0 |
| 2020-06-02 04:40:00 | SPY | ETF | 306.81 | 306.85 | 306.81 | 306.85 | 2290.0 |
| 2020-06-02 04:45:00 | SPY | ETF | 306.9 | 307.23 | 306.9 | 307.08 | 11715.0 |
| 2020-06-02 04:50:00 | SPY | ETF | 307.1 | 307.16 | 307.08 | 307.08 | 2283.0 |
| 2020-06-02 04:55:00 | SPY | ETF | 307.01 | 307.01 | 306.91 | 306.91 | 6517.0 |
| 2020-06-02 05:00:00 | SPY | ETF | 306.91 | 307.06 | 306.91 | 307.06 | 1648.0 |
| 2020-06-02 05:05:00 | SPY | ETF | 307.07 | 307.16 | 307.07 | 307.12 | 2808.0 |
| 2020-06-02 05:10:00 | SPY | ETF | 307.03 | 307.03 | 306.91 | 306.91 | 403.0 |
| 2020-06-02 05:20:00 | SPY | ETF | 306.91 | 307.02 | 306.81 | 307.02 | 14221.0 |
| 2020-06-02 05:25:00 | SPY | ETF | 307.01 | 307.21 | 307.01 | 307.21 | 505.0 |
| 2020-06-02 05:30:00 | SPY | ETF | 307.21 | 307.56 | 307.21 | 307.56 | 16489.0 |
| 2020-06-02 05:35:00 | SPY | ETF | 307.5 | 307.64 | 307.46 | 307.58 | 9267.0 |
| 2020-06-02 05:40:00 | SPY | ETF | 307.65 | 307.88 | 307.65 | 307.8 | 8169.0 |
| 2020-06-02 05:45:00 | SPY | ETF | 307.8 | 307.81 | 307.66 | 307.73 | 4563.0 |
| 2020-06-02 05:50:00 | SPY | ETF | 307.68 | 307.69 | 307.63 | 307.63 | 5319.0 |
| 2020-06-02 05:55:00 | SPY | ETF | 307.69 | 307.69 | 307.63 | 307.63 | 1711.0 |
| 2020-06-02 06:00:00 | SPY | ETF | 307.57 | 307.61 | 307.56 | 307.61 | 3876.0 |
| 2020-06-02 06:05:00 | SPY | ETF | 307.6 | 307.68 | 307.6 | 307.68 | 3139.0 |
| 2020-06-02 06:10:00 | SPY | ETF | 307.65 | 307.68 | 307.63 | 307.68 | 1817.0 |
| 2020-06-02 06:15:00 | SPY | ETF | 307.7 | 307.7 | 307.49 | 307.49 | 2126.0 |
| 2020-06-02 06:20:00 | SPY | ETF | 307.55 | 307.62 | 307.5 | 307.5 | 5489.0 |
| 2020-06-02 06:25:00 | SPY | ETF | 307.43 | 307.6 | 307.43 | 307.6 | 3225.0 |
| 2020-06-02 06:30:00 | SPY | ETF | 307.56 | 307.56 | 307.51 | 307.53 | 792.0 |
| 2020-06-02 06:35:00 | SPY | ETF | 307.55 | 307.55 | 307.43 | 307.53 | 3074.0 |
| 2020-06-02 06:40:00 | SPY | ETF | 307.5 | 307.55 | 307.5 | 307.52 | 1800.0 |
| 2020-06-02 06:45:00 | SPY | ETF | 307.62 | 307.75 | 307.55 | 307.55 | 27951.0 |
| 2020-06-02 06:50:00 | SPY | ETF | 307.55 | 307.55 | 307.36 | 307.38 | 20793.0 |
| 2020-06-02 06:55:00 | SPY | ETF | 307.49 | 307.49 | 307.41 | 307.41 | 1175.0 |
| 2020-06-02 07:00:00 | SPY | ETF | 307.37 | 307.42 | 307.2 | 307.25 | 47335.0 |
| 2020-06-02 07:05:00 | SPY | ETF | 307.25 | 307.35 | 307.25 | 307.31 | 13606.0 |
| 2020-06-02 07:10:00 | SPY | ETF | 307.33 | 307.33 | 307.25 | 307.32 | 15029.0 |
| 2020-06-02 07:15:00 | SPY | ETF | 307.25 | 307.31 | 307.25 | 307.25 | 12189.0 |
| 2020-06-02 07:20:00 | SPY | ETF | 307.22 | 307.25 | 307.16 | 307.21 | 10513.0 |
| 2020-06-02 07:25:00 | SPY | ETF | 307.16 | 307.16 | 306.98 | 307.13 | 12445.0 |
| 2020-06-02 07:30:00 | SPY | ETF | 307.1 | 307.12 | 307.0 | 307.0 | 3803.0 |
| 2020-06-02 07:35:00 | SPY | ETF | 307.03 | 307.2 | 307.03 | 307.12 | 9563.0 |
| 2020-06-02 07:40:00 | SPY | ETF | 307.13 | 307.23 | 307.13 | 307.2 | 5413.0 |
| 2020-06-02 07:45:00 | SPY | ETF | 307.23 | 307.25 | 307.15 | 307.2 | 3916.0 |
| 2020-06-02 07:50:00 | SPY | ETF | 307.2 | 307.2 | 307.03 | 307.03 | 10748.0 |
| 2020-06-02 07:55:00 | SPY | ETF | 307.03 | 307.03 | 306.8 | 306.97 | 34033.0 |
| 2020-06-02 08:00:00 | SPY | ETF | 307.2501 | 307.4 | 304.02 | 305.95 | 127590.0 |
| 2020-06-02 08:05:00 | SPY | ETF | 307.05 | 307.08 | 306.9 | 306.9 | 50031.0 |
| 2020-06-02 08:10:00 | SPY | ETF | 306.88 | 306.99 | 306.8 | 306.99 | 27130.0 |
> showing 50 of 74,915 rows — these rows as CSV