PREVIEW / etf_5min / 2024-02-08
file: by_date/etf_5min/2024/2024-02-08.parquet size: 2.2 MB rows: 108,189
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-02-08 04:00:00 | SPY | ETF | 497.98 | 497.98 | 497.93 | 497.95 | 1500.0 |
| 2024-02-08 04:05:00 | SPY | ETF | 497.94 | 497.96 | 497.89 | 497.9 | 3072.0 |
| 2024-02-08 04:10:00 | SPY | ETF | 497.9 | 498.04 | 497.9 | 497.98 | 681.0 |
| 2024-02-08 04:15:00 | SPY | ETF | 498.01 | 498.01 | 498.01 | 498.01 | 400.0 |
| 2024-02-08 04:20:00 | SPY | ETF | 498.07 | 498.07 | 498.03 | 498.03 | 1021.0 |
| 2024-02-08 04:25:00 | SPY | ETF | 498.0 | 498.0 | 497.88 | 497.88 | 2000.0 |
| 2024-02-08 04:30:00 | SPY | ETF | 497.95 | 497.95 | 497.95 | 497.95 | 129.0 |
| 2024-02-08 04:35:00 | SPY | ETF | 497.93 | 498.01 | 497.93 | 498.01 | 308.0 |
| 2024-02-08 04:40:00 | SPY | ETF | 498.04 | 498.04 | 498.02 | 498.02 | 500.0 |
| 2024-02-08 04:45:00 | SPY | ETF | 498.05 | 498.05 | 498.0 | 498.01 | 4659.0 |
| 2024-02-08 04:50:00 | SPY | ETF | 497.99 | 497.99 | 497.99 | 497.99 | 200.0 |
| 2024-02-08 04:55:00 | SPY | ETF | 498.02 | 498.02 | 498.02 | 498.02 | 114.0 |
| 2024-02-08 05:00:00 | SPY | ETF | 497.96 | 497.96 | 497.96 | 497.96 | 600.0 |
| 2024-02-08 05:05:00 | SPY | ETF | 497.93 | 497.94 | 497.93 | 497.94 | 200.0 |
| 2024-02-08 05:10:00 | SPY | ETF | 497.96 | 498.0 | 497.95 | 498.0 | 5038.0 |
| 2024-02-08 05:15:00 | SPY | ETF | 497.93 | 497.93 | 497.93 | 497.93 | 100.0 |
| 2024-02-08 05:20:00 | SPY | ETF | 497.97 | 497.98 | 497.95 | 497.98 | 650.0 |
| 2024-02-08 05:30:00 | SPY | ETF | 497.97 | 497.97 | 497.87 | 497.91 | 2336.0 |
| 2024-02-08 05:35:00 | SPY | ETF | 497.94 | 497.94 | 497.94 | 497.94 | 100.0 |
| 2024-02-08 05:45:00 | SPY | ETF | 497.81 | 497.81 | 497.75 | 497.77 | 1842.0 |
| 2024-02-08 05:50:00 | SPY | ETF | 497.7 | 497.73 | 497.69 | 497.69 | 2351.0 |
| 2024-02-08 05:55:00 | SPY | ETF | 497.77 | 497.77 | 497.76 | 497.76 | 450.0 |
| 2024-02-08 06:05:00 | SPY | ETF | 497.77 | 497.79 | 497.75 | 497.75 | 500.0 |
| 2024-02-08 06:10:00 | SPY | ETF | 497.73 | 497.73 | 497.68 | 497.68 | 259.0 |
| 2024-02-08 06:15:00 | SPY | ETF | 497.7 | 497.7 | 497.7 | 497.7 | 400.0 |
| 2024-02-08 06:20:00 | SPY | ETF | 497.56 | 497.56 | 497.41 | 497.41 | 3158.0 |
| 2024-02-08 06:25:00 | SPY | ETF | 497.31 | 497.34 | 497.2 | 497.2 | 7297.0 |
| 2024-02-08 06:30:00 | SPY | ETF | 497.23 | 497.3 | 497.2 | 497.3 | 1670.0 |
| 2024-02-08 06:35:00 | SPY | ETF | 497.36 | 497.47 | 497.36 | 497.47 | 6498.0 |
| 2024-02-08 06:40:00 | SPY | ETF | 497.44 | 497.49 | 497.44 | 497.49 | 6618.0 |
| 2024-02-08 06:45:00 | SPY | ETF | 497.51 | 497.55 | 497.44 | 497.44 | 3539.0 |
| 2024-02-08 06:50:00 | SPY | ETF | 497.35 | 497.35 | 497.35 | 497.35 | 130.0 |
| 2024-02-08 06:55:00 | SPY | ETF | 497.42 | 497.44 | 497.36 | 497.44 | 400.0 |
| 2024-02-08 07:00:00 | SPY | ETF | 497.51 | 497.58 | 497.46 | 497.54 | 8372.0 |
| 2024-02-08 07:05:00 | SPY | ETF | 497.48 | 497.48 | 497.39 | 497.39 | 1450.0 |
| 2024-02-08 07:10:00 | SPY | ETF | 497.44 | 497.65 | 497.44 | 497.65 | 10231.0 |
| 2024-02-08 07:15:00 | SPY | ETF | 497.58 | 497.62 | 497.54 | 497.57 | 990.0 |
| 2024-02-08 07:20:00 | SPY | ETF | 497.61 | 497.66 | 497.61 | 497.65 | 1000.0 |
| 2024-02-08 07:25:00 | SPY | ETF | 497.67 | 497.68 | 497.58 | 497.65 | 24696.0 |
| 2024-02-08 07:30:00 | SPY | ETF | 497.64 | 497.64 | 497.52 | 497.52 | 32359.0 |
| 2024-02-08 07:35:00 | SPY | ETF | 497.45 | 497.53 | 497.42 | 497.53 | 5273.0 |
| 2024-02-08 07:40:00 | SPY | ETF | 497.56 | 497.56 | 497.49 | 497.52 | 8857.0 |
| 2024-02-08 07:45:00 | SPY | ETF | 497.65 | 497.66 | 497.63 | 497.64 | 2882.0 |
| 2024-02-08 07:50:00 | SPY | ETF | 497.64 | 497.64 | 497.54 | 497.54 | 16696.0 |
| 2024-02-08 07:55:00 | SPY | ETF | 497.53 | 497.53 | 497.37 | 497.44 | 21555.0 |
| 2024-02-08 08:00:00 | SPY | ETF | 497.5097 | 498.34 | 497.31 | 497.56 | 44513.0 |
| 2024-02-08 08:05:00 | SPY | ETF | 497.54 | 497.66 | 497.51 | 497.57 | 11364.0 |
| 2024-02-08 08:10:00 | SPY | ETF | 497.52 | 497.53 | 497.4101 | 497.49 | 8584.0 |
| 2024-02-08 08:15:00 | SPY | ETF | 497.53 | 497.59 | 497.44 | 497.44 | 24841.0 |
| 2024-02-08 08:20:00 | SPY | ETF | 497.42 | 497.42 | 497.2426 | 497.4 | 10223.0 |
> showing 50 of 108,189 rows — these rows as CSV