PREVIEW / etf_5min / 2006-09-08
file: by_date/etf_5min/2006/2006-09-08.parquet size: 205 KB rows: 10,285
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-09-08 04:25:00 | SPY | ETF | 130.29 | 130.29 | 130.29 | 130.29 | 100.0 |
| 2006-09-08 07:10:00 | SPY | ETF | 130.07 | 130.12 | 130.07 | 130.12 | 24900.0 |
| 2006-09-08 07:15:00 | SPY | ETF | 130.1 | 130.14 | 130.1 | 130.14 | 31400.0 |
| 2006-09-08 07:25:00 | SPY | ETF | 130.15 | 130.15 | 130.15 | 130.15 | 27500.0 |
| 2006-09-08 07:35:00 | SPY | ETF | 130.15 | 130.15 | 130.15 | 130.15 | 100.0 |
| 2006-09-08 07:45:00 | SPY | ETF | 130.14 | 130.16 | 130.14 | 130.16 | 7200.0 |
| 2006-09-08 07:50:00 | SPY | ETF | 130.2 | 130.2 | 130.2 | 130.2 | 1100.0 |
| 2006-09-08 07:55:00 | SPY | ETF | 130.21 | 130.24 | 130.21 | 130.24 | 28800.0 |
| 2006-09-08 08:00:00 | SPY | ETF | 130.22 | 130.22 | 130.09 | 130.15 | 1172900.0 |
| 2006-09-08 08:05:00 | SPY | ETF | 130.18 | 130.2 | 130.18 | 130.2 | 4700.0 |
| 2006-09-08 08:10:00 | SPY | ETF | 130.17 | 130.2 | 130.16 | 130.19 | 1269300.0 |
| 2006-09-08 08:15:00 | SPY | ETF | 130.19 | 130.2 | 130.18 | 130.18 | 34700.0 |
| 2006-09-08 08:20:00 | SPY | ETF | 130.18 | 130.18 | 130.17 | 130.17 | 2400.0 |
| 2006-09-08 08:25:00 | SPY | ETF | 130.17 | 130.18 | 130.17 | 130.18 | 1200.0 |
| 2006-09-08 08:30:00 | SPY | ETF | 130.19 | 130.19 | 130.19 | 130.19 | 300.0 |
| 2006-09-08 08:35:00 | SPY | ETF | 130.18 | 130.22 | 130.18 | 130.19 | 30600.0 |
| 2006-09-08 08:40:00 | SPY | ETF | 130.19 | 130.2 | 130.19 | 130.19 | 23700.0 |
| 2006-09-08 08:45:00 | SPY | ETF | 130.2 | 130.22 | 130.2 | 130.21 | 427500.0 |
| 2006-09-08 08:50:00 | SPY | ETF | 130.21 | 130.21 | 130.18 | 130.19 | 77200.0 |
| 2006-09-08 08:55:00 | SPY | ETF | 130.2 | 130.2 | 130.19 | 130.2 | 115100.0 |
| 2006-09-08 09:00:00 | SPY | ETF | 130.2 | 130.2 | 130.18 | 130.18 | 2200.0 |
| 2006-09-08 09:05:00 | SPY | ETF | 130.19 | 130.19 | 130.15 | 130.17 | 17400.0 |
| 2006-09-08 09:10:00 | SPY | ETF | 130.18 | 130.2 | 130.17 | 130.19 | 117700.0 |
| 2006-09-08 09:15:00 | SPY | ETF | 130.17 | 130.18 | 130.14 | 130.14 | 73000.0 |
| 2006-09-08 09:20:00 | SPY | ETF | 130.14 | 130.14 | 130.11 | 130.11 | 29300.0 |
| 2006-09-08 09:25:00 | SPY | ETF | 130.12 | 130.14 | 130.1 | 130.1 | 22800.0 |
| 2006-09-08 09:30:00 | SPY | ETF | 130.08 | 130.15 | 130.05 | 130.09 | 710200.0 |
| 2006-09-08 09:35:00 | SPY | ETF | 130.1 | 130.11 | 129.99 | 130.05 | 973400.0 |
| 2006-09-08 09:40:00 | SPY | ETF | 130.05 | 130.16 | 130.03 | 130.06 | 1313000.0 |
| 2006-09-08 09:45:00 | SPY | ETF | 130.07 | 130.12 | 129.99 | 130.0 | 710600.0 |
| 2006-09-08 09:50:00 | SPY | ETF | 130.0 | 130.08 | 129.99 | 130.02 | 465700.0 |
| 2006-09-08 09:55:00 | SPY | ETF | 130.02 | 130.12 | 129.98 | 130.06 | 773900.0 |
| 2006-09-08 10:00:00 | SPY | ETF | 130.06 | 130.08 | 129.99 | 130.03 | 475700.0 |
| 2006-09-08 10:05:00 | SPY | ETF | 130.03 | 130.07 | 129.9 | 129.9 | 437700.0 |
| 2006-09-08 10:10:00 | SPY | ETF | 129.9 | 129.94 | 129.84 | 129.88 | 845200.0 |
| 2006-09-08 10:15:00 | SPY | ETF | 129.88 | 129.95 | 129.84 | 129.91 | 685400.0 |
| 2006-09-08 10:20:00 | SPY | ETF | 129.9 | 129.93 | 129.87 | 129.9175 | 335900.0 |
| 2006-09-08 10:25:00 | SPY | ETF | 129.92 | 130.04 | 129.88 | 130.03 | 437600.0 |
| 2006-09-08 10:30:00 | SPY | ETF | 130.03 | 130.05 | 129.95 | 129.95 | 423900.0 |
| 2006-09-08 10:35:00 | SPY | ETF | 129.94 | 130.0 | 129.83 | 129.9295 | 546700.0 |
| 2006-09-08 10:40:00 | SPY | ETF | 129.91 | 129.96 | 129.88 | 129.92 | 250600.0 |
| 2006-09-08 10:45:00 | SPY | ETF | 129.92 | 130.03 | 129.85 | 130.03 | 402000.0 |
| 2006-09-08 10:50:00 | SPY | ETF | 130.03 | 130.07 | 129.99 | 130.0 | 560800.0 |
| 2006-09-08 10:55:00 | SPY | ETF | 130.0 | 130.12 | 129.98 | 130.11 | 618600.0 |
| 2006-09-08 11:00:00 | SPY | ETF | 130.11 | 130.13 | 130.06 | 130.09 | 617100.0 |
| 2006-09-08 11:05:00 | SPY | ETF | 130.09 | 130.11 | 130.03 | 130.08 | 335300.0 |
| 2006-09-08 11:10:00 | SPY | ETF | 130.08 | 130.17 | 130.08 | 130.12 | 783100.0 |
| 2006-09-08 11:15:00 | SPY | ETF | 130.12 | 130.16 | 130.05 | 130.09 | 1103800.0 |
| 2006-09-08 11:20:00 | SPY | ETF | 130.1 | 130.14 | 130.04 | 130.05 | 487900.0 |
| 2006-09-08 11:25:00 | SPY | ETF | 130.05 | 130.12 | 130.04 | 130.1 | 286200.0 |
> showing 50 of 10,285 rows — these rows as CSV