PREVIEW / etf_5min / 2023-12-07
file: by_date/etf_5min/2023/2023-12-07.parquet size: 2.1 MB rows: 104,564
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-12-07 04:00:00 | SPY | ETF | 454.47 | 454.6 | 454.45 | 454.6 | 2601.0 |
| 2023-12-07 04:05:00 | SPY | ETF | 454.67 | 454.73 | 454.65 | 454.65 | 10659.0 |
| 2023-12-07 04:10:00 | SPY | ETF | 454.41 | 454.41 | 454.4 | 454.4 | 390.0 |
| 2023-12-07 04:15:00 | SPY | ETF | 454.35 | 454.35 | 454.31 | 454.31 | 701.0 |
| 2023-12-07 04:20:00 | SPY | ETF | 454.3 | 454.3 | 454.2 | 454.3 | 7700.0 |
| 2023-12-07 04:25:00 | SPY | ETF | 454.37 | 454.65 | 454.37 | 454.65 | 800.0 |
| 2023-12-07 04:30:00 | SPY | ETF | 454.66 | 454.77 | 454.66 | 454.75 | 1400.0 |
| 2023-12-07 04:35:00 | SPY | ETF | 454.72 | 454.75 | 454.7 | 454.75 | 1535.0 |
| 2023-12-07 04:40:00 | SPY | ETF | 454.72 | 454.81 | 454.72 | 454.77 | 300.0 |
| 2023-12-07 04:45:00 | SPY | ETF | 454.74 | 454.74 | 454.74 | 454.74 | 100.0 |
| 2023-12-07 04:55:00 | SPY | ETF | 454.74 | 454.78 | 454.74 | 454.78 | 200.0 |
| 2023-12-07 05:00:00 | SPY | ETF | 454.92 | 454.92 | 454.85 | 454.85 | 614.0 |
| 2023-12-07 05:05:00 | SPY | ETF | 454.85 | 454.85 | 454.85 | 454.85 | 100.0 |
| 2023-12-07 05:10:00 | SPY | ETF | 454.9 | 454.9 | 454.9 | 454.9 | 270.0 |
| 2023-12-07 05:20:00 | SPY | ETF | 454.92 | 454.92 | 454.92 | 454.92 | 1100.0 |
| 2023-12-07 05:25:00 | SPY | ETF | 454.85 | 454.85 | 454.79 | 454.79 | 306.0 |
| 2023-12-07 05:30:00 | SPY | ETF | 454.75 | 454.75 | 454.64 | 454.64 | 800.0 |
| 2023-12-07 05:35:00 | SPY | ETF | 454.67 | 454.67 | 454.64 | 454.64 | 1096.0 |
| 2023-12-07 05:55:00 | SPY | ETF | 454.77 | 454.79 | 454.77 | 454.79 | 674.0 |
| 2023-12-07 06:00:00 | SPY | ETF | 454.89 | 454.89 | 454.87 | 454.87 | 453.0 |
| 2023-12-07 06:05:00 | SPY | ETF | 454.87 | 454.94 | 454.87 | 454.94 | 659.0 |
| 2023-12-07 06:15:00 | SPY | ETF | 454.89 | 454.89 | 454.89 | 454.89 | 256.0 |
| 2023-12-07 06:20:00 | SPY | ETF | 455.01 | 455.02 | 454.91 | 454.91 | 5911.0 |
| 2023-12-07 06:25:00 | SPY | ETF | 454.99 | 455.05 | 454.99 | 455.05 | 1054.0 |
| 2023-12-07 06:30:00 | SPY | ETF | 455.07 | 455.1 | 454.99 | 455.03 | 38609.0 |
| 2023-12-07 06:35:00 | SPY | ETF | 455.12 | 455.13 | 454.99 | 454.99 | 9560.0 |
| 2023-12-07 06:40:00 | SPY | ETF | 455.02 | 455.02 | 455.02 | 455.02 | 100.0 |
| 2023-12-07 06:45:00 | SPY | ETF | 455.04 | 455.04 | 455.03 | 455.03 | 1052.0 |
| 2023-12-07 06:50:00 | SPY | ETF | 454.99 | 455.0 | 454.93 | 454.98 | 1950.0 |
| 2023-12-07 06:55:00 | SPY | ETF | 455.03 | 455.05 | 454.95 | 454.99 | 1070.0 |
| 2023-12-07 07:00:00 | SPY | ETF | 454.99 | 455.03 | 454.9 | 454.92 | 8555.0 |
| 2023-12-07 07:05:00 | SPY | ETF | 454.92 | 454.92 | 454.85 | 454.88 | 2254.0 |
| 2023-12-07 07:10:00 | SPY | ETF | 454.89 | 454.96 | 454.86 | 454.94 | 4200.0 |
| 2023-12-07 07:15:00 | SPY | ETF | 454.95 | 454.98 | 454.93 | 454.98 | 1865.0 |
| 2023-12-07 07:20:00 | SPY | ETF | 454.98 | 454.98 | 454.82 | 454.87 | 6925.0 |
| 2023-12-07 07:25:00 | SPY | ETF | 454.81 | 455.01 | 454.81 | 454.96 | 26987.0 |
| 2023-12-07 07:30:00 | SPY | ETF | 454.97 | 455.02 | 454.95 | 455.01 | 3538.0 |
| 2023-12-07 07:35:00 | SPY | ETF | 455.01 | 455.1 | 454.95 | 455.03 | 18629.0 |
| 2023-12-07 07:40:00 | SPY | ETF | 455.01 | 455.17 | 454.99 | 455.17 | 6066.0 |
| 2023-12-07 07:45:00 | SPY | ETF | 455.13 | 455.17 | 455.06 | 455.09 | 16707.0 |
| 2023-12-07 07:50:00 | SPY | ETF | 455.15 | 455.17 | 455.13 | 455.13 | 2232.0 |
| 2023-12-07 07:55:00 | SPY | ETF | 455.2 | 455.35 | 455.18 | 455.33 | 24652.0 |
| 2023-12-07 08:00:00 | SPY | ETF | 454.9995 | 455.42 | 454.4 | 455.42 | 67432.0 |
| 2023-12-07 08:05:00 | SPY | ETF | 454.5094 | 455.49 | 454.5094 | 455.43 | 58586.0 |
| 2023-12-07 08:10:00 | SPY | ETF | 455.45 | 455.58 | 455.32 | 455.33 | 139833.0 |
| 2023-12-07 08:15:00 | SPY | ETF | 455.35 | 455.56 | 455.35 | 455.45 | 16648.0 |
| 2023-12-07 08:20:00 | SPY | ETF | 455.58 | 455.62 | 455.43 | 455.48 | 13662.0 |
| 2023-12-07 08:25:00 | SPY | ETF | 455.5 | 455.51 | 455.38 | 455.38 | 96881.0 |
| 2023-12-07 08:30:00 | SPY | ETF | 455.36 | 455.42 | 455.14 | 455.35 | 101458.0 |
| 2023-12-07 08:35:00 | SPY | ETF | 455.32 | 455.7 | 455.26 | 455.62 | 34806.0 |
> showing 50 of 104,564 rows — these rows as CSV