PREVIEW / etf_5min / 2023-02-15
file: by_date/etf_5min/2023/2023-02-15.parquet size: 2.0 MB rows: 96,091
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 |
|---|---|---|---|---|---|---|---|
| 2023-02-15 04:00:00 | SPY | ETF | 410.64 | 411.45 | 410.0 | 411.35 | 8025.0 |
| 2023-02-15 04:05:00 | SPY | ETF | 411.41 | 411.41 | 411.35 | 411.41 | 697.0 |
| 2023-02-15 04:10:00 | SPY | ETF | 411.44 | 411.44 | 411.25 | 411.25 | 1057.0 |
| 2023-02-15 04:15:00 | SPY | ETF | 411.25 | 411.3 | 411.23 | 411.24 | 1605.0 |
| 2023-02-15 04:20:00 | SPY | ETF | 411.37 | 411.37 | 411.27 | 411.3 | 829.0 |
| 2023-02-15 04:25:00 | SPY | ETF | 411.41 | 411.45 | 411.28 | 411.28 | 592.0 |
| 2023-02-15 04:30:00 | SPY | ETF | 411.32 | 411.32 | 411.32 | 411.32 | 500.0 |
| 2023-02-15 04:35:00 | SPY | ETF | 411.35 | 411.54 | 411.34 | 411.52 | 2420.0 |
| 2023-02-15 04:45:00 | SPY | ETF | 411.55 | 411.58 | 411.55 | 411.58 | 900.0 |
| 2023-02-15 04:50:00 | SPY | ETF | 411.41 | 411.41 | 411.34 | 411.34 | 323.0 |
| 2023-02-15 04:55:00 | SPY | ETF | 411.35 | 411.35 | 411.35 | 411.35 | 100.0 |
| 2023-02-15 05:00:00 | SPY | ETF | 411.3 | 411.31 | 411.11 | 411.11 | 1103.0 |
| 2023-02-15 05:05:00 | SPY | ETF | 411.11 | 411.11 | 411.11 | 411.11 | 200.0 |
| 2023-02-15 05:10:00 | SPY | ETF | 411.11 | 411.11 | 411.11 | 411.11 | 100.0 |
| 2023-02-15 05:20:00 | SPY | ETF | 411.23 | 411.27 | 411.19 | 411.21 | 3215.0 |
| 2023-02-15 05:25:00 | SPY | ETF | 411.05 | 411.05 | 411.0 | 411.0 | 200.0 |
| 2023-02-15 05:35:00 | SPY | ETF | 410.97 | 411.28 | 410.97 | 411.28 | 400.0 |
| 2023-02-15 05:40:00 | SPY | ETF | 411.29 | 411.47 | 411.29 | 411.47 | 1623.0 |
| 2023-02-15 05:45:00 | SPY | ETF | 411.44 | 411.44 | 411.31 | 411.31 | 767.0 |
| 2023-02-15 05:50:00 | SPY | ETF | 411.45 | 411.45 | 411.44 | 411.44 | 1013.0 |
| 2023-02-15 05:55:00 | SPY | ETF | 411.39 | 411.41 | 411.37 | 411.41 | 1400.0 |
| 2023-02-15 06:00:00 | SPY | ETF | 411.44 | 411.5 | 411.36 | 411.36 | 749.0 |
| 2023-02-15 06:05:00 | SPY | ETF | 411.37 | 411.37 | 411.37 | 411.37 | 399.0 |
| 2023-02-15 06:10:00 | SPY | ETF | 411.4 | 411.4 | 411.19 | 411.19 | 748.0 |
| 2023-02-15 06:15:00 | SPY | ETF | 411.11 | 411.3 | 411.11 | 411.26 | 957.0 |
| 2023-02-15 06:20:00 | SPY | ETF | 411.28 | 411.32 | 411.26 | 411.32 | 21000.0 |
| 2023-02-15 06:25:00 | SPY | ETF | 411.29 | 411.34 | 411.29 | 411.34 | 20100.0 |
| 2023-02-15 06:30:00 | SPY | ETF | 411.3 | 411.42 | 411.3 | 411.4 | 13500.0 |
| 2023-02-15 06:35:00 | SPY | ETF | 411.3 | 411.3 | 411.14 | 411.14 | 24481.0 |
| 2023-02-15 06:40:00 | SPY | ETF | 411.19 | 411.26 | 411.19 | 411.25 | 26138.0 |
| 2023-02-15 06:45:00 | SPY | ETF | 411.11 | 411.11 | 410.99 | 410.99 | 2135.0 |
| 2023-02-15 06:50:00 | SPY | ETF | 411.03 | 411.31 | 411.03 | 411.28 | 2832.0 |
| 2023-02-15 06:55:00 | SPY | ETF | 411.24 | 411.24 | 411.08 | 411.22 | 800.0 |
| 2023-02-15 07:00:00 | SPY | ETF | 411.28 | 411.4 | 411.28 | 411.39 | 2874.0 |
| 2023-02-15 07:05:00 | SPY | ETF | 411.4 | 411.4 | 411.35 | 411.39 | 1998.0 |
| 2023-02-15 07:10:00 | SPY | ETF | 411.38 | 412.25 | 411.38 | 412.16 | 40621.0 |
| 2023-02-15 07:15:00 | SPY | ETF | 412.1 | 412.1 | 411.96 | 412.01 | 7931.0 |
| 2023-02-15 07:20:00 | SPY | ETF | 412.0 | 412.13 | 411.94 | 411.99 | 7415.0 |
| 2023-02-15 07:25:00 | SPY | ETF | 411.98 | 411.99 | 411.85 | 411.88 | 5145.0 |
| 2023-02-15 07:30:00 | SPY | ETF | 411.88 | 411.97 | 411.88 | 411.9 | 20719.0 |
| 2023-02-15 07:35:00 | SPY | ETF | 411.92 | 411.96 | 411.68 | 411.7 | 20987.0 |
| 2023-02-15 07:40:00 | SPY | ETF | 411.63 | 411.63 | 411.55 | 411.55 | 14920.0 |
| 2023-02-15 07:45:00 | SPY | ETF | 411.75 | 411.76 | 411.48 | 411.48 | 9362.0 |
| 2023-02-15 07:50:00 | SPY | ETF | 411.48 | 411.48 | 411.29 | 411.4 | 60249.0 |
| 2023-02-15 07:55:00 | SPY | ETF | 411.34 | 411.5 | 411.26 | 411.5 | 19173.0 |
| 2023-02-15 08:00:00 | SPY | ETF | 411.31 | 412.26 | 410.31 | 411.25 | 64471.0 |
| 2023-02-15 08:05:00 | SPY | ETF | 411.2 | 411.22 | 410.79 | 410.97 | 66078.0 |
| 2023-02-15 08:10:00 | SPY | ETF | 410.95 | 410.96 | 410.78 | 410.78 | 11714.0 |
| 2023-02-15 08:15:00 | SPY | ETF | 410.81 | 411.0 | 410.74 | 410.9401 | 27875.0 |
| 2023-02-15 08:20:00 | SPY | ETF | 410.93 | 410.97 | 410.8 | 410.91 | 15070.0 |
> showing 50 of 96,091 rows — these rows as CSV