PREVIEW / etf_5min / 2023-03-23
file: by_date/etf_5min/2023/2023-03-23.parquet size: 2.0 MB rows: 100,837
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 |
|---|---|---|---|---|---|---|---|
| 2023-03-23 04:00:00 | SPY | ETF | 395.02 | 395.31 | 394.03 | 395.31 | 46238.0 |
| 2023-03-23 04:05:00 | SPY | ETF | 395.3 | 395.37 | 395.29 | 395.37 | 5427.0 |
| 2023-03-23 04:10:00 | SPY | ETF | 395.31 | 395.36 | 395.04 | 395.17 | 5750.0 |
| 2023-03-23 04:15:00 | SPY | ETF | 395.26 | 395.38 | 395.2 | 395.38 | 6533.0 |
| 2023-03-23 04:20:00 | SPY | ETF | 395.34 | 395.38 | 395.22 | 395.26 | 4729.0 |
| 2023-03-23 04:25:00 | SPY | ETF | 395.32 | 395.33 | 395.21 | 395.21 | 10423.0 |
| 2023-03-23 04:30:00 | SPY | ETF | 394.96 | 395.19 | 394.96 | 395.14 | 1250.0 |
| 2023-03-23 04:35:00 | SPY | ETF | 395.22 | 395.22 | 395.04 | 395.07 | 1500.0 |
| 2023-03-23 04:40:00 | SPY | ETF | 395.22 | 395.37 | 395.22 | 395.37 | 2758.0 |
| 2023-03-23 04:45:00 | SPY | ETF | 395.34 | 395.49 | 395.33 | 395.42 | 3215.0 |
| 2023-03-23 04:50:00 | SPY | ETF | 395.39 | 395.39 | 395.27 | 395.34 | 1900.0 |
| 2023-03-23 04:55:00 | SPY | ETF | 395.3 | 395.3 | 395.15 | 395.17 | 2676.0 |
| 2023-03-23 05:00:00 | SPY | ETF | 395.15 | 395.17 | 394.74 | 394.74 | 5974.0 |
| 2023-03-23 05:05:00 | SPY | ETF | 394.88 | 394.95 | 394.84 | 394.9 | 4300.0 |
| 2023-03-23 05:10:00 | SPY | ETF | 394.9 | 394.95 | 394.68 | 394.95 | 8190.0 |
| 2023-03-23 05:15:00 | SPY | ETF | 394.91 | 394.91 | 394.78 | 394.81 | 3332.0 |
| 2023-03-23 05:20:00 | SPY | ETF | 394.77 | 394.82 | 394.6 | 394.63 | 2203.0 |
| 2023-03-23 05:25:00 | SPY | ETF | 394.54 | 394.54 | 394.39 | 394.47 | 2900.0 |
| 2023-03-23 05:30:00 | SPY | ETF | 394.5 | 394.5 | 394.09 | 394.21 | 6450.0 |
| 2023-03-23 05:35:00 | SPY | ETF | 394.24 | 394.38 | 394.24 | 394.3 | 2600.0 |
| 2023-03-23 05:40:00 | SPY | ETF | 394.28 | 394.28 | 394.09 | 394.14 | 1930.0 |
| 2023-03-23 05:45:00 | SPY | ETF | 394.16 | 394.3 | 394.13 | 394.26 | 2322.0 |
| 2023-03-23 05:50:00 | SPY | ETF | 394.2 | 394.4 | 394.2 | 394.34 | 3158.0 |
| 2023-03-23 05:55:00 | SPY | ETF | 394.4 | 394.49 | 394.29 | 394.3 | 2601.0 |
| 2023-03-23 06:00:00 | SPY | ETF | 394.36 | 394.43 | 393.88 | 394.36 | 19184.0 |
| 2023-03-23 06:05:00 | SPY | ETF | 394.26 | 394.31 | 394.11 | 394.3 | 9566.0 |
| 2023-03-23 06:10:00 | SPY | ETF | 394.18 | 394.18 | 393.96 | 393.98 | 4292.0 |
| 2023-03-23 06:15:00 | SPY | ETF | 393.92 | 393.92 | 393.83 | 393.9 | 1900.0 |
| 2023-03-23 06:20:00 | SPY | ETF | 393.89 | 393.89 | 393.3 | 393.3 | 13397.0 |
| 2023-03-23 06:25:00 | SPY | ETF | 393.34 | 393.55 | 393.3 | 393.4 | 46310.0 |
| 2023-03-23 06:30:00 | SPY | ETF | 393.29 | 393.45 | 393.12 | 393.35 | 47103.0 |
| 2023-03-23 06:35:00 | SPY | ETF | 393.43 | 393.55 | 393.42 | 393.54 | 8593.0 |
| 2023-03-23 06:40:00 | SPY | ETF | 393.62 | 393.68 | 393.45 | 393.45 | 11650.0 |
| 2023-03-23 06:45:00 | SPY | ETF | 393.49 | 393.78 | 393.49 | 393.66 | 14307.0 |
| 2023-03-23 06:50:00 | SPY | ETF | 393.67 | 393.85 | 393.67 | 393.8 | 4443.0 |
| 2023-03-23 06:55:00 | SPY | ETF | 393.77 | 393.97 | 393.7 | 393.95 | 4905.0 |
| 2023-03-23 07:00:00 | SPY | ETF | 393.98 | 394.25 | 393.98 | 394.25 | 9251.0 |
| 2023-03-23 07:05:00 | SPY | ETF | 394.241 | 394.31 | 394.11 | 394.23 | 13490.0 |
| 2023-03-23 07:10:00 | SPY | ETF | 394.2 | 394.5 | 394.19 | 394.5 | 17553.0 |
| 2023-03-23 07:15:00 | SPY | ETF | 394.66 | 394.66 | 394.55 | 394.55 | 10316.0 |
| 2023-03-23 07:20:00 | SPY | ETF | 394.45 | 394.51 | 394.35 | 394.39 | 16786.0 |
| 2023-03-23 07:25:00 | SPY | ETF | 394.3 | 394.37 | 394.19 | 394.28 | 8470.0 |
| 2023-03-23 07:30:00 | SPY | ETF | 394.31 | 394.31 | 394.11 | 394.15 | 5086.0 |
| 2023-03-23 07:35:00 | SPY | ETF | 394.17 | 394.32 | 394.17 | 394.22 | 7753.0 |
| 2023-03-23 07:40:00 | SPY | ETF | 394.22 | 394.31 | 394.17 | 394.3 | 7789.0 |
| 2023-03-23 07:45:00 | SPY | ETF | 394.32 | 394.67 | 394.32 | 394.54 | 22003.0 |
| 2023-03-23 07:50:00 | SPY | ETF | 394.57 | 394.69 | 394.48 | 394.67 | 13409.0 |
| 2023-03-23 07:55:00 | SPY | ETF | 394.66 | 394.88 | 394.29 | 394.59 | 89974.0 |
| 2023-03-23 08:00:00 | SPY | ETF | 394.65 | 395.25 | 393.5196 | 394.04 | 101544.0 |
| 2023-03-23 08:05:00 | SPY | ETF | 394.16 | 394.3 | 394.06 | 394.13 | 22860.0 |
> showing 50 of 100,837 rows — these rows as CSV