PREVIEW / etf_5min / 2006-01-25
file: by_date/etf_5min/2006/2006-01-25.parquet size: 184 KB rows: 9,317
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 |
|---|---|---|---|---|---|---|---|
| 2006-01-25 06:50:00 | SPY | ETF | 126.95 | 126.95 | 126.95 | 126.95 | 1000.0 |
| 2006-01-25 07:10:00 | SPY | ETF | 126.99 | 127.0 | 126.99 | 127.0 | 30000.0 |
| 2006-01-25 07:15:00 | SPY | ETF | 127.09 | 127.09 | 127.08 | 127.08 | 2100.0 |
| 2006-01-25 07:20:00 | SPY | ETF | 127.09 | 127.09 | 127.06 | 127.06 | 21400.0 |
| 2006-01-25 07:25:00 | SPY | ETF | 127.08 | 127.09 | 127.08 | 127.09 | 200.0 |
| 2006-01-25 07:30:00 | SPY | ETF | 127.09 | 127.1 | 127.09 | 127.1 | 3100.0 |
| 2006-01-25 07:35:00 | SPY | ETF | 127.09 | 127.12 | 127.09 | 127.12 | 1300.0 |
| 2006-01-25 07:40:00 | SPY | ETF | 127.12 | 127.12 | 127.12 | 127.12 | 100.0 |
| 2006-01-25 07:45:00 | SPY | ETF | 127.11 | 127.11 | 127.04 | 127.04 | 3000.0 |
| 2006-01-25 07:50:00 | SPY | ETF | 127.04 | 127.04 | 127.0 | 127.0 | 26000.0 |
| 2006-01-25 07:55:00 | SPY | ETF | 126.99 | 127.04 | 126.99 | 127.04 | 4900.0 |
| 2006-01-25 08:00:00 | SPY | ETF | 127.01 | 127.13 | 126.93 | 127.05 | 475900.0 |
| 2006-01-25 08:05:00 | SPY | ETF | 127.05 | 127.11 | 127.01 | 127.11 | 95300.0 |
| 2006-01-25 08:10:00 | SPY | ETF | 127.08 | 127.09 | 127.07 | 127.09 | 101000.0 |
| 2006-01-25 08:15:00 | SPY | ETF | 127.08 | 127.09 | 127.05 | 127.06 | 100100.0 |
| 2006-01-25 08:20:00 | SPY | ETF | 127.04 | 127.04 | 127.02 | 127.02 | 5100.0 |
| 2006-01-25 08:25:00 | SPY | ETF | 127.02 | 127.04 | 127.02 | 127.04 | 39400.0 |
| 2006-01-25 08:30:00 | SPY | ETF | 127.01 | 127.05 | 126.99 | 126.99 | 13800.0 |
| 2006-01-25 08:35:00 | SPY | ETF | 126.99 | 126.99 | 126.94 | 126.95 | 50800.0 |
| 2006-01-25 08:40:00 | SPY | ETF | 126.95 | 127.0 | 126.95 | 127.0 | 7300.0 |
| 2006-01-25 08:45:00 | SPY | ETF | 127.0 | 127.0 | 126.94 | 126.94 | 24700.0 |
| 2006-01-25 08:50:00 | SPY | ETF | 126.93 | 126.95 | 126.92 | 126.95 | 68600.0 |
| 2006-01-25 08:55:00 | SPY | ETF | 126.95 | 126.97 | 126.94 | 126.97 | 14200.0 |
| 2006-01-25 09:00:00 | SPY | ETF | 126.96 | 126.97 | 126.92 | 126.97 | 32600.0 |
| 2006-01-25 09:05:00 | SPY | ETF | 126.96 | 126.97 | 126.95 | 126.97 | 18200.0 |
| 2006-01-25 09:10:00 | SPY | ETF | 126.97 | 127.0 | 126.95 | 126.95 | 50400.0 |
| 2006-01-25 09:15:00 | SPY | ETF | 126.95 | 126.95 | 126.91 | 126.91 | 17800.0 |
| 2006-01-25 09:20:00 | SPY | ETF | 126.92 | 126.96 | 126.92 | 126.95 | 5800.0 |
| 2006-01-25 09:25:00 | SPY | ETF | 126.95 | 127.01 | 126.95 | 127.01 | 74700.0 |
| 2006-01-25 09:30:00 | SPY | ETF | 127.04 | 127.11 | 126.99 | 127.0 | 810500.0 |
| 2006-01-25 09:35:00 | SPY | ETF | 127.01 | 127.0701 | 126.85 | 126.98 | 821800.0 |
| 2006-01-25 09:40:00 | SPY | ETF | 126.95 | 126.97 | 126.86 | 126.89 | 887600.0 |
| 2006-01-25 09:45:00 | SPY | ETF | 126.89 | 127.07 | 126.86 | 127.0 | 946900.0 |
| 2006-01-25 09:50:00 | SPY | ETF | 127.03 | 127.1 | 126.98 | 127.08 | 952400.0 |
| 2006-01-25 09:55:00 | SPY | ETF | 127.08 | 127.1 | 126.98 | 127.02 | 685900.0 |
| 2006-01-25 10:00:00 | SPY | ETF | 127.02 | 127.18 | 126.97 | 127.13 | 3590100.0 |
| 2006-01-25 10:05:00 | SPY | ETF | 127.14 | 127.15 | 126.88 | 126.91 | 1286400.0 |
| 2006-01-25 10:10:00 | SPY | ETF | 126.91 | 126.92 | 126.62 | 126.76 | 2071600.0 |
| 2006-01-25 10:15:00 | SPY | ETF | 126.76 | 126.84 | 126.73 | 126.77 | 661600.0 |
| 2006-01-25 10:20:00 | SPY | ETF | 126.76 | 126.77 | 126.36 | 126.39 | 2395200.0 |
| 2006-01-25 10:25:00 | SPY | ETF | 126.39 | 126.52 | 126.28 | 126.51 | 2597300.0 |
| 2006-01-25 10:30:00 | SPY | ETF | 126.5 | 126.51 | 126.37 | 126.39 | 2184500.0 |
| 2006-01-25 10:35:00 | SPY | ETF | 126.39 | 126.5576 | 126.39 | 126.52 | 2188600.0 |
| 2006-01-25 10:40:00 | SPY | ETF | 126.53 | 126.58 | 126.46 | 126.54 | 626600.0 |
| 2006-01-25 10:45:00 | SPY | ETF | 126.53 | 126.7 | 126.48 | 126.65 | 900700.0 |
| 2006-01-25 10:50:00 | SPY | ETF | 126.65 | 126.81 | 126.65 | 126.71 | 1045300.0 |
| 2006-01-25 10:55:00 | SPY | ETF | 126.7 | 126.84 | 126.67 | 126.84 | 862200.0 |
| 2006-01-25 11:00:00 | SPY | ETF | 126.82 | 126.98 | 126.81 | 126.86 | 967200.0 |
| 2006-01-25 11:05:00 | SPY | ETF | 126.88 | 126.92 | 126.8 | 126.8201 | 663800.0 |
| 2006-01-25 11:10:00 | SPY | ETF | 126.82 | 126.85 | 126.75 | 126.79 | 564200.0 |
> showing 50 of 9,317 rows — these rows as CSV