PREVIEW / etf_5min / 2024-01-17
file: by_date/etf_5min/2024/2024-01-17.parquet size: 2.2 MB rows: 111,270
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-17 04:00:00 | SPY | ETF | 472.6 | 472.87 | 472.5 | 472.5 | 7384.0 |
| 2024-01-17 04:05:00 | SPY | ETF | 472.47 | 472.5 | 472.35 | 472.35 | 4903.0 |
| 2024-01-17 04:10:00 | SPY | ETF | 472.41 | 472.41 | 472.16 | 472.17 | 2081.0 |
| 2024-01-17 04:15:00 | SPY | ETF | 472.11 | 472.39 | 472.11 | 472.39 | 10480.0 |
| 2024-01-17 04:20:00 | SPY | ETF | 472.4 | 472.65 | 472.4 | 472.65 | 809.0 |
| 2024-01-17 04:25:00 | SPY | ETF | 472.61 | 472.61 | 472.61 | 472.61 | 100.0 |
| 2024-01-17 04:30:00 | SPY | ETF | 472.78 | 472.78 | 472.78 | 472.78 | 223.0 |
| 2024-01-17 04:35:00 | SPY | ETF | 472.9 | 472.91 | 472.9 | 472.91 | 300.0 |
| 2024-01-17 04:40:00 | SPY | ETF | 472.84 | 472.84 | 472.84 | 472.84 | 240.0 |
| 2024-01-17 04:45:00 | SPY | ETF | 472.78 | 472.78 | 472.77 | 472.77 | 300.0 |
| 2024-01-17 04:50:00 | SPY | ETF | 472.9 | 473.02 | 472.87 | 473.02 | 12200.0 |
| 2024-01-17 04:55:00 | SPY | ETF | 473.02 | 473.02 | 472.97 | 472.97 | 700.0 |
| 2024-01-17 05:05:00 | SPY | ETF | 473.01 | 473.01 | 473.01 | 473.01 | 175.0 |
| 2024-01-17 05:10:00 | SPY | ETF | 473.09 | 473.12 | 473.09 | 473.09 | 2536.0 |
| 2024-01-17 05:15:00 | SPY | ETF | 473.01 | 473.08 | 472.99 | 473.08 | 1096.0 |
| 2024-01-17 05:20:00 | SPY | ETF | 473.06 | 473.06 | 473.05 | 473.05 | 900.0 |
| 2024-01-17 05:25:00 | SPY | ETF | 472.96 | 473.0 | 472.77 | 472.77 | 2644.0 |
| 2024-01-17 05:30:00 | SPY | ETF | 472.76 | 472.8 | 472.76 | 472.8 | 1650.0 |
| 2024-01-17 05:40:00 | SPY | ETF | 472.71 | 472.71 | 472.66 | 472.66 | 500.0 |
| 2024-01-17 05:45:00 | SPY | ETF | 472.75 | 472.79 | 472.75 | 472.76 | 800.0 |
| 2024-01-17 05:50:00 | SPY | ETF | 472.58 | 472.84 | 472.58 | 472.84 | 3750.0 |
| 2024-01-17 05:55:00 | SPY | ETF | 472.82 | 472.85 | 472.8 | 472.85 | 600.0 |
| 2024-01-17 06:05:00 | SPY | ETF | 472.65 | 472.74 | 472.65 | 472.74 | 400.0 |
| 2024-01-17 06:10:00 | SPY | ETF | 472.51 | 472.53 | 472.5 | 472.5 | 1093.0 |
| 2024-01-17 06:15:00 | SPY | ETF | 472.56 | 472.56 | 472.56 | 472.56 | 500.0 |
| 2024-01-17 06:20:00 | SPY | ETF | 472.54 | 472.73 | 472.51 | 472.73 | 2058.0 |
| 2024-01-17 06:25:00 | SPY | ETF | 472.71 | 472.71 | 472.71 | 472.71 | 800.0 |
| 2024-01-17 06:30:00 | SPY | ETF | 472.94 | 473.0 | 472.9 | 473.0 | 10500.0 |
| 2024-01-17 06:35:00 | SPY | ETF | 473.12 | 473.2 | 473.06 | 473.2 | 1570.0 |
| 2024-01-17 06:40:00 | SPY | ETF | 473.1 | 473.1 | 473.1 | 473.1 | 600.0 |
| 2024-01-17 06:45:00 | SPY | ETF | 473.1 | 473.1 | 473.1 | 473.1 | 5000.0 |
| 2024-01-17 06:50:00 | SPY | ETF | 473.1 | 473.17 | 473.0 | 473.0 | 975.0 |
| 2024-01-17 06:55:00 | SPY | ETF | 473.11 | 473.11 | 473.11 | 473.11 | 500.0 |
| 2024-01-17 07:00:00 | SPY | ETF | 473.19 | 473.22 | 473.05 | 473.18 | 8662.0 |
| 2024-01-17 07:05:00 | SPY | ETF | 473.22 | 473.31 | 473.19 | 473.28 | 34761.0 |
| 2024-01-17 07:10:00 | SPY | ETF | 473.21 | 473.22 | 473.1 | 473.21 | 49257.0 |
| 2024-01-17 07:15:00 | SPY | ETF | 473.22 | 473.44 | 473.22 | 473.39 | 7610.0 |
| 2024-01-17 07:20:00 | SPY | ETF | 473.39 | 473.64 | 473.39 | 473.62 | 20172.0 |
| 2024-01-17 07:25:00 | SPY | ETF | 473.63 | 473.67 | 473.49 | 473.5 | 23828.0 |
| 2024-01-17 07:30:00 | SPY | ETF | 473.48 | 473.48 | 473.41 | 473.45 | 2432.0 |
| 2024-01-17 07:35:00 | SPY | ETF | 473.48 | 473.55 | 473.36 | 473.36 | 12077.0 |
| 2024-01-17 07:40:00 | SPY | ETF | 473.38 | 473.38 | 473.28 | 473.3 | 6623.0 |
| 2024-01-17 07:45:00 | SPY | ETF | 473.28 | 473.34 | 473.2 | 473.29 | 37192.0 |
| 2024-01-17 07:50:00 | SPY | ETF | 473.33 | 473.44 | 473.29 | 473.38 | 5592.0 |
| 2024-01-17 07:55:00 | SPY | ETF | 473.4 | 473.58 | 473.25 | 473.26 | 28082.0 |
| 2024-01-17 08:00:00 | SPY | ETF | 473.4601 | 473.82 | 472.46 | 472.93 | 123051.0 |
| 2024-01-17 08:05:00 | SPY | ETF | 473.0 | 473.11 | 472.93 | 473.08 | 17815.0 |
| 2024-01-17 08:10:00 | SPY | ETF | 473.04 | 473.22 | 472.93 | 473.14 | 24789.0 |
| 2024-01-17 08:15:00 | SPY | ETF | 473.12 | 473.12 | 472.95 | 472.999 | 4126.0 |
| 2024-01-17 08:20:00 | SPY | ETF | 473.11 | 473.11 | 472.8 | 472.82 | 29354.0 |
> showing 50 of 111,270 rows — these rows as CSV