PREVIEW / etf_5min / 2021-06-04
file: by_date/etf_5min/2021/2021-06-04.parquet size: 1.7 MB rows: 78,013
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-06-04 04:00:00 | SPY | ETF | 418.91 | 418.91 | 418.83 | 418.83 | 1176.0 |
| 2021-06-04 04:10:00 | SPY | ETF | 418.86 | 419.0 | 418.86 | 419.0 | 300.0 |
| 2021-06-04 04:15:00 | SPY | ETF | 419.0 | 419.22 | 419.0 | 419.0 | 800.0 |
| 2021-06-04 04:20:00 | SPY | ETF | 419.0 | 419.0 | 419.0 | 419.0 | 199.0 |
| 2021-06-04 04:25:00 | SPY | ETF | 418.85 | 418.85 | 418.82 | 418.82 | 320.0 |
| 2021-06-04 04:30:00 | SPY | ETF | 418.79 | 418.79 | 418.79 | 418.79 | 100.0 |
| 2021-06-04 04:40:00 | SPY | ETF | 418.69 | 418.69 | 418.64 | 418.64 | 200.0 |
| 2021-06-04 04:45:00 | SPY | ETF | 418.65 | 418.65 | 418.65 | 418.65 | 100.0 |
| 2021-06-04 04:55:00 | SPY | ETF | 418.66 | 418.78 | 418.66 | 418.78 | 200.0 |
| 2021-06-04 05:05:00 | SPY | ETF | 418.7 | 418.87 | 418.7 | 418.87 | 1100.0 |
| 2021-06-04 05:10:00 | SPY | ETF | 418.95 | 418.95 | 418.95 | 418.95 | 570.0 |
| 2021-06-04 05:15:00 | SPY | ETF | 418.82 | 418.82 | 418.7 | 418.72 | 2095.0 |
| 2021-06-04 05:20:00 | SPY | ETF | 418.67 | 418.67 | 418.67 | 418.67 | 100.0 |
| 2021-06-04 05:25:00 | SPY | ETF | 418.79 | 418.79 | 418.79 | 418.79 | 500.0 |
| 2021-06-04 05:30:00 | SPY | ETF | 418.72 | 418.72 | 418.69 | 418.69 | 450.0 |
| 2021-06-04 05:35:00 | SPY | ETF | 418.65 | 418.71 | 418.64 | 418.71 | 800.0 |
| 2021-06-04 05:40:00 | SPY | ETF | 418.67 | 418.67 | 418.64 | 418.64 | 716.0 |
| 2021-06-04 05:45:00 | SPY | ETF | 418.72 | 418.72 | 418.72 | 418.72 | 100.0 |
| 2021-06-04 05:50:00 | SPY | ETF | 418.82 | 418.82 | 418.82 | 418.82 | 250.0 |
| 2021-06-04 05:55:00 | SPY | ETF | 418.88 | 419.03 | 418.88 | 419.03 | 800.0 |
| 2021-06-04 06:05:00 | SPY | ETF | 418.8 | 418.87 | 418.77 | 418.87 | 712.0 |
| 2021-06-04 06:10:00 | SPY | ETF | 418.77 | 418.77 | 418.7 | 418.74 | 699.0 |
| 2021-06-04 06:15:00 | SPY | ETF | 418.78 | 418.78 | 418.57 | 418.67 | 600.0 |
| 2021-06-04 06:20:00 | SPY | ETF | 418.78 | 418.78 | 418.78 | 418.78 | 100.0 |
| 2021-06-04 06:25:00 | SPY | ETF | 418.62 | 418.66 | 418.62 | 418.66 | 400.0 |
| 2021-06-04 06:30:00 | SPY | ETF | 418.66 | 418.66 | 418.46 | 418.46 | 4356.0 |
| 2021-06-04 06:35:00 | SPY | ETF | 418.49 | 418.5 | 418.48 | 418.5 | 55700.0 |
| 2021-06-04 06:40:00 | SPY | ETF | 418.52 | 418.56 | 418.52 | 418.56 | 200.0 |
| 2021-06-04 06:45:00 | SPY | ETF | 418.6 | 418.78 | 418.6 | 418.78 | 21260.0 |
| 2021-06-04 06:50:00 | SPY | ETF | 418.77 | 418.77 | 418.77 | 418.77 | 200.0 |
| 2021-06-04 06:55:00 | SPY | ETF | 418.76 | 418.8 | 418.76 | 418.77 | 2400.0 |
| 2021-06-04 07:00:00 | SPY | ETF | 418.84 | 419.08 | 418.84 | 419.05 | 5800.0 |
| 2021-06-04 07:05:00 | SPY | ETF | 419.25 | 419.28 | 418.98 | 418.98 | 5993.0 |
| 2021-06-04 07:10:00 | SPY | ETF | 419.04 | 419.15 | 419.0 | 419.15 | 4930.0 |
| 2021-06-04 07:15:00 | SPY | ETF | 419.22 | 419.22 | 419.05 | 419.19 | 5098.0 |
| 2021-06-04 07:20:00 | SPY | ETF | 419.2 | 419.31 | 419.2 | 419.27 | 11210.0 |
| 2021-06-04 07:25:00 | SPY | ETF | 419.2 | 419.3 | 419.2 | 419.25 | 3050.0 |
| 2021-06-04 07:30:00 | SPY | ETF | 419.28 | 419.3 | 419.19 | 419.19 | 16473.0 |
| 2021-06-04 07:35:00 | SPY | ETF | 419.18 | 419.26 | 419.18 | 419.2 | 2735.0 |
| 2021-06-04 07:40:00 | SPY | ETF | 419.23 | 419.24 | 419.0 | 419.01 | 5350.0 |
| 2021-06-04 07:45:00 | SPY | ETF | 419.01 | 419.03 | 418.99 | 419.03 | 1869.0 |
| 2021-06-04 07:50:00 | SPY | ETF | 419.06 | 419.2 | 419.04 | 419.18 | 2599.0 |
| 2021-06-04 07:55:00 | SPY | ETF | 419.23 | 419.24 | 419.15 | 419.2 | 6466.0 |
| 2021-06-04 08:00:00 | SPY | ETF | 419.2599 | 419.47 | 418.7304 | 419.45 | 32355.0 |
| 2021-06-04 08:05:00 | SPY | ETF | 419.44 | 419.61 | 419.39 | 419.4 | 36193.0 |
| 2021-06-04 08:10:00 | SPY | ETF | 419.32 | 419.38 | 419.27 | 419.27 | 8979.0 |
| 2021-06-04 08:15:00 | SPY | ETF | 419.22 | 419.28 | 419.17 | 419.17 | 6800.0 |
| 2021-06-04 08:20:00 | SPY | ETF | 419.16 | 419.2 | 419.01 | 419.2 | 3134.0 |
| 2021-06-04 08:25:00 | SPY | ETF | 419.22 | 419.25 | 419.09 | 419.23 | 45756.0 |
| 2021-06-04 08:30:00 | SPY | ETF | 419.27 | 420.76 | 418.74 | 420.53 | 355041.0 |
> showing 50 of 78,013 rows — these rows as CSV