PREVIEW / etf_5min / 2023-01-17
file: by_date/etf_5min/2023/2023-01-17.parquet size: 2.0 MB rows: 100,368
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-17 04:00:00 | SPY | ETF | 397.95 | 397.95 | 397.43 | 397.57 | 7984.0 |
| 2023-01-17 04:05:00 | SPY | ETF | 397.58 | 397.75 | 397.57 | 397.62 | 2616.0 |
| 2023-01-17 04:10:00 | SPY | ETF | 397.64 | 397.64 | 397.36 | 397.37 | 4698.0 |
| 2023-01-17 04:15:00 | SPY | ETF | 397.4 | 397.4 | 397.34 | 397.36 | 3467.0 |
| 2023-01-17 04:20:00 | SPY | ETF | 397.32 | 397.32 | 396.9 | 396.98 | 9766.0 |
| 2023-01-17 04:25:00 | SPY | ETF | 396.95 | 397.17 | 396.88 | 397.13 | 14686.0 |
| 2023-01-17 04:30:00 | SPY | ETF | 397.14 | 397.48 | 397.14 | 397.48 | 1924.0 |
| 2023-01-17 04:35:00 | SPY | ETF | 397.64 | 397.64 | 397.51 | 397.51 | 646.0 |
| 2023-01-17 04:40:00 | SPY | ETF | 397.68 | 397.68 | 397.63 | 397.68 | 924.0 |
| 2023-01-17 04:45:00 | SPY | ETF | 397.69 | 397.69 | 397.5 | 397.5 | 5935.0 |
| 2023-01-17 04:50:00 | SPY | ETF | 397.55 | 397.58 | 397.54 | 397.55 | 3912.0 |
| 2023-01-17 04:55:00 | SPY | ETF | 397.49 | 397.49 | 397.31 | 397.31 | 2013.0 |
| 2023-01-17 05:00:00 | SPY | ETF | 397.33 | 397.36 | 397.23 | 397.23 | 6917.0 |
| 2023-01-17 05:05:00 | SPY | ETF | 397.2 | 397.2 | 397.09 | 397.11 | 3140.0 |
| 2023-01-17 05:10:00 | SPY | ETF | 397.15 | 397.21 | 397.15 | 397.21 | 400.0 |
| 2023-01-17 05:15:00 | SPY | ETF | 397.14 | 397.2 | 397.09 | 397.2 | 1705.0 |
| 2023-01-17 05:20:00 | SPY | ETF | 397.51 | 397.52 | 397.42 | 397.45 | 2116.0 |
| 2023-01-17 05:25:00 | SPY | ETF | 397.45 | 397.45 | 397.29 | 397.39 | 5022.0 |
| 2023-01-17 05:30:00 | SPY | ETF | 397.54 | 397.64 | 397.52 | 397.64 | 358.0 |
| 2023-01-17 05:35:00 | SPY | ETF | 397.55 | 397.55 | 397.52 | 397.52 | 873.0 |
| 2023-01-17 05:40:00 | SPY | ETF | 397.5 | 397.5 | 397.42 | 397.42 | 852.0 |
| 2023-01-17 05:45:00 | SPY | ETF | 397.42 | 397.6 | 397.39 | 397.6 | 2020.0 |
| 2023-01-17 05:50:00 | SPY | ETF | 397.58 | 397.58 | 397.58 | 397.58 | 844.0 |
| 2023-01-17 05:55:00 | SPY | ETF | 397.74 | 397.8 | 397.69 | 397.69 | 2650.0 |
| 2023-01-17 06:00:00 | SPY | ETF | 397.56 | 397.56 | 397.5 | 397.5 | 610.0 |
| 2023-01-17 06:05:00 | SPY | ETF | 397.5 | 397.56 | 397.48 | 397.55 | 1400.0 |
| 2023-01-17 06:10:00 | SPY | ETF | 397.5 | 397.5 | 397.39 | 397.47 | 1949.0 |
| 2023-01-17 06:15:00 | SPY | ETF | 397.46 | 397.46 | 397.46 | 397.46 | 200.0 |
| 2023-01-17 06:20:00 | SPY | ETF | 397.48 | 397.57 | 397.48 | 397.51 | 10960.0 |
| 2023-01-17 06:25:00 | SPY | ETF | 397.45 | 397.5 | 397.44 | 397.44 | 1450.0 |
| 2023-01-17 06:30:00 | SPY | ETF | 397.49 | 397.52 | 397.49 | 397.49 | 2506.0 |
| 2023-01-17 06:35:00 | SPY | ETF | 397.5 | 397.55 | 397.45 | 397.45 | 807.0 |
| 2023-01-17 06:40:00 | SPY | ETF | 397.38 | 397.43 | 397.38 | 397.43 | 1500.0 |
| 2023-01-17 06:45:00 | SPY | ETF | 397.51 | 397.51 | 397.49 | 397.49 | 1050.0 |
| 2023-01-17 06:50:00 | SPY | ETF | 397.56 | 397.56 | 397.56 | 397.56 | 120.0 |
| 2023-01-17 06:55:00 | SPY | ETF | 397.74 | 397.82 | 397.74 | 397.75 | 5974.0 |
| 2023-01-17 07:00:00 | SPY | ETF | 397.79 | 397.85 | 397.57 | 397.58 | 11884.0 |
| 2023-01-17 07:05:00 | SPY | ETF | 397.58 | 397.82 | 397.56 | 397.8 | 9551.0 |
| 2023-01-17 07:10:00 | SPY | ETF | 397.75 | 397.85 | 397.72 | 397.76 | 3758.0 |
| 2023-01-17 07:15:00 | SPY | ETF | 397.79 | 397.98 | 397.78 | 397.98 | 5668.0 |
| 2023-01-17 07:20:00 | SPY | ETF | 397.99 | 397.99 | 397.6 | 397.87 | 24404.0 |
| 2023-01-17 07:25:00 | SPY | ETF | 397.89 | 398.09 | 397.89 | 398.0 | 14127.0 |
| 2023-01-17 07:30:00 | SPY | ETF | 398.08 | 398.08 | 397.88 | 397.95 | 6719.0 |
| 2023-01-17 07:35:00 | SPY | ETF | 397.98 | 398.04 | 397.76 | 397.77 | 22900.0 |
| 2023-01-17 07:40:00 | SPY | ETF | 397.77 | 397.77 | 397.62 | 397.62 | 12260.0 |
| 2023-01-17 07:45:00 | SPY | ETF | 397.62 | 397.62 | 397.31 | 397.43 | 29088.0 |
| 2023-01-17 07:50:00 | SPY | ETF | 397.37 | 397.45 | 397.23 | 397.33 | 19977.0 |
| 2023-01-17 07:55:00 | SPY | ETF | 397.43 | 397.44 | 397.38 | 397.39 | 4527.0 |
| 2023-01-17 08:00:00 | SPY | ETF | 397.64 | 398.06 | 397.03 | 397.1 | 83033.0 |
| 2023-01-17 08:05:00 | SPY | ETF | 397.1 | 397.23 | 397.1 | 397.22 | 13395.0 |
> showing 50 of 100,368 rows — these rows as CSV