PREVIEW / etf_5min / 2021-07-28
file: by_date/etf_5min/2021/2021-07-28.parquet size: 1.7 MB rows: 80,181
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 |
|---|---|---|---|---|---|---|---|
| 2021-07-28 04:00:00 | SPY | ETF | 439.0 | 439.0 | 438.83 | 438.83 | 351.0 |
| 2021-07-28 04:05:00 | SPY | ETF | 439.09 | 439.13 | 439.09 | 439.13 | 400.0 |
| 2021-07-28 04:10:00 | SPY | ETF | 439.12 | 439.12 | 439.09 | 439.09 | 500.0 |
| 2021-07-28 04:15:00 | SPY | ETF | 439.26 | 439.26 | 439.26 | 439.26 | 128.0 |
| 2021-07-28 04:20:00 | SPY | ETF | 439.2 | 439.42 | 439.2 | 439.42 | 2040.0 |
| 2021-07-28 04:25:00 | SPY | ETF | 439.35 | 439.35 | 439.35 | 439.35 | 338.0 |
| 2021-07-28 04:30:00 | SPY | ETF | 439.47 | 439.68 | 439.47 | 439.64 | 1697.0 |
| 2021-07-28 04:35:00 | SPY | ETF | 439.62 | 439.62 | 439.62 | 439.62 | 100.0 |
| 2021-07-28 04:40:00 | SPY | ETF | 439.77 | 439.77 | 439.57 | 439.57 | 1241.0 |
| 2021-07-28 04:45:00 | SPY | ETF | 439.69 | 439.7 | 439.69 | 439.7 | 1000.0 |
| 2021-07-28 04:50:00 | SPY | ETF | 439.67 | 439.8 | 439.67 | 439.8 | 611.0 |
| 2021-07-28 04:55:00 | SPY | ETF | 439.92 | 439.95 | 439.87 | 439.91 | 1200.0 |
| 2021-07-28 05:00:00 | SPY | ETF | 439.9 | 439.9 | 439.9 | 439.9 | 100.0 |
| 2021-07-28 05:05:00 | SPY | ETF | 439.84 | 439.84 | 439.75 | 439.75 | 5337.0 |
| 2021-07-28 05:10:00 | SPY | ETF | 439.76 | 439.76 | 439.73 | 439.73 | 800.0 |
| 2021-07-28 05:15:00 | SPY | ETF | 439.77 | 439.85 | 439.75 | 439.75 | 1690.0 |
| 2021-07-28 05:30:00 | SPY | ETF | 439.82 | 439.82 | 439.82 | 439.82 | 300.0 |
| 2021-07-28 05:35:00 | SPY | ETF | 439.6 | 439.6 | 439.56 | 439.56 | 2029.0 |
| 2021-07-28 05:40:00 | SPY | ETF | 439.7 | 439.7 | 439.7 | 439.7 | 400.0 |
| 2021-07-28 05:45:00 | SPY | ETF | 439.69 | 439.69 | 439.69 | 439.69 | 100.0 |
| 2021-07-28 05:50:00 | SPY | ETF | 439.76 | 439.78 | 439.76 | 439.78 | 400.0 |
| 2021-07-28 05:55:00 | SPY | ETF | 439.84 | 439.85 | 439.79 | 439.79 | 1260.0 |
| 2021-07-28 06:10:00 | SPY | ETF | 439.41 | 439.41 | 439.1 | 439.1 | 2800.0 |
| 2021-07-28 06:15:00 | SPY | ETF | 439.02 | 439.25 | 438.96 | 439.25 | 7890.0 |
| 2021-07-28 06:20:00 | SPY | ETF | 439.11 | 439.11 | 439.0 | 439.03 | 3819.0 |
| 2021-07-28 06:30:00 | SPY | ETF | 439.07 | 439.1 | 439.07 | 439.1 | 4500.0 |
| 2021-07-28 06:35:00 | SPY | ETF | 439.15 | 439.18 | 439.15 | 439.15 | 550.0 |
| 2021-07-28 06:40:00 | SPY | ETF | 439.17 | 439.22 | 439.17 | 439.22 | 1500.0 |
| 2021-07-28 06:45:00 | SPY | ETF | 439.23 | 439.3 | 439.21 | 439.21 | 7209.0 |
| 2021-07-28 06:50:00 | SPY | ETF | 439.2 | 439.2 | 438.84 | 438.89 | 3900.0 |
| 2021-07-28 06:55:00 | SPY | ETF | 439.15 | 439.25 | 439.13 | 439.25 | 1500.0 |
| 2021-07-28 07:00:00 | SPY | ETF | 439.18 | 439.22 | 439.0 | 439.15 | 4550.0 |
| 2021-07-28 07:05:00 | SPY | ETF | 439.22 | 439.29 | 439.15 | 439.24 | 2433.0 |
| 2021-07-28 07:10:00 | SPY | ETF | 439.22 | 439.28 | 439.21 | 439.28 | 5440.0 |
| 2021-07-28 07:15:00 | SPY | ETF | 439.28 | 439.28 | 439.05 | 439.06 | 8204.0 |
| 2021-07-28 07:20:00 | SPY | ETF | 439.25 | 439.32 | 439.13 | 439.23 | 1780.0 |
| 2021-07-28 07:25:00 | SPY | ETF | 439.21 | 439.27 | 439.2 | 439.27 | 4143.0 |
| 2021-07-28 07:30:00 | SPY | ETF | 439.28 | 439.53 | 439.28 | 439.53 | 40892.0 |
| 2021-07-28 07:35:00 | SPY | ETF | 439.54 | 439.56 | 439.44 | 439.49 | 8269.0 |
| 2021-07-28 07:40:00 | SPY | ETF | 439.5 | 439.51 | 439.3 | 439.36 | 14340.0 |
| 2021-07-28 07:45:00 | SPY | ETF | 439.36 | 439.36 | 439.22 | 439.23 | 6222.0 |
| 2021-07-28 07:50:00 | SPY | ETF | 439.23 | 439.23 | 438.93 | 438.98 | 15605.0 |
| 2021-07-28 07:55:00 | SPY | ETF | 438.9 | 439.15 | 438.89 | 439.13 | 5570.0 |
| 2021-07-28 08:00:00 | SPY | ETF | 439.2599 | 439.84 | 438.42 | 439.17 | 32556.0 |
| 2021-07-28 08:05:00 | SPY | ETF | 439.16 | 439.25 | 439.12 | 439.15 | 45467.0 |
| 2021-07-28 08:10:00 | SPY | ETF | 439.1 | 439.15 | 438.94 | 438.96 | 9318.0 |
| 2021-07-28 08:15:00 | SPY | ETF | 439.0 | 439.25 | 439.0 | 439.24 | 32947.0 |
| 2021-07-28 08:20:00 | SPY | ETF | 439.24 | 439.43 | 439.19 | 439.37 | 51328.0 |
| 2021-07-28 08:25:00 | SPY | ETF | 439.37 | 439.48 | 439.36 | 439.47 | 38535.0 |
| 2021-07-28 08:30:00 | SPY | ETF | 439.47 | 439.5 | 439.41 | 439.44 | 14404.0 |
> showing 50 of 80,181 rows — these rows as CSV