PREVIEW / etf_1min / 2006-01-13
file: by_date/etf_1min/2006/2006-01-13.parquet size: 325 KB rows: 22,854
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-01-13 07:10:00 | SPY | ETF | 128.65 | 128.65 | 128.65 | 128.65 | 4800.0 |
| 2006-01-13 07:19:00 | SPY | ETF | 128.66 | 128.66 | 128.65 | 128.65 | 5000.0 |
| 2006-01-13 07:35:00 | SPY | ETF | 128.66 | 128.66 | 128.64 | 128.64 | 42200.0 |
| 2006-01-13 07:37:00 | SPY | ETF | 128.65 | 128.65 | 128.65 | 128.65 | 24800.0 |
| 2006-01-13 07:38:00 | SPY | ETF | 128.66 | 128.66 | 128.66 | 128.66 | 200.0 |
| 2006-01-13 07:39:00 | SPY | ETF | 128.65 | 128.65 | 128.65 | 128.65 | 4800.0 |
| 2006-01-13 07:40:00 | SPY | ETF | 128.65 | 128.65 | 128.65 | 128.65 | 400.0 |
| 2006-01-13 07:43:00 | SPY | ETF | 128.62 | 128.62 | 128.62 | 128.62 | 15000.0 |
| 2006-01-13 07:45:00 | SPY | ETF | 128.62 | 128.64 | 128.62 | 128.64 | 18500.0 |
| 2006-01-13 07:53:00 | SPY | ETF | 128.64 | 128.64 | 128.64 | 128.64 | 100.0 |
| 2006-01-13 07:56:00 | SPY | ETF | 128.67 | 128.67 | 128.67 | 128.67 | 24900.0 |
| 2006-01-13 07:59:00 | SPY | ETF | 128.65 | 128.65 | 128.65 | 128.65 | 25000.0 |
| 2006-01-13 08:00:00 | SPY | ETF | 128.65 | 128.65 | 128.65 | 128.65 | 100.0 |
| 2006-01-13 08:01:00 | SPY | ETF | 128.65 | 128.69 | 128.61 | 128.69 | 56000.0 |
| 2006-01-13 08:02:00 | SPY | ETF | 128.65 | 128.65 | 128.61 | 128.64 | 101500.0 |
| 2006-01-13 08:03:00 | SPY | ETF | 128.63 | 128.63 | 128.63 | 128.63 | 14000.0 |
| 2006-01-13 08:06:00 | SPY | ETF | 128.65 | 128.65 | 128.65 | 128.65 | 5000.0 |
| 2006-01-13 08:08:00 | SPY | ETF | 128.64 | 128.64 | 128.64 | 128.64 | 1500.0 |
| 2006-01-13 08:09:00 | SPY | ETF | 128.64 | 128.64 | 128.64 | 128.64 | 500.0 |
| 2006-01-13 08:11:00 | SPY | ETF | 128.65 | 128.65 | 128.65 | 128.65 | 100.0 |
| 2006-01-13 08:12:00 | SPY | ETF | 128.65 | 128.65 | 128.65 | 128.65 | 400.0 |
| 2006-01-13 08:13:00 | SPY | ETF | 128.63 | 128.64 | 128.62 | 128.62 | 2000.0 |
| 2006-01-13 08:14:00 | SPY | ETF | 128.61 | 128.61 | 128.61 | 128.61 | 300.0 |
| 2006-01-13 08:20:00 | SPY | ETF | 128.64 | 128.64 | 128.64 | 128.64 | 50000.0 |
| 2006-01-13 08:24:00 | SPY | ETF | 128.67 | 128.67 | 128.67 | 128.67 | 100000.0 |
| 2006-01-13 08:28:00 | SPY | ETF | 128.69 | 128.71 | 128.69 | 128.71 | 1500.0 |
| 2006-01-13 08:30:00 | SPY | ETF | 128.61 | 128.63 | 128.55 | 128.63 | 115700.0 |
| 2006-01-13 08:31:00 | SPY | ETF | 128.63 | 128.68 | 128.62 | 128.68 | 457200.0 |
| 2006-01-13 08:32:00 | SPY | ETF | 128.68 | 128.74 | 128.68 | 128.72 | 108100.0 |
| 2006-01-13 08:33:00 | SPY | ETF | 128.7 | 128.7 | 128.69 | 128.69 | 52900.0 |
| 2006-01-13 08:34:00 | SPY | ETF | 128.7 | 128.71 | 128.7 | 128.7 | 28400.0 |
| 2006-01-13 08:35:00 | SPY | ETF | 128.7 | 128.71 | 128.7 | 128.71 | 2200.0 |
| 2006-01-13 08:36:00 | SPY | ETF | 128.72 | 128.72 | 128.72 | 128.72 | 600.0 |
| 2006-01-13 08:37:00 | SPY | ETF | 128.76 | 128.76 | 128.72 | 128.72 | 11400.0 |
| 2006-01-13 08:38:00 | SPY | ETF | 128.71 | 128.73 | 128.71 | 128.73 | 2500.0 |
| 2006-01-13 08:40:00 | SPY | ETF | 128.73 | 128.73 | 128.73 | 128.73 | 3000.0 |
| 2006-01-13 08:42:00 | SPY | ETF | 128.7 | 128.7 | 128.7 | 128.7 | 1000.0 |
| 2006-01-13 08:45:00 | SPY | ETF | 128.68 | 128.68 | 128.68 | 128.68 | 800.0 |
| 2006-01-13 08:46:00 | SPY | ETF | 128.68 | 128.68 | 128.68 | 128.68 | 24700.0 |
| 2006-01-13 08:48:00 | SPY | ETF | 128.65 | 128.66 | 128.65 | 128.66 | 25700.0 |
| 2006-01-13 08:52:00 | SPY | ETF | 128.67 | 128.67 | 128.65 | 128.65 | 20800.0 |
| 2006-01-13 08:53:00 | SPY | ETF | 128.65 | 128.65 | 128.65 | 128.65 | 7600.0 |
| 2006-01-13 08:55:00 | SPY | ETF | 128.66 | 128.66 | 128.66 | 128.66 | 200.0 |
| 2006-01-13 08:56:00 | SPY | ETF | 128.66 | 128.66 | 128.66 | 128.66 | 400.0 |
| 2006-01-13 08:57:00 | SPY | ETF | 128.65 | 128.66 | 128.65 | 128.66 | 1200.0 |
| 2006-01-13 08:58:00 | SPY | ETF | 128.65 | 128.65 | 128.65 | 128.65 | 45100.0 |
| 2006-01-13 08:59:00 | SPY | ETF | 128.65 | 128.65 | 128.65 | 128.65 | 1600.0 |
| 2006-01-13 09:02:00 | SPY | ETF | 128.65 | 128.65 | 128.64 | 128.64 | 10300.0 |
| 2006-01-13 09:03:00 | SPY | ETF | 128.64 | 128.64 | 128.64 | 128.64 | 42600.0 |
| 2006-01-13 09:04:00 | SPY | ETF | 128.66 | 128.66 | 128.64 | 128.64 | 3500.0 |
> showing 50 of 22,854 rows — these rows as CSV