PREVIEW / etf_5min / 2020-11-19
file: by_date/etf_5min/2020/2020-11-19.parquet size: 1.7 MB rows: 75,176
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-11-19 04:00:00 | SPY | ETF | 354.84 | 354.89 | 354.66 | 354.66 | 13432.0 |
| 2020-11-19 04:05:00 | SPY | ETF | 354.56 | 355.18 | 354.42 | 355.12 | 12771.0 |
| 2020-11-19 04:10:00 | SPY | ETF | 355.28 | 355.47 | 355.15 | 355.15 | 7648.0 |
| 2020-11-19 04:15:00 | SPY | ETF | 355.19 | 355.19 | 355.04 | 355.07 | 4864.0 |
| 2020-11-19 04:20:00 | SPY | ETF | 354.68 | 354.89 | 354.67 | 354.89 | 1233.0 |
| 2020-11-19 04:25:00 | SPY | ETF | 355.06 | 355.17 | 355.03 | 355.17 | 1382.0 |
| 2020-11-19 04:30:00 | SPY | ETF | 355.17 | 355.18 | 355.02 | 355.02 | 4141.0 |
| 2020-11-19 04:35:00 | SPY | ETF | 355.05 | 355.09 | 354.9 | 354.95 | 2394.0 |
| 2020-11-19 04:40:00 | SPY | ETF | 355.1 | 355.1 | 355.09 | 355.09 | 1550.0 |
| 2020-11-19 04:45:00 | SPY | ETF | 355.17 | 355.26 | 355.17 | 355.26 | 1028.0 |
| 2020-11-19 04:50:00 | SPY | ETF | 355.09 | 355.09 | 354.98 | 354.98 | 1336.0 |
| 2020-11-19 04:55:00 | SPY | ETF | 354.82 | 354.87 | 354.8 | 354.8 | 3743.0 |
| 2020-11-19 05:00:00 | SPY | ETF | 354.8 | 354.8 | 354.67 | 354.67 | 706.0 |
| 2020-11-19 05:05:00 | SPY | ETF | 354.72 | 354.72 | 354.67 | 354.67 | 1205.0 |
| 2020-11-19 05:10:00 | SPY | ETF | 354.56 | 354.56 | 354.21 | 354.44 | 5804.0 |
| 2020-11-19 05:15:00 | SPY | ETF | 354.47 | 354.57 | 354.44 | 354.57 | 6203.0 |
| 2020-11-19 05:20:00 | SPY | ETF | 354.58 | 354.7 | 354.58 | 354.7 | 324.0 |
| 2020-11-19 05:25:00 | SPY | ETF | 355.04 | 355.12 | 354.92 | 355.12 | 5681.0 |
| 2020-11-19 05:30:00 | SPY | ETF | 355.12 | 355.35 | 355.12 | 355.33 | 7602.0 |
| 2020-11-19 05:35:00 | SPY | ETF | 355.31 | 355.31 | 355.21 | 355.21 | 451.0 |
| 2020-11-19 05:40:00 | SPY | ETF | 355.21 | 355.26 | 355.18 | 355.26 | 2344.0 |
| 2020-11-19 05:45:00 | SPY | ETF | 355.16 | 355.2 | 355.16 | 355.2 | 1400.0 |
| 2020-11-19 05:50:00 | SPY | ETF | 355.41 | 355.41 | 355.28 | 355.28 | 210.0 |
| 2020-11-19 05:55:00 | SPY | ETF | 355.17 | 355.24 | 355.17 | 355.24 | 2250.0 |
| 2020-11-19 06:00:00 | SPY | ETF | 355.19 | 355.38 | 355.19 | 355.32 | 2363.0 |
| 2020-11-19 06:05:00 | SPY | ETF | 355.27 | 355.27 | 355.21 | 355.21 | 2101.0 |
| 2020-11-19 06:15:00 | SPY | ETF | 355.04 | 355.04 | 354.78 | 354.86 | 12434.0 |
| 2020-11-19 06:20:00 | SPY | ETF | 354.8 | 354.81 | 354.74 | 354.81 | 3981.0 |
| 2020-11-19 06:25:00 | SPY | ETF | 354.79 | 354.94 | 354.79 | 354.94 | 1234.0 |
| 2020-11-19 06:30:00 | SPY | ETF | 355.04 | 355.16 | 355.03 | 355.16 | 5912.0 |
| 2020-11-19 06:35:00 | SPY | ETF | 355.13 | 355.33 | 355.13 | 355.28 | 1730.0 |
| 2020-11-19 06:40:00 | SPY | ETF | 355.34 | 355.6 | 355.34 | 355.6 | 8787.0 |
| 2020-11-19 06:45:00 | SPY | ETF | 355.64 | 356.0 | 355.64 | 355.97 | 16535.0 |
| 2020-11-19 06:50:00 | SPY | ETF | 355.91 | 355.91 | 355.75 | 355.82 | 2000.0 |
| 2020-11-19 06:55:00 | SPY | ETF | 355.85 | 355.85 | 355.81 | 355.82 | 1200.0 |
| 2020-11-19 07:00:00 | SPY | ETF | 355.92 | 356.24 | 355.92 | 356.13 | 46703.0 |
| 2020-11-19 07:05:00 | SPY | ETF | 356.15 | 356.15 | 355.88 | 355.97 | 6738.0 |
| 2020-11-19 07:10:00 | SPY | ETF | 355.97 | 356.05 | 355.97 | 356.02 | 5471.0 |
| 2020-11-19 07:15:00 | SPY | ETF | 356.0 | 356.02 | 355.93 | 355.95 | 2982.0 |
| 2020-11-19 07:20:00 | SPY | ETF | 355.93 | 356.09 | 355.92 | 356.04 | 25181.0 |
| 2020-11-19 07:25:00 | SPY | ETF | 356.02 | 356.13 | 356.0 | 356.01 | 11706.0 |
| 2020-11-19 07:30:00 | SPY | ETF | 356.02 | 356.22 | 356.0 | 356.21 | 28949.0 |
| 2020-11-19 07:35:00 | SPY | ETF | 356.2 | 356.28 | 356.19 | 356.28 | 30497.0 |
| 2020-11-19 07:40:00 | SPY | ETF | 356.26 | 356.31 | 356.08 | 356.1 | 34098.0 |
| 2020-11-19 07:45:00 | SPY | ETF | 356.09 | 356.32 | 356.08 | 356.3 | 22183.0 |
| 2020-11-19 07:50:00 | SPY | ETF | 356.3 | 356.33 | 356.26 | 356.31 | 15891.0 |
| 2020-11-19 07:55:00 | SPY | ETF | 356.28 | 356.28 | 356.02 | 356.03 | 33521.0 |
| 2020-11-19 08:00:00 | SPY | ETF | 355.8801 | 357.0 | 354.8104 | 355.75 | 98643.0 |
| 2020-11-19 08:05:00 | SPY | ETF | 355.75 | 355.98 | 355.75 | 355.93 | 12781.0 |
| 2020-11-19 08:10:00 | SPY | ETF | 355.91 | 356.25 | 355.91 | 356.142 | 34266.0 |
> showing 50 of 75,176 rows — these rows as CSV