PREVIEW / etf_5min / 2020-09-08
file: by_date/etf_5min/2020/2020-09-08.parquet size: 1.8 MB rows: 80,459
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 |
|---|---|---|---|---|---|---|---|
| 2020-09-08 04:00:00 | SPY | ETF | 343.44 | 343.58 | 343.24 | 343.31 | 4752.0 |
| 2020-09-08 04:05:00 | SPY | ETF | 343.16 | 343.19 | 343.13 | 343.14 | 5606.0 |
| 2020-09-08 04:10:00 | SPY | ETF | 343.14 | 343.15 | 342.63 | 342.64 | 2436.0 |
| 2020-09-08 04:15:00 | SPY | ETF | 342.63 | 342.63 | 341.9 | 342.03 | 5316.0 |
| 2020-09-08 04:20:00 | SPY | ETF | 341.92 | 341.93 | 341.51 | 341.51 | 5564.0 |
| 2020-09-08 04:25:00 | SPY | ETF | 341.41 | 341.62 | 341.11 | 341.57 | 7866.0 |
| 2020-09-08 04:30:00 | SPY | ETF | 341.6 | 341.6 | 341.38 | 341.44 | 2438.0 |
| 2020-09-08 04:35:00 | SPY | ETF | 341.39 | 341.63 | 341.0 | 341.61 | 2911.0 |
| 2020-09-08 04:40:00 | SPY | ETF | 341.61 | 341.61 | 340.84 | 340.86 | 6047.0 |
| 2020-09-08 04:45:00 | SPY | ETF | 340.8 | 340.91 | 340.27 | 340.61 | 23454.0 |
| 2020-09-08 04:50:00 | SPY | ETF | 340.47 | 340.47 | 340.43 | 340.43 | 767.0 |
| 2020-09-08 04:55:00 | SPY | ETF | 340.45 | 340.64 | 340.44 | 340.44 | 3411.0 |
| 2020-09-08 05:00:00 | SPY | ETF | 340.33 | 341.06 | 340.2 | 341.06 | 5749.0 |
| 2020-09-08 05:05:00 | SPY | ETF | 340.98 | 340.98 | 340.89 | 340.93 | 320.0 |
| 2020-09-08 05:10:00 | SPY | ETF | 341.0 | 341.14 | 340.94 | 340.94 | 2826.0 |
| 2020-09-08 05:15:00 | SPY | ETF | 340.82 | 340.83 | 340.66 | 340.75 | 3550.0 |
| 2020-09-08 05:20:00 | SPY | ETF | 340.9 | 340.9 | 340.9 | 340.9 | 200.0 |
| 2020-09-08 05:25:00 | SPY | ETF | 340.55 | 340.6 | 340.38 | 340.6 | 18831.0 |
| 2020-09-08 05:30:00 | SPY | ETF | 340.58 | 340.6 | 340.08 | 340.21 | 22488.0 |
| 2020-09-08 05:35:00 | SPY | ETF | 340.23 | 340.58 | 340.23 | 340.54 | 21009.0 |
| 2020-09-08 05:40:00 | SPY | ETF | 340.65 | 340.65 | 339.99 | 340.03 | 13032.0 |
| 2020-09-08 05:45:00 | SPY | ETF | 339.82 | 340.2 | 339.82 | 340.02 | 1849.0 |
| 2020-09-08 05:50:00 | SPY | ETF | 340.1 | 340.46 | 339.8 | 339.8 | 13067.0 |
| 2020-09-08 05:55:00 | SPY | ETF | 339.7 | 339.94 | 339.58 | 339.78 | 8044.0 |
| 2020-09-08 06:00:00 | SPY | ETF | 339.68 | 340.05 | 339.58 | 339.93 | 57112.0 |
| 2020-09-08 06:05:00 | SPY | ETF | 339.88 | 340.04 | 339.7 | 340.0 | 17981.0 |
| 2020-09-08 06:10:00 | SPY | ETF | 339.98 | 339.99 | 339.73 | 339.92 | 29710.0 |
| 2020-09-08 06:15:00 | SPY | ETF | 339.86 | 340.16 | 339.84 | 339.96 | 8853.0 |
| 2020-09-08 06:20:00 | SPY | ETF | 339.88 | 339.89 | 339.68 | 339.68 | 3702.0 |
| 2020-09-08 06:25:00 | SPY | ETF | 339.54 | 339.54 | 338.92 | 338.92 | 30497.0 |
| 2020-09-08 06:30:00 | SPY | ETF | 339.03 | 339.3 | 338.94 | 338.96 | 7749.0 |
| 2020-09-08 06:35:00 | SPY | ETF | 338.95 | 339.06 | 338.72 | 338.95 | 59208.0 |
| 2020-09-08 06:40:00 | SPY | ETF | 338.91 | 339.2 | 338.91 | 339.2 | 72413.0 |
| 2020-09-08 06:45:00 | SPY | ETF | 339.2 | 339.2 | 339.03 | 339.11 | 19158.0 |
| 2020-09-08 06:50:00 | SPY | ETF | 339.21 | 339.35 | 339.12 | 339.12 | 23713.0 |
| 2020-09-08 06:55:00 | SPY | ETF | 339.3 | 339.47 | 339.3 | 339.47 | 21124.0 |
| 2020-09-08 07:00:00 | SPY | ETF | 339.55 | 339.97 | 339.52 | 339.92 | 35498.0 |
| 2020-09-08 07:05:00 | SPY | ETF | 339.95 | 340.2 | 339.63 | 339.65 | 36258.0 |
| 2020-09-08 07:10:00 | SPY | ETF | 339.64 | 339.89 | 339.62 | 339.64 | 8374.0 |
| 2020-09-08 07:15:00 | SPY | ETF | 339.64 | 339.64 | 339.19 | 339.28 | 37712.0 |
| 2020-09-08 07:20:00 | SPY | ETF | 339.29 | 339.29 | 338.8 | 339.15 | 32332.0 |
| 2020-09-08 07:25:00 | SPY | ETF | 339.18 | 339.45 | 339.16 | 339.43 | 21424.0 |
| 2020-09-08 07:30:00 | SPY | ETF | 339.4 | 339.43 | 338.83 | 338.83 | 16645.0 |
| 2020-09-08 07:35:00 | SPY | ETF | 338.82 | 338.82 | 338.4 | 338.5 | 47473.0 |
| 2020-09-08 07:40:00 | SPY | ETF | 338.5 | 338.5 | 337.75 | 337.77 | 83794.0 |
| 2020-09-08 07:45:00 | SPY | ETF | 337.76 | 337.82 | 337.42 | 337.81 | 37718.0 |
| 2020-09-08 07:50:00 | SPY | ETF | 337.8 | 338.0 | 337.77 | 337.98 | 37202.0 |
| 2020-09-08 07:55:00 | SPY | ETF | 337.99 | 338.56 | 337.94 | 338.34 | 65392.0 |
| 2020-09-08 08:00:00 | SPY | ETF | 339.7101 | 344.49 | 337.42 | 338.18 | 98666.0 |
| 2020-09-08 08:05:00 | SPY | ETF | 338.15 | 338.15 | 337.5 | 337.5 | 36951.0 |
> showing 50 of 80,459 rows — these rows as CSV