PREVIEW / etf_5min / 2020-05-08
file: by_date/etf_5min/2020/2020-05-08.parquet size: 1.6 MB rows: 74,500
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-05-08 04:00:00 | SPY | ETF | 291.0 | 291.0 | 290.74 | 290.8 | 18966.0 |
| 2020-05-08 04:05:00 | SPY | ETF | 290.87 | 290.97 | 290.84 | 290.93 | 3119.0 |
| 2020-05-08 04:10:00 | SPY | ETF | 290.77 | 290.85 | 290.7 | 290.7 | 19105.0 |
| 2020-05-08 04:15:00 | SPY | ETF | 290.62 | 290.64 | 290.62 | 290.64 | 1118.0 |
| 2020-05-08 04:20:00 | SPY | ETF | 290.53 | 290.63 | 290.43 | 290.63 | 1821.0 |
| 2020-05-08 04:25:00 | SPY | ETF | 290.53 | 290.65 | 290.53 | 290.65 | 10694.0 |
| 2020-05-08 04:30:00 | SPY | ETF | 290.66 | 290.76 | 290.66 | 290.76 | 699.0 |
| 2020-05-08 04:35:00 | SPY | ETF | 290.66 | 290.78 | 290.66 | 290.78 | 815.0 |
| 2020-05-08 04:40:00 | SPY | ETF | 290.76 | 290.8 | 290.76 | 290.8 | 1220.0 |
| 2020-05-08 04:45:00 | SPY | ETF | 290.8 | 290.83 | 290.76 | 290.78 | 2023.0 |
| 2020-05-08 04:50:00 | SPY | ETF | 290.77 | 290.78 | 290.77 | 290.78 | 1110.0 |
| 2020-05-08 04:55:00 | SPY | ETF | 290.87 | 291.0 | 290.87 | 290.98 | 7721.0 |
| 2020-05-08 05:00:00 | SPY | ETF | 290.85 | 290.85 | 290.85 | 290.85 | 120.0 |
| 2020-05-08 05:05:00 | SPY | ETF | 290.88 | 290.9 | 290.86 | 290.9 | 2600.0 |
| 2020-05-08 05:10:00 | SPY | ETF | 290.9 | 290.97 | 290.89 | 290.97 | 2383.0 |
| 2020-05-08 05:15:00 | SPY | ETF | 291.08 | 291.23 | 291.08 | 291.17 | 8013.0 |
| 2020-05-08 05:20:00 | SPY | ETF | 291.19 | 291.19 | 291.12 | 291.15 | 1350.0 |
| 2020-05-08 05:25:00 | SPY | ETF | 291.21 | 291.21 | 291.21 | 291.21 | 5000.0 |
| 2020-05-08 05:30:00 | SPY | ETF | 291.14 | 291.19 | 291.09 | 291.09 | 3014.0 |
| 2020-05-08 05:35:00 | SPY | ETF | 290.85 | 291.01 | 290.85 | 291.01 | 4400.0 |
| 2020-05-08 05:40:00 | SPY | ETF | 291.17 | 291.37 | 291.17 | 291.31 | 2359.0 |
| 2020-05-08 05:45:00 | SPY | ETF | 291.36 | 291.36 | 291.3 | 291.3 | 1140.0 |
| 2020-05-08 05:50:00 | SPY | ETF | 291.33 | 291.36 | 291.32 | 291.32 | 3300.0 |
| 2020-05-08 05:55:00 | SPY | ETF | 291.3 | 291.56 | 291.3 | 291.56 | 7920.0 |
| 2020-05-08 06:00:00 | SPY | ETF | 291.5 | 291.61 | 291.38 | 291.6 | 9462.0 |
| 2020-05-08 06:05:00 | SPY | ETF | 291.65 | 291.68 | 291.59 | 291.68 | 5110.0 |
| 2020-05-08 06:10:00 | SPY | ETF | 291.63 | 291.63 | 291.59 | 291.61 | 5650.0 |
| 2020-05-08 06:15:00 | SPY | ETF | 291.6 | 291.66 | 291.55 | 291.58 | 2343.0 |
| 2020-05-08 06:20:00 | SPY | ETF | 291.51 | 291.57 | 291.45 | 291.57 | 726.0 |
| 2020-05-08 06:25:00 | SPY | ETF | 291.58 | 291.6 | 291.53 | 291.55 | 1000.0 |
| 2020-05-08 06:30:00 | SPY | ETF | 291.65 | 291.74 | 291.65 | 291.73 | 18303.0 |
| 2020-05-08 06:35:00 | SPY | ETF | 291.62 | 291.7 | 291.62 | 291.67 | 1120.0 |
| 2020-05-08 06:40:00 | SPY | ETF | 291.57 | 291.6 | 291.52 | 291.6 | 3150.0 |
| 2020-05-08 06:45:00 | SPY | ETF | 291.66 | 291.66 | 291.55 | 291.6 | 7933.0 |
| 2020-05-08 06:50:00 | SPY | ETF | 291.55 | 291.58 | 291.53 | 291.57 | 5023.0 |
| 2020-05-08 06:55:00 | SPY | ETF | 291.56 | 291.6 | 291.5 | 291.5 | 10812.0 |
| 2020-05-08 07:00:00 | SPY | ETF | 291.48 | 291.48 | 291.15 | 291.2 | 70307.0 |
| 2020-05-08 07:05:00 | SPY | ETF | 291.21 | 291.31 | 291.18 | 291.3 | 9468.0 |
| 2020-05-08 07:10:00 | SPY | ETF | 291.3 | 291.3 | 291.25 | 291.27 | 2567.0 |
| 2020-05-08 07:15:00 | SPY | ETF | 291.21 | 291.27 | 291.12 | 291.27 | 8561.0 |
| 2020-05-08 07:20:00 | SPY | ETF | 291.25 | 291.42 | 291.25 | 291.38 | 6891.0 |
| 2020-05-08 07:25:00 | SPY | ETF | 291.39 | 291.43 | 291.33 | 291.43 | 18422.0 |
| 2020-05-08 07:30:00 | SPY | ETF | 291.4 | 291.46 | 291.24 | 291.26 | 10553.0 |
| 2020-05-08 07:35:00 | SPY | ETF | 291.23 | 291.26 | 291.09 | 291.1 | 41716.0 |
| 2020-05-08 07:40:00 | SPY | ETF | 291.1 | 291.25 | 291.1 | 291.18 | 35816.0 |
| 2020-05-08 07:45:00 | SPY | ETF | 291.17 | 291.21 | 290.99 | 291.08 | 18516.0 |
| 2020-05-08 07:50:00 | SPY | ETF | 291.13 | 291.13 | 290.97 | 291.07 | 17740.0 |
| 2020-05-08 07:55:00 | SPY | ETF | 291.04 | 291.05 | 290.87 | 290.9 | 22130.0 |
| 2020-05-08 08:00:00 | SPY | ETF | 290.9 | 292.23 | 290.81 | 291.02 | 221116.0 |
| 2020-05-08 08:05:00 | SPY | ETF | 291.04 | 291.24 | 290.95 | 291.2 | 45050.0 |
> showing 50 of 74,500 rows — these rows as CSV