PREVIEW / etf_5min / 2023-03-31
file: by_date/etf_5min/2023/2023-03-31.parquet size: 2.0 MB rows: 97,158
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-03-31 04:00:00 | SPY | ETF | 403.81 | 403.82 | 403.7 | 403.8 | 5855.0 |
| 2023-03-31 04:05:00 | SPY | ETF | 403.81 | 403.87 | 403.78 | 403.78 | 628.0 |
| 2023-03-31 04:15:00 | SPY | ETF | 403.7 | 403.7 | 403.53 | 403.53 | 1350.0 |
| 2023-03-31 04:20:00 | SPY | ETF | 403.6 | 403.84 | 403.6 | 403.79 | 2000.0 |
| 2023-03-31 04:25:00 | SPY | ETF | 403.72 | 403.79 | 403.72 | 403.78 | 700.0 |
| 2023-03-31 04:30:00 | SPY | ETF | 403.76 | 403.85 | 403.73 | 403.85 | 441.0 |
| 2023-03-31 04:35:00 | SPY | ETF | 403.85 | 403.85 | 403.79 | 403.79 | 400.0 |
| 2023-03-31 04:40:00 | SPY | ETF | 403.89 | 403.89 | 403.89 | 403.89 | 100.0 |
| 2023-03-31 04:45:00 | SPY | ETF | 404.05 | 404.06 | 404.05 | 404.05 | 1900.0 |
| 2023-03-31 04:50:00 | SPY | ETF | 403.95 | 403.95 | 403.95 | 403.95 | 500.0 |
| 2023-03-31 04:55:00 | SPY | ETF | 403.81 | 403.81 | 403.81 | 403.81 | 200.0 |
| 2023-03-31 05:00:00 | SPY | ETF | 403.87 | 403.87 | 403.82 | 403.87 | 300.0 |
| 2023-03-31 05:05:00 | SPY | ETF | 404.08 | 404.2 | 404.08 | 404.2 | 1209.0 |
| 2023-03-31 05:10:00 | SPY | ETF | 404.27 | 404.35 | 404.27 | 404.31 | 1837.0 |
| 2023-03-31 05:15:00 | SPY | ETF | 404.31 | 404.35 | 404.3 | 404.31 | 1414.0 |
| 2023-03-31 05:20:00 | SPY | ETF | 404.33 | 404.36 | 404.28 | 404.32 | 2599.0 |
| 2023-03-31 05:30:00 | SPY | ETF | 404.44 | 404.44 | 404.44 | 404.44 | 100.0 |
| 2023-03-31 05:40:00 | SPY | ETF | 404.36 | 404.38 | 404.35 | 404.38 | 440.0 |
| 2023-03-31 05:45:00 | SPY | ETF | 404.47 | 404.53 | 404.45 | 404.48 | 2583.0 |
| 2023-03-31 05:50:00 | SPY | ETF | 404.24 | 404.24 | 404.2 | 404.2 | 747.0 |
| 2023-03-31 05:55:00 | SPY | ETF | 404.17 | 404.32 | 404.17 | 404.32 | 1089.0 |
| 2023-03-31 06:05:00 | SPY | ETF | 404.27 | 404.27 | 404.21 | 404.21 | 300.0 |
| 2023-03-31 06:10:00 | SPY | ETF | 404.13 | 404.22 | 404.13 | 404.22 | 599.0 |
| 2023-03-31 06:15:00 | SPY | ETF | 404.23 | 404.31 | 404.23 | 404.3 | 1328.0 |
| 2023-03-31 06:20:00 | SPY | ETF | 404.28 | 404.28 | 404.28 | 404.28 | 112.0 |
| 2023-03-31 06:25:00 | SPY | ETF | 404.3 | 404.3 | 404.3 | 404.3 | 109.0 |
| 2023-03-31 06:35:00 | SPY | ETF | 404.43 | 404.43 | 404.37 | 404.37 | 347.0 |
| 2023-03-31 06:40:00 | SPY | ETF | 404.44 | 404.45 | 404.41 | 404.45 | 1671.0 |
| 2023-03-31 06:45:00 | SPY | ETF | 404.42 | 404.42 | 404.38 | 404.38 | 630.0 |
| 2023-03-31 06:55:00 | SPY | ETF | 404.3 | 404.36 | 404.3 | 404.36 | 13050.0 |
| 2023-03-31 07:00:00 | SPY | ETF | 404.39 | 404.5 | 404.33 | 404.35 | 23284.0 |
| 2023-03-31 07:05:00 | SPY | ETF | 404.35 | 404.41 | 404.28 | 404.41 | 4477.0 |
| 2023-03-31 07:10:00 | SPY | ETF | 404.41 | 404.42 | 404.38 | 404.42 | 7825.0 |
| 2023-03-31 07:15:00 | SPY | ETF | 404.44 | 404.47 | 404.43 | 404.43 | 2663.0 |
| 2023-03-31 07:20:00 | SPY | ETF | 404.43 | 404.45 | 404.38 | 404.39 | 6231.0 |
| 2023-03-31 07:25:00 | SPY | ETF | 404.47 | 404.56 | 404.45 | 404.52 | 4088.0 |
| 2023-03-31 07:30:00 | SPY | ETF | 404.57 | 404.69 | 404.49 | 404.49 | 11000.0 |
| 2023-03-31 07:35:00 | SPY | ETF | 404.53 | 404.64 | 404.53 | 404.6 | 9490.0 |
| 2023-03-31 07:40:00 | SPY | ETF | 404.58 | 404.6 | 404.56 | 404.59 | 1699.0 |
| 2023-03-31 07:45:00 | SPY | ETF | 404.6 | 404.6 | 404.54 | 404.56 | 6766.0 |
| 2023-03-31 07:50:00 | SPY | ETF | 404.54 | 404.57 | 404.34 | 404.36 | 17231.0 |
| 2023-03-31 07:55:00 | SPY | ETF | 404.39 | 404.39 | 404.27 | 404.27 | 12209.0 |
| 2023-03-31 08:00:00 | SPY | ETF | 404.38 | 404.99 | 403.6796 | 404.31 | 34929.0 |
| 2023-03-31 08:05:00 | SPY | ETF | 404.32 | 404.34 | 404.21 | 404.3 | 28253.0 |
| 2023-03-31 08:10:00 | SPY | ETF | 404.3 | 404.39 | 404.28 | 404.32 | 15334.0 |
| 2023-03-31 08:15:00 | SPY | ETF | 404.32 | 404.37 | 404.16 | 404.26 | 25651.0 |
| 2023-03-31 08:20:00 | SPY | ETF | 404.29 | 404.47 | 404.25 | 404.39 | 87808.0 |
| 2023-03-31 08:25:00 | SPY | ETF | 404.42 | 404.64 | 404.42 | 404.64 | 26705.0 |
| 2023-03-31 08:30:00 | SPY | ETF | 404.36 | 405.45 | 403.9 | 405.1 | 361081.0 |
| 2023-03-31 08:35:00 | SPY | ETF | 405.15 | 405.23 | 404.84 | 405.01 | 65359.0 |
> showing 50 of 97,158 rows — these rows as CSV