PREVIEW / etf_5min / 2023-12-13
file: by_date/etf_5min/2023/2023-12-13.parquet size: 2.3 MB rows: 111,264
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-12-13 04:00:00 | SPY | ETF | 464.88 | 464.92 | 464.75 | 464.75 | 5200.0 |
| 2023-12-13 04:05:00 | SPY | ETF | 464.72 | 464.8 | 464.72 | 464.8 | 2211.0 |
| 2023-12-13 04:10:00 | SPY | ETF | 464.79 | 464.79 | 464.68 | 464.69 | 1500.0 |
| 2023-12-13 04:20:00 | SPY | ETF | 464.78 | 464.84 | 464.78 | 464.83 | 1500.0 |
| 2023-12-13 04:30:00 | SPY | ETF | 464.75 | 464.83 | 464.75 | 464.83 | 300.0 |
| 2023-12-13 04:35:00 | SPY | ETF | 464.79 | 464.79 | 464.79 | 464.79 | 400.0 |
| 2023-12-13 04:45:00 | SPY | ETF | 464.7 | 464.79 | 464.68 | 464.79 | 1200.0 |
| 2023-12-13 04:50:00 | SPY | ETF | 464.81 | 464.81 | 464.81 | 464.81 | 1399.0 |
| 2023-12-13 04:55:00 | SPY | ETF | 464.8 | 464.8 | 464.73 | 464.73 | 334.0 |
| 2023-12-13 05:00:00 | SPY | ETF | 464.7 | 464.7 | 464.7 | 464.7 | 100.0 |
| 2023-12-13 05:05:00 | SPY | ETF | 464.65 | 464.65 | 464.65 | 464.65 | 100.0 |
| 2023-12-13 05:10:00 | SPY | ETF | 464.64 | 464.65 | 464.64 | 464.65 | 400.0 |
| 2023-12-13 05:15:00 | SPY | ETF | 464.67 | 464.67 | 464.67 | 464.67 | 570.0 |
| 2023-12-13 05:25:00 | SPY | ETF | 464.6 | 464.6 | 464.6 | 464.6 | 103.0 |
| 2023-12-13 05:35:00 | SPY | ETF | 464.66 | 464.66 | 464.62 | 464.62 | 900.0 |
| 2023-12-13 05:40:00 | SPY | ETF | 464.58 | 464.64 | 464.58 | 464.64 | 200.0 |
| 2023-12-13 05:50:00 | SPY | ETF | 464.7 | 464.78 | 464.7 | 464.78 | 400.0 |
| 2023-12-13 05:55:00 | SPY | ETF | 464.77 | 464.77 | 464.77 | 464.77 | 100.0 |
| 2023-12-13 06:00:00 | SPY | ETF | 464.65 | 464.65 | 464.59 | 464.59 | 400.0 |
| 2023-12-13 06:10:00 | SPY | ETF | 464.59 | 464.63 | 464.59 | 464.63 | 200.0 |
| 2023-12-13 06:20:00 | SPY | ETF | 464.81 | 464.83 | 464.8 | 464.83 | 1606.0 |
| 2023-12-13 06:25:00 | SPY | ETF | 464.83 | 464.86 | 464.83 | 464.84 | 2003.0 |
| 2023-12-13 06:30:00 | SPY | ETF | 464.83 | 464.9 | 464.83 | 464.87 | 711.0 |
| 2023-12-13 06:40:00 | SPY | ETF | 464.87 | 464.89 | 464.86 | 464.89 | 1934.0 |
| 2023-12-13 06:45:00 | SPY | ETF | 464.81 | 464.81 | 464.81 | 464.81 | 100.0 |
| 2023-12-13 06:50:00 | SPY | ETF | 464.8 | 464.8 | 464.72 | 464.76 | 1550.0 |
| 2023-12-13 07:00:00 | SPY | ETF | 464.75 | 464.82 | 464.75 | 464.76 | 7322.0 |
| 2023-12-13 07:05:00 | SPY | ETF | 464.76 | 464.76 | 464.68 | 464.68 | 8982.0 |
| 2023-12-13 07:10:00 | SPY | ETF | 464.67 | 464.8 | 464.67 | 464.79 | 1576.0 |
| 2023-12-13 07:15:00 | SPY | ETF | 464.79 | 464.8 | 464.77 | 464.77 | 3029.0 |
| 2023-12-13 07:20:00 | SPY | ETF | 464.78 | 464.78 | 464.67 | 464.67 | 9600.0 |
| 2023-12-13 07:25:00 | SPY | ETF | 464.66 | 464.67 | 464.61 | 464.66 | 7407.0 |
| 2023-12-13 07:30:00 | SPY | ETF | 464.65 | 464.74 | 464.65 | 464.74 | 3510.0 |
| 2023-12-13 07:35:00 | SPY | ETF | 464.75 | 464.75 | 464.67 | 464.68 | 5680.0 |
| 2023-12-13 07:40:00 | SPY | ETF | 464.69 | 464.71 | 464.61 | 464.619 | 9200.0 |
| 2023-12-13 07:45:00 | SPY | ETF | 464.6 | 464.67 | 464.58 | 464.58 | 9153.0 |
| 2023-12-13 07:50:00 | SPY | ETF | 464.63 | 464.67 | 464.6 | 464.66 | 8657.0 |
| 2023-12-13 07:55:00 | SPY | ETF | 464.64 | 464.65 | 464.6 | 464.6 | 16572.0 |
| 2023-12-13 08:00:00 | SPY | ETF | 464.72 | 464.82 | 464.58 | 464.61 | 44362.0 |
| 2023-12-13 08:05:00 | SPY | ETF | 464.63 | 464.7 | 464.63 | 464.7 | 21827.0 |
| 2023-12-13 08:10:00 | SPY | ETF | 464.68 | 464.68 | 464.58 | 464.66 | 14274.0 |
| 2023-12-13 08:15:00 | SPY | ETF | 464.67 | 464.67 | 464.61 | 464.61 | 8496.0 |
| 2023-12-13 08:20:00 | SPY | ETF | 464.62 | 464.72 | 464.62 | 464.71 | 13617.0 |
| 2023-12-13 08:25:00 | SPY | ETF | 464.71 | 464.84 | 464.71 | 464.84 | 19231.0 |
| 2023-12-13 08:30:00 | SPY | ETF | 464.84 | 465.09 | 464.73 | 464.78 | 117193.0 |
| 2023-12-13 08:35:00 | SPY | ETF | 464.84 | 465.08 | 464.1 | 465.0 | 24815.0 |
| 2023-12-13 08:40:00 | SPY | ETF | 464.96 | 465.04 | 464.81 | 465.04 | 27922.0 |
| 2023-12-13 08:45:00 | SPY | ETF | 465.03 | 465.25 | 464.99 | 465.22 | 41408.0 |
| 2023-12-13 08:50:00 | SPY | ETF | 465.19 | 465.36 | 465.15 | 465.33 | 27679.0 |
| 2023-12-13 08:55:00 | SPY | ETF | 465.31 | 465.31 | 465.18 | 465.27 | 19459.0 |
> showing 50 of 111,264 rows — these rows as CSV