PREVIEW / etf_5min / 2023-05-23
file: by_date/etf_5min/2023/2023-05-23.parquet size: 1.9 MB rows: 95,375
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-05-23 04:00:00 | SPY | ETF | 418.53 | 418.98 | 418.43 | 418.5 | 20897.0 |
| 2023-05-23 04:05:00 | SPY | ETF | 418.55 | 418.62 | 418.55 | 418.62 | 615.0 |
| 2023-05-23 04:10:00 | SPY | ETF | 418.63 | 418.63 | 418.5 | 418.5 | 700.0 |
| 2023-05-23 04:15:00 | SPY | ETF | 418.47 | 418.56 | 418.46 | 418.56 | 2750.0 |
| 2023-05-23 04:20:00 | SPY | ETF | 418.48 | 418.49 | 418.39 | 418.41 | 4710.0 |
| 2023-05-23 04:25:00 | SPY | ETF | 418.51 | 418.51 | 418.47 | 418.47 | 800.0 |
| 2023-05-23 04:30:00 | SPY | ETF | 418.42 | 418.56 | 418.41 | 418.56 | 4000.0 |
| 2023-05-23 04:35:00 | SPY | ETF | 418.59 | 418.59 | 418.54 | 418.54 | 6945.0 |
| 2023-05-23 04:40:00 | SPY | ETF | 418.49 | 418.49 | 418.47 | 418.49 | 10050.0 |
| 2023-05-23 04:45:00 | SPY | ETF | 418.51 | 418.51 | 418.5 | 418.5 | 200.0 |
| 2023-05-23 04:50:00 | SPY | ETF | 418.55 | 418.58 | 418.5 | 418.5 | 2825.0 |
| 2023-05-23 04:55:00 | SPY | ETF | 418.5 | 418.5 | 418.45 | 418.45 | 342.0 |
| 2023-05-23 05:00:00 | SPY | ETF | 418.44 | 418.5 | 418.42 | 418.5 | 400.0 |
| 2023-05-23 05:10:00 | SPY | ETF | 418.39 | 418.39 | 418.36 | 418.36 | 407.0 |
| 2023-05-23 05:15:00 | SPY | ETF | 418.4 | 418.4 | 418.35 | 418.35 | 773.0 |
| 2023-05-23 05:20:00 | SPY | ETF | 418.19 | 418.19 | 418.09 | 418.09 | 5222.0 |
| 2023-05-23 05:25:00 | SPY | ETF | 418.14 | 418.29 | 418.11 | 418.29 | 2031.0 |
| 2023-05-23 05:30:00 | SPY | ETF | 418.34 | 418.43 | 418.34 | 418.43 | 2000.0 |
| 2023-05-23 05:35:00 | SPY | ETF | 418.42 | 418.42 | 418.34 | 418.34 | 1035.0 |
| 2023-05-23 05:40:00 | SPY | ETF | 418.24 | 418.24 | 418.18 | 418.21 | 5700.0 |
| 2023-05-23 05:45:00 | SPY | ETF | 418.21 | 418.21 | 418.21 | 418.21 | 100.0 |
| 2023-05-23 05:50:00 | SPY | ETF | 418.19 | 418.19 | 418.09 | 418.09 | 1500.0 |
| 2023-05-23 05:55:00 | SPY | ETF | 418.14 | 418.21 | 418.14 | 418.19 | 1913.0 |
| 2023-05-23 06:00:00 | SPY | ETF | 418.17 | 418.19 | 418.05 | 418.19 | 1100.0 |
| 2023-05-23 06:05:00 | SPY | ETF | 418.2 | 418.38 | 418.2 | 418.31 | 6458.0 |
| 2023-05-23 06:10:00 | SPY | ETF | 418.34 | 418.44 | 418.34 | 418.44 | 973.0 |
| 2023-05-23 06:15:00 | SPY | ETF | 418.41 | 418.49 | 418.41 | 418.44 | 464.0 |
| 2023-05-23 06:20:00 | SPY | ETF | 418.43 | 418.46 | 418.38 | 418.43 | 3685.0 |
| 2023-05-23 06:25:00 | SPY | ETF | 418.39 | 418.39 | 418.39 | 418.39 | 230.0 |
| 2023-05-23 06:30:00 | SPY | ETF | 418.59 | 418.68 | 418.57 | 418.68 | 3100.0 |
| 2023-05-23 06:35:00 | SPY | ETF | 418.75 | 418.79 | 418.7 | 418.75 | 7624.0 |
| 2023-05-23 06:40:00 | SPY | ETF | 418.7 | 418.7 | 418.65 | 418.65 | 900.0 |
| 2023-05-23 06:45:00 | SPY | ETF | 418.64 | 418.64 | 418.61 | 418.61 | 500.0 |
| 2023-05-23 06:50:00 | SPY | ETF | 418.59 | 418.59 | 418.52 | 418.52 | 886.0 |
| 2023-05-23 06:55:00 | SPY | ETF | 418.54 | 418.57 | 418.53 | 418.57 | 3200.0 |
| 2023-05-23 07:00:00 | SPY | ETF | 418.53 | 418.59 | 418.27 | 418.28 | 70634.0 |
| 2023-05-23 07:05:00 | SPY | ETF | 418.27 | 418.33 | 418.21 | 418.3 | 55767.0 |
| 2023-05-23 07:10:00 | SPY | ETF | 418.29 | 418.31 | 418.18 | 418.26 | 24453.0 |
| 2023-05-23 07:15:00 | SPY | ETF | 418.25 | 418.42 | 418.19 | 418.42 | 14218.0 |
| 2023-05-23 07:20:00 | SPY | ETF | 418.37 | 418.45 | 418.32 | 418.32 | 15829.0 |
| 2023-05-23 07:25:00 | SPY | ETF | 418.32 | 418.43 | 418.31 | 418.43 | 7322.0 |
| 2023-05-23 07:30:00 | SPY | ETF | 418.4 | 418.4 | 418.13 | 418.19 | 4586.0 |
| 2023-05-23 07:35:00 | SPY | ETF | 418.2 | 418.27 | 418.13 | 418.13 | 17975.0 |
| 2023-05-23 07:40:00 | SPY | ETF | 418.13 | 418.13 | 417.91 | 417.91 | 15925.0 |
| 2023-05-23 07:45:00 | SPY | ETF | 418.0 | 418.05 | 417.79 | 417.79 | 17580.0 |
| 2023-05-23 07:50:00 | SPY | ETF | 417.77 | 417.88 | 417.53 | 417.54 | 37191.0 |
| 2023-05-23 07:55:00 | SPY | ETF | 417.62 | 417.64 | 417.5 | 417.5 | 19820.0 |
| 2023-05-23 08:00:00 | SPY | ETF | 418.2183 | 419.53 | 417.47 | 417.58 | 39626.0 |
| 2023-05-23 08:05:00 | SPY | ETF | 417.63 | 417.74 | 417.59 | 417.74 | 21735.0 |
| 2023-05-23 08:10:00 | SPY | ETF | 417.76 | 417.81 | 417.65 | 417.67 | 21065.0 |
> showing 50 of 95,375 rows — these rows as CSV