PREVIEW / etf_5min / 2021-08-06
file: by_date/etf_5min/2021/2021-08-06.parquet size: 1.7 MB rows: 77,399
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-08-06 04:05:00 | SPY | ETF | 441.41 | 441.41 | 441.41 | 441.41 | 1200.0 |
| 2021-08-06 04:10:00 | SPY | ETF | 441.4 | 441.4 | 441.4 | 441.4 | 1350.0 |
| 2021-08-06 04:15:00 | SPY | ETF | 441.45 | 441.47 | 441.42 | 441.43 | 1214.0 |
| 2021-08-06 04:20:00 | SPY | ETF | 441.43 | 441.43 | 441.43 | 441.43 | 400.0 |
| 2021-08-06 04:25:00 | SPY | ETF | 441.5 | 441.51 | 441.5 | 441.51 | 288.0 |
| 2021-08-06 04:30:00 | SPY | ETF | 441.56 | 441.56 | 441.56 | 441.56 | 123.0 |
| 2021-08-06 04:35:00 | SPY | ETF | 441.54 | 441.61 | 441.54 | 441.61 | 1250.0 |
| 2021-08-06 04:40:00 | SPY | ETF | 441.65 | 441.65 | 441.65 | 441.65 | 800.0 |
| 2021-08-06 04:55:00 | SPY | ETF | 441.82 | 441.93 | 441.82 | 441.88 | 1700.0 |
| 2021-08-06 05:05:00 | SPY | ETF | 441.85 | 441.85 | 441.85 | 441.85 | 100.0 |
| 2021-08-06 05:10:00 | SPY | ETF | 441.85 | 441.85 | 441.85 | 441.85 | 200.0 |
| 2021-08-06 05:20:00 | SPY | ETF | 441.87 | 441.9 | 441.87 | 441.9 | 3282.0 |
| 2021-08-06 05:25:00 | SPY | ETF | 441.86 | 441.86 | 441.81 | 441.81 | 1000.0 |
| 2021-08-06 05:30:00 | SPY | ETF | 441.84 | 441.84 | 441.84 | 441.84 | 600.0 |
| 2021-08-06 05:45:00 | SPY | ETF | 441.86 | 441.89 | 441.86 | 441.89 | 500.0 |
| 2021-08-06 06:00:00 | SPY | ETF | 441.87 | 441.87 | 441.87 | 441.87 | 474.0 |
| 2021-08-06 06:05:00 | SPY | ETF | 441.83 | 441.85 | 441.83 | 441.85 | 12700.0 |
| 2021-08-06 06:10:00 | SPY | ETF | 441.85 | 442.0 | 441.85 | 442.0 | 4420.0 |
| 2021-08-06 06:15:00 | SPY | ETF | 441.98 | 441.98 | 441.97 | 441.97 | 690.0 |
| 2021-08-06 06:20:00 | SPY | ETF | 441.95 | 442.03 | 441.95 | 442.03 | 3100.0 |
| 2021-08-06 06:25:00 | SPY | ETF | 442.07 | 442.07 | 442.0 | 442.0 | 2291.0 |
| 2021-08-06 06:30:00 | SPY | ETF | 442.0 | 442.0 | 441.98 | 441.98 | 5018.0 |
| 2021-08-06 06:40:00 | SPY | ETF | 441.94 | 441.96 | 441.94 | 441.96 | 200.0 |
| 2021-08-06 06:45:00 | SPY | ETF | 441.95 | 441.95 | 441.95 | 441.95 | 2900.0 |
| 2021-08-06 06:50:00 | SPY | ETF | 441.92 | 441.92 | 441.92 | 441.92 | 2898.0 |
| 2021-08-06 06:55:00 | SPY | ETF | 441.93 | 441.93 | 441.9 | 441.93 | 2870.0 |
| 2021-08-06 07:00:00 | SPY | ETF | 441.94 | 442.0 | 441.93 | 441.96 | 3325.0 |
| 2021-08-06 07:05:00 | SPY | ETF | 441.96 | 442.1 | 441.96 | 442.1 | 10672.0 |
| 2021-08-06 07:10:00 | SPY | ETF | 442.08 | 442.08 | 442.03 | 442.03 | 2480.0 |
| 2021-08-06 07:15:00 | SPY | ETF | 442.05 | 442.09 | 442.05 | 442.07 | 3063.0 |
| 2021-08-06 07:20:00 | SPY | ETF | 442.07 | 442.07 | 442.05 | 442.05 | 367.0 |
| 2021-08-06 07:25:00 | SPY | ETF | 442.06 | 442.06 | 442.0 | 442.0 | 1958.0 |
| 2021-08-06 07:30:00 | SPY | ETF | 442.01 | 442.1 | 442.01 | 442.1 | 8152.0 |
| 2021-08-06 07:35:00 | SPY | ETF | 442.1 | 442.1 | 442.07 | 442.09 | 1864.0 |
| 2021-08-06 07:40:00 | SPY | ETF | 442.11 | 442.11 | 442.05 | 442.05 | 736.0 |
| 2021-08-06 07:45:00 | SPY | ETF | 442.04 | 442.04 | 442.0 | 442.0 | 360.0 |
| 2021-08-06 07:50:00 | SPY | ETF | 441.99 | 441.99 | 441.95 | 441.97 | 26306.0 |
| 2021-08-06 07:55:00 | SPY | ETF | 441.94 | 441.95 | 441.94 | 441.95 | 900.0 |
| 2021-08-06 08:00:00 | SPY | ETF | 441.9501 | 442.1 | 441.56 | 441.91 | 15090.0 |
| 2021-08-06 08:05:00 | SPY | ETF | 441.9399 | 441.98 | 441.9399 | 441.98 | 5157.0 |
| 2021-08-06 08:10:00 | SPY | ETF | 441.97 | 442.01 | 441.97 | 441.97 | 15442.0 |
| 2021-08-06 08:15:00 | SPY | ETF | 441.98 | 442.0 | 441.95 | 441.97 | 5487.0 |
| 2021-08-06 08:20:00 | SPY | ETF | 441.99 | 441.99 | 441.9 | 441.93 | 3296.0 |
| 2021-08-06 08:25:00 | SPY | ETF | 441.91 | 441.93 | 441.8 | 441.82 | 36770.0 |
| 2021-08-06 08:30:00 | SPY | ETF | 441.77 | 442.6 | 441.6 | 442.11 | 315588.0 |
| 2021-08-06 08:35:00 | SPY | ETF | 442.07 | 442.16 | 441.75 | 442.09 | 123352.0 |
| 2021-08-06 08:40:00 | SPY | ETF | 442.09 | 442.25 | 441.62 | 441.8 | 116643.0 |
| 2021-08-06 08:45:00 | SPY | ETF | 441.76 | 441.94 | 441.62 | 441.63 | 86438.0 |
| 2021-08-06 08:50:00 | SPY | ETF | 441.66 | 441.73 | 441.36 | 441.63 | 55470.0 |
| 2021-08-06 08:55:00 | SPY | ETF | 441.65 | 442.27 | 441.64 | 441.85 | 81772.0 |
> showing 50 of 77,399 rows — these rows as CSV