PREVIEW / etf_5min / 2005-01-18
file: by_date/etf_5min/2005/2005-01-18.parquet size: 118 KB rows: 6,150
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-18 08:05:00 | SPY | ETF | 118.11 | 118.13 | 118.1 | 118.1 | 12000.0 |
| 2005-01-18 08:10:00 | SPY | ETF | 118.14 | 118.14 | 118.14 | 118.14 | 1000.0 |
| 2005-01-18 08:15:00 | SPY | ETF | 118.15 | 118.15 | 118.11 | 118.14 | 6100.0 |
| 2005-01-18 08:20:00 | SPY | ETF | 118.12 | 118.12 | 118.08 | 118.08 | 11700.0 |
| 2005-01-18 08:25:00 | SPY | ETF | 118.06 | 118.08 | 118.06 | 118.08 | 13500.0 |
| 2005-01-18 08:30:00 | SPY | ETF | 118.08 | 118.1 | 118.08 | 118.1 | 8100.0 |
| 2005-01-18 08:35:00 | SPY | ETF | 118.12 | 118.12 | 118.12 | 118.12 | 100.0 |
| 2005-01-18 08:40:00 | SPY | ETF | 118.11 | 118.11 | 118.11 | 118.11 | 800.0 |
| 2005-01-18 08:45:00 | SPY | ETF | 118.12 | 118.12 | 118.11 | 118.11 | 4300.0 |
| 2005-01-18 08:50:00 | SPY | ETF | 118.12 | 118.12 | 118.11 | 118.12 | 2800.0 |
| 2005-01-18 09:00:00 | SPY | ETF | 118.12 | 118.13 | 118.07 | 118.07 | 24300.0 |
| 2005-01-18 09:05:00 | SPY | ETF | 118.07 | 118.07 | 118.0 | 118.04 | 15100.0 |
| 2005-01-18 09:10:00 | SPY | ETF | 118.02 | 118.06 | 118.01 | 118.05 | 113700.0 |
| 2005-01-18 09:15:00 | SPY | ETF | 118.05 | 118.06 | 118.05 | 118.06 | 600.0 |
| 2005-01-18 09:20:00 | SPY | ETF | 118.06 | 118.07 | 118.0 | 118.05 | 184400.0 |
| 2005-01-18 09:25:00 | SPY | ETF | 118.06 | 118.06 | 118.04 | 118.04 | 900.0 |
| 2005-01-18 09:30:00 | SPY | ETF | 118.05 | 118.16 | 118.0 | 118.05 | 1952800.0 |
| 2005-01-18 09:35:00 | SPY | ETF | 118.05 | 118.06 | 117.95 | 118.04 | 934200.0 |
| 2005-01-18 09:40:00 | SPY | ETF | 118.03 | 118.08 | 117.98 | 117.99 | 920800.0 |
| 2005-01-18 09:45:00 | SPY | ETF | 118.0 | 118.07 | 117.98 | 118.04 | 1005000.0 |
| 2005-01-18 09:50:00 | SPY | ETF | 118.03 | 118.16 | 118.02 | 118.12 | 748400.0 |
| 2005-01-18 09:55:00 | SPY | ETF | 118.12 | 118.14 | 118.0 | 118.1 | 821700.0 |
| 2005-01-18 10:00:00 | SPY | ETF | 118.1 | 118.2 | 118.07 | 118.18 | 705000.0 |
| 2005-01-18 10:05:00 | SPY | ETF | 118.2 | 118.22 | 118.08 | 118.12 | 597700.0 |
| 2005-01-18 10:10:00 | SPY | ETF | 118.11 | 118.15 | 118.09 | 118.1 | 310700.0 |
| 2005-01-18 10:15:00 | SPY | ETF | 118.1 | 118.14 | 118.03 | 118.1 | 511200.0 |
| 2005-01-18 10:20:00 | SPY | ETF | 118.09 | 118.28 | 118.07 | 118.26 | 504300.0 |
| 2005-01-18 10:25:00 | SPY | ETF | 118.26 | 118.41 | 118.25 | 118.4 | 1511300.0 |
| 2005-01-18 10:30:00 | SPY | ETF | 118.4 | 118.64 | 118.38 | 118.58 | 1955600.0 |
| 2005-01-18 10:35:00 | SPY | ETF | 118.59 | 118.83 | 118.58 | 118.75 | 1767600.0 |
| 2005-01-18 10:40:00 | SPY | ETF | 118.73 | 118.97 | 118.73 | 118.9 | 1334500.0 |
| 2005-01-18 10:45:00 | SPY | ETF | 118.89 | 118.92 | 118.82 | 118.87 | 1519600.0 |
| 2005-01-18 10:50:00 | SPY | ETF | 118.88 | 119.05 | 118.86 | 118.93 | 1528300.0 |
| 2005-01-18 10:55:00 | SPY | ETF | 118.93 | 118.95 | 118.86 | 118.93 | 589000.0 |
| 2005-01-18 11:00:00 | SPY | ETF | 118.93 | 118.96 | 118.88 | 118.88 | 788200.0 |
| 2005-01-18 11:05:00 | SPY | ETF | 118.89 | 118.92 | 118.83 | 118.84 | 629400.0 |
| 2005-01-18 11:10:00 | SPY | ETF | 118.86 | 119.0 | 118.84 | 118.9 | 995500.0 |
| 2005-01-18 11:15:00 | SPY | ETF | 118.91 | 118.97 | 118.88 | 118.94 | 334700.0 |
| 2005-01-18 11:20:00 | SPY | ETF | 118.94 | 119.02 | 118.92 | 118.94 | 432600.0 |
| 2005-01-18 11:25:00 | SPY | ETF | 118.93 | 119.0 | 118.93 | 118.96 | 539700.0 |
| 2005-01-18 11:30:00 | SPY | ETF | 118.96 | 119.11 | 118.96 | 119.08 | 810000.0 |
| 2005-01-18 11:35:00 | SPY | ETF | 119.08 | 119.25 | 119.04 | 119.19 | 795800.0 |
| 2005-01-18 11:40:00 | SPY | ETF | 119.19 | 119.23 | 119.14 | 119.15 | 1281700.0 |
| 2005-01-18 11:45:00 | SPY | ETF | 119.13 | 119.24 | 119.11 | 119.19 | 758000.0 |
| 2005-01-18 11:50:00 | SPY | ETF | 119.2 | 119.3 | 119.18 | 119.23 | 539300.0 |
| 2005-01-18 11:55:00 | SPY | ETF | 119.23 | 119.24 | 119.15 | 119.15 | 379300.0 |
| 2005-01-18 12:00:00 | SPY | ETF | 119.16 | 119.25 | 119.14 | 119.21 | 207500.0 |
| 2005-01-18 12:05:00 | SPY | ETF | 119.21 | 119.29 | 119.19 | 119.27 | 239700.0 |
| 2005-01-18 12:10:00 | SPY | ETF | 119.27 | 119.35 | 119.23 | 119.25 | 797800.0 |
| 2005-01-18 12:15:00 | SPY | ETF | 119.24 | 119.29 | 119.22 | 119.26 | 160300.0 |
> showing 50 of 6,150 rows — these rows as CSV