PREVIEW / etf_5min / 2005-07-28
file: by_date/etf_5min/2005/2005-07-28.parquet size: 122 KB rows: 6,697
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-07-28 06:05:00 | SPY | ETF | 123.8 | 123.8 | 123.8 | 123.8 | 5700.0 |
| 2005-07-28 07:00:00 | SPY | ETF | 123.9 | 123.9 | 123.9 | 123.9 | 24900.0 |
| 2005-07-28 07:25:00 | SPY | ETF | 123.92 | 123.92 | 123.92 | 123.92 | 25000.0 |
| 2005-07-28 07:30:00 | SPY | ETF | 123.93 | 123.93 | 123.93 | 123.93 | 25000.0 |
| 2005-07-28 07:35:00 | SPY | ETF | 123.92 | 123.92 | 123.92 | 123.92 | 100.0 |
| 2005-07-28 07:50:00 | SPY | ETF | 123.89 | 123.89 | 123.89 | 123.89 | 500.0 |
| 2005-07-28 08:00:00 | SPY | ETF | 123.92 | 123.95 | 123.92 | 123.95 | 64400.0 |
| 2005-07-28 08:05:00 | SPY | ETF | 123.95 | 123.96 | 123.95 | 123.95 | 1300.0 |
| 2005-07-28 08:10:00 | SPY | ETF | 123.95 | 123.95 | 123.95 | 123.95 | 700.0 |
| 2005-07-28 08:15:00 | SPY | ETF | 123.95 | 123.95 | 123.94 | 123.95 | 20100.0 |
| 2005-07-28 08:20:00 | SPY | ETF | 124.0 | 124.08 | 124.0 | 124.07 | 41400.0 |
| 2005-07-28 08:25:00 | SPY | ETF | 124.05 | 124.06 | 124.02 | 124.04 | 348600.0 |
| 2005-07-28 08:30:00 | SPY | ETF | 124.05 | 124.09 | 124.03 | 124.03 | 240700.0 |
| 2005-07-28 08:35:00 | SPY | ETF | 124.06 | 124.08 | 124.05 | 124.08 | 111200.0 |
| 2005-07-28 08:40:00 | SPY | ETF | 124.09 | 124.1 | 124.08 | 124.1 | 4700.0 |
| 2005-07-28 08:45:00 | SPY | ETF | 124.1 | 124.11 | 124.1 | 124.11 | 400.0 |
| 2005-07-28 08:50:00 | SPY | ETF | 124.08 | 124.1 | 124.08 | 124.08 | 4600.0 |
| 2005-07-28 08:55:00 | SPY | ETF | 124.08 | 124.08 | 123.93 | 123.93 | 301000.0 |
| 2005-07-28 09:00:00 | SPY | ETF | 124.07 | 124.09 | 124.07 | 124.07 | 600.0 |
| 2005-07-28 09:05:00 | SPY | ETF | 124.06 | 124.07 | 124.05 | 124.05 | 116500.0 |
| 2005-07-28 09:10:00 | SPY | ETF | 124.05 | 124.05 | 124.03 | 124.05 | 29000.0 |
| 2005-07-28 09:15:00 | SPY | ETF | 124.05 | 124.05 | 124.05 | 124.05 | 5100.0 |
| 2005-07-28 09:20:00 | SPY | ETF | 124.03 | 124.05 | 124.03 | 124.05 | 600.0 |
| 2005-07-28 09:25:00 | SPY | ETF | 124.03 | 124.03 | 124.0 | 124.0 | 24400.0 |
| 2005-07-28 09:30:00 | SPY | ETF | 123.99 | 124.07 | 123.93 | 124.05 | 1215400.0 |
| 2005-07-28 09:35:00 | SPY | ETF | 124.05 | 124.11 | 123.99 | 124.08 | 773900.0 |
| 2005-07-28 09:40:00 | SPY | ETF | 124.06 | 124.21 | 124.03 | 124.17 | 1254600.0 |
| 2005-07-28 09:45:00 | SPY | ETF | 124.17 | 124.2 | 124.05 | 124.08 | 1130600.0 |
| 2005-07-28 09:50:00 | SPY | ETF | 124.08 | 124.12 | 124.0 | 124.04 | 969400.0 |
| 2005-07-28 09:55:00 | SPY | ETF | 124.0 | 124.1 | 124.0 | 124.04 | 731200.0 |
| 2005-07-28 10:00:00 | SPY | ETF | 124.02 | 124.08 | 124.02 | 124.07 | 576300.0 |
| 2005-07-28 10:05:00 | SPY | ETF | 124.07 | 124.08 | 123.85 | 123.87 | 945400.0 |
| 2005-07-28 10:10:00 | SPY | ETF | 123.85 | 123.9 | 123.8 | 123.87 | 784400.0 |
| 2005-07-28 10:15:00 | SPY | ETF | 123.86 | 123.9 | 123.75 | 123.83 | 745600.0 |
| 2005-07-28 10:20:00 | SPY | ETF | 123.83 | 123.87 | 123.65 | 123.66 | 878100.0 |
| 2005-07-28 10:25:00 | SPY | ETF | 123.67 | 123.78 | 123.64 | 123.78 | 870800.0 |
| 2005-07-28 10:30:00 | SPY | ETF | 123.77 | 123.83 | 123.76 | 123.8 | 703700.0 |
| 2005-07-28 10:35:00 | SPY | ETF | 123.82 | 123.96 | 123.74 | 123.96 | 635200.0 |
| 2005-07-28 10:40:00 | SPY | ETF | 123.96 | 124.08 | 123.94 | 124.06 | 839700.0 |
| 2005-07-28 10:45:00 | SPY | ETF | 124.06 | 124.06 | 123.97 | 124.03 | 590000.0 |
| 2005-07-28 10:50:00 | SPY | ETF | 124.04 | 124.07 | 123.98 | 124.0 | 252700.0 |
| 2005-07-28 10:55:00 | SPY | ETF | 124.01 | 124.04 | 123.95 | 123.98 | 163400.0 |
| 2005-07-28 11:00:00 | SPY | ETF | 123.99 | 124.06 | 123.91 | 123.95 | 280500.0 |
| 2005-07-28 11:05:00 | SPY | ETF | 123.95 | 124.0 | 123.92 | 123.97 | 364800.0 |
| 2005-07-28 11:10:00 | SPY | ETF | 123.98 | 123.98 | 123.9 | 123.97 | 201300.0 |
| 2005-07-28 11:15:00 | SPY | ETF | 123.97 | 124.07 | 123.96 | 124.02 | 816100.0 |
| 2005-07-28 11:20:00 | SPY | ETF | 124.0 | 124.07 | 124.0 | 124.03 | 125700.0 |
| 2005-07-28 11:25:00 | SPY | ETF | 124.02 | 124.04 | 123.96 | 124.02 | 308300.0 |
| 2005-07-28 11:30:00 | SPY | ETF | 124.01 | 124.08 | 123.97 | 124.06 | 774900.0 |
| 2005-07-28 11:35:00 | SPY | ETF | 124.08 | 124.08 | 123.93 | 124.02 | 879200.0 |
> showing 50 of 6,697 rows — these rows as CSV