PREVIEW / etf_5min / 2006-11-13
file: by_date/etf_5min/2006/2006-11-13.parquet size: 238 KB rows: 11,858
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-11-13 06:05:00 | SPY | ETF | 138.31 | 138.32 | 138.31 | 138.32 | 20000.0 |
| 2006-11-13 07:25:00 | SPY | ETF | 138.23 | 138.23 | 138.23 | 138.23 | 500.0 |
| 2006-11-13 07:30:00 | SPY | ETF | 138.19 | 138.19 | 138.19 | 138.19 | 2500.0 |
| 2006-11-13 07:40:00 | SPY | ETF | 138.17 | 138.17 | 138.16 | 138.16 | 5100.0 |
| 2006-11-13 07:45:00 | SPY | ETF | 138.18 | 138.18 | 138.18 | 138.18 | 200.0 |
| 2006-11-13 07:50:00 | SPY | ETF | 138.18 | 138.22 | 138.18 | 138.22 | 5400.0 |
| 2006-11-13 07:55:00 | SPY | ETF | 138.22 | 138.22 | 138.22 | 138.22 | 1300.0 |
| 2006-11-13 08:00:00 | SPY | ETF | 138.22 | 138.27 | 138.17 | 138.19 | 34900.0 |
| 2006-11-13 08:05:00 | SPY | ETF | 138.17 | 138.17 | 138.13 | 138.13 | 600.0 |
| 2006-11-13 08:10:00 | SPY | ETF | 138.15 | 138.28 | 138.13 | 138.28 | 21600.0 |
| 2006-11-13 08:15:00 | SPY | ETF | 138.23 | 138.24 | 138.17 | 138.24 | 20600.0 |
| 2006-11-13 08:20:00 | SPY | ETF | 138.21 | 138.21 | 138.12 | 138.12 | 5300.0 |
| 2006-11-13 08:25:00 | SPY | ETF | 138.13 | 138.14 | 138.11 | 138.11 | 275700.0 |
| 2006-11-13 08:30:00 | SPY | ETF | 138.11 | 138.12 | 138.11 | 138.12 | 1100.0 |
| 2006-11-13 08:35:00 | SPY | ETF | 138.12 | 138.14 | 138.12 | 138.14 | 9900.0 |
| 2006-11-13 08:40:00 | SPY | ETF | 138.16 | 138.21 | 138.16 | 138.18 | 32000.0 |
| 2006-11-13 08:45:00 | SPY | ETF | 138.18 | 138.2 | 138.18 | 138.2 | 8800.0 |
| 2006-11-13 08:50:00 | SPY | ETF | 138.18 | 138.18 | 138.18 | 138.18 | 100.0 |
| 2006-11-13 08:55:00 | SPY | ETF | 138.16 | 138.16 | 138.12 | 138.14 | 17000.0 |
| 2006-11-13 09:00:00 | SPY | ETF | 138.14 | 138.14 | 138.14 | 138.14 | 100.0 |
| 2006-11-13 09:05:00 | SPY | ETF | 138.14 | 138.18 | 138.14 | 138.18 | 300.0 |
| 2006-11-13 09:10:00 | SPY | ETF | 138.18 | 138.19 | 138.17 | 138.19 | 34700.0 |
| 2006-11-13 09:15:00 | SPY | ETF | 138.18 | 138.25 | 138.18 | 138.21 | 22300.0 |
| 2006-11-13 09:20:00 | SPY | ETF | 138.22 | 138.23 | 138.2 | 138.2 | 208100.0 |
| 2006-11-13 09:25:00 | SPY | ETF | 138.2 | 138.2 | 138.17 | 138.17 | 7700.0 |
| 2006-11-13 09:30:00 | SPY | ETF | 138.18 | 138.2 | 138.11 | 138.15 | 594300.0 |
| 2006-11-13 09:35:00 | SPY | ETF | 138.12 | 138.24 | 138.07 | 138.19 | 996500.0 |
| 2006-11-13 09:40:00 | SPY | ETF | 138.2 | 138.45 | 138.19 | 138.38 | 1755600.0 |
| 2006-11-13 09:45:00 | SPY | ETF | 138.37 | 138.38 | 138.27 | 138.35 | 859400.0 |
| 2006-11-13 09:50:00 | SPY | ETF | 138.35 | 138.52 | 138.32 | 138.5 | 1722600.0 |
| 2006-11-13 09:55:00 | SPY | ETF | 138.51 | 138.73 | 138.42 | 138.71 | 3327600.0 |
| 2006-11-13 10:00:00 | SPY | ETF | 138.71 | 138.83 | 138.68 | 138.77 | 3377600.0 |
| 2006-11-13 10:05:00 | SPY | ETF | 138.77 | 138.82 | 138.7 | 138.81 | 688800.0 |
| 2006-11-13 10:10:00 | SPY | ETF | 138.8 | 138.98 | 138.79 | 138.95 | 2109000.0 |
| 2006-11-13 10:15:00 | SPY | ETF | 138.94 | 139.04 | 138.94 | 138.94 | 1986600.0 |
| 2006-11-13 10:20:00 | SPY | ETF | 138.94 | 138.95 | 138.87 | 138.89 | 686900.0 |
| 2006-11-13 10:25:00 | SPY | ETF | 138.88 | 138.95 | 138.88 | 138.94 | 562500.0 |
| 2006-11-13 10:30:00 | SPY | ETF | 138.93 | 138.97 | 138.85 | 138.88 | 904100.0 |
| 2006-11-13 10:35:00 | SPY | ETF | 138.88 | 138.97 | 138.87 | 138.89 | 371700.0 |
| 2006-11-13 10:40:00 | SPY | ETF | 138.89 | 138.92 | 138.86 | 138.89 | 295600.0 |
| 2006-11-13 10:45:00 | SPY | ETF | 138.89 | 138.9 | 138.8 | 138.88 | 1080600.0 |
| 2006-11-13 10:50:00 | SPY | ETF | 138.86 | 138.9 | 138.85 | 138.89 | 174800.0 |
| 2006-11-13 10:55:00 | SPY | ETF | 138.89 | 138.95 | 138.86 | 138.87 | 535400.0 |
| 2006-11-13 11:00:00 | SPY | ETF | 138.87 | 138.95 | 138.86 | 138.92 | 413700.0 |
| 2006-11-13 11:05:00 | SPY | ETF | 138.93 | 138.97 | 138.84 | 138.87 | 504600.0 |
| 2006-11-13 11:10:00 | SPY | ETF | 138.86 | 138.9 | 138.82 | 138.85 | 780000.0 |
| 2006-11-13 11:15:00 | SPY | ETF | 138.85 | 138.87 | 138.82 | 138.86 | 454100.0 |
| 2006-11-13 11:20:00 | SPY | ETF | 138.87 | 138.92 | 138.82 | 138.88 | 373000.0 |
| 2006-11-13 11:25:00 | SPY | ETF | 138.87 | 138.87 | 138.8 | 138.8 | 837500.0 |
| 2006-11-13 11:30:00 | SPY | ETF | 138.8 | 138.85 | 138.75 | 138.83 | 1699500.0 |
> showing 50 of 11,858 rows — these rows as CSV