PREVIEW / etf_5min / 2005-10-14
file: by_date/etf_5min/2005/2005-10-14.parquet size: 142 KB rows: 7,055
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-14 07:05:00 | SPY | ETF | 117.7 | 117.74 | 117.7 | 117.74 | 135800.0 |
| 2005-10-14 07:10:00 | SPY | ETF | 117.74 | 117.77 | 117.74 | 117.77 | 50100.0 |
| 2005-10-14 07:20:00 | SPY | ETF | 117.78 | 117.78 | 117.78 | 117.78 | 1000.0 |
| 2005-10-14 07:25:00 | SPY | ETF | 117.78 | 117.83 | 117.78 | 117.78 | 6700.0 |
| 2005-10-14 07:30:00 | SPY | ETF | 117.77 | 117.77 | 117.77 | 117.77 | 100.0 |
| 2005-10-14 07:35:00 | SPY | ETF | 117.78 | 117.79 | 117.74 | 117.79 | 64100.0 |
| 2005-10-14 07:40:00 | SPY | ETF | 117.79 | 117.8 | 117.75 | 117.75 | 57700.0 |
| 2005-10-14 07:45:00 | SPY | ETF | 117.77 | 117.79 | 117.75 | 117.75 | 60800.0 |
| 2005-10-14 07:50:00 | SPY | ETF | 117.77 | 117.77 | 117.71 | 117.72 | 126600.0 |
| 2005-10-14 08:00:00 | SPY | ETF | 117.75 | 117.83 | 117.67 | 117.75 | 1697900.0 |
| 2005-10-14 08:05:00 | SPY | ETF | 117.75 | 117.79 | 117.75 | 117.79 | 13400.0 |
| 2005-10-14 08:10:00 | SPY | ETF | 117.81 | 117.84 | 117.78 | 117.83 | 55300.0 |
| 2005-10-14 08:15:00 | SPY | ETF | 117.85 | 117.89 | 117.83 | 117.85 | 33400.0 |
| 2005-10-14 08:20:00 | SPY | ETF | 117.83 | 117.83 | 117.71 | 117.73 | 20800.0 |
| 2005-10-14 08:25:00 | SPY | ETF | 117.73 | 117.78 | 117.69 | 117.73 | 662300.0 |
| 2005-10-14 08:30:00 | SPY | ETF | 117.79 | 118.38 | 117.79 | 118.3 | 2297000.0 |
| 2005-10-14 08:35:00 | SPY | ETF | 118.29 | 118.29 | 118.15 | 118.25 | 913900.0 |
| 2005-10-14 08:40:00 | SPY | ETF | 118.26 | 118.31 | 118.19 | 118.31 | 392500.0 |
| 2005-10-14 08:45:00 | SPY | ETF | 118.31 | 118.33 | 118.05 | 118.27 | 346900.0 |
| 2005-10-14 08:50:00 | SPY | ETF | 118.28 | 118.34 | 118.27 | 118.32 | 354800.0 |
| 2005-10-14 08:55:00 | SPY | ETF | 118.31 | 118.34 | 118.29 | 118.29 | 203900.0 |
| 2005-10-14 09:00:00 | SPY | ETF | 118.29 | 118.34 | 118.26 | 118.33 | 135900.0 |
| 2005-10-14 09:05:00 | SPY | ETF | 118.33 | 118.34 | 118.27 | 118.27 | 148900.0 |
| 2005-10-14 09:10:00 | SPY | ETF | 118.27 | 118.27 | 118.21 | 118.22 | 94800.0 |
| 2005-10-14 09:15:00 | SPY | ETF | 118.22 | 118.27 | 118.16 | 118.26 | 141200.0 |
| 2005-10-14 09:20:00 | SPY | ETF | 118.26 | 118.26 | 118.16 | 118.16 | 159300.0 |
| 2005-10-14 09:25:00 | SPY | ETF | 118.16 | 118.19 | 118.11 | 118.12 | 125800.0 |
| 2005-10-14 09:30:00 | SPY | ETF | 118.12 | 118.26 | 118.05 | 118.24 | 2298600.0 |
| 2005-10-14 09:35:00 | SPY | ETF | 118.24 | 118.33 | 118.19 | 118.27 | 1656400.0 |
| 2005-10-14 09:40:00 | SPY | ETF | 118.29 | 118.33 | 118.19 | 118.21 | 1724300.0 |
| 2005-10-14 09:45:00 | SPY | ETF | 118.21 | 118.33 | 117.84 | 118.0 | 3075400.0 |
| 2005-10-14 09:50:00 | SPY | ETF | 118.0 | 118.09 | 117.93 | 118.01 | 2729500.0 |
| 2005-10-14 09:55:00 | SPY | ETF | 118.03 | 118.04 | 117.81 | 117.86 | 2135600.0 |
| 2005-10-14 10:00:00 | SPY | ETF | 117.88 | 118.09 | 117.84 | 118.0 | 2779000.0 |
| 2005-10-14 10:05:00 | SPY | ETF | 118.01 | 118.05 | 117.83 | 117.86 | 729800.0 |
| 2005-10-14 10:10:00 | SPY | ETF | 117.88 | 118.03 | 117.8 | 117.83 | 975300.0 |
| 2005-10-14 10:15:00 | SPY | ETF | 117.83 | 117.87 | 117.56 | 117.64 | 2677800.0 |
| 2005-10-14 10:20:00 | SPY | ETF | 117.65 | 117.84 | 117.57 | 117.81 | 1960900.0 |
| 2005-10-14 10:25:00 | SPY | ETF | 117.82 | 117.83 | 117.67 | 117.69 | 840800.0 |
| 2005-10-14 10:30:00 | SPY | ETF | 117.72 | 117.8 | 117.6 | 117.76 | 913300.0 |
| 2005-10-14 10:35:00 | SPY | ETF | 117.72 | 117.95 | 117.72 | 117.93 | 1393500.0 |
| 2005-10-14 10:40:00 | SPY | ETF | 117.9 | 118.0 | 117.78 | 117.96 | 1221900.0 |
| 2005-10-14 10:45:00 | SPY | ETF | 117.96 | 118.03 | 117.89 | 118.0 | 2207700.0 |
| 2005-10-14 10:50:00 | SPY | ETF | 117.98 | 118.02 | 117.89 | 117.94 | 847600.0 |
| 2005-10-14 10:55:00 | SPY | ETF | 117.96 | 118.0 | 117.82 | 117.86 | 856200.0 |
| 2005-10-14 11:00:00 | SPY | ETF | 117.86 | 117.94 | 117.81 | 117.84 | 724400.0 |
| 2005-10-14 11:05:00 | SPY | ETF | 117.84 | 117.94 | 117.81 | 117.92 | 314600.0 |
| 2005-10-14 11:10:00 | SPY | ETF | 117.92 | 117.99 | 117.87 | 117.98 | 249600.0 |
| 2005-10-14 11:15:00 | SPY | ETF | 117.99 | 118.39 | 117.97 | 118.33 | 1928400.0 |
| 2005-10-14 11:20:00 | SPY | ETF | 118.31 | 118.33 | 118.05 | 118.11 | 1172100.0 |
> showing 50 of 7,055 rows — these rows as CSV