PREVIEW / etf_5min / 2022-07-19
file: by_date/etf_5min/2022/2022-07-19.parquet size: 1.9 MB rows: 90,881
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-19 04:00:00 | SPY | ETF | 382.62 | 382.75 | 382.49 | 382.62 | 4646.0 |
| 2022-07-19 04:05:00 | SPY | ETF | 382.52 | 383.0 | 382.52 | 383.0 | 2128.0 |
| 2022-07-19 04:10:00 | SPY | ETF | 382.93 | 382.93 | 382.93 | 382.93 | 1200.0 |
| 2022-07-19 04:15:00 | SPY | ETF | 382.8 | 382.83 | 382.69 | 382.75 | 1384.0 |
| 2022-07-19 04:20:00 | SPY | ETF | 382.78 | 382.93 | 382.71 | 382.93 | 1500.0 |
| 2022-07-19 04:25:00 | SPY | ETF | 382.93 | 382.93 | 382.68 | 382.68 | 3663.0 |
| 2022-07-19 04:30:00 | SPY | ETF | 382.66 | 383.05 | 382.66 | 383.05 | 500.0 |
| 2022-07-19 04:35:00 | SPY | ETF | 383.05 | 383.33 | 383.02 | 383.2 | 4270.0 |
| 2022-07-19 04:40:00 | SPY | ETF | 383.15 | 383.33 | 383.15 | 383.33 | 802.0 |
| 2022-07-19 04:45:00 | SPY | ETF | 383.35 | 383.35 | 383.28 | 383.28 | 850.0 |
| 2022-07-19 04:50:00 | SPY | ETF | 383.14 | 383.14 | 383.05 | 383.05 | 1700.0 |
| 2022-07-19 04:55:00 | SPY | ETF | 383.44 | 383.75 | 383.44 | 383.61 | 11922.0 |
| 2022-07-19 05:00:00 | SPY | ETF | 383.56 | 383.76 | 383.56 | 383.68 | 1100.0 |
| 2022-07-19 05:05:00 | SPY | ETF | 383.7 | 383.75 | 383.63 | 383.63 | 15800.0 |
| 2022-07-19 05:10:00 | SPY | ETF | 383.6 | 383.93 | 383.6 | 383.87 | 12280.0 |
| 2022-07-19 05:15:00 | SPY | ETF | 383.87 | 383.87 | 383.7 | 383.7 | 2750.0 |
| 2022-07-19 05:20:00 | SPY | ETF | 383.77 | 384.36 | 383.76 | 384.36 | 8753.0 |
| 2022-07-19 05:25:00 | SPY | ETF | 384.32 | 384.34 | 384.32 | 384.34 | 1500.0 |
| 2022-07-19 05:30:00 | SPY | ETF | 384.39 | 384.5 | 384.39 | 384.42 | 3051.0 |
| 2022-07-19 05:35:00 | SPY | ETF | 384.45 | 384.47 | 384.44 | 384.47 | 4540.0 |
| 2022-07-19 05:40:00 | SPY | ETF | 384.5 | 384.52 | 384.5 | 384.52 | 1000.0 |
| 2022-07-19 05:45:00 | SPY | ETF | 384.62 | 384.69 | 384.55 | 384.55 | 1375.0 |
| 2022-07-19 05:50:00 | SPY | ETF | 384.77 | 384.9 | 384.76 | 384.85 | 4100.0 |
| 2022-07-19 05:55:00 | SPY | ETF | 384.8 | 384.8 | 384.56 | 384.6 | 5380.0 |
| 2022-07-19 06:00:00 | SPY | ETF | 384.64 | 384.66 | 384.48 | 384.66 | 3492.0 |
| 2022-07-19 06:05:00 | SPY | ETF | 384.78 | 385.04 | 384.78 | 385.0 | 8762.0 |
| 2022-07-19 06:10:00 | SPY | ETF | 385.03 | 385.45 | 385.02 | 385.38 | 14973.0 |
| 2022-07-19 06:15:00 | SPY | ETF | 385.3 | 385.33 | 385.18 | 385.19 | 7398.0 |
| 2022-07-19 06:20:00 | SPY | ETF | 385.22 | 385.31 | 385.22 | 385.25 | 3150.0 |
| 2022-07-19 06:25:00 | SPY | ETF | 385.11 | 385.4 | 384.98 | 385.17 | 12035.0 |
| 2022-07-19 06:30:00 | SPY | ETF | 385.22 | 385.48 | 385.19 | 385.48 | 6220.0 |
| 2022-07-19 06:35:00 | SPY | ETF | 385.5 | 385.75 | 385.45 | 385.7 | 9846.0 |
| 2022-07-19 06:40:00 | SPY | ETF | 385.65 | 385.65 | 385.41 | 385.44 | 3544.0 |
| 2022-07-19 06:45:00 | SPY | ETF | 385.42 | 385.46 | 385.37 | 385.37 | 1800.0 |
| 2022-07-19 06:50:00 | SPY | ETF | 385.26 | 385.3 | 385.09 | 385.27 | 3702.0 |
| 2022-07-19 06:55:00 | SPY | ETF | 385.11 | 385.27 | 385.1 | 385.25 | 11350.0 |
| 2022-07-19 07:00:00 | SPY | ETF | 385.19 | 385.19 | 384.81 | 384.84 | 8936.0 |
| 2022-07-19 07:05:00 | SPY | ETF | 384.85 | 385.03 | 384.79 | 384.9 | 16372.0 |
| 2022-07-19 07:10:00 | SPY | ETF | 384.87 | 385.25 | 384.87 | 385.25 | 18153.0 |
| 2022-07-19 07:15:00 | SPY | ETF | 385.27 | 385.27 | 384.94 | 384.94 | 23978.0 |
| 2022-07-19 07:20:00 | SPY | ETF | 384.92 | 384.95 | 384.82 | 384.87 | 16208.0 |
| 2022-07-19 07:25:00 | SPY | ETF | 384.94 | 385.08 | 384.85 | 385.05 | 4410.0 |
| 2022-07-19 07:30:00 | SPY | ETF | 385.09 | 385.19 | 384.88 | 384.88 | 23883.0 |
| 2022-07-19 07:35:00 | SPY | ETF | 385.0 | 385.0 | 384.7 | 384.7 | 24493.0 |
| 2022-07-19 07:40:00 | SPY | ETF | 384.75 | 384.75 | 384.56 | 384.56 | 11736.0 |
| 2022-07-19 07:45:00 | SPY | ETF | 384.55 | 384.76 | 384.55 | 384.76 | 38569.0 |
| 2022-07-19 07:50:00 | SPY | ETF | 384.76 | 385.3 | 384.76 | 385.24 | 28474.0 |
| 2022-07-19 07:55:00 | SPY | ETF | 385.16 | 385.18 | 385.03 | 385.12 | 14597.0 |
| 2022-07-19 08:00:00 | SPY | ETF | 385.14 | 385.55 | 382.47 | 385.11 | 65224.0 |
| 2022-07-19 08:05:00 | SPY | ETF | 385.11 | 385.13 | 384.83 | 384.83 | 7834.0 |
> showing 50 of 90,881 rows — these rows as CSV