PREVIEW / etf_5min / 2022-11-15
file: by_date/etf_5min/2022/2022-11-15.parquet size: 2.1 MB rows: 103,288
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-11-15 04:00:00 | SPY | ETF | 397.67 | 397.83 | 397.63 | 397.83 | 14705.0 |
| 2022-11-15 04:05:00 | SPY | ETF | 397.9 | 397.91 | 397.61 | 397.65 | 5283.0 |
| 2022-11-15 04:10:00 | SPY | ETF | 397.65 | 397.71 | 397.5 | 397.71 | 9649.0 |
| 2022-11-15 04:15:00 | SPY | ETF | 397.76 | 397.76 | 397.43 | 397.6 | 10632.0 |
| 2022-11-15 04:20:00 | SPY | ETF | 397.56 | 397.61 | 397.43 | 397.48 | 15874.0 |
| 2022-11-15 04:25:00 | SPY | ETF | 397.48 | 397.5 | 397.39 | 397.5 | 1852.0 |
| 2022-11-15 04:30:00 | SPY | ETF | 397.62 | 397.63 | 397.48 | 397.57 | 8600.0 |
| 2022-11-15 04:35:00 | SPY | ETF | 397.59 | 397.59 | 397.36 | 397.39 | 2962.0 |
| 2022-11-15 04:40:00 | SPY | ETF | 397.46 | 397.65 | 397.46 | 397.6 | 1907.0 |
| 2022-11-15 04:45:00 | SPY | ETF | 397.63 | 397.67 | 397.55 | 397.56 | 3179.0 |
| 2022-11-15 04:50:00 | SPY | ETF | 397.62 | 397.79 | 397.62 | 397.71 | 4445.0 |
| 2022-11-15 04:55:00 | SPY | ETF | 397.71 | 397.79 | 397.68 | 397.75 | 1807.0 |
| 2022-11-15 05:00:00 | SPY | ETF | 397.73 | 398.15 | 397.73 | 398.13 | 4013.0 |
| 2022-11-15 05:05:00 | SPY | ETF | 398.16 | 398.17 | 398.0 | 398.05 | 4222.0 |
| 2022-11-15 05:10:00 | SPY | ETF | 398.11 | 398.4 | 398.11 | 398.4 | 2589.0 |
| 2022-11-15 05:15:00 | SPY | ETF | 398.41 | 398.41 | 398.2 | 398.2 | 1270.0 |
| 2022-11-15 05:20:00 | SPY | ETF | 398.15 | 398.22 | 398.0 | 398.0 | 4309.0 |
| 2022-11-15 05:25:00 | SPY | ETF | 397.99 | 397.99 | 397.85 | 397.85 | 3367.0 |
| 2022-11-15 05:30:00 | SPY | ETF | 397.89 | 397.96 | 397.84 | 397.84 | 2594.0 |
| 2022-11-15 05:35:00 | SPY | ETF | 397.92 | 397.99 | 397.73 | 397.89 | 2614.0 |
| 2022-11-15 05:40:00 | SPY | ETF | 397.94 | 397.95 | 397.8 | 397.89 | 5850.0 |
| 2022-11-15 05:45:00 | SPY | ETF | 397.95 | 398.0 | 397.86 | 397.86 | 8810.0 |
| 2022-11-15 05:50:00 | SPY | ETF | 397.88 | 397.92 | 397.8 | 397.89 | 3909.0 |
| 2022-11-15 05:55:00 | SPY | ETF | 397.82 | 397.95 | 397.82 | 397.95 | 4627.0 |
| 2022-11-15 06:00:00 | SPY | ETF | 397.94 | 398.3 | 397.94 | 398.17 | 22071.0 |
| 2022-11-15 06:05:00 | SPY | ETF | 398.19 | 398.21 | 398.06 | 398.21 | 2553.0 |
| 2022-11-15 06:10:00 | SPY | ETF | 398.2 | 398.21 | 397.95 | 397.95 | 1236.0 |
| 2022-11-15 06:15:00 | SPY | ETF | 397.89 | 397.95 | 397.8 | 397.81 | 1919.0 |
| 2022-11-15 06:20:00 | SPY | ETF | 397.84 | 397.89 | 397.71 | 397.71 | 12034.0 |
| 2022-11-15 06:25:00 | SPY | ETF | 397.69 | 397.9 | 397.69 | 397.9 | 13879.0 |
| 2022-11-15 06:30:00 | SPY | ETF | 397.88 | 397.93 | 397.78 | 397.78 | 2570.0 |
| 2022-11-15 06:35:00 | SPY | ETF | 397.76 | 397.85 | 397.6 | 397.62 | 5389.0 |
| 2022-11-15 06:40:00 | SPY | ETF | 397.56 | 397.66 | 397.54 | 397.64 | 37746.0 |
| 2022-11-15 06:45:00 | SPY | ETF | 397.59 | 397.85 | 397.55 | 397.85 | 24536.0 |
| 2022-11-15 06:50:00 | SPY | ETF | 397.82 | 397.83 | 397.75 | 397.75 | 6279.0 |
| 2022-11-15 06:55:00 | SPY | ETF | 397.82 | 398.07 | 397.82 | 398.05 | 18941.0 |
| 2022-11-15 07:00:00 | SPY | ETF | 398.07 | 398.07 | 397.68 | 397.68 | 9614.0 |
| 2022-11-15 07:05:00 | SPY | ETF | 397.73 | 398.2 | 397.73 | 398.09 | 41396.0 |
| 2022-11-15 07:10:00 | SPY | ETF | 398.09 | 398.21 | 398.04 | 398.04 | 45112.0 |
| 2022-11-15 07:15:00 | SPY | ETF | 398.01 | 398.32 | 397.85 | 398.3 | 32495.0 |
| 2022-11-15 07:20:00 | SPY | ETF | 398.32 | 398.79 | 398.22 | 398.68 | 32293.0 |
| 2022-11-15 07:25:00 | SPY | ETF | 398.68 | 399.11 | 398.68 | 398.92 | 68669.0 |
| 2022-11-15 07:30:00 | SPY | ETF | 398.95 | 399.01 | 398.85 | 398.98 | 25895.0 |
| 2022-11-15 07:35:00 | SPY | ETF | 399.0 | 399.12 | 398.99 | 399.0 | 29506.0 |
| 2022-11-15 07:40:00 | SPY | ETF | 398.99 | 399.1 | 398.91 | 399.0 | 31714.0 |
| 2022-11-15 07:45:00 | SPY | ETF | 398.99 | 399.15 | 398.99 | 399.07 | 8951.0 |
| 2022-11-15 07:50:00 | SPY | ETF | 399.12 | 399.12 | 398.9 | 398.97 | 23692.0 |
| 2022-11-15 07:55:00 | SPY | ETF | 398.98 | 399.09 | 398.9 | 399.05 | 38840.0 |
| 2022-11-15 08:00:00 | SPY | ETF | 398.0 | 399.19 | 396.8 | 399.0 | 100861.0 |
| 2022-11-15 08:05:00 | SPY | ETF | 398.0 | 399.57 | 398.0 | 399.57 | 128424.0 |
> showing 50 of 103,288 rows — these rows as CSV