PREVIEW / etf_5min / 2022-11-30
file: by_date/etf_5min/2022/2022-11-30.parquet size: 2.1 MB rows: 101,616
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-30 04:00:00 | SPY | ETF | 395.65 | 396.58 | 395.65 | 396.4 | 10964.0 |
| 2022-11-30 04:05:00 | SPY | ETF | 396.43 | 396.54 | 396.4 | 396.48 | 2789.0 |
| 2022-11-30 04:10:00 | SPY | ETF | 396.44 | 396.66 | 396.39 | 396.5 | 3112.0 |
| 2022-11-30 04:15:00 | SPY | ETF | 396.53 | 396.67 | 396.5 | 396.63 | 3482.0 |
| 2022-11-30 04:20:00 | SPY | ETF | 396.61 | 396.7 | 396.61 | 396.67 | 1375.0 |
| 2022-11-30 04:25:00 | SPY | ETF | 396.68 | 396.94 | 396.62 | 396.85 | 1451.0 |
| 2022-11-30 04:30:00 | SPY | ETF | 396.9 | 396.93 | 396.77 | 396.77 | 3302.0 |
| 2022-11-30 04:35:00 | SPY | ETF | 396.87 | 396.87 | 396.6 | 396.6 | 1464.0 |
| 2022-11-30 04:40:00 | SPY | ETF | 396.4 | 396.4 | 395.91 | 395.98 | 5174.0 |
| 2022-11-30 04:45:00 | SPY | ETF | 395.96 | 396.14 | 395.93 | 396.13 | 1558.0 |
| 2022-11-30 04:50:00 | SPY | ETF | 396.15 | 396.17 | 396.13 | 396.17 | 1048.0 |
| 2022-11-30 04:55:00 | SPY | ETF | 396.19 | 396.2 | 396.17 | 396.17 | 718.0 |
| 2022-11-30 05:00:00 | SPY | ETF | 396.21 | 396.32 | 396.04 | 396.04 | 2030.0 |
| 2022-11-30 05:05:00 | SPY | ETF | 396.08 | 396.15 | 396.0 | 396.15 | 708.0 |
| 2022-11-30 05:10:00 | SPY | ETF | 396.13 | 396.35 | 396.13 | 396.35 | 616.0 |
| 2022-11-30 05:15:00 | SPY | ETF | 396.23 | 396.23 | 396.2 | 396.2 | 1100.0 |
| 2022-11-30 05:20:00 | SPY | ETF | 396.2 | 396.28 | 396.1 | 396.11 | 1041.0 |
| 2022-11-30 05:25:00 | SPY | ETF | 396.02 | 396.14 | 396.02 | 396.14 | 381.0 |
| 2022-11-30 05:30:00 | SPY | ETF | 396.23 | 396.35 | 396.23 | 396.34 | 1498.0 |
| 2022-11-30 05:35:00 | SPY | ETF | 396.23 | 396.42 | 396.23 | 396.42 | 500.0 |
| 2022-11-30 05:40:00 | SPY | ETF | 396.4 | 396.43 | 396.38 | 396.42 | 880.0 |
| 2022-11-30 05:45:00 | SPY | ETF | 396.26 | 396.41 | 396.26 | 396.41 | 549.0 |
| 2022-11-30 05:50:00 | SPY | ETF | 396.22 | 396.22 | 395.96 | 395.96 | 220.0 |
| 2022-11-30 05:55:00 | SPY | ETF | 395.97 | 396.06 | 395.97 | 395.98 | 695.0 |
| 2022-11-30 06:00:00 | SPY | ETF | 396.14 | 396.14 | 396.06 | 396.06 | 300.0 |
| 2022-11-30 06:05:00 | SPY | ETF | 395.94 | 395.94 | 395.82 | 395.85 | 2200.0 |
| 2022-11-30 06:10:00 | SPY | ETF | 395.79 | 395.85 | 395.79 | 395.84 | 727.0 |
| 2022-11-30 06:15:00 | SPY | ETF | 395.87 | 395.94 | 395.87 | 395.94 | 1569.0 |
| 2022-11-30 06:20:00 | SPY | ETF | 396.0 | 396.1 | 396.0 | 396.1 | 1338.0 |
| 2022-11-30 06:25:00 | SPY | ETF | 395.95 | 395.95 | 395.95 | 395.95 | 100.0 |
| 2022-11-30 06:30:00 | SPY | ETF | 395.98 | 395.98 | 395.88 | 395.94 | 641.0 |
| 2022-11-30 06:35:00 | SPY | ETF | 396.09 | 396.14 | 396.08 | 396.08 | 800.0 |
| 2022-11-30 06:40:00 | SPY | ETF | 396.16 | 396.16 | 396.16 | 396.16 | 100.0 |
| 2022-11-30 06:45:00 | SPY | ETF | 396.13 | 396.28 | 396.13 | 396.26 | 3976.0 |
| 2022-11-30 06:50:00 | SPY | ETF | 396.2 | 396.2 | 396.11 | 396.19 | 1710.0 |
| 2022-11-30 06:55:00 | SPY | ETF | 396.21 | 396.4 | 396.21 | 396.4 | 902.0 |
| 2022-11-30 07:00:00 | SPY | ETF | 396.28 | 396.33 | 396.24 | 396.25 | 7894.0 |
| 2022-11-30 07:05:00 | SPY | ETF | 396.26 | 396.33 | 396.23 | 396.33 | 10179.0 |
| 2022-11-30 07:10:00 | SPY | ETF | 396.28 | 396.34 | 396.25 | 396.34 | 15269.0 |
| 2022-11-30 07:15:00 | SPY | ETF | 396.34 | 396.34 | 396.13 | 396.16 | 14123.0 |
| 2022-11-30 07:20:00 | SPY | ETF | 396.12 | 396.24 | 396.12 | 396.19 | 9658.0 |
| 2022-11-30 07:25:00 | SPY | ETF | 396.12 | 396.26 | 396.1 | 396.2 | 16251.0 |
| 2022-11-30 07:30:00 | SPY | ETF | 396.2 | 396.28 | 396.08 | 396.08 | 9495.0 |
| 2022-11-30 07:35:00 | SPY | ETF | 396.07 | 396.18 | 396.0 | 396.05 | 8619.0 |
| 2022-11-30 07:40:00 | SPY | ETF | 396.04 | 396.07 | 395.95 | 395.95 | 6044.0 |
| 2022-11-30 07:45:00 | SPY | ETF | 395.95 | 396.13 | 395.95 | 396.09 | 18842.0 |
| 2022-11-30 07:50:00 | SPY | ETF | 396.1 | 396.36 | 396.1 | 396.29 | 12081.0 |
| 2022-11-30 07:55:00 | SPY | ETF | 396.27 | 396.28 | 396.01 | 396.01 | 8335.0 |
| 2022-11-30 08:00:00 | SPY | ETF | 396.01 | 396.5204 | 395.92 | 395.99 | 34088.0 |
| 2022-11-30 08:05:00 | SPY | ETF | 395.98 | 396.24 | 395.98 | 396.06 | 17896.0 |
> showing 50 of 101,616 rows — these rows as CSV