PREVIEW / etf_5min / 2021-05-05
file: by_date/etf_5min/2021/2021-05-05.parquet size: 1.8 MB rows: 82,826
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-05-05 04:00:00 | SPY | ETF | 416.8 | 416.8 | 416.03 | 416.53 | 7085.0 |
| 2021-05-05 04:05:00 | SPY | ETF | 416.53 | 416.56 | 416.47 | 416.56 | 1600.0 |
| 2021-05-05 04:10:00 | SPY | ETF | 416.54 | 416.7 | 416.54 | 416.6 | 2100.0 |
| 2021-05-05 04:15:00 | SPY | ETF | 416.71 | 416.75 | 416.68 | 416.68 | 5706.0 |
| 2021-05-05 04:20:00 | SPY | ETF | 416.73 | 416.87 | 416.73 | 416.8 | 1247.0 |
| 2021-05-05 04:25:00 | SPY | ETF | 416.8 | 417.02 | 416.8 | 417.01 | 2611.0 |
| 2021-05-05 04:30:00 | SPY | ETF | 417.07 | 417.16 | 417.02 | 417.12 | 4000.0 |
| 2021-05-05 04:40:00 | SPY | ETF | 416.94 | 416.94 | 416.9 | 416.92 | 2142.0 |
| 2021-05-05 04:45:00 | SPY | ETF | 416.82 | 416.94 | 416.82 | 416.94 | 250.0 |
| 2021-05-05 04:55:00 | SPY | ETF | 416.92 | 416.92 | 416.83 | 416.83 | 1500.0 |
| 2021-05-05 05:00:00 | SPY | ETF | 416.87 | 416.87 | 416.87 | 416.87 | 600.0 |
| 2021-05-05 05:05:00 | SPY | ETF | 416.93 | 416.97 | 416.9 | 416.97 | 400.0 |
| 2021-05-05 05:10:00 | SPY | ETF | 416.94 | 416.94 | 416.94 | 416.94 | 399.0 |
| 2021-05-05 05:15:00 | SPY | ETF | 417.1 | 417.1 | 417.1 | 417.1 | 400.0 |
| 2021-05-05 05:20:00 | SPY | ETF | 417.13 | 417.17 | 417.07 | 417.17 | 519.0 |
| 2021-05-05 05:25:00 | SPY | ETF | 416.94 | 416.94 | 416.94 | 416.94 | 600.0 |
| 2021-05-05 05:30:00 | SPY | ETF | 416.96 | 417.1 | 416.96 | 417.1 | 3192.0 |
| 2021-05-05 05:35:00 | SPY | ETF | 417.09 | 417.16 | 417.02 | 417.03 | 51575.0 |
| 2021-05-05 05:40:00 | SPY | ETF | 417.05 | 417.05 | 417.0 | 417.0 | 575.0 |
| 2021-05-05 05:45:00 | SPY | ETF | 416.92 | 416.95 | 416.88 | 416.88 | 3396.0 |
| 2021-05-05 05:50:00 | SPY | ETF | 416.92 | 416.97 | 416.92 | 416.97 | 200.0 |
| 2021-05-05 05:55:00 | SPY | ETF | 417.01 | 417.07 | 416.92 | 417.0 | 4480.0 |
| 2021-05-05 06:00:00 | SPY | ETF | 417.0 | 417.0 | 417.0 | 417.0 | 100.0 |
| 2021-05-05 06:05:00 | SPY | ETF | 416.95 | 416.95 | 416.88 | 416.88 | 1000.0 |
| 2021-05-05 06:10:00 | SPY | ETF | 416.89 | 416.92 | 416.89 | 416.92 | 900.0 |
| 2021-05-05 06:15:00 | SPY | ETF | 416.91 | 416.96 | 416.87 | 416.96 | 2975.0 |
| 2021-05-05 06:20:00 | SPY | ETF | 417.0 | 417.1 | 417.0 | 417.1 | 4795.0 |
| 2021-05-05 06:25:00 | SPY | ETF | 417.05 | 417.12 | 417.02 | 417.1 | 2908.0 |
| 2021-05-05 06:30:00 | SPY | ETF | 417.15 | 417.2 | 417.1 | 417.18 | 8290.0 |
| 2021-05-05 06:35:00 | SPY | ETF | 417.18 | 417.28 | 417.12 | 417.25 | 21856.0 |
| 2021-05-05 06:40:00 | SPY | ETF | 417.21 | 417.21 | 416.84 | 416.96 | 15799.0 |
| 2021-05-05 06:45:00 | SPY | ETF | 417.02 | 417.06 | 417.01 | 417.01 | 5102.0 |
| 2021-05-05 06:50:00 | SPY | ETF | 416.99 | 416.99 | 416.99 | 416.99 | 100.0 |
| 2021-05-05 06:55:00 | SPY | ETF | 417.1 | 417.1 | 416.99 | 417.03 | 1599.0 |
| 2021-05-05 07:00:00 | SPY | ETF | 416.97 | 416.98 | 416.84 | 416.88 | 35324.0 |
| 2021-05-05 07:05:00 | SPY | ETF | 416.83 | 416.869 | 416.65 | 416.73 | 61084.0 |
| 2021-05-05 07:10:00 | SPY | ETF | 416.68 | 416.73 | 416.66 | 416.66 | 6630.0 |
| 2021-05-05 07:15:00 | SPY | ETF | 416.66 | 416.69 | 416.62 | 416.68 | 10830.0 |
| 2021-05-05 07:20:00 | SPY | ETF | 416.65 | 416.68 | 416.62 | 416.66 | 1864.0 |
| 2021-05-05 07:25:00 | SPY | ETF | 416.66 | 416.93 | 416.66 | 416.93 | 5478.0 |
| 2021-05-05 07:30:00 | SPY | ETF | 416.93 | 417.06 | 416.9 | 417.04 | 17239.0 |
| 2021-05-05 07:35:00 | SPY | ETF | 417.05 | 417.05 | 417.0 | 417.05 | 3392.0 |
| 2021-05-05 07:40:00 | SPY | ETF | 417.02 | 417.1 | 416.99 | 417.0 | 24416.0 |
| 2021-05-05 07:45:00 | SPY | ETF | 417.0 | 417.0 | 416.86 | 416.86 | 3350.0 |
| 2021-05-05 07:50:00 | SPY | ETF | 416.9 | 417.0 | 416.87 | 416.97 | 2490.0 |
| 2021-05-05 07:55:00 | SPY | ETF | 417.0 | 417.05 | 416.97 | 416.97 | 4874.0 |
| 2021-05-05 08:00:00 | SPY | ETF | 416.99 | 417.2 | 416.0 | 417.05 | 41203.0 |
| 2021-05-05 08:05:00 | SPY | ETF | 417.08 | 417.25 | 417.08 | 417.22 | 29053.0 |
| 2021-05-05 08:10:00 | SPY | ETF | 417.24 | 417.27 | 417.2 | 417.21 | 12322.0 |
| 2021-05-05 08:15:00 | SPY | ETF | 417.22 | 417.48 | 417.2 | 417.21 | 33208.0 |
> showing 50 of 82,826 rows — these rows as CSV