PREVIEW / etf_5min / 2022-03-07
file: by_date/etf_5min/2022/2022-03-07.parquet size: 2.2 MB rows: 107,827
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-07 04:00:00 | SPY | ETF | 425.95 | 427.85 | 425.64 | 425.72 | 62665.0 |
| 2022-03-07 04:05:00 | SPY | ETF | 425.72 | 426.95 | 425.72 | 426.8 | 7577.0 |
| 2022-03-07 04:10:00 | SPY | ETF | 426.73 | 426.85 | 426.61 | 426.8 | 3951.0 |
| 2022-03-07 04:15:00 | SPY | ETF | 426.69 | 426.69 | 426.0 | 426.32 | 1094.0 |
| 2022-03-07 04:20:00 | SPY | ETF | 426.49 | 426.79 | 426.32 | 426.32 | 1054.0 |
| 2022-03-07 04:25:00 | SPY | ETF | 426.22 | 426.7 | 426.2 | 426.32 | 5182.0 |
| 2022-03-07 04:30:00 | SPY | ETF | 426.38 | 426.42 | 425.66 | 425.71 | 5713.0 |
| 2022-03-07 04:35:00 | SPY | ETF | 425.68 | 425.75 | 425.42 | 425.42 | 21265.0 |
| 2022-03-07 04:40:00 | SPY | ETF | 425.38 | 426.03 | 425.27 | 425.71 | 6144.0 |
| 2022-03-07 04:45:00 | SPY | ETF | 425.52 | 425.54 | 424.98 | 425.09 | 10290.0 |
| 2022-03-07 04:50:00 | SPY | ETF | 425.0 | 425.5 | 424.98 | 425.5 | 5855.0 |
| 2022-03-07 04:55:00 | SPY | ETF | 425.45 | 426.12 | 425.45 | 425.85 | 3199.0 |
| 2022-03-07 05:00:00 | SPY | ETF | 425.98 | 426.06 | 425.75 | 425.87 | 1055.0 |
| 2022-03-07 05:05:00 | SPY | ETF | 425.85 | 426.04 | 425.64 | 426.04 | 962.0 |
| 2022-03-07 05:10:00 | SPY | ETF | 425.86 | 426.48 | 425.86 | 426.48 | 1438.0 |
| 2022-03-07 05:15:00 | SPY | ETF | 426.49 | 426.49 | 426.14 | 426.23 | 500.0 |
| 2022-03-07 05:20:00 | SPY | ETF | 426.16 | 426.32 | 426.16 | 426.32 | 621.0 |
| 2022-03-07 05:25:00 | SPY | ETF | 426.27 | 426.28 | 425.83 | 425.86 | 3414.0 |
| 2022-03-07 05:30:00 | SPY | ETF | 425.63 | 425.74 | 425.34 | 425.74 | 9017.0 |
| 2022-03-07 05:35:00 | SPY | ETF | 425.64 | 425.78 | 425.49 | 425.49 | 1455.0 |
| 2022-03-07 05:40:00 | SPY | ETF | 425.44 | 425.74 | 425.44 | 425.6 | 13724.0 |
| 2022-03-07 05:45:00 | SPY | ETF | 425.9 | 426.09 | 425.73 | 426.09 | 2721.0 |
| 2022-03-07 05:50:00 | SPY | ETF | 426.15 | 426.34 | 426.08 | 426.33 | 10216.0 |
| 2022-03-07 05:55:00 | SPY | ETF | 426.22 | 426.46 | 425.22 | 425.22 | 20516.0 |
| 2022-03-07 06:00:00 | SPY | ETF | 425.29 | 425.3 | 424.73 | 424.73 | 16122.0 |
| 2022-03-07 06:05:00 | SPY | ETF | 424.79 | 425.09 | 424.58 | 425.08 | 15800.0 |
| 2022-03-07 06:10:00 | SPY | ETF | 425.08 | 425.46 | 425.08 | 425.37 | 10750.0 |
| 2022-03-07 06:15:00 | SPY | ETF | 425.0 | 425.23 | 424.25 | 425.19 | 16262.0 |
| 2022-03-07 06:20:00 | SPY | ETF | 425.16 | 426.1 | 425.16 | 426.06 | 16155.0 |
| 2022-03-07 06:25:00 | SPY | ETF | 425.95 | 426.07 | 425.77 | 425.77 | 5697.0 |
| 2022-03-07 06:30:00 | SPY | ETF | 425.78 | 426.09 | 425.78 | 425.96 | 11114.0 |
| 2022-03-07 06:35:00 | SPY | ETF | 425.86 | 426.02 | 425.54 | 425.54 | 3700.0 |
| 2022-03-07 06:40:00 | SPY | ETF | 425.63 | 426.29 | 425.63 | 426.26 | 3591.0 |
| 2022-03-07 06:45:00 | SPY | ETF | 426.16 | 426.44 | 426.1 | 426.2 | 8748.0 |
| 2022-03-07 06:50:00 | SPY | ETF | 426.33 | 426.9 | 426.25 | 426.85 | 19962.0 |
| 2022-03-07 06:55:00 | SPY | ETF | 426.8 | 427.34 | 426.8 | 427.16 | 28193.0 |
| 2022-03-07 07:00:00 | SPY | ETF | 427.24 | 428.35 | 427.18 | 428.3 | 75265.0 |
| 2022-03-07 07:05:00 | SPY | ETF | 428.3 | 428.62 | 427.75 | 428.02 | 80163.0 |
| 2022-03-07 07:10:00 | SPY | ETF | 428.21 | 428.98 | 428.21 | 428.6 | 47476.0 |
| 2022-03-07 07:15:00 | SPY | ETF | 428.6 | 429.5 | 428.46 | 429.49 | 97313.0 |
| 2022-03-07 07:20:00 | SPY | ETF | 429.45 | 429.86 | 429.26 | 429.85 | 74074.0 |
| 2022-03-07 07:25:00 | SPY | ETF | 429.85 | 430.22 | 429.25 | 430.09 | 102759.0 |
| 2022-03-07 07:30:00 | SPY | ETF | 430.1 | 430.57 | 429.77 | 430.0 | 144196.0 |
| 2022-03-07 07:35:00 | SPY | ETF | 430.12 | 430.39 | 429.82 | 430.31 | 75534.0 |
| 2022-03-07 07:40:00 | SPY | ETF | 430.21 | 430.21 | 429.54 | 429.7 | 71228.0 |
| 2022-03-07 07:45:00 | SPY | ETF | 429.83 | 429.85 | 429.11 | 429.17 | 47637.0 |
| 2022-03-07 07:50:00 | SPY | ETF | 429.13 | 429.81 | 429.1 | 429.75 | 62105.0 |
| 2022-03-07 07:55:00 | SPY | ETF | 429.75 | 429.9 | 428.76 | 428.76 | 91028.0 |
| 2022-03-07 08:00:00 | SPY | ETF | 427.955 | 432.424 | 423.54 | 428.6 | 241010.0 |
| 2022-03-07 08:05:00 | SPY | ETF | 428.59 | 429.14 | 428.45 | 429.14 | 27929.0 |
> showing 50 of 107,827 rows — these rows as CSV