PREVIEW / etf_5min / 2021-01-29
file: by_date/etf_5min/2021/2021-01-29.parquet size: 2.0 MB rows: 92,055
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-01-29 04:00:00 | SPY | ETF | 373.96 | 374.38 | 373.96 | 374.28 | 42969.0 |
| 2021-01-29 04:05:00 | SPY | ETF | 374.25 | 374.64 | 374.19 | 374.34 | 22186.0 |
| 2021-01-29 04:10:00 | SPY | ETF | 374.45 | 374.45 | 374.14 | 374.21 | 1844.0 |
| 2021-01-29 04:15:00 | SPY | ETF | 374.08 | 374.15 | 373.45 | 373.45 | 7166.0 |
| 2021-01-29 04:20:00 | SPY | ETF | 373.3 | 373.54 | 373.24 | 373.54 | 1874.0 |
| 2021-01-29 04:25:00 | SPY | ETF | 373.74 | 374.17 | 373.59 | 374.17 | 5466.0 |
| 2021-01-29 04:30:00 | SPY | ETF | 373.94 | 374.32 | 373.9 | 374.32 | 3200.0 |
| 2021-01-29 04:35:00 | SPY | ETF | 374.65 | 374.79 | 374.44 | 374.44 | 27745.0 |
| 2021-01-29 04:40:00 | SPY | ETF | 374.4 | 374.4 | 374.4 | 374.4 | 100.0 |
| 2021-01-29 04:45:00 | SPY | ETF | 373.84 | 374.03 | 373.45 | 374.03 | 8608.0 |
| 2021-01-29 04:50:00 | SPY | ETF | 374.19 | 374.19 | 373.47 | 373.47 | 4086.0 |
| 2021-01-29 04:55:00 | SPY | ETF | 373.8 | 373.8 | 373.74 | 373.74 | 2600.0 |
| 2021-01-29 05:00:00 | SPY | ETF | 373.47 | 373.47 | 373.17 | 373.42 | 6600.0 |
| 2021-01-29 05:05:00 | SPY | ETF | 373.32 | 373.4 | 373.14 | 373.3 | 2260.0 |
| 2021-01-29 05:10:00 | SPY | ETF | 373.28 | 373.53 | 373.2 | 373.53 | 7414.0 |
| 2021-01-29 05:15:00 | SPY | ETF | 373.57 | 373.57 | 372.87 | 372.87 | 4562.0 |
| 2021-01-29 05:20:00 | SPY | ETF | 372.95 | 373.0 | 372.85 | 373.0 | 720.0 |
| 2021-01-29 05:25:00 | SPY | ETF | 373.13 | 373.37 | 373.13 | 373.27 | 1880.0 |
| 2021-01-29 05:30:00 | SPY | ETF | 373.2 | 373.23 | 373.2 | 373.23 | 1300.0 |
| 2021-01-29 05:35:00 | SPY | ETF | 373.6 | 373.67 | 373.44 | 373.47 | 26150.0 |
| 2021-01-29 05:40:00 | SPY | ETF | 373.22 | 373.76 | 373.22 | 373.76 | 3869.0 |
| 2021-01-29 05:45:00 | SPY | ETF | 373.73 | 373.92 | 373.73 | 373.9 | 4700.0 |
| 2021-01-29 05:50:00 | SPY | ETF | 373.9 | 374.06 | 373.88 | 374.0 | 5447.0 |
| 2021-01-29 05:55:00 | SPY | ETF | 374.05 | 374.26 | 374.05 | 374.18 | 925.0 |
| 2021-01-29 06:00:00 | SPY | ETF | 374.18 | 374.18 | 374.0 | 374.0 | 25700.0 |
| 2021-01-29 06:05:00 | SPY | ETF | 374.03 | 374.03 | 373.62 | 373.62 | 4101.0 |
| 2021-01-29 06:10:00 | SPY | ETF | 373.88 | 374.0 | 373.88 | 373.95 | 5700.0 |
| 2021-01-29 06:15:00 | SPY | ETF | 374.22 | 374.69 | 374.22 | 374.63 | 87927.0 |
| 2021-01-29 06:20:00 | SPY | ETF | 374.66 | 374.8 | 374.6 | 374.8 | 32814.0 |
| 2021-01-29 06:25:00 | SPY | ETF | 374.66 | 375.5 | 374.66 | 375.19 | 58071.0 |
| 2021-01-29 06:30:00 | SPY | ETF | 375.22 | 375.5 | 375.12 | 375.35 | 15065.0 |
| 2021-01-29 06:35:00 | SPY | ETF | 375.35 | 376.1 | 375.3 | 375.8 | 28268.0 |
| 2021-01-29 06:40:00 | SPY | ETF | 375.76 | 375.94 | 375.6 | 375.77 | 98230.0 |
| 2021-01-29 06:45:00 | SPY | ETF | 375.77 | 375.77 | 375.3 | 375.39 | 17850.0 |
| 2021-01-29 06:50:00 | SPY | ETF | 375.58 | 375.58 | 375.12 | 375.12 | 8166.0 |
| 2021-01-29 06:55:00 | SPY | ETF | 375.1 | 375.25 | 375.0 | 375.24 | 19090.0 |
| 2021-01-29 07:00:00 | SPY | ETF | 375.28 | 375.3 | 375.06 | 375.15 | 93585.0 |
| 2021-01-29 07:05:00 | SPY | ETF | 375.2 | 375.5 | 375.19 | 375.39 | 40602.0 |
| 2021-01-29 07:10:00 | SPY | ETF | 375.42 | 375.42 | 375.13 | 375.2 | 40434.0 |
| 2021-01-29 07:15:00 | SPY | ETF | 375.2 | 375.44 | 375.1 | 375.19 | 14233.0 |
| 2021-01-29 07:20:00 | SPY | ETF | 375.21 | 375.4 | 375.2 | 375.37 | 12275.0 |
| 2021-01-29 07:25:00 | SPY | ETF | 375.34 | 375.7 | 375.29 | 375.65 | 14673.0 |
| 2021-01-29 07:30:00 | SPY | ETF | 375.65 | 375.89 | 375.2 | 375.28 | 37900.0 |
| 2021-01-29 07:35:00 | SPY | ETF | 375.25 | 375.25 | 374.66 | 374.67 | 27149.0 |
| 2021-01-29 07:40:00 | SPY | ETF | 374.64 | 374.83 | 374.5 | 374.8 | 40178.0 |
| 2021-01-29 07:45:00 | SPY | ETF | 374.78 | 374.94 | 374.6 | 374.77 | 62553.0 |
| 2021-01-29 07:50:00 | SPY | ETF | 374.75 | 374.8 | 374.26 | 374.44 | 57862.0 |
| 2021-01-29 07:55:00 | SPY | ETF | 374.37 | 374.57 | 374.29 | 374.53 | 67133.0 |
| 2021-01-29 08:00:00 | SPY | ETF | 374.45 | 376.0996 | 372.31 | 373.89 | 1195797.0 |
| 2021-01-29 08:05:00 | SPY | ETF | 373.75 | 376.64 | 373.0 | 373.36 | 328484.0 |
> showing 50 of 92,055 rows — these rows as CSV