PREVIEW / etf_5min / 2023-12-04
file: by_date/etf_5min/2023/2023-12-04.parquet size: 2.2 MB rows: 109,460
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-04 04:00:00 | SPY | ETF | 458.06 | 459.0 | 458.06 | 458.07 | 14929.0 |
| 2023-12-04 04:05:00 | SPY | ETF | 458.0 | 458.0 | 457.67 | 457.68 | 1800.0 |
| 2023-12-04 04:10:00 | SPY | ETF | 457.7 | 457.72 | 457.63 | 457.65 | 5625.0 |
| 2023-12-04 04:15:00 | SPY | ETF | 457.64 | 457.75 | 457.61 | 457.75 | 4550.0 |
| 2023-12-04 04:20:00 | SPY | ETF | 457.72 | 457.74 | 457.6 | 457.65 | 2700.0 |
| 2023-12-04 04:25:00 | SPY | ETF | 457.8 | 457.8 | 457.74 | 457.74 | 1400.0 |
| 2023-12-04 04:30:00 | SPY | ETF | 457.77 | 457.84 | 457.72 | 457.84 | 1797.0 |
| 2023-12-04 04:35:00 | SPY | ETF | 457.8 | 457.8 | 457.68 | 457.7 | 1001.0 |
| 2023-12-04 04:40:00 | SPY | ETF | 457.73 | 457.8 | 457.73 | 457.8 | 300.0 |
| 2023-12-04 04:45:00 | SPY | ETF | 457.85 | 457.91 | 457.85 | 457.9 | 560.0 |
| 2023-12-04 04:55:00 | SPY | ETF | 457.99 | 458.0 | 457.99 | 458.0 | 658.0 |
| 2023-12-04 05:00:00 | SPY | ETF | 458.0 | 458.0 | 457.9 | 457.9 | 4033.0 |
| 2023-12-04 05:05:00 | SPY | ETF | 457.81 | 457.81 | 457.81 | 457.81 | 142.0 |
| 2023-12-04 05:10:00 | SPY | ETF | 457.83 | 457.88 | 457.82 | 457.84 | 4055.0 |
| 2023-12-04 05:20:00 | SPY | ETF | 458.0 | 458.0 | 457.98 | 457.98 | 400.0 |
| 2023-12-04 05:25:00 | SPY | ETF | 457.95 | 458.01 | 457.95 | 458.01 | 1156.0 |
| 2023-12-04 05:30:00 | SPY | ETF | 457.96 | 457.96 | 457.96 | 457.96 | 1028.0 |
| 2023-12-04 05:35:00 | SPY | ETF | 457.96 | 458.0 | 457.91 | 457.91 | 1617.0 |
| 2023-12-04 05:40:00 | SPY | ETF | 457.84 | 457.84 | 457.63 | 457.63 | 1200.0 |
| 2023-12-04 05:50:00 | SPY | ETF | 457.79 | 457.79 | 457.73 | 457.74 | 1500.0 |
| 2023-12-04 05:55:00 | SPY | ETF | 457.77 | 457.8 | 457.73 | 457.8 | 3400.0 |
| 2023-12-04 06:00:00 | SPY | ETF | 457.85 | 457.95 | 457.85 | 457.95 | 6696.0 |
| 2023-12-04 06:05:00 | SPY | ETF | 457.69 | 457.69 | 457.69 | 457.69 | 900.0 |
| 2023-12-04 06:10:00 | SPY | ETF | 457.65 | 457.8 | 457.65 | 457.77 | 2095.0 |
| 2023-12-04 06:15:00 | SPY | ETF | 457.77 | 457.77 | 457.74 | 457.74 | 3000.0 |
| 2023-12-04 06:20:00 | SPY | ETF | 457.77 | 457.8 | 457.74 | 457.78 | 2119.0 |
| 2023-12-04 06:25:00 | SPY | ETF | 457.7 | 457.81 | 457.7 | 457.81 | 500.0 |
| 2023-12-04 06:30:00 | SPY | ETF | 457.89 | 457.89 | 457.81 | 457.81 | 1680.0 |
| 2023-12-04 06:35:00 | SPY | ETF | 457.76 | 457.76 | 457.63 | 457.7 | 4168.0 |
| 2023-12-04 06:40:00 | SPY | ETF | 457.64 | 457.64 | 457.52 | 457.56 | 101729.0 |
| 2023-12-04 06:45:00 | SPY | ETF | 457.57 | 457.61 | 457.57 | 457.61 | 850.0 |
| 2023-12-04 06:50:00 | SPY | ETF | 457.59 | 457.59 | 457.53 | 457.58 | 5160.0 |
| 2023-12-04 06:55:00 | SPY | ETF | 457.56 | 457.56 | 457.38 | 457.53 | 6680.0 |
| 2023-12-04 07:00:00 | SPY | ETF | 457.51 | 457.52 | 457.21 | 457.34 | 16252.0 |
| 2023-12-04 07:05:00 | SPY | ETF | 457.33 | 457.39 | 457.3 | 457.3 | 16685.0 |
| 2023-12-04 07:10:00 | SPY | ETF | 457.29 | 457.29 | 457.18 | 457.26 | 5374.0 |
| 2023-12-04 07:15:00 | SPY | ETF | 457.29 | 457.33 | 457.22 | 457.33 | 4766.0 |
| 2023-12-04 07:20:00 | SPY | ETF | 457.3 | 457.3 | 457.22 | 457.28 | 4318.0 |
| 2023-12-04 07:25:00 | SPY | ETF | 457.34 | 457.45 | 457.34 | 457.43 | 3685.0 |
| 2023-12-04 07:30:00 | SPY | ETF | 457.43 | 457.6 | 457.4 | 457.56 | 32917.0 |
| 2023-12-04 07:35:00 | SPY | ETF | 457.54 | 457.72 | 457.54 | 457.72 | 7775.0 |
| 2023-12-04 07:40:00 | SPY | ETF | 457.74 | 457.74 | 457.58 | 457.66 | 16747.0 |
| 2023-12-04 07:45:00 | SPY | ETF | 457.63 | 457.77 | 457.619 | 457.75 | 11591.0 |
| 2023-12-04 07:50:00 | SPY | ETF | 457.73 | 457.78 | 457.7 | 457.78 | 5310.0 |
| 2023-12-04 07:55:00 | SPY | ETF | 457.8 | 457.84 | 457.73 | 457.76 | 5940.0 |
| 2023-12-04 08:00:00 | SPY | ETF | 457.45 | 458.46 | 457.1696 | 457.55 | 76822.0 |
| 2023-12-04 08:05:00 | SPY | ETF | 457.53 | 457.69 | 457.5 | 457.63 | 2668.0 |
| 2023-12-04 08:10:00 | SPY | ETF | 457.59 | 457.6 | 457.45 | 457.56 | 11303.0 |
| 2023-12-04 08:15:00 | SPY | ETF | 457.5501 | 457.77 | 457.5501 | 457.64 | 18235.0 |
| 2023-12-04 08:20:00 | SPY | ETF | 457.62 | 457.64 | 457.44 | 457.44 | 9459.0 |
> showing 50 of 109,460 rows — these rows as CSV