PREVIEW / etf_5min / 2022-04-19
file: by_date/etf_5min/2022/2022-04-19.parquet size: 2.0 MB rows: 94,020
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-04-19 04:00:00 | SPY | ETF | 438.99 | 439.14 | 438.99 | 439.08 | 6420.0 |
| 2022-04-19 04:05:00 | SPY | ETF | 439.09 | 439.5 | 439.09 | 439.28 | 1100.0 |
| 2022-04-19 04:10:00 | SPY | ETF | 439.34 | 439.34 | 439.05 | 439.06 | 1900.0 |
| 2022-04-19 04:15:00 | SPY | ETF | 439.12 | 439.12 | 439.06 | 439.1 | 3100.0 |
| 2022-04-19 04:20:00 | SPY | ETF | 439.02 | 439.34 | 439.02 | 439.34 | 2426.0 |
| 2022-04-19 04:25:00 | SPY | ETF | 439.21 | 439.45 | 439.21 | 439.45 | 400.0 |
| 2022-04-19 04:30:00 | SPY | ETF | 439.32 | 439.33 | 439.32 | 439.33 | 338.0 |
| 2022-04-19 04:35:00 | SPY | ETF | 439.4 | 439.51 | 439.4 | 439.48 | 700.0 |
| 2022-04-19 04:40:00 | SPY | ETF | 439.21 | 439.28 | 439.0 | 439.0 | 2710.0 |
| 2022-04-19 04:45:00 | SPY | ETF | 438.91 | 438.91 | 437.68 | 437.88 | 35233.0 |
| 2022-04-19 04:50:00 | SPY | ETF | 437.82 | 437.92 | 437.55 | 437.55 | 2900.0 |
| 2022-04-19 04:55:00 | SPY | ETF | 437.52 | 437.58 | 437.39 | 437.39 | 24956.0 |
| 2022-04-19 05:00:00 | SPY | ETF | 437.46 | 437.46 | 437.27 | 437.3 | 30599.0 |
| 2022-04-19 05:05:00 | SPY | ETF | 437.3 | 437.36 | 437.26 | 437.26 | 14697.0 |
| 2022-04-19 05:10:00 | SPY | ETF | 437.3 | 437.33 | 437.01 | 437.08 | 19290.0 |
| 2022-04-19 05:15:00 | SPY | ETF | 437.1 | 437.18 | 437.0 | 437.14 | 11890.0 |
| 2022-04-19 05:20:00 | SPY | ETF | 437.16 | 437.24 | 436.76 | 436.76 | 11700.0 |
| 2022-04-19 05:25:00 | SPY | ETF | 436.83 | 436.83 | 436.52 | 436.67 | 15100.0 |
| 2022-04-19 05:30:00 | SPY | ETF | 436.56 | 436.76 | 436.4 | 436.66 | 34881.0 |
| 2022-04-19 05:35:00 | SPY | ETF | 436.75 | 436.94 | 436.6 | 436.63 | 1900.0 |
| 2022-04-19 05:40:00 | SPY | ETF | 436.52 | 436.72 | 436.52 | 436.72 | 200.0 |
| 2022-04-19 05:50:00 | SPY | ETF | 436.7 | 436.73 | 436.38 | 436.42 | 2500.0 |
| 2022-04-19 06:00:00 | SPY | ETF | 436.79 | 436.79 | 436.63 | 436.68 | 2100.0 |
| 2022-04-19 06:05:00 | SPY | ETF | 436.53 | 436.65 | 436.53 | 436.58 | 1402.0 |
| 2022-04-19 06:10:00 | SPY | ETF | 436.6 | 436.6 | 436.44 | 436.55 | 3496.0 |
| 2022-04-19 06:15:00 | SPY | ETF | 436.75 | 437.06 | 436.75 | 437.05 | 1550.0 |
| 2022-04-19 06:20:00 | SPY | ETF | 437.02 | 437.25 | 437.02 | 437.16 | 19313.0 |
| 2022-04-19 06:25:00 | SPY | ETF | 437.3 | 437.3 | 437.21 | 437.22 | 6175.0 |
| 2022-04-19 06:30:00 | SPY | ETF | 437.19 | 437.19 | 437.01 | 437.01 | 2750.0 |
| 2022-04-19 06:35:00 | SPY | ETF | 437.06 | 437.17 | 437.06 | 437.17 | 2609.0 |
| 2022-04-19 06:40:00 | SPY | ETF | 437.05 | 437.35 | 437.05 | 437.35 | 3718.0 |
| 2022-04-19 06:45:00 | SPY | ETF | 437.27 | 437.27 | 437.07 | 437.07 | 600.0 |
| 2022-04-19 06:50:00 | SPY | ETF | 437.08 | 437.3 | 437.08 | 437.3 | 2700.0 |
| 2022-04-19 06:55:00 | SPY | ETF | 437.3 | 437.54 | 437.25 | 437.54 | 4200.0 |
| 2022-04-19 07:00:00 | SPY | ETF | 437.59 | 437.86 | 437.51 | 437.84 | 10138.0 |
| 2022-04-19 07:05:00 | SPY | ETF | 437.89 | 437.89 | 437.6 | 437.77 | 7410.0 |
| 2022-04-19 07:10:00 | SPY | ETF | 437.7 | 437.76 | 437.61 | 437.73 | 14293.0 |
| 2022-04-19 07:15:00 | SPY | ETF | 437.78 | 438.04 | 437.69 | 437.8 | 11628.0 |
| 2022-04-19 07:20:00 | SPY | ETF | 437.74 | 437.96 | 437.7 | 437.9 | 9050.0 |
| 2022-04-19 07:25:00 | SPY | ETF | 437.9 | 438.03 | 437.7 | 437.7 | 12650.0 |
| 2022-04-19 07:30:00 | SPY | ETF | 437.73 | 437.78 | 437.64 | 437.73 | 22720.0 |
| 2022-04-19 07:35:00 | SPY | ETF | 437.7 | 437.7 | 437.32 | 437.37 | 13507.0 |
| 2022-04-19 07:40:00 | SPY | ETF | 437.43 | 437.69 | 437.43 | 437.57 | 9259.0 |
| 2022-04-19 07:45:00 | SPY | ETF | 437.69 | 437.75 | 437.65 | 437.75 | 8934.0 |
| 2022-04-19 07:50:00 | SPY | ETF | 437.78 | 438.18 | 437.78 | 438.1 | 8409.0 |
| 2022-04-19 07:55:00 | SPY | ETF | 438.2 | 438.2 | 438.0 | 438.11 | 18514.0 |
| 2022-04-19 08:00:00 | SPY | ETF | 437.5 | 439.95 | 436.5796 | 438.1 | 61396.0 |
| 2022-04-19 08:05:00 | SPY | ETF | 438.08 | 438.4 | 438.08 | 438.4 | 14270.0 |
| 2022-04-19 08:10:00 | SPY | ETF | 438.38 | 438.5496 | 438.36 | 438.36 | 21348.0 |
| 2022-04-19 08:15:00 | SPY | ETF | 438.39 | 438.43 | 438.18 | 438.23 | 19622.0 |
> showing 50 of 94,020 rows — these rows as CSV