PREVIEW / etf_5min / 2007-01-17
file: by_date/etf_5min/2007/2007-01-17.parquet size: 282 KB rows: 13,547
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 |
|---|---|---|---|---|---|---|---|
| 2007-01-17 05:30:00 | SPY | ETF | 143.05 | 143.05 | 143.04 | 143.04 | 10000.0 |
| 2007-01-17 07:00:00 | SPY | ETF | 143.1 | 143.12 | 143.1 | 143.12 | 200.0 |
| 2007-01-17 07:05:00 | SPY | ETF | 143.1 | 143.1 | 143.1 | 143.1 | 200.0 |
| 2007-01-17 07:20:00 | SPY | ETF | 143.18 | 143.18 | 143.16 | 143.18 | 1300.0 |
| 2007-01-17 07:25:00 | SPY | ETF | 143.18 | 143.22 | 143.17 | 143.22 | 3900.0 |
| 2007-01-17 07:30:00 | SPY | ETF | 143.22 | 143.22 | 143.22 | 143.22 | 1000.0 |
| 2007-01-17 07:45:00 | SPY | ETF | 143.13 | 143.13 | 143.12 | 143.12 | 300.0 |
| 2007-01-17 08:00:00 | SPY | ETF | 143.13 | 143.18 | 143.12 | 143.12 | 37900.0 |
| 2007-01-17 08:05:00 | SPY | ETF | 143.12 | 143.12 | 143.12 | 143.12 | 5100.0 |
| 2007-01-17 08:10:00 | SPY | ETF | 143.14 | 143.18 | 143.14 | 143.18 | 3500.0 |
| 2007-01-17 08:15:00 | SPY | ETF | 143.13 | 143.13 | 143.13 | 143.13 | 3500.0 |
| 2007-01-17 08:20:00 | SPY | ETF | 143.16 | 143.16 | 143.1 | 143.12 | 38300.0 |
| 2007-01-17 08:25:00 | SPY | ETF | 143.14 | 143.17 | 143.12 | 143.14 | 28200.0 |
| 2007-01-17 08:30:00 | SPY | ETF | 143.1 | 143.11 | 142.81 | 142.87 | 653900.0 |
| 2007-01-17 08:35:00 | SPY | ETF | 142.89 | 142.93 | 142.85 | 142.9 | 188700.0 |
| 2007-01-17 08:40:00 | SPY | ETF | 142.88 | 142.91 | 142.88 | 142.9 | 98200.0 |
| 2007-01-17 08:45:00 | SPY | ETF | 142.89 | 142.89 | 142.8 | 142.83 | 144200.0 |
| 2007-01-17 08:50:00 | SPY | ETF | 142.81 | 142.81 | 142.71 | 142.71 | 26500.0 |
| 2007-01-17 08:55:00 | SPY | ETF | 142.72 | 142.76 | 142.72 | 142.75 | 39300.0 |
| 2007-01-17 09:00:00 | SPY | ETF | 142.73 | 142.8 | 142.73 | 142.79 | 35900.0 |
| 2007-01-17 09:05:00 | SPY | ETF | 142.8 | 142.81 | 142.77 | 142.8 | 62100.0 |
| 2007-01-17 09:10:00 | SPY | ETF | 142.8 | 142.8 | 142.78 | 142.79 | 10500.0 |
| 2007-01-17 09:15:00 | SPY | ETF | 142.8 | 142.89 | 142.8 | 142.87 | 16200.0 |
| 2007-01-17 09:20:00 | SPY | ETF | 142.87 | 142.89 | 142.87 | 142.87 | 53600.0 |
| 2007-01-17 09:25:00 | SPY | ETF | 142.83 | 142.9 | 142.83 | 142.88 | 79300.0 |
| 2007-01-17 09:30:00 | SPY | ETF | 142.85 | 142.95 | 142.79 | 142.89 | 657600.0 |
| 2007-01-17 09:35:00 | SPY | ETF | 142.88 | 143.02 | 142.84 | 142.94 | 1003000.0 |
| 2007-01-17 09:40:00 | SPY | ETF | 142.9499 | 142.99 | 142.88 | 142.92 | 1322400.0 |
| 2007-01-17 09:45:00 | SPY | ETF | 142.92 | 142.94 | 142.82 | 142.88 | 862700.0 |
| 2007-01-17 09:50:00 | SPY | ETF | 142.88 | 143.16 | 142.87 | 143.12 | 1457600.0 |
| 2007-01-17 09:55:00 | SPY | ETF | 143.12 | 143.15 | 143.07 | 143.08 | 1141200.0 |
| 2007-01-17 10:00:00 | SPY | ETF | 143.08 | 143.08 | 142.8 | 142.9 | 965700.0 |
| 2007-01-17 10:05:00 | SPY | ETF | 142.9 | 143.03 | 142.9 | 143.03 | 509800.0 |
| 2007-01-17 10:10:00 | SPY | ETF | 143.02 | 143.07 | 142.95 | 142.95 | 669900.0 |
| 2007-01-17 10:15:00 | SPY | ETF | 142.96 | 143.05 | 142.93 | 142.98 | 549700.0 |
| 2007-01-17 10:20:00 | SPY | ETF | 142.96 | 142.99 | 142.89 | 142.9 | 631200.0 |
| 2007-01-17 10:25:00 | SPY | ETF | 142.91 | 143.02 | 142.9 | 142.95 | 390600.0 |
| 2007-01-17 10:30:00 | SPY | ETF | 142.95 | 142.96 | 142.75 | 142.83 | 1305300.0 |
| 2007-01-17 10:35:00 | SPY | ETF | 142.83 | 142.98 | 142.8 | 142.9299 | 663300.0 |
| 2007-01-17 10:40:00 | SPY | ETF | 142.92 | 143.05 | 142.9 | 143.0 | 495000.0 |
| 2007-01-17 10:45:00 | SPY | ETF | 143.0 | 143.05 | 142.99 | 143.03 | 235200.0 |
| 2007-01-17 10:50:00 | SPY | ETF | 143.03 | 143.03 | 142.94 | 142.99 | 236900.0 |
| 2007-01-17 10:55:00 | SPY | ETF | 142.99 | 143.0 | 142.9 | 142.95 | 247900.0 |
| 2007-01-17 11:00:00 | SPY | ETF | 142.97 | 143.21 | 142.95 | 143.19 | 704700.0 |
| 2007-01-17 11:05:00 | SPY | ETF | 143.2 | 143.21 | 142.97 | 143.13 | 496500.0 |
| 2007-01-17 11:10:00 | SPY | ETF | 143.13 | 143.15 | 143.08 | 143.13 | 270800.0 |
| 2007-01-17 11:15:00 | SPY | ETF | 143.11 | 143.15 | 143.02 | 143.04 | 334900.0 |
| 2007-01-17 11:20:00 | SPY | ETF | 143.03 | 143.1 | 143.01 | 143.08 | 193600.0 |
| 2007-01-17 11:25:00 | SPY | ETF | 143.07 | 143.11 | 143.01 | 143.06 | 243500.0 |
| 2007-01-17 11:30:00 | SPY | ETF | 143.07 | 143.12 | 143.05 | 143.09 | 189700.0 |
> showing 50 of 13,547 rows — these rows as CSV