PREVIEW / etf_1min / 2005-03-01
file: by_date/etf_1min/2005/2005-03-01.parquet size: 228 KB rows: 16,969
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-03-01 08:00:00 | SPY | ETF | 120.86 | 120.86 | 120.86 | 120.86 | 200.0 |
| 2005-03-01 08:01:00 | SPY | ETF | 120.86 | 120.86 | 120.86 | 120.86 | 400.0 |
| 2005-03-01 08:03:00 | SPY | ETF | 120.88 | 120.88 | 120.88 | 120.88 | 100.0 |
| 2005-03-01 08:04:00 | SPY | ETF | 120.9 | 120.9 | 120.9 | 120.9 | 500.0 |
| 2005-03-01 08:08:00 | SPY | ETF | 120.91 | 120.91 | 120.88 | 120.88 | 2400.0 |
| 2005-03-01 08:11:00 | SPY | ETF | 120.9 | 120.9 | 120.9 | 120.9 | 100.0 |
| 2005-03-01 08:12:00 | SPY | ETF | 120.9 | 120.9 | 120.9 | 120.9 | 900.0 |
| 2005-03-01 08:15:00 | SPY | ETF | 120.9 | 120.9 | 120.9 | 120.9 | 200.0 |
| 2005-03-01 08:16:00 | SPY | ETF | 120.9 | 120.9 | 120.9 | 120.9 | 200.0 |
| 2005-03-01 08:20:00 | SPY | ETF | 120.88 | 120.89 | 120.88 | 120.89 | 90100.0 |
| 2005-03-01 08:22:00 | SPY | ETF | 120.88 | 120.9 | 120.88 | 120.9 | 1500.0 |
| 2005-03-01 08:25:00 | SPY | ETF | 120.89 | 120.89 | 120.89 | 120.89 | 200.0 |
| 2005-03-01 08:38:00 | SPY | ETF | 120.91 | 120.91 | 120.91 | 120.91 | 2400.0 |
| 2005-03-01 08:47:00 | SPY | ETF | 120.86 | 120.86 | 120.86 | 120.86 | 7400.0 |
| 2005-03-01 08:57:00 | SPY | ETF | 120.83 | 120.83 | 120.83 | 120.83 | 2500.0 |
| 2005-03-01 08:59:00 | SPY | ETF | 120.82 | 120.82 | 120.82 | 120.82 | 1000.0 |
| 2005-03-01 09:00:00 | SPY | ETF | 120.83 | 120.83 | 120.83 | 120.83 | 500.0 |
| 2005-03-01 09:01:00 | SPY | ETF | 120.82 | 120.82 | 120.82 | 120.82 | 300.0 |
| 2005-03-01 09:05:00 | SPY | ETF | 120.82 | 120.82 | 120.82 | 120.82 | 100.0 |
| 2005-03-01 09:06:00 | SPY | ETF | 120.82 | 120.82 | 120.82 | 120.82 | 100.0 |
| 2005-03-01 09:07:00 | SPY | ETF | 120.82 | 120.82 | 120.82 | 120.82 | 100.0 |
| 2005-03-01 09:08:00 | SPY | ETF | 120.83 | 120.83 | 120.83 | 120.83 | 1300.0 |
| 2005-03-01 09:09:00 | SPY | ETF | 120.84 | 120.84 | 120.84 | 120.84 | 10000.0 |
| 2005-03-01 09:10:00 | SPY | ETF | 120.84 | 120.84 | 120.81 | 120.81 | 3600.0 |
| 2005-03-01 09:11:00 | SPY | ETF | 120.83 | 120.84 | 120.83 | 120.84 | 4200.0 |
| 2005-03-01 09:20:00 | SPY | ETF | 120.84 | 120.84 | 120.81 | 120.81 | 19000.0 |
| 2005-03-01 09:21:00 | SPY | ETF | 120.81 | 120.81 | 120.8 | 120.8 | 25700.0 |
| 2005-03-01 09:22:00 | SPY | ETF | 120.81 | 120.83 | 120.81 | 120.82 | 400.0 |
| 2005-03-01 09:23:00 | SPY | ETF | 120.8 | 120.8 | 120.8 | 120.8 | 8800.0 |
| 2005-03-01 09:24:00 | SPY | ETF | 120.81 | 120.83 | 120.8 | 120.8 | 4200.0 |
| 2005-03-01 09:29:00 | SPY | ETF | 120.79 | 120.8 | 120.78 | 120.8 | 10200.0 |
| 2005-03-01 09:30:00 | SPY | ETF | 120.78 | 120.87 | 120.78 | 120.87 | 348900.0 |
| 2005-03-01 09:31:00 | SPY | ETF | 120.87 | 120.94 | 120.84 | 120.9 | 125200.0 |
| 2005-03-01 09:32:00 | SPY | ETF | 120.9 | 120.95 | 120.87 | 120.95 | 634000.0 |
| 2005-03-01 09:33:00 | SPY | ETF | 120.95 | 121.01 | 120.92 | 121.0 | 379000.0 |
| 2005-03-01 09:34:00 | SPY | ETF | 121.02 | 121.04 | 120.94 | 121.02 | 381000.0 |
| 2005-03-01 09:35:00 | SPY | ETF | 121.01 | 121.06 | 121.0 | 121.02 | 410600.0 |
| 2005-03-01 09:36:00 | SPY | ETF | 121.02 | 121.04 | 120.96 | 121.01 | 418500.0 |
| 2005-03-01 09:37:00 | SPY | ETF | 121.0 | 121.02 | 120.97 | 121.02 | 170800.0 |
| 2005-03-01 09:38:00 | SPY | ETF | 121.02 | 121.14 | 121.0 | 121.11 | 167600.0 |
| 2005-03-01 09:39:00 | SPY | ETF | 121.12 | 121.12 | 121.08 | 121.1 | 221500.0 |
| 2005-03-01 09:40:00 | SPY | ETF | 121.11 | 121.13 | 121.08 | 121.13 | 150600.0 |
| 2005-03-01 09:41:00 | SPY | ETF | 121.13 | 121.19 | 121.09 | 121.14 | 321500.0 |
| 2005-03-01 09:42:00 | SPY | ETF | 121.14 | 121.2 | 121.12 | 121.18 | 148000.0 |
| 2005-03-01 09:43:00 | SPY | ETF | 121.16 | 121.18 | 121.14 | 121.15 | 54800.0 |
| 2005-03-01 09:44:00 | SPY | ETF | 121.13 | 121.21 | 121.13 | 121.17 | 195500.0 |
| 2005-03-01 09:45:00 | SPY | ETF | 121.16 | 121.2 | 121.11 | 121.12 | 167700.0 |
| 2005-03-01 09:46:00 | SPY | ETF | 121.13 | 121.14 | 121.09 | 121.1 | 143400.0 |
| 2005-03-01 09:47:00 | SPY | ETF | 121.09 | 121.11 | 121.08 | 121.08 | 75300.0 |
| 2005-03-01 09:48:00 | SPY | ETF | 121.08 | 121.13 | 121.05 | 121.12 | 93300.0 |
> showing 50 of 16,969 rows — these rows as CSV