PREVIEW / etf_1min / 2005-01-05
file: by_date/etf_1min/2005/2005-01-05.parquet size: 253 KB rows: 16,728
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-05 08:00:00 | SPY | ETF | 118.71 | 118.71 | 118.71 | 118.71 | 2000.0 |
| 2005-01-05 08:03:00 | SPY | ETF | 118.72 | 118.72 | 118.72 | 118.72 | 7400.0 |
| 2005-01-05 08:05:00 | SPY | ETF | 118.75 | 118.75 | 118.75 | 118.75 | 200.0 |
| 2005-01-05 08:08:00 | SPY | ETF | 118.81 | 118.81 | 118.81 | 118.81 | 21300.0 |
| 2005-01-05 08:09:00 | SPY | ETF | 118.81 | 118.81 | 118.81 | 118.81 | 11400.0 |
| 2005-01-05 08:16:00 | SPY | ETF | 118.81 | 118.81 | 118.81 | 118.81 | 26500.0 |
| 2005-01-05 08:21:00 | SPY | ETF | 118.82 | 118.82 | 118.82 | 118.82 | 100.0 |
| 2005-01-05 08:29:00 | SPY | ETF | 118.8 | 118.8 | 118.8 | 118.8 | 5000.0 |
| 2005-01-05 08:38:00 | SPY | ETF | 118.78 | 118.78 | 118.78 | 118.78 | 2500.0 |
| 2005-01-05 08:40:00 | SPY | ETF | 118.78 | 118.78 | 118.78 | 118.78 | 3500.0 |
| 2005-01-05 08:41:00 | SPY | ETF | 118.75 | 118.75 | 118.75 | 118.75 | 200.0 |
| 2005-01-05 08:45:00 | SPY | ETF | 118.72 | 118.72 | 118.71 | 118.71 | 3000.0 |
| 2005-01-05 08:46:00 | SPY | ETF | 118.64 | 118.64 | 118.64 | 118.64 | 4200.0 |
| 2005-01-05 08:47:00 | SPY | ETF | 118.63 | 118.63 | 118.63 | 118.63 | 400.0 |
| 2005-01-05 08:48:00 | SPY | ETF | 118.65 | 118.7 | 118.65 | 118.7 | 14300.0 |
| 2005-01-05 08:49:00 | SPY | ETF | 118.7 | 118.7 | 118.67 | 118.68 | 6000.0 |
| 2005-01-05 08:50:00 | SPY | ETF | 118.65 | 118.65 | 118.65 | 118.65 | 9400.0 |
| 2005-01-05 08:51:00 | SPY | ETF | 118.62 | 118.62 | 118.62 | 118.62 | 3100.0 |
| 2005-01-05 08:52:00 | SPY | ETF | 118.63 | 118.63 | 118.63 | 118.63 | 100.0 |
| 2005-01-05 08:53:00 | SPY | ETF | 118.63 | 118.63 | 118.62 | 118.62 | 2100.0 |
| 2005-01-05 08:56:00 | SPY | ETF | 118.66 | 118.66 | 118.62 | 118.62 | 168600.0 |
| 2005-01-05 08:57:00 | SPY | ETF | 118.62 | 118.62 | 118.6 | 118.6 | 15500.0 |
| 2005-01-05 08:58:00 | SPY | ETF | 118.6 | 118.6 | 118.59 | 118.59 | 36100.0 |
| 2005-01-05 08:59:00 | SPY | ETF | 118.59 | 118.59 | 118.57 | 118.57 | 88900.0 |
| 2005-01-05 09:00:00 | SPY | ETF | 118.57 | 118.57 | 118.57 | 118.57 | 100.0 |
| 2005-01-05 09:01:00 | SPY | ETF | 118.56 | 118.56 | 118.56 | 118.56 | 4800.0 |
| 2005-01-05 09:02:00 | SPY | ETF | 118.61 | 118.61 | 118.61 | 118.61 | 100.0 |
| 2005-01-05 09:04:00 | SPY | ETF | 118.61 | 118.61 | 118.6 | 118.6 | 1400.0 |
| 2005-01-05 09:05:00 | SPY | ETF | 118.61 | 118.61 | 118.6 | 118.6 | 700.0 |
| 2005-01-05 09:06:00 | SPY | ETF | 118.6 | 118.63 | 118.6 | 118.63 | 8400.0 |
| 2005-01-05 09:09:00 | SPY | ETF | 118.64 | 118.64 | 118.64 | 118.64 | 200.0 |
| 2005-01-05 09:11:00 | SPY | ETF | 118.64 | 118.64 | 118.63 | 118.64 | 600.0 |
| 2005-01-05 09:14:00 | SPY | ETF | 118.65 | 118.65 | 118.65 | 118.65 | 12100.0 |
| 2005-01-05 09:15:00 | SPY | ETF | 118.65 | 118.66 | 118.65 | 118.66 | 22600.0 |
| 2005-01-05 09:16:00 | SPY | ETF | 118.7 | 118.7 | 118.69 | 118.69 | 7400.0 |
| 2005-01-05 09:17:00 | SPY | ETF | 118.69 | 118.69 | 118.69 | 118.69 | 2800.0 |
| 2005-01-05 09:18:00 | SPY | ETF | 118.7 | 118.7 | 118.69 | 118.7 | 3500.0 |
| 2005-01-05 09:20:00 | SPY | ETF | 118.7 | 118.72 | 118.7 | 118.72 | 200.0 |
| 2005-01-05 09:21:00 | SPY | ETF | 118.72 | 118.72 | 118.72 | 118.72 | 100.0 |
| 2005-01-05 09:22:00 | SPY | ETF | 118.71 | 118.71 | 118.7 | 118.7 | 23600.0 |
| 2005-01-05 09:23:00 | SPY | ETF | 118.68 | 118.68 | 118.67 | 118.67 | 300.0 |
| 2005-01-05 09:24:00 | SPY | ETF | 118.67 | 118.67 | 118.67 | 118.67 | 1800.0 |
| 2005-01-05 09:25:00 | SPY | ETF | 118.68 | 118.68 | 118.68 | 118.68 | 200.0 |
| 2005-01-05 09:28:00 | SPY | ETF | 118.69 | 118.7 | 118.69 | 118.7 | 300.0 |
| 2005-01-05 09:29:00 | SPY | ETF | 118.7 | 118.72 | 118.7 | 118.72 | 900.0 |
| 2005-01-05 09:30:00 | SPY | ETF | 118.74 | 118.88 | 118.74 | 118.87 | 183200.0 |
| 2005-01-05 09:31:00 | SPY | ETF | 118.86 | 118.92 | 118.74 | 118.88 | 222900.0 |
| 2005-01-05 09:32:00 | SPY | ETF | 118.92 | 118.92 | 118.78 | 118.91 | 182800.0 |
| 2005-01-05 09:33:00 | SPY | ETF | 118.87 | 118.95 | 118.86 | 118.9 | 399600.0 |
| 2005-01-05 09:34:00 | SPY | ETF | 118.93 | 118.96 | 118.86 | 118.88 | 224900.0 |
> showing 50 of 16,728 rows — these rows as CSV