PREVIEW / etf_5min / 2021-11-15
file: by_date/etf_5min/2021/2021-11-15.parquet size: 1.8 MB rows: 84,418
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 |
|---|---|---|---|---|---|---|---|
| 2021-11-15 04:00:00 | SPY | ETF | 468.05 | 468.16 | 468.0 | 468.16 | 1683.0 |
| 2021-11-15 04:05:00 | SPY | ETF | 468.16 | 468.31 | 468.16 | 468.31 | 1142.0 |
| 2021-11-15 04:10:00 | SPY | ETF | 468.23 | 468.26 | 468.16 | 468.16 | 974.0 |
| 2021-11-15 04:15:00 | SPY | ETF | 468.09 | 468.1 | 468.03 | 468.09 | 2294.0 |
| 2021-11-15 04:20:00 | SPY | ETF | 468.06 | 468.14 | 468.06 | 468.14 | 1400.0 |
| 2021-11-15 04:25:00 | SPY | ETF | 468.14 | 468.14 | 468.08 | 468.08 | 500.0 |
| 2021-11-15 04:30:00 | SPY | ETF | 468.08 | 468.08 | 468.08 | 468.08 | 100.0 |
| 2021-11-15 04:35:00 | SPY | ETF | 468.0 | 468.0 | 467.94 | 467.94 | 861.0 |
| 2021-11-15 04:40:00 | SPY | ETF | 467.98 | 468.0 | 467.98 | 467.98 | 2100.0 |
| 2021-11-15 04:45:00 | SPY | ETF | 467.98 | 468.03 | 467.98 | 468.03 | 573.0 |
| 2021-11-15 04:50:00 | SPY | ETF | 468.03 | 468.03 | 468.03 | 468.03 | 300.0 |
| 2021-11-15 04:55:00 | SPY | ETF | 468.11 | 468.11 | 468.11 | 468.11 | 100.0 |
| 2021-11-15 05:00:00 | SPY | ETF | 468.12 | 468.12 | 468.12 | 468.12 | 152.0 |
| 2021-11-15 05:05:00 | SPY | ETF | 468.21 | 468.25 | 468.21 | 468.25 | 5500.0 |
| 2021-11-15 05:15:00 | SPY | ETF | 468.29 | 468.32 | 468.29 | 468.32 | 3481.0 |
| 2021-11-15 05:20:00 | SPY | ETF | 468.34 | 468.34 | 468.32 | 468.32 | 600.0 |
| 2021-11-15 05:25:00 | SPY | ETF | 468.32 | 468.32 | 468.26 | 468.26 | 500.0 |
| 2021-11-15 05:30:00 | SPY | ETF | 468.3 | 468.3 | 468.25 | 468.25 | 423.0 |
| 2021-11-15 05:35:00 | SPY | ETF | 468.32 | 468.49 | 468.32 | 468.49 | 694.0 |
| 2021-11-15 05:40:00 | SPY | ETF | 468.37 | 468.37 | 468.37 | 468.37 | 100.0 |
| 2021-11-15 05:45:00 | SPY | ETF | 468.33 | 468.33 | 468.33 | 468.33 | 100.0 |
| 2021-11-15 05:50:00 | SPY | ETF | 468.33 | 468.33 | 468.33 | 468.33 | 150.0 |
| 2021-11-15 05:55:00 | SPY | ETF | 468.39 | 468.44 | 468.39 | 468.44 | 920.0 |
| 2021-11-15 06:00:00 | SPY | ETF | 468.47 | 468.47 | 468.32 | 468.32 | 1498.0 |
| 2021-11-15 06:05:00 | SPY | ETF | 468.34 | 468.34 | 468.34 | 468.34 | 100.0 |
| 2021-11-15 06:10:00 | SPY | ETF | 468.37 | 468.38 | 468.37 | 468.38 | 699.0 |
| 2021-11-15 06:15:00 | SPY | ETF | 468.35 | 468.5 | 468.35 | 468.45 | 1207.0 |
| 2021-11-15 06:25:00 | SPY | ETF | 468.44 | 468.44 | 468.34 | 468.34 | 2132.0 |
| 2021-11-15 06:30:00 | SPY | ETF | 468.38 | 468.55 | 468.38 | 468.55 | 666.0 |
| 2021-11-15 06:35:00 | SPY | ETF | 468.45 | 468.45 | 468.4 | 468.4 | 200.0 |
| 2021-11-15 06:40:00 | SPY | ETF | 468.45 | 468.45 | 468.45 | 468.45 | 200.0 |
| 2021-11-15 06:45:00 | SPY | ETF | 468.47 | 468.47 | 468.43 | 468.43 | 700.0 |
| 2021-11-15 06:50:00 | SPY | ETF | 468.49 | 468.5 | 468.49 | 468.5 | 588.0 |
| 2021-11-15 06:55:00 | SPY | ETF | 468.47 | 468.47 | 468.45 | 468.46 | 23881.0 |
| 2021-11-15 07:00:00 | SPY | ETF | 468.45 | 468.45 | 468.39 | 468.4 | 8879.0 |
| 2021-11-15 07:05:00 | SPY | ETF | 468.4 | 468.4 | 468.37 | 468.39 | 5977.0 |
| 2021-11-15 07:10:00 | SPY | ETF | 468.39 | 468.39 | 468.35 | 468.39 | 10117.0 |
| 2021-11-15 07:15:00 | SPY | ETF | 468.38 | 468.38 | 468.34 | 468.34 | 16382.0 |
| 2021-11-15 07:20:00 | SPY | ETF | 468.33 | 468.33 | 468.24 | 468.25 | 25540.0 |
| 2021-11-15 07:25:00 | SPY | ETF | 468.24 | 468.26 | 468.24 | 468.26 | 1279.0 |
| 2021-11-15 07:30:00 | SPY | ETF | 468.28 | 468.36 | 468.25 | 468.33 | 7137.0 |
| 2021-11-15 07:35:00 | SPY | ETF | 468.35 | 468.38 | 468.34 | 468.37 | 10096.0 |
| 2021-11-15 07:40:00 | SPY | ETF | 468.39 | 468.39 | 468.35 | 468.39 | 2959.0 |
| 2021-11-15 07:45:00 | SPY | ETF | 468.41 | 468.44 | 468.41 | 468.41 | 1730.0 |
| 2021-11-15 07:50:00 | SPY | ETF | 468.45 | 468.46 | 468.45 | 468.46 | 1382.0 |
| 2021-11-15 07:55:00 | SPY | ETF | 468.45 | 468.45 | 468.43 | 468.44 | 1982.0 |
| 2021-11-15 08:00:00 | SPY | ETF | 468.4499 | 468.7 | 467.31 | 468.68 | 29152.0 |
| 2021-11-15 08:05:00 | SPY | ETF | 468.65 | 468.71 | 468.58 | 468.62 | 15734.0 |
| 2021-11-15 08:10:00 | SPY | ETF | 468.62 | 468.91 | 468.62 | 468.88 | 13073.0 |
| 2021-11-15 08:15:00 | SPY | ETF | 468.91 | 469.09 | 468.89 | 469.06 | 22445.0 |
> showing 50 of 84,418 rows — these rows as CSV