PREVIEW / etf_5min / 2021-03-03
file: by_date/etf_5min/2021/2021-03-03.parquet size: 1.9 MB rows: 91,021
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-03-03 04:00:00 | SPY | ETF | 388.78 | 388.99 | 388.76 | 388.99 | 3985.0 |
| 2021-03-03 04:05:00 | SPY | ETF | 388.97 | 389.13 | 388.97 | 389.1 | 1877.0 |
| 2021-03-03 04:10:00 | SPY | ETF | 389.14 | 389.46 | 389.14 | 389.46 | 1950.0 |
| 2021-03-03 04:15:00 | SPY | ETF | 389.44 | 389.44 | 389.43 | 389.43 | 17700.0 |
| 2021-03-03 04:20:00 | SPY | ETF | 389.22 | 389.22 | 389.22 | 389.22 | 500.0 |
| 2021-03-03 04:25:00 | SPY | ETF | 389.34 | 389.34 | 389.1 | 389.13 | 6600.0 |
| 2021-03-03 04:30:00 | SPY | ETF | 389.12 | 389.19 | 389.11 | 389.14 | 77375.0 |
| 2021-03-03 04:35:00 | SPY | ETF | 388.97 | 388.99 | 388.63 | 388.7 | 6200.0 |
| 2021-03-03 04:40:00 | SPY | ETF | 388.82 | 389.1 | 388.82 | 389.1 | 800.0 |
| 2021-03-03 04:45:00 | SPY | ETF | 388.98 | 389.06 | 388.98 | 389.03 | 700.0 |
| 2021-03-03 04:50:00 | SPY | ETF | 389.01 | 389.01 | 388.83 | 388.83 | 1200.0 |
| 2021-03-03 04:55:00 | SPY | ETF | 388.76 | 388.91 | 388.76 | 388.91 | 200.0 |
| 2021-03-03 05:00:00 | SPY | ETF | 388.99 | 389.01 | 388.99 | 389.0 | 1100.0 |
| 2021-03-03 05:05:00 | SPY | ETF | 389.04 | 389.06 | 388.98 | 388.98 | 800.0 |
| 2021-03-03 05:10:00 | SPY | ETF | 388.92 | 388.92 | 388.92 | 388.92 | 100.0 |
| 2021-03-03 05:15:00 | SPY | ETF | 388.93 | 388.93 | 388.93 | 388.93 | 500.0 |
| 2021-03-03 05:20:00 | SPY | ETF | 389.06 | 389.11 | 388.99 | 388.99 | 14386.0 |
| 2021-03-03 05:25:00 | SPY | ETF | 389.03 | 389.09 | 389.0 | 389.0 | 2400.0 |
| 2021-03-03 05:30:00 | SPY | ETF | 389.01 | 389.03 | 388.91 | 388.91 | 2000.0 |
| 2021-03-03 05:35:00 | SPY | ETF | 388.88 | 388.88 | 388.6 | 388.76 | 33949.0 |
| 2021-03-03 05:40:00 | SPY | ETF | 388.69 | 388.7 | 388.56 | 388.56 | 16100.0 |
| 2021-03-03 05:45:00 | SPY | ETF | 388.54 | 388.71 | 388.54 | 388.63 | 5000.0 |
| 2021-03-03 05:50:00 | SPY | ETF | 388.63 | 388.73 | 388.63 | 388.73 | 400.0 |
| 2021-03-03 05:55:00 | SPY | ETF | 388.7 | 388.92 | 388.64 | 388.85 | 4300.0 |
| 2021-03-03 06:00:00 | SPY | ETF | 388.87 | 388.87 | 388.54 | 388.54 | 3400.0 |
| 2021-03-03 06:05:00 | SPY | ETF | 388.66 | 388.75 | 388.61 | 388.72 | 2415.0 |
| 2021-03-03 06:10:00 | SPY | ETF | 388.6 | 388.6 | 388.51 | 388.51 | 400.0 |
| 2021-03-03 06:15:00 | SPY | ETF | 388.66 | 388.66 | 388.56 | 388.57 | 1800.0 |
| 2021-03-03 06:20:00 | SPY | ETF | 388.69 | 388.79 | 388.69 | 388.79 | 1500.0 |
| 2021-03-03 06:25:00 | SPY | ETF | 388.76 | 388.76 | 388.75 | 388.75 | 1700.0 |
| 2021-03-03 06:30:00 | SPY | ETF | 388.71 | 388.71 | 388.57 | 388.6 | 27500.0 |
| 2021-03-03 06:35:00 | SPY | ETF | 388.6 | 388.63 | 388.56 | 388.56 | 7140.0 |
| 2021-03-03 06:40:00 | SPY | ETF | 388.54 | 388.78 | 388.5 | 388.78 | 26187.0 |
| 2021-03-03 06:45:00 | SPY | ETF | 388.85 | 388.91 | 388.85 | 388.85 | 36830.0 |
| 2021-03-03 06:50:00 | SPY | ETF | 388.85 | 388.92 | 388.8 | 388.8 | 48600.0 |
| 2021-03-03 06:55:00 | SPY | ETF | 388.82 | 388.9 | 388.8 | 388.81 | 5442.0 |
| 2021-03-03 07:00:00 | SPY | ETF | 388.87 | 388.97 | 388.78 | 388.84 | 16748.0 |
| 2021-03-03 07:05:00 | SPY | ETF | 388.84 | 388.88 | 388.65 | 388.67 | 23172.0 |
| 2021-03-03 07:10:00 | SPY | ETF | 388.66 | 388.75 | 388.6 | 388.63 | 6899.0 |
| 2021-03-03 07:15:00 | SPY | ETF | 388.64 | 388.73 | 388.63 | 388.64 | 4498.0 |
| 2021-03-03 07:20:00 | SPY | ETF | 388.61 | 388.75 | 388.58 | 388.75 | 6816.0 |
| 2021-03-03 07:25:00 | SPY | ETF | 388.73 | 388.73 | 388.65 | 388.65 | 7298.0 |
| 2021-03-03 07:30:00 | SPY | ETF | 388.63 | 388.68 | 388.2 | 388.22 | 23143.0 |
| 2021-03-03 07:35:00 | SPY | ETF | 388.3 | 388.35 | 388.07 | 388.11 | 10892.0 |
| 2021-03-03 07:40:00 | SPY | ETF | 388.11 | 388.4 | 388.11 | 388.39 | 10665.0 |
| 2021-03-03 07:45:00 | SPY | ETF | 388.4 | 388.4 | 388.23 | 388.23 | 6550.0 |
| 2021-03-03 07:50:00 | SPY | ETF | 388.18 | 388.25 | 388.11 | 388.16 | 28761.0 |
| 2021-03-03 07:55:00 | SPY | ETF | 388.11 | 388.21 | 388.05 | 388.1 | 44186.0 |
| 2021-03-03 08:00:00 | SPY | ETF | 388.84 | 388.99 | 387.99 | 388.18 | 85947.0 |
| 2021-03-03 08:05:00 | SPY | ETF | 388.18 | 388.18 | 387.38 | 387.44 | 28056.0 |
> showing 50 of 91,021 rows — these rows as CSV