PREVIEW / etf_5min / 2022-07-18
file: by_date/etf_5min/2022/2022-07-18.parquet size: 1.9 MB rows: 92,498
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-07-18 04:00:00 | SPY | ETF | 388.24 | 388.38 | 386.71 | 388.3 | 14553.0 |
| 2022-07-18 04:05:00 | SPY | ETF | 388.31 | 388.43 | 388.3 | 388.43 | 1049.0 |
| 2022-07-18 04:10:00 | SPY | ETF | 388.41 | 388.45 | 388.25 | 388.35 | 2460.0 |
| 2022-07-18 04:15:00 | SPY | ETF | 388.35 | 388.39 | 388.35 | 388.39 | 1100.0 |
| 2022-07-18 04:20:00 | SPY | ETF | 388.42 | 388.7 | 388.42 | 388.69 | 1678.0 |
| 2022-07-18 04:25:00 | SPY | ETF | 388.73 | 389.29 | 388.73 | 389.19 | 5449.0 |
| 2022-07-18 04:30:00 | SPY | ETF | 389.27 | 389.32 | 389.09 | 389.21 | 3617.0 |
| 2022-07-18 04:35:00 | SPY | ETF | 389.08 | 389.1 | 389.01 | 389.1 | 2378.0 |
| 2022-07-18 04:40:00 | SPY | ETF | 389.23 | 389.3 | 389.23 | 389.3 | 1799.0 |
| 2022-07-18 04:45:00 | SPY | ETF | 389.05 | 389.14 | 389.05 | 389.14 | 800.0 |
| 2022-07-18 04:50:00 | SPY | ETF | 389.11 | 389.3 | 389.11 | 389.25 | 1289.0 |
| 2022-07-18 04:55:00 | SPY | ETF | 389.33 | 389.45 | 389.32 | 389.35 | 1724.0 |
| 2022-07-18 05:00:00 | SPY | ETF | 389.35 | 389.37 | 389.35 | 389.37 | 1330.0 |
| 2022-07-18 05:05:00 | SPY | ETF | 389.25 | 389.25 | 388.92 | 389.01 | 2800.0 |
| 2022-07-18 05:10:00 | SPY | ETF | 389.06 | 389.15 | 389.06 | 389.15 | 801.0 |
| 2022-07-18 05:15:00 | SPY | ETF | 389.14 | 389.15 | 389.09 | 389.15 | 2400.0 |
| 2022-07-18 05:20:00 | SPY | ETF | 389.25 | 389.29 | 389.25 | 389.29 | 250.0 |
| 2022-07-18 05:25:00 | SPY | ETF | 389.32 | 389.32 | 388.96 | 388.96 | 900.0 |
| 2022-07-18 05:30:00 | SPY | ETF | 389.02 | 389.02 | 388.8 | 388.85 | 1495.0 |
| 2022-07-18 05:35:00 | SPY | ETF | 388.87 | 388.87 | 388.84 | 388.84 | 500.0 |
| 2022-07-18 05:40:00 | SPY | ETF | 388.92 | 388.96 | 388.74 | 388.79 | 1501.0 |
| 2022-07-18 05:45:00 | SPY | ETF | 388.8 | 388.81 | 388.65 | 388.65 | 5590.0 |
| 2022-07-18 05:50:00 | SPY | ETF | 388.63 | 388.67 | 388.6 | 388.62 | 3039.0 |
| 2022-07-18 05:55:00 | SPY | ETF | 388.64 | 388.76 | 388.64 | 388.76 | 9205.0 |
| 2022-07-18 06:00:00 | SPY | ETF | 388.75 | 388.75 | 388.68 | 388.68 | 537.0 |
| 2022-07-18 06:05:00 | SPY | ETF | 388.72 | 388.74 | 388.72 | 388.74 | 480.0 |
| 2022-07-18 06:10:00 | SPY | ETF | 388.77 | 389.05 | 388.75 | 389.05 | 4392.0 |
| 2022-07-18 06:15:00 | SPY | ETF | 388.99 | 388.99 | 388.85 | 388.91 | 8474.0 |
| 2022-07-18 06:20:00 | SPY | ETF | 388.95 | 389.03 | 388.95 | 388.96 | 1050.0 |
| 2022-07-18 06:25:00 | SPY | ETF | 389.0 | 389.0 | 388.98 | 388.98 | 600.0 |
| 2022-07-18 06:30:00 | SPY | ETF | 388.99 | 389.0 | 388.95 | 388.95 | 400.0 |
| 2022-07-18 06:35:00 | SPY | ETF | 388.75 | 388.75 | 388.73 | 388.73 | 616.0 |
| 2022-07-18 06:45:00 | SPY | ETF | 388.72 | 388.75 | 388.65 | 388.72 | 3521.0 |
| 2022-07-18 06:50:00 | SPY | ETF | 388.8 | 388.81 | 388.62 | 388.62 | 7200.0 |
| 2022-07-18 06:55:00 | SPY | ETF | 388.65 | 388.77 | 388.65 | 388.77 | 1098.0 |
| 2022-07-18 07:00:00 | SPY | ETF | 388.73 | 388.73 | 388.46 | 388.64 | 11026.0 |
| 2022-07-18 07:05:00 | SPY | ETF | 388.67 | 389.1 | 388.67 | 389.1 | 16559.0 |
| 2022-07-18 07:10:00 | SPY | ETF | 389.03 | 389.12 | 388.91 | 388.91 | 56639.0 |
| 2022-07-18 07:15:00 | SPY | ETF | 388.88 | 389.06 | 388.87 | 389.0 | 12855.0 |
| 2022-07-18 07:20:00 | SPY | ETF | 389.02 | 389.29 | 388.96 | 389.24 | 7395.0 |
| 2022-07-18 07:25:00 | SPY | ETF | 389.24 | 389.25 | 388.99 | 389.12 | 19586.0 |
| 2022-07-18 07:30:00 | SPY | ETF | 389.15 | 389.2 | 389.11 | 389.11 | 32207.0 |
| 2022-07-18 07:35:00 | SPY | ETF | 389.1 | 389.1 | 388.92 | 388.92 | 7775.0 |
| 2022-07-18 07:40:00 | SPY | ETF | 388.91 | 388.97 | 388.82 | 388.85 | 6782.0 |
| 2022-07-18 07:45:00 | SPY | ETF | 388.88 | 389.04 | 388.88 | 388.98 | 2592.0 |
| 2022-07-18 07:50:00 | SPY | ETF | 389.04 | 389.1 | 388.89 | 388.89 | 13962.0 |
| 2022-07-18 07:55:00 | SPY | ETF | 388.94 | 388.94 | 388.76 | 388.8 | 2178.0 |
| 2022-07-18 08:00:00 | SPY | ETF | 388.5001 | 389.29 | 386.81 | 388.82 | 54087.0 |
| 2022-07-18 08:05:00 | SPY | ETF | 388.8 | 389.01 | 388.8 | 388.92 | 17572.0 |
| 2022-07-18 08:10:00 | SPY | ETF | 388.85 | 389.0 | 385.8 | 388.85 | 35354.0 |
> showing 50 of 92,498 rows — these rows as CSV