PREVIEW / etf_5min / 2023-04-13
file: by_date/etf_5min/2023/2023-04-13.parquet size: 2.0 MB rows: 94,966
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-04-13 04:00:00 | SPY | ETF | 409.0 | 409.26 | 409.0 | 409.26 | 5990.0 |
| 2023-04-13 04:05:00 | SPY | ETF | 409.27 | 409.31 | 409.04 | 409.04 | 15904.0 |
| 2023-04-13 04:10:00 | SPY | ETF | 409.03 | 409.03 | 408.82 | 408.82 | 2416.0 |
| 2023-04-13 04:15:00 | SPY | ETF | 408.82 | 408.82 | 408.69 | 408.73 | 3744.0 |
| 2023-04-13 04:20:00 | SPY | ETF | 408.8 | 408.8 | 408.64 | 408.68 | 2018.0 |
| 2023-04-13 04:25:00 | SPY | ETF | 408.75 | 408.81 | 408.61 | 408.68 | 5484.0 |
| 2023-04-13 04:30:00 | SPY | ETF | 408.7 | 408.76 | 408.68 | 408.68 | 3200.0 |
| 2023-04-13 04:35:00 | SPY | ETF | 408.7 | 408.86 | 408.61 | 408.86 | 1860.0 |
| 2023-04-13 04:40:00 | SPY | ETF | 408.68 | 408.69 | 408.67 | 408.69 | 357.0 |
| 2023-04-13 04:45:00 | SPY | ETF | 408.73 | 408.73 | 408.73 | 408.73 | 400.0 |
| 2023-04-13 04:50:00 | SPY | ETF | 408.73 | 408.77 | 408.73 | 408.77 | 463.0 |
| 2023-04-13 04:55:00 | SPY | ETF | 408.64 | 408.64 | 408.54 | 408.54 | 1730.0 |
| 2023-04-13 05:00:00 | SPY | ETF | 408.6 | 408.6 | 408.54 | 408.54 | 2550.0 |
| 2023-04-13 05:05:00 | SPY | ETF | 408.54 | 408.54 | 408.54 | 408.54 | 100.0 |
| 2023-04-13 05:10:00 | SPY | ETF | 408.63 | 408.86 | 408.63 | 408.86 | 1733.0 |
| 2023-04-13 05:15:00 | SPY | ETF | 408.86 | 409.07 | 408.82 | 409.07 | 5685.0 |
| 2023-04-13 05:20:00 | SPY | ETF | 409.35 | 409.36 | 409.25 | 409.29 | 2563.0 |
| 2023-04-13 05:25:00 | SPY | ETF | 409.3 | 409.3 | 409.18 | 409.2 | 4467.0 |
| 2023-04-13 05:30:00 | SPY | ETF | 409.21 | 409.23 | 409.05 | 409.06 | 4492.0 |
| 2023-04-13 05:35:00 | SPY | ETF | 409.09 | 409.11 | 408.98 | 408.98 | 4838.0 |
| 2023-04-13 05:40:00 | SPY | ETF | 408.98 | 408.98 | 408.88 | 408.88 | 3023.0 |
| 2023-04-13 05:45:00 | SPY | ETF | 408.85 | 408.85 | 408.85 | 408.85 | 400.0 |
| 2023-04-13 05:50:00 | SPY | ETF | 408.88 | 408.88 | 408.87 | 408.87 | 600.0 |
| 2023-04-13 05:55:00 | SPY | ETF | 408.96 | 409.02 | 408.95 | 409.02 | 700.0 |
| 2023-04-13 06:00:00 | SPY | ETF | 408.95 | 408.95 | 408.9 | 408.91 | 2399.0 |
| 2023-04-13 06:05:00 | SPY | ETF | 408.89 | 408.9 | 408.8 | 408.81 | 3300.0 |
| 2023-04-13 06:10:00 | SPY | ETF | 408.8 | 408.8 | 408.54 | 408.54 | 1663.0 |
| 2023-04-13 06:15:00 | SPY | ETF | 408.52 | 408.52 | 408.42 | 408.42 | 5000.0 |
| 2023-04-13 06:20:00 | SPY | ETF | 408.39 | 408.41 | 408.35 | 408.4 | 2497.0 |
| 2023-04-13 06:25:00 | SPY | ETF | 408.33 | 408.47 | 408.33 | 408.35 | 3306.0 |
| 2023-04-13 06:30:00 | SPY | ETF | 408.37 | 408.5 | 408.37 | 408.48 | 531.0 |
| 2023-04-13 06:35:00 | SPY | ETF | 408.43 | 408.5 | 408.43 | 408.5 | 1918.0 |
| 2023-04-13 06:40:00 | SPY | ETF | 408.5 | 408.5 | 408.43 | 408.43 | 1157.0 |
| 2023-04-13 06:45:00 | SPY | ETF | 408.45 | 408.47 | 408.45 | 408.47 | 1400.0 |
| 2023-04-13 06:50:00 | SPY | ETF | 408.44 | 408.44 | 408.39 | 408.39 | 950.0 |
| 2023-04-13 06:55:00 | SPY | ETF | 408.4 | 408.57 | 408.4 | 408.52 | 7216.0 |
| 2023-04-13 07:00:00 | SPY | ETF | 408.5 | 408.56 | 408.48 | 408.55 | 4438.0 |
| 2023-04-13 07:05:00 | SPY | ETF | 408.5 | 408.56 | 408.42 | 408.56 | 2998.0 |
| 2023-04-13 07:10:00 | SPY | ETF | 408.54 | 408.68 | 408.54 | 408.68 | 9566.0 |
| 2023-04-13 07:15:00 | SPY | ETF | 408.75 | 408.79 | 408.72 | 408.76 | 2446.0 |
| 2023-04-13 07:20:00 | SPY | ETF | 408.71 | 408.71 | 408.55 | 408.57 | 1963.0 |
| 2023-04-13 07:25:00 | SPY | ETF | 408.54 | 408.75 | 408.53 | 408.53 | 33126.0 |
| 2023-04-13 07:30:00 | SPY | ETF | 408.56 | 408.78 | 408.56 | 408.78 | 6511.0 |
| 2023-04-13 07:35:00 | SPY | ETF | 408.67 | 408.68 | 408.57 | 408.57 | 2208.0 |
| 2023-04-13 07:40:00 | SPY | ETF | 408.56 | 408.56 | 408.46 | 408.51 | 2136.0 |
| 2023-04-13 07:45:00 | SPY | ETF | 408.47 | 408.47 | 408.41 | 408.43 | 3116.0 |
| 2023-04-13 07:50:00 | SPY | ETF | 408.47 | 408.55 | 408.4 | 408.44 | 28994.0 |
| 2023-04-13 07:55:00 | SPY | ETF | 408.4 | 408.4 | 408.08 | 408.22 | 21013.0 |
| 2023-04-13 08:00:00 | SPY | ETF | 408.512 | 409.2 | 408.02 | 408.11 | 55972.0 |
| 2023-04-13 08:05:00 | SPY | ETF | 408.16 | 408.43 | 408.16 | 408.39 | 14516.0 |
> showing 50 of 94,966 rows — these rows as CSV