PREVIEW / etf_5min / 2004-01-14
file: by_date/etf_5min/2004/2004-01-14.parquet size: 91 KB rows: 4,877
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-14 08:00:00 | SPY | ETF | 112.65 | 112.68 | 112.65 | 112.68 | 500.0 |
| 2004-01-14 08:05:00 | SPY | ETF | 112.66 | 112.66 | 112.66 | 112.66 | 100.0 |
| 2004-01-14 08:10:00 | SPY | ETF | 112.66 | 112.66 | 112.66 | 112.66 | 100.0 |
| 2004-01-14 08:15:00 | SPY | ETF | 112.66 | 112.67 | 112.63 | 112.63 | 3800.0 |
| 2004-01-14 08:20:00 | SPY | ETF | 112.63 | 112.63 | 112.63 | 112.63 | 1000.0 |
| 2004-01-14 08:25:00 | SPY | ETF | 112.69 | 112.69 | 112.69 | 112.69 | 3000.0 |
| 2004-01-14 08:30:00 | SPY | ETF | 112.69 | 112.75 | 112.69 | 112.75 | 2000.0 |
| 2004-01-14 08:35:00 | SPY | ETF | 112.75 | 112.75 | 112.75 | 112.75 | 100.0 |
| 2004-01-14 08:45:00 | SPY | ETF | 112.82 | 112.82 | 112.82 | 112.82 | 2000.0 |
| 2004-01-14 08:50:00 | SPY | ETF | 112.79 | 112.79 | 112.79 | 112.79 | 4500.0 |
| 2004-01-14 08:55:00 | SPY | ETF | 112.8 | 112.8 | 112.8 | 112.8 | 200.0 |
| 2004-01-14 09:25:00 | SPY | ETF | 112.72 | 112.72 | 112.72 | 112.72 | 100.0 |
| 2004-01-14 09:30:00 | SPY | ETF | 112.79 | 112.84 | 112.68 | 112.75 | 1350200.0 |
| 2004-01-14 09:35:00 | SPY | ETF | 112.76 | 112.79 | 112.67 | 112.75 | 342700.0 |
| 2004-01-14 09:40:00 | SPY | ETF | 112.74 | 112.87 | 112.71 | 112.84 | 365200.0 |
| 2004-01-14 09:45:00 | SPY | ETF | 112.84 | 112.88 | 112.78 | 112.79 | 596600.0 |
| 2004-01-14 09:50:00 | SPY | ETF | 112.83 | 112.83 | 112.71 | 112.73 | 382900.0 |
| 2004-01-14 09:55:00 | SPY | ETF | 112.72 | 112.84 | 112.72 | 112.84 | 245800.0 |
| 2004-01-14 10:00:00 | SPY | ETF | 112.81 | 112.93 | 112.74 | 112.86 | 293600.0 |
| 2004-01-14 10:05:00 | SPY | ETF | 112.88 | 113.03 | 112.82 | 112.97 | 440800.0 |
| 2004-01-14 10:10:00 | SPY | ETF | 112.98 | 113.03 | 112.94 | 112.98 | 413900.0 |
| 2004-01-14 10:15:00 | SPY | ETF | 112.97 | 113.0 | 112.93 | 112.97 | 302000.0 |
| 2004-01-14 10:20:00 | SPY | ETF | 112.97 | 113.03 | 112.93 | 112.96 | 501400.0 |
| 2004-01-14 10:25:00 | SPY | ETF | 112.97 | 112.98 | 112.89 | 112.9 | 154000.0 |
| 2004-01-14 10:30:00 | SPY | ETF | 112.93 | 113.0 | 112.9 | 112.98 | 234500.0 |
| 2004-01-14 10:35:00 | SPY | ETF | 112.99 | 113.0 | 112.94 | 112.97 | 397400.0 |
| 2004-01-14 10:40:00 | SPY | ETF | 112.96 | 113.0 | 112.92 | 112.95 | 171600.0 |
| 2004-01-14 10:45:00 | SPY | ETF | 112.95 | 112.96 | 112.86 | 112.91 | 209700.0 |
| 2004-01-14 10:50:00 | SPY | ETF | 112.95 | 112.99 | 112.91 | 112.98 | 87800.0 |
| 2004-01-14 10:55:00 | SPY | ETF | 112.97 | 112.98 | 112.91 | 112.93 | 193300.0 |
| 2004-01-14 11:00:00 | SPY | ETF | 112.94 | 113.0 | 112.92 | 112.99 | 144400.0 |
| 2004-01-14 11:05:00 | SPY | ETF | 112.99 | 113.03 | 112.94 | 112.97 | 531000.0 |
| 2004-01-14 11:10:00 | SPY | ETF | 112.97 | 113.0 | 112.93 | 112.99 | 185100.0 |
| 2004-01-14 11:15:00 | SPY | ETF | 112.99 | 113.04 | 112.95 | 113.01 | 134400.0 |
| 2004-01-14 11:20:00 | SPY | ETF | 113.0 | 113.17 | 113.0 | 113.11 | 1128000.0 |
| 2004-01-14 11:25:00 | SPY | ETF | 113.13 | 113.17 | 113.08 | 113.1 | 1727200.0 |
| 2004-01-14 11:30:00 | SPY | ETF | 113.1 | 113.11 | 113.06 | 113.08 | 69100.0 |
| 2004-01-14 11:35:00 | SPY | ETF | 113.08 | 113.1 | 113.02 | 113.05 | 99200.0 |
| 2004-01-14 11:40:00 | SPY | ETF | 113.07 | 113.1 | 113.02 | 113.03 | 186900.0 |
| 2004-01-14 11:45:00 | SPY | ETF | 113.03 | 113.04 | 113.0 | 113.03 | 223800.0 |
| 2004-01-14 11:50:00 | SPY | ETF | 113.05 | 113.08 | 112.99 | 112.99 | 359500.0 |
| 2004-01-14 11:55:00 | SPY | ETF | 113.01 | 113.02 | 112.95 | 112.95 | 270800.0 |
| 2004-01-14 12:00:00 | SPY | ETF | 112.96 | 112.99 | 112.92 | 112.98 | 290600.0 |
| 2004-01-14 12:05:00 | SPY | ETF | 112.99 | 113.0 | 112.97 | 112.98 | 156300.0 |
| 2004-01-14 12:10:00 | SPY | ETF | 112.98 | 113.0 | 112.96 | 112.99 | 41800.0 |
| 2004-01-14 12:15:00 | SPY | ETF | 112.99 | 113.0 | 112.95 | 112.95 | 145300.0 |
| 2004-01-14 12:20:00 | SPY | ETF | 112.98 | 112.98 | 112.86 | 112.92 | 692300.0 |
| 2004-01-14 12:25:00 | SPY | ETF | 112.88 | 112.92 | 112.8 | 112.82 | 271600.0 |
| 2004-01-14 12:30:00 | SPY | ETF | 112.81 | 112.82 | 112.71 | 112.81 | 417400.0 |
| 2004-01-14 12:35:00 | SPY | ETF | 112.81 | 112.86 | 112.77 | 112.83 | 190900.0 |
> showing 50 of 4,877 rows — these rows as CSV