PREVIEW / etf_5min / 2006-10-10
file: by_date/etf_5min/2006/2006-10-10.parquet size: 227 KB rows: 11,487
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-10-10 07:00:00 | SPY | ETF | 135.15 | 135.15 | 135.15 | 135.15 | 10000.0 |
| 2006-10-10 07:35:00 | SPY | ETF | 135.08 | 135.12 | 135.07 | 135.12 | 78900.0 |
| 2006-10-10 07:40:00 | SPY | ETF | 135.12 | 135.12 | 135.12 | 135.12 | 3300.0 |
| 2006-10-10 07:45:00 | SPY | ETF | 135.16 | 135.23 | 135.16 | 135.2 | 800.0 |
| 2006-10-10 07:50:00 | SPY | ETF | 135.2 | 135.22 | 135.2 | 135.22 | 1900.0 |
| 2006-10-10 07:55:00 | SPY | ETF | 135.22 | 135.22 | 135.22 | 135.22 | 1800.0 |
| 2006-10-10 08:00:00 | SPY | ETF | 135.2 | 135.24 | 135.1 | 135.21 | 114900.0 |
| 2006-10-10 08:05:00 | SPY | ETF | 135.19 | 135.19 | 135.18 | 135.18 | 5100.0 |
| 2006-10-10 08:10:00 | SPY | ETF | 135.2 | 135.24 | 135.17 | 135.17 | 21900.0 |
| 2006-10-10 08:15:00 | SPY | ETF | 135.18 | 135.18 | 135.15 | 135.15 | 15900.0 |
| 2006-10-10 08:20:00 | SPY | ETF | 135.17 | 135.18 | 135.17 | 135.18 | 2900.0 |
| 2006-10-10 08:25:00 | SPY | ETF | 135.19 | 135.19 | 135.15 | 135.15 | 15600.0 |
| 2006-10-10 08:30:00 | SPY | ETF | 135.16 | 135.17 | 135.15 | 135.15 | 8000.0 |
| 2006-10-10 08:35:00 | SPY | ETF | 135.14 | 135.15 | 135.12 | 135.12 | 8600.0 |
| 2006-10-10 08:40:00 | SPY | ETF | 135.12 | 135.15 | 135.12 | 135.15 | 14000.0 |
| 2006-10-10 08:45:00 | SPY | ETF | 135.15 | 135.15 | 135.14 | 135.14 | 3300.0 |
| 2006-10-10 08:50:00 | SPY | ETF | 135.18 | 135.18 | 135.14 | 135.14 | 77000.0 |
| 2006-10-10 08:55:00 | SPY | ETF | 135.07 | 135.16 | 135.07 | 135.15 | 28900.0 |
| 2006-10-10 09:00:00 | SPY | ETF | 135.17 | 135.21 | 135.16 | 135.19 | 40600.0 |
| 2006-10-10 09:05:00 | SPY | ETF | 135.23 | 135.23 | 135.17 | 135.17 | 28000.0 |
| 2006-10-10 09:10:00 | SPY | ETF | 135.16 | 135.16 | 135.14 | 135.14 | 13000.0 |
| 2006-10-10 09:15:00 | SPY | ETF | 135.15 | 135.15 | 135.11 | 135.11 | 5800.0 |
| 2006-10-10 09:20:00 | SPY | ETF | 135.11 | 135.16 | 135.11 | 135.13 | 63800.0 |
| 2006-10-10 09:25:00 | SPY | ETF | 135.14 | 135.14 | 135.1 | 135.11 | 28100.0 |
| 2006-10-10 09:30:00 | SPY | ETF | 135.11 | 135.18 | 135.03 | 135.13 | 1134600.0 |
| 2006-10-10 09:35:00 | SPY | ETF | 135.12 | 135.25 | 135.08 | 135.2 | 888000.0 |
| 2006-10-10 09:40:00 | SPY | ETF | 135.19 | 135.25 | 135.14 | 135.15 | 1615700.0 |
| 2006-10-10 09:45:00 | SPY | ETF | 135.14 | 135.18 | 135.07 | 135.09 | 1302500.0 |
| 2006-10-10 09:50:00 | SPY | ETF | 135.1 | 135.13 | 135.03 | 135.06 | 1353900.0 |
| 2006-10-10 09:55:00 | SPY | ETF | 135.06 | 135.1 | 134.94 | 134.95 | 1339400.0 |
| 2006-10-10 10:00:00 | SPY | ETF | 134.95 | 135.06 | 134.91 | 134.95 | 1141600.0 |
| 2006-10-10 10:05:00 | SPY | ETF | 134.96 | 135.03 | 134.92 | 134.96 | 672100.0 |
| 2006-10-10 10:10:00 | SPY | ETF | 134.96 | 135.03 | 134.93 | 135.01 | 840100.0 |
| 2006-10-10 10:15:00 | SPY | ETF | 135.0 | 135.01 | 134.89 | 134.98 | 494700.0 |
| 2006-10-10 10:20:00 | SPY | ETF | 134.97 | 134.98 | 134.9 | 134.92 | 302200.0 |
| 2006-10-10 10:25:00 | SPY | ETF | 134.93 | 135.01 | 134.89 | 134.99 | 665000.0 |
| 2006-10-10 10:30:00 | SPY | ETF | 134.99 | 135.1 | 134.99 | 135.09 | 664900.0 |
| 2006-10-10 10:35:00 | SPY | ETF | 135.09 | 135.13 | 135.02 | 135.08 | 553900.0 |
| 2006-10-10 10:40:00 | SPY | ETF | 135.08 | 135.11 | 135.04 | 135.1 | 472000.0 |
| 2006-10-10 10:45:00 | SPY | ETF | 135.1 | 135.11 | 135.04 | 135.08 | 474400.0 |
| 2006-10-10 10:50:00 | SPY | ETF | 135.06 | 135.17 | 135.03 | 135.11 | 789700.0 |
| 2006-10-10 10:55:00 | SPY | ETF | 135.14 | 135.24 | 135.11 | 135.19 | 1104500.0 |
| 2006-10-10 11:00:00 | SPY | ETF | 135.19 | 135.23 | 135.1 | 135.15 | 348200.0 |
| 2006-10-10 11:05:00 | SPY | ETF | 135.15 | 135.22 | 135.11 | 135.2101 | 491700.0 |
| 2006-10-10 11:10:00 | SPY | ETF | 135.22 | 135.25 | 135.14 | 135.24 | 557600.0 |
| 2006-10-10 11:15:00 | SPY | ETF | 135.25 | 135.29 | 135.22 | 135.23 | 1220400.0 |
| 2006-10-10 11:20:00 | SPY | ETF | 135.23 | 135.45 | 135.23 | 135.4 | 3126600.0 |
| 2006-10-10 11:25:00 | SPY | ETF | 135.41 | 135.42 | 135.34 | 135.36 | 545300.0 |
| 2006-10-10 11:30:00 | SPY | ETF | 135.35 | 135.38 | 135.31 | 135.31 | 291900.0 |
| 2006-10-10 11:35:00 | SPY | ETF | 135.31 | 135.31 | 135.21 | 135.26 | 684200.0 |
> showing 50 of 11,487 rows — these rows as CSV