PREVIEW / etf_5min / 2023-01-30
file: by_date/etf_5min/2023/2023-01-30.parquet size: 2.0 MB rows: 98,567
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-01-30 04:00:00 | SPY | ETF | 402.68 | 404.44 | 402.65 | 402.73 | 16264.0 |
| 2023-01-30 04:05:00 | SPY | ETF | 402.6 | 402.86 | 402.57 | 402.57 | 10429.0 |
| 2023-01-30 04:10:00 | SPY | ETF | 402.57 | 402.86 | 402.57 | 402.86 | 9747.0 |
| 2023-01-30 04:15:00 | SPY | ETF | 402.87 | 403.0 | 402.77 | 403.0 | 185217.0 |
| 2023-01-30 04:20:00 | SPY | ETF | 403.0 | 403.19 | 402.94 | 402.98 | 31035.0 |
| 2023-01-30 04:25:00 | SPY | ETF | 402.93 | 402.94 | 402.59 | 402.6 | 2901.0 |
| 2023-01-30 04:30:00 | SPY | ETF | 402.59 | 402.74 | 402.52 | 402.64 | 2578.0 |
| 2023-01-30 04:35:00 | SPY | ETF | 402.45 | 402.45 | 401.85 | 402.05 | 109321.0 |
| 2023-01-30 04:40:00 | SPY | ETF | 402.07 | 402.22 | 402.07 | 402.21 | 807.0 |
| 2023-01-30 04:45:00 | SPY | ETF | 402.2 | 402.58 | 402.13 | 402.58 | 6250.0 |
| 2023-01-30 04:50:00 | SPY | ETF | 402.57 | 402.62 | 402.27 | 402.4 | 9325.0 |
| 2023-01-30 04:55:00 | SPY | ETF | 402.35 | 402.37 | 402.27 | 402.36 | 1000.0 |
| 2023-01-30 05:00:00 | SPY | ETF | 402.31 | 402.31 | 402.05 | 402.26 | 1700.0 |
| 2023-01-30 05:05:00 | SPY | ETF | 402.3 | 402.3 | 402.22 | 402.22 | 3465.0 |
| 2023-01-30 05:10:00 | SPY | ETF | 402.34 | 402.4 | 402.22 | 402.31 | 3803.0 |
| 2023-01-30 05:15:00 | SPY | ETF | 402.19 | 402.32 | 402.19 | 402.32 | 631.0 |
| 2023-01-30 05:20:00 | SPY | ETF | 402.3 | 402.31 | 402.27 | 402.29 | 5200.0 |
| 2023-01-30 05:25:00 | SPY | ETF | 402.23 | 402.27 | 402.19 | 402.24 | 1782.0 |
| 2023-01-30 05:30:00 | SPY | ETF | 402.18 | 402.25 | 402.17 | 402.25 | 1400.0 |
| 2023-01-30 05:35:00 | SPY | ETF | 402.35 | 402.47 | 402.35 | 402.47 | 1600.0 |
| 2023-01-30 05:40:00 | SPY | ETF | 402.46 | 402.6 | 402.44 | 402.48 | 5492.0 |
| 2023-01-30 05:45:00 | SPY | ETF | 402.53 | 402.53 | 402.52 | 402.52 | 800.0 |
| 2023-01-30 05:50:00 | SPY | ETF | 402.5 | 402.5 | 402.28 | 402.28 | 1100.0 |
| 2023-01-30 05:55:00 | SPY | ETF | 402.31 | 402.31 | 402.26 | 402.3 | 1900.0 |
| 2023-01-30 06:00:00 | SPY | ETF | 402.5 | 402.54 | 402.24 | 402.26 | 1282.0 |
| 2023-01-30 06:05:00 | SPY | ETF | 402.27 | 402.36 | 402.25 | 402.25 | 4300.0 |
| 2023-01-30 06:10:00 | SPY | ETF | 402.21 | 402.24 | 402.1 | 402.11 | 3450.0 |
| 2023-01-30 06:15:00 | SPY | ETF | 402.1 | 402.22 | 402.07 | 402.07 | 4284.0 |
| 2023-01-30 06:20:00 | SPY | ETF | 402.09 | 402.09 | 401.86 | 401.92 | 3780.0 |
| 2023-01-30 06:25:00 | SPY | ETF | 401.83 | 401.88 | 401.75 | 401.88 | 3396.0 |
| 2023-01-30 06:30:00 | SPY | ETF | 401.82 | 401.82 | 401.42 | 401.5 | 11800.0 |
| 2023-01-30 06:35:00 | SPY | ETF | 401.49 | 401.62 | 401.47 | 401.54 | 14783.0 |
| 2023-01-30 06:40:00 | SPY | ETF | 401.66 | 401.72 | 401.62 | 401.63 | 17009.0 |
| 2023-01-30 06:45:00 | SPY | ETF | 401.63 | 401.98 | 401.63 | 401.9 | 8700.0 |
| 2023-01-30 06:50:00 | SPY | ETF | 401.81 | 401.82 | 401.65 | 401.82 | 10077.0 |
| 2023-01-30 06:55:00 | SPY | ETF | 401.79 | 401.91 | 401.77 | 401.77 | 6150.0 |
| 2023-01-30 07:00:00 | SPY | ETF | 401.86 | 402.11 | 401.86 | 402.05 | 65699.0 |
| 2023-01-30 07:05:00 | SPY | ETF | 402.0 | 402.1 | 401.98 | 402.03 | 20224.0 |
| 2023-01-30 07:10:00 | SPY | ETF | 402.05 | 402.25 | 402.05 | 402.19 | 88263.0 |
| 2023-01-30 07:15:00 | SPY | ETF | 402.2 | 402.32 | 402.18 | 402.25 | 188304.0 |
| 2023-01-30 07:20:00 | SPY | ETF | 402.28 | 402.29 | 402.1 | 402.1 | 4118.0 |
| 2023-01-30 07:25:00 | SPY | ETF | 402.08 | 402.27 | 402.07 | 402.27 | 14764.0 |
| 2023-01-30 07:30:00 | SPY | ETF | 402.3 | 402.38 | 402.12 | 402.15 | 7527.0 |
| 2023-01-30 07:35:00 | SPY | ETF | 402.21 | 402.21 | 401.96 | 402.04 | 10990.0 |
| 2023-01-30 07:40:00 | SPY | ETF | 402.09 | 402.33 | 402.06 | 402.32 | 12303.0 |
| 2023-01-30 07:45:00 | SPY | ETF | 402.3 | 402.45 | 402.25 | 402.43 | 25057.0 |
| 2023-01-30 07:50:00 | SPY | ETF | 402.46 | 402.51 | 402.33 | 402.33 | 26143.0 |
| 2023-01-30 07:55:00 | SPY | ETF | 402.35 | 402.5 | 402.32 | 402.32 | 33154.0 |
| 2023-01-30 08:00:00 | SPY | ETF | 401.96 | 404.56 | 401.525 | 402.24 | 68619.0 |
| 2023-01-30 08:05:00 | SPY | ETF | 402.17 | 402.54 | 402.15 | 402.54 | 31565.0 |
> showing 50 of 98,567 rows — these rows as CSV