PREVIEW / etf_5min / 2007-01-16
file: by_date/etf_5min/2007/2007-01-16.parquet size: 278 KB rows: 14,139
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-16 06:05:00 | SPY | ETF | 143.37 | 143.37 | 143.37 | 143.37 | 15000.0 |
| 2007-01-16 06:15:00 | SPY | ETF | 143.35 | 143.35 | 143.35 | 143.35 | 5000.0 |
| 2007-01-16 06:55:00 | SPY | ETF | 143.28 | 143.29 | 143.28 | 143.29 | 2500.0 |
| 2007-01-16 07:05:00 | SPY | ETF | 143.28 | 143.3 | 143.28 | 143.3 | 200.0 |
| 2007-01-16 07:10:00 | SPY | ETF | 143.35 | 143.35 | 143.35 | 143.35 | 8500.0 |
| 2007-01-16 07:20:00 | SPY | ETF | 143.32 | 143.32 | 143.29 | 143.29 | 3500.0 |
| 2007-01-16 07:45:00 | SPY | ETF | 143.31 | 143.31 | 143.31 | 143.31 | 2500.0 |
| 2007-01-16 08:00:00 | SPY | ETF | 143.31 | 143.35 | 143.29 | 143.31 | 47700.0 |
| 2007-01-16 08:05:00 | SPY | ETF | 143.27 | 143.27 | 143.27 | 143.27 | 200.0 |
| 2007-01-16 08:10:00 | SPY | ETF | 143.3 | 143.32 | 143.3 | 143.32 | 900.0 |
| 2007-01-16 08:15:00 | SPY | ETF | 143.3 | 143.3 | 143.28 | 143.28 | 15600.0 |
| 2007-01-16 08:20:00 | SPY | ETF | 143.3 | 143.3 | 143.3 | 143.3 | 1500.0 |
| 2007-01-16 08:25:00 | SPY | ETF | 143.28 | 143.29 | 143.27 | 143.27 | 6000.0 |
| 2007-01-16 08:30:00 | SPY | ETF | 143.26 | 143.26 | 143.15 | 143.22 | 128200.0 |
| 2007-01-16 08:35:00 | SPY | ETF | 143.2 | 143.21 | 143.13 | 143.15 | 76500.0 |
| 2007-01-16 08:40:00 | SPY | ETF | 143.15 | 143.2 | 143.14 | 143.16 | 43500.0 |
| 2007-01-16 08:45:00 | SPY | ETF | 143.15 | 143.17 | 143.15 | 143.15 | 2800.0 |
| 2007-01-16 08:50:00 | SPY | ETF | 143.15 | 143.18 | 143.14 | 143.18 | 21600.0 |
| 2007-01-16 08:55:00 | SPY | ETF | 143.18 | 143.19 | 143.17 | 143.18 | 71800.0 |
| 2007-01-16 09:00:00 | SPY | ETF | 143.19 | 143.21 | 143.17 | 143.17 | 52000.0 |
| 2007-01-16 09:05:00 | SPY | ETF | 143.18 | 143.24 | 143.18 | 143.24 | 36800.0 |
| 2007-01-16 09:10:00 | SPY | ETF | 143.25 | 143.25 | 143.12 | 143.12 | 62500.0 |
| 2007-01-16 09:15:00 | SPY | ETF | 143.13 | 143.13 | 143.08 | 143.1 | 36900.0 |
| 2007-01-16 09:20:00 | SPY | ETF | 143.08 | 143.09 | 143.06 | 143.07 | 41400.0 |
| 2007-01-16 09:25:00 | SPY | ETF | 143.1 | 143.1 | 143.04 | 143.06 | 48200.0 |
| 2007-01-16 09:30:00 | SPY | ETF | 143.07 | 143.15 | 142.97 | 143.14 | 1579700.0 |
| 2007-01-16 09:35:00 | SPY | ETF | 143.14 | 143.16 | 143.05 | 143.11 | 692500.0 |
| 2007-01-16 09:40:00 | SPY | ETF | 143.11 | 143.21 | 143.04 | 143.2 | 1213400.0 |
| 2007-01-16 09:45:00 | SPY | ETF | 143.19 | 143.44 | 143.15 | 143.22 | 1046700.0 |
| 2007-01-16 09:50:00 | SPY | ETF | 143.21 | 143.25 | 143.13 | 143.19 | 705800.0 |
| 2007-01-16 09:55:00 | SPY | ETF | 143.19 | 143.28 | 143.19 | 143.23 | 532500.0 |
| 2007-01-16 10:00:00 | SPY | ETF | 143.22 | 143.23 | 143.0 | 143.0 | 1149600.0 |
| 2007-01-16 10:05:00 | SPY | ETF | 143.01 | 143.01 | 142.86 | 142.88 | 873900.0 |
| 2007-01-16 10:10:00 | SPY | ETF | 142.88 | 143.04 | 142.85 | 143.01 | 750000.0 |
| 2007-01-16 10:15:00 | SPY | ETF | 143.01 | 143.06 | 142.97 | 143.0 | 777000.0 |
| 2007-01-16 10:20:00 | SPY | ETF | 143.0 | 143.04 | 142.89 | 142.93 | 465700.0 |
| 2007-01-16 10:25:00 | SPY | ETF | 142.94 | 143.04 | 142.93 | 143.01 | 442500.0 |
| 2007-01-16 10:30:00 | SPY | ETF | 143.01 | 143.08 | 142.95 | 142.96 | 321800.0 |
| 2007-01-16 10:35:00 | SPY | ETF | 142.96 | 143.0 | 142.89 | 142.91 | 384600.0 |
| 2007-01-16 10:40:00 | SPY | ETF | 142.91 | 142.97 | 142.9 | 142.94 | 292100.0 |
| 2007-01-16 10:45:00 | SPY | ETF | 142.95 | 142.96 | 142.84 | 142.86 | 302100.0 |
| 2007-01-16 10:50:00 | SPY | ETF | 142.87 | 142.96 | 142.85 | 142.91 | 521400.0 |
| 2007-01-16 10:55:00 | SPY | ETF | 142.9399 | 142.9399 | 142.78 | 142.82 | 1560700.0 |
| 2007-01-16 11:00:00 | SPY | ETF | 142.8 | 142.95 | 142.8 | 142.92 | 1301800.0 |
| 2007-01-16 11:05:00 | SPY | ETF | 142.92 | 142.97 | 142.86 | 142.93 | 294800.0 |
| 2007-01-16 11:10:00 | SPY | ETF | 142.93 | 143.01 | 142.93 | 142.95 | 1300000.0 |
| 2007-01-16 11:15:00 | SPY | ETF | 142.95 | 142.99 | 142.91 | 142.97 | 307800.0 |
| 2007-01-16 11:20:00 | SPY | ETF | 142.96 | 142.97 | 142.86 | 142.89 | 639600.0 |
| 2007-01-16 11:25:00 | SPY | ETF | 142.89 | 142.89 | 142.81 | 142.89 | 323600.0 |
| 2007-01-16 11:30:00 | SPY | ETF | 142.88 | 143.0 | 142.88 | 142.96 | 348700.0 |
> showing 50 of 14,139 rows — these rows as CSV