PREVIEW / etf_5min / 2023-04-06
file: by_date/etf_5min/2023/2023-04-06.parquet size: 1.9 MB rows: 93,930
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-06 04:00:00 | SPY | ETF | 407.62 | 407.73 | 407.6 | 407.7 | 2217.0 |
| 2023-04-06 04:05:00 | SPY | ETF | 407.72 | 407.72 | 407.6 | 407.6 | 1505.0 |
| 2023-04-06 04:10:00 | SPY | ETF | 407.72 | 407.79 | 407.72 | 407.79 | 992.0 |
| 2023-04-06 04:15:00 | SPY | ETF | 407.69 | 407.7 | 407.64 | 407.64 | 790.0 |
| 2023-04-06 04:20:00 | SPY | ETF | 407.62 | 407.68 | 407.5 | 407.55 | 2883.0 |
| 2023-04-06 04:25:00 | SPY | ETF | 407.53 | 407.53 | 407.53 | 407.53 | 189.0 |
| 2023-04-06 04:30:00 | SPY | ETF | 407.51 | 407.62 | 407.51 | 407.57 | 2615.0 |
| 2023-04-06 04:35:00 | SPY | ETF | 407.5 | 407.5 | 407.5 | 407.5 | 525.0 |
| 2023-04-06 04:40:00 | SPY | ETF | 407.49 | 407.5 | 407.49 | 407.5 | 800.0 |
| 2023-04-06 04:45:00 | SPY | ETF | 407.58 | 407.58 | 407.58 | 407.58 | 250.0 |
| 2023-04-06 04:50:00 | SPY | ETF | 407.46 | 407.57 | 407.46 | 407.57 | 507.0 |
| 2023-04-06 04:55:00 | SPY | ETF | 407.63 | 407.69 | 407.62 | 407.67 | 5761.0 |
| 2023-04-06 05:00:00 | SPY | ETF | 407.71 | 407.73 | 407.71 | 407.72 | 449.0 |
| 2023-04-06 05:05:00 | SPY | ETF | 407.59 | 407.62 | 407.56 | 407.62 | 4924.0 |
| 2023-04-06 05:10:00 | SPY | ETF | 407.57 | 407.57 | 407.57 | 407.57 | 200.0 |
| 2023-04-06 05:15:00 | SPY | ETF | 407.6 | 407.6 | 407.5 | 407.5 | 400.0 |
| 2023-04-06 05:20:00 | SPY | ETF | 407.48 | 407.49 | 407.36 | 407.36 | 924.0 |
| 2023-04-06 05:25:00 | SPY | ETF | 407.44 | 407.44 | 407.38 | 407.4 | 1199.0 |
| 2023-04-06 05:30:00 | SPY | ETF | 407.44 | 407.44 | 407.44 | 407.44 | 200.0 |
| 2023-04-06 05:35:00 | SPY | ETF | 407.4 | 407.4 | 407.4 | 407.4 | 800.0 |
| 2023-04-06 05:40:00 | SPY | ETF | 407.53 | 407.53 | 407.4 | 407.45 | 1796.0 |
| 2023-04-06 05:45:00 | SPY | ETF | 407.42 | 407.42 | 407.4 | 407.4 | 654.0 |
| 2023-04-06 05:55:00 | SPY | ETF | 407.29 | 407.29 | 407.22 | 407.25 | 1769.0 |
| 2023-04-06 06:00:00 | SPY | ETF | 407.19 | 407.2 | 406.85 | 406.9 | 5929.0 |
| 2023-04-06 06:05:00 | SPY | ETF | 406.91 | 407.15 | 406.91 | 407.13 | 29161.0 |
| 2023-04-06 06:10:00 | SPY | ETF | 407.12 | 407.41 | 407.12 | 407.41 | 32543.0 |
| 2023-04-06 06:15:00 | SPY | ETF | 407.43 | 407.45 | 407.37 | 407.37 | 1666.0 |
| 2023-04-06 06:20:00 | SPY | ETF | 407.49 | 407.49 | 407.46 | 407.46 | 490.0 |
| 2023-04-06 06:25:00 | SPY | ETF | 407.43 | 407.47 | 407.41 | 407.41 | 663.0 |
| 2023-04-06 06:30:00 | SPY | ETF | 407.45 | 407.54 | 407.43 | 407.43 | 4328.0 |
| 2023-04-06 06:35:00 | SPY | ETF | 407.48 | 407.57 | 407.48 | 407.55 | 30581.0 |
| 2023-04-06 06:40:00 | SPY | ETF | 407.53 | 407.61 | 407.48 | 407.61 | 23304.0 |
| 2023-04-06 06:45:00 | SPY | ETF | 407.56 | 407.65 | 407.55 | 407.6 | 18538.0 |
| 2023-04-06 06:50:00 | SPY | ETF | 407.6 | 407.6 | 407.47 | 407.48 | 9246.0 |
| 2023-04-06 06:55:00 | SPY | ETF | 407.56 | 407.56 | 407.56 | 407.56 | 100.0 |
| 2023-04-06 07:00:00 | SPY | ETF | 407.65 | 407.82 | 407.62 | 407.701 | 13621.0 |
| 2023-04-06 07:05:00 | SPY | ETF | 407.67 | 407.75 | 407.63 | 407.75 | 1750.0 |
| 2023-04-06 07:10:00 | SPY | ETF | 407.81 | 407.9 | 407.81 | 407.9 | 5299.0 |
| 2023-04-06 07:15:00 | SPY | ETF | 407.89 | 407.91 | 407.81 | 407.85 | 5250.0 |
| 2023-04-06 07:20:00 | SPY | ETF | 407.77 | 407.83 | 407.76 | 407.79 | 3040.0 |
| 2023-04-06 07:25:00 | SPY | ETF | 407.81 | 407.84 | 407.78 | 407.83 | 3922.0 |
| 2023-04-06 07:30:00 | SPY | ETF | 407.9 | 408.08 | 407.9 | 408.0 | 17857.0 |
| 2023-04-06 07:35:00 | SPY | ETF | 408.0 | 408.04 | 407.95 | 407.99 | 8757.0 |
| 2023-04-06 07:40:00 | SPY | ETF | 408.01 | 408.02 | 407.93 | 407.93 | 7754.0 |
| 2023-04-06 07:45:00 | SPY | ETF | 407.92 | 408.17 | 407.91 | 408.15 | 41289.0 |
| 2023-04-06 07:50:00 | SPY | ETF | 408.18 | 408.18 | 408.101 | 408.15 | 9038.0 |
| 2023-04-06 07:55:00 | SPY | ETF | 408.18 | 408.25 | 408.17 | 408.25 | 2421.0 |
| 2023-04-06 08:00:00 | SPY | ETF | 408.101 | 408.33 | 406.55 | 408.08 | 66667.0 |
| 2023-04-06 08:05:00 | SPY | ETF | 408.05 | 408.08 | 407.8 | 407.84 | 8155.0 |
| 2023-04-06 08:10:00 | SPY | ETF | 407.8 | 407.86 | 407.73 | 407.85 | 10062.0 |
> showing 50 of 93,930 rows — these rows as CSV