PREVIEW / etf_5min / 2022-07-29
file: by_date/etf_5min/2022/2022-07-29.parquet size: 1.9 MB rows: 92,614
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-29 04:00:00 | SPY | ETF | 408.71 | 408.97 | 408.71 | 408.88 | 3180.0 |
| 2022-07-29 04:05:00 | SPY | ETF | 408.98 | 409.13 | 408.98 | 409.0 | 4803.0 |
| 2022-07-29 04:10:00 | SPY | ETF | 409.11 | 409.11 | 409.0 | 409.07 | 9391.0 |
| 2022-07-29 04:15:00 | SPY | ETF | 409.0 | 409.2 | 408.92 | 409.18 | 20330.0 |
| 2022-07-29 04:20:00 | SPY | ETF | 409.1 | 409.1 | 408.76 | 408.77 | 1321.0 |
| 2022-07-29 04:25:00 | SPY | ETF | 408.81 | 409.1 | 408.81 | 409.1 | 4103.0 |
| 2022-07-29 04:35:00 | SPY | ETF | 409.0 | 409.0 | 409.0 | 409.0 | 1331.0 |
| 2022-07-29 04:40:00 | SPY | ETF | 408.8 | 409.06 | 408.7 | 408.7 | 2950.0 |
| 2022-07-29 04:45:00 | SPY | ETF | 408.7 | 408.7 | 408.41 | 408.41 | 2900.0 |
| 2022-07-29 04:50:00 | SPY | ETF | 408.4 | 408.46 | 408.35 | 408.35 | 2600.0 |
| 2022-07-29 04:55:00 | SPY | ETF | 408.55 | 408.55 | 408.55 | 408.55 | 100.0 |
| 2022-07-29 05:00:00 | SPY | ETF | 408.5 | 408.58 | 408.5 | 408.53 | 1500.0 |
| 2022-07-29 05:05:00 | SPY | ETF | 408.44 | 408.45 | 408.36 | 408.41 | 33051.0 |
| 2022-07-29 05:10:00 | SPY | ETF | 408.42 | 408.44 | 408.41 | 408.44 | 21400.0 |
| 2022-07-29 05:15:00 | SPY | ETF | 408.57 | 408.57 | 408.45 | 408.46 | 3254.0 |
| 2022-07-29 05:20:00 | SPY | ETF | 408.35 | 408.55 | 408.34 | 408.55 | 1400.0 |
| 2022-07-29 05:25:00 | SPY | ETF | 408.56 | 408.7 | 408.56 | 408.7 | 2398.0 |
| 2022-07-29 05:30:00 | SPY | ETF | 408.83 | 408.95 | 408.81 | 408.95 | 1241.0 |
| 2022-07-29 05:35:00 | SPY | ETF | 408.95 | 409.02 | 408.9 | 408.95 | 1600.0 |
| 2022-07-29 05:40:00 | SPY | ETF | 408.87 | 408.92 | 408.87 | 408.91 | 3000.0 |
| 2022-07-29 05:50:00 | SPY | ETF | 408.93 | 408.93 | 408.93 | 408.93 | 500.0 |
| 2022-07-29 05:55:00 | SPY | ETF | 408.98 | 409.14 | 408.94 | 409.14 | 1540.0 |
| 2022-07-29 06:00:00 | SPY | ETF | 409.17 | 409.17 | 408.94 | 409.07 | 1194.0 |
| 2022-07-29 06:05:00 | SPY | ETF | 409.14 | 409.19 | 409.12 | 409.19 | 21145.0 |
| 2022-07-29 06:10:00 | SPY | ETF | 409.2 | 409.2 | 409.02 | 409.05 | 12400.0 |
| 2022-07-29 06:15:00 | SPY | ETF | 409.0 | 409.02 | 408.85 | 408.85 | 1300.0 |
| 2022-07-29 06:20:00 | SPY | ETF | 408.87 | 408.98 | 408.87 | 408.94 | 9278.0 |
| 2022-07-29 06:25:00 | SPY | ETF | 409.0 | 409.0 | 408.93 | 408.93 | 239.0 |
| 2022-07-29 06:30:00 | SPY | ETF | 408.95 | 409.05 | 408.95 | 409.04 | 29571.0 |
| 2022-07-29 06:35:00 | SPY | ETF | 409.2 | 409.36 | 409.2 | 409.36 | 4100.0 |
| 2022-07-29 06:40:00 | SPY | ETF | 409.28 | 409.34 | 409.28 | 409.34 | 1214.0 |
| 2022-07-29 06:45:00 | SPY | ETF | 409.21 | 409.21 | 409.2 | 409.21 | 891.0 |
| 2022-07-29 06:50:00 | SPY | ETF | 409.36 | 409.37 | 409.24 | 409.27 | 5608.0 |
| 2022-07-29 06:55:00 | SPY | ETF | 409.23 | 409.24 | 409.16 | 409.16 | 2400.0 |
| 2022-07-29 07:00:00 | SPY | ETF | 409.16 | 409.26 | 409.0 | 409.0 | 12489.0 |
| 2022-07-29 07:05:00 | SPY | ETF | 408.94 | 408.97 | 408.67 | 408.72 | 14083.0 |
| 2022-07-29 07:10:00 | SPY | ETF | 408.68 | 408.83 | 408.68 | 408.7 | 13068.0 |
| 2022-07-29 07:15:00 | SPY | ETF | 408.71 | 408.85 | 408.67 | 408.85 | 2194.0 |
| 2022-07-29 07:20:00 | SPY | ETF | 408.85 | 408.85 | 408.6 | 408.7 | 22353.0 |
| 2022-07-29 07:25:00 | SPY | ETF | 408.69 | 408.7 | 408.54 | 408.55 | 1700.0 |
| 2022-07-29 07:30:00 | SPY | ETF | 408.63 | 408.63 | 408.53 | 408.53 | 7665.0 |
| 2022-07-29 07:35:00 | SPY | ETF | 408.55 | 408.7 | 408.51 | 408.65 | 4318.0 |
| 2022-07-29 07:40:00 | SPY | ETF | 408.56 | 408.56 | 408.39 | 408.49 | 8600.0 |
| 2022-07-29 07:45:00 | SPY | ETF | 408.49 | 408.5 | 408.46 | 408.5 | 3113.0 |
| 2022-07-29 07:50:00 | SPY | ETF | 408.46 | 408.62 | 408.41 | 408.58 | 6001.0 |
| 2022-07-29 07:55:00 | SPY | ETF | 408.52 | 408.57 | 408.42 | 408.57 | 2250.0 |
| 2022-07-29 08:00:00 | SPY | ETF | 409.14 | 409.5 | 408.36 | 408.74 | 28423.0 |
| 2022-07-29 08:05:00 | SPY | ETF | 408.76 | 408.8 | 408.66 | 408.66 | 1900.0 |
| 2022-07-29 08:10:00 | SPY | ETF | 408.65 | 408.66 | 408.43 | 408.43 | 97079.0 |
| 2022-07-29 08:15:00 | SPY | ETF | 408.41 | 408.42 | 408.24 | 408.25 | 29858.0 |
> showing 50 of 92,614 rows — these rows as CSV