PREVIEW / etf_5min / 2022-03-09
file: by_date/etf_5min/2022/2022-03-09.parquet size: 2.0 MB rows: 101,158
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-09 04:00:00 | SPY | ETF | 421.5 | 422.24 | 419.11 | 422.0 | 28615.0 |
| 2022-03-09 04:05:00 | SPY | ETF | 421.9 | 422.15 | 421.66 | 421.66 | 18014.0 |
| 2022-03-09 04:10:00 | SPY | ETF | 421.79 | 422.0 | 421.29 | 421.29 | 5055.0 |
| 2022-03-09 04:15:00 | SPY | ETF | 421.81 | 422.14 | 421.73 | 422.13 | 8451.0 |
| 2022-03-09 04:20:00 | SPY | ETF | 422.21 | 422.69 | 422.21 | 422.69 | 7915.0 |
| 2022-03-09 04:25:00 | SPY | ETF | 422.67 | 422.94 | 422.61 | 422.73 | 10614.0 |
| 2022-03-09 04:30:00 | SPY | ETF | 422.75 | 423.18 | 422.55 | 423.18 | 21095.0 |
| 2022-03-09 04:35:00 | SPY | ETF | 423.06 | 423.38 | 423.01 | 423.38 | 7889.0 |
| 2022-03-09 04:40:00 | SPY | ETF | 423.44 | 423.83 | 423.31 | 423.71 | 10382.0 |
| 2022-03-09 04:45:00 | SPY | ETF | 423.67 | 423.68 | 422.85 | 423.06 | 14405.0 |
| 2022-03-09 04:50:00 | SPY | ETF | 423.11 | 423.93 | 423.04 | 423.72 | 8149.0 |
| 2022-03-09 04:55:00 | SPY | ETF | 423.63 | 423.88 | 423.43 | 423.87 | 30675.0 |
| 2022-03-09 05:00:00 | SPY | ETF | 423.84 | 423.95 | 423.25 | 423.95 | 11739.0 |
| 2022-03-09 05:05:00 | SPY | ETF | 423.91 | 424.18 | 423.83 | 423.83 | 10288.0 |
| 2022-03-09 05:10:00 | SPY | ETF | 423.9 | 424.1 | 423.58 | 424.0 | 27225.0 |
| 2022-03-09 05:15:00 | SPY | ETF | 423.69 | 424.14 | 423.56 | 424.1 | 5666.0 |
| 2022-03-09 05:20:00 | SPY | ETF | 423.7 | 423.7 | 423.21 | 423.34 | 15170.0 |
| 2022-03-09 05:25:00 | SPY | ETF | 423.41 | 423.88 | 423.38 | 423.88 | 6175.0 |
| 2022-03-09 05:30:00 | SPY | ETF | 424.0 | 424.19 | 423.7 | 423.86 | 2648.0 |
| 2022-03-09 05:35:00 | SPY | ETF | 423.92 | 424.3 | 423.92 | 424.08 | 7670.0 |
| 2022-03-09 05:40:00 | SPY | ETF | 423.88 | 424.23 | 423.88 | 424.23 | 22000.0 |
| 2022-03-09 05:45:00 | SPY | ETF | 423.99 | 424.08 | 423.86 | 423.87 | 5066.0 |
| 2022-03-09 05:50:00 | SPY | ETF | 424.11 | 424.11 | 423.21 | 423.39 | 18422.0 |
| 2022-03-09 05:55:00 | SPY | ETF | 423.29 | 423.29 | 422.56 | 423.06 | 10440.0 |
| 2022-03-09 06:00:00 | SPY | ETF | 422.86 | 423.37 | 422.73 | 423.37 | 6823.0 |
| 2022-03-09 06:05:00 | SPY | ETF | 423.36 | 423.66 | 423.36 | 423.58 | 6850.0 |
| 2022-03-09 06:10:00 | SPY | ETF | 423.5 | 423.65 | 423.06 | 423.06 | 4600.0 |
| 2022-03-09 06:15:00 | SPY | ETF | 423.03 | 423.73 | 423.03 | 423.67 | 4275.0 |
| 2022-03-09 06:20:00 | SPY | ETF | 423.63 | 424.2 | 423.17 | 424.12 | 15140.0 |
| 2022-03-09 06:25:00 | SPY | ETF | 424.21 | 424.38 | 423.5 | 423.5 | 2171.0 |
| 2022-03-09 06:30:00 | SPY | ETF | 423.43 | 423.76 | 423.29 | 423.64 | 3000.0 |
| 2022-03-09 06:35:00 | SPY | ETF | 423.63 | 423.64 | 423.13 | 423.22 | 16725.0 |
| 2022-03-09 06:40:00 | SPY | ETF | 423.06 | 423.06 | 422.51 | 422.6 | 11436.0 |
| 2022-03-09 06:45:00 | SPY | ETF | 422.55 | 422.93 | 422.33 | 422.88 | 15691.0 |
| 2022-03-09 06:50:00 | SPY | ETF | 422.94 | 423.37 | 422.94 | 423.18 | 28397.0 |
| 2022-03-09 06:55:00 | SPY | ETF | 423.08 | 423.16 | 422.86 | 422.98 | 9977.0 |
| 2022-03-09 07:00:00 | SPY | ETF | 422.81 | 422.95 | 422.4 | 422.92 | 56971.0 |
| 2022-03-09 07:05:00 | SPY | ETF | 422.92 | 423.25 | 422.5 | 423.1 | 52119.0 |
| 2022-03-09 07:10:00 | SPY | ETF | 422.91 | 423.13 | 422.73 | 423.13 | 20379.0 |
| 2022-03-09 07:15:00 | SPY | ETF | 423.08 | 423.59 | 422.95 | 423.54 | 59132.0 |
| 2022-03-09 07:20:00 | SPY | ETF | 423.5 | 423.75 | 423.32 | 423.57 | 46338.0 |
| 2022-03-09 07:25:00 | SPY | ETF | 423.48 | 423.6 | 423.3 | 423.33 | 4225.0 |
| 2022-03-09 07:30:00 | SPY | ETF | 423.4 | 423.6 | 423.06 | 423.4 | 36818.0 |
| 2022-03-09 07:35:00 | SPY | ETF | 423.56 | 423.79 | 423.04 | 423.18 | 12508.0 |
| 2022-03-09 07:40:00 | SPY | ETF | 423.21 | 423.71 | 423.17 | 423.68 | 9823.0 |
| 2022-03-09 07:45:00 | SPY | ETF | 423.68 | 424.01 | 423.37 | 423.55 | 133895.0 |
| 2022-03-09 07:50:00 | SPY | ETF | 423.58 | 423.9 | 423.55 | 423.89 | 19026.0 |
| 2022-03-09 07:55:00 | SPY | ETF | 423.9 | 424.2 | 423.67 | 424.04 | 75870.0 |
| 2022-03-09 08:00:00 | SPY | ETF | 422.9399 | 424.65 | 417.73 | 424.13 | 151180.0 |
| 2022-03-09 08:05:00 | SPY | ETF | 424.09 | 424.34 | 423.81 | 424.32 | 36549.0 |
> showing 50 of 101,158 rows — these rows as CSV