PREVIEW / etf_1min / 2006-01-27

all etf 1-min files

  file:    by_date/etf_1min/2006/2006-01-27.parquet
  size:    389 KB
  rows:    26,734

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-27 04:24:00	SPY	ETF	127.82	127.82	127.82	127.82	50000.0
2006-01-27 04:38:00	SPY	ETF	127.75	127.75	127.75	127.75	100.0
2006-01-27 06:47:00	SPY	ETF	127.77	127.77	127.77	127.77	100.0
2006-01-27 07:01:00	SPY	ETF	127.79	127.79	127.79	127.79	3000.0
2006-01-27 07:02:00	SPY	ETF	127.8	127.8	127.8	127.8	600.0
2006-01-27 07:07:00	SPY	ETF	127.81	127.83	127.81	127.83	2000.0
2006-01-27 07:16:00	SPY	ETF	127.85	127.85	127.85	127.85	2400.0
2006-01-27 07:21:00	SPY	ETF	127.81	127.81	127.81	127.81	700.0
2006-01-27 07:25:00	SPY	ETF	127.85	127.86	127.85	127.86	2000.0
2006-01-27 07:26:00	SPY	ETF	127.85	127.86	127.85	127.86	2000.0
2006-01-27 07:28:00	SPY	ETF	127.82	127.82	127.82	127.82	10000.0
2006-01-27 07:35:00	SPY	ETF	127.82	127.82	127.82	127.82	1500.0
2006-01-27 07:37:00	SPY	ETF	127.78	127.78	127.77	127.77	10000.0
2006-01-27 07:39:00	SPY	ETF	127.75	127.75	127.75	127.75	5000.0
2006-01-27 07:40:00	SPY	ETF	127.75	127.75	127.74	127.74	600.0
2006-01-27 07:41:00	SPY	ETF	127.76	127.76	127.76	127.76	500.0
2006-01-27 07:42:00	SPY	ETF	127.78	127.8	127.78	127.8	2400.0
2006-01-27 07:43:00	SPY	ETF	127.78	127.78	127.78	127.78	300.0
2006-01-27 07:45:00	SPY	ETF	127.8	127.8	127.8	127.8	47300.0
2006-01-27 07:46:00	SPY	ETF	127.77	127.77	127.77	127.77	200.0
2006-01-27 07:47:00	SPY	ETF	127.81	127.81	127.81	127.81	8000.0
2006-01-27 07:49:00	SPY	ETF	127.82	127.82	127.82	127.82	20000.0
2006-01-27 07:53:00	SPY	ETF	127.83	127.83	127.83	127.83	200.0
2006-01-27 07:55:00	SPY	ETF	127.83	127.83	127.83	127.83	100.0
2006-01-27 07:57:00	SPY	ETF	127.83	127.83	127.83	127.83	100.0
2006-01-27 08:00:00	SPY	ETF	127.86	127.86	127.75	127.83	153100.0
2006-01-27 08:01:00	SPY	ETF	127.86	127.87	127.74	127.85	224700.0
2006-01-27 08:02:00	SPY	ETF	127.85	127.85	127.83	127.85	3500.0
2006-01-27 08:03:00	SPY	ETF	127.85	127.9	127.85	127.9	23200.0
2006-01-27 08:04:00	SPY	ETF	127.89	127.9	127.89	127.9	700.0
2006-01-27 08:05:00	SPY	ETF	127.9	127.9	127.9	127.9	1000.0
2006-01-27 08:06:00	SPY	ETF	127.92	127.95	127.91	127.95	5400.0
2006-01-27 08:07:00	SPY	ETF	127.91	127.91	127.91	127.91	500.0
2006-01-27 08:08:00	SPY	ETF	127.81	127.81	127.81	127.81	20000.0
2006-01-27 08:09:00	SPY	ETF	127.88	127.88	127.82	127.86	20800.0
2006-01-27 08:10:00	SPY	ETF	127.86	127.86	127.86	127.86	100.0
2006-01-27 08:11:00	SPY	ETF	127.84	127.84	127.84	127.84	1000.0
2006-01-27 08:12:00	SPY	ETF	127.84	127.84	127.84	127.84	2800.0
2006-01-27 08:13:00	SPY	ETF	127.84	127.86	127.84	127.86	5500.0
2006-01-27 08:14:00	SPY	ETF	127.86	127.86	127.86	127.86	200.0
2006-01-27 08:15:00	SPY	ETF	127.87	127.88	127.87	127.88	500.0
2006-01-27 08:16:00	SPY	ETF	127.88	127.88	127.87	127.88	1700.0
2006-01-27 08:18:00	SPY	ETF	127.89	127.89	127.88	127.88	6200.0
2006-01-27 08:19:00	SPY	ETF	127.9	127.9	127.89	127.89	8500.0
2006-01-27 08:20:00	SPY	ETF	127.9	127.9	127.9	127.9	1000.0
2006-01-27 08:22:00	SPY	ETF	127.89	127.89	127.89	127.89	900.0
2006-01-27 08:23:00	SPY	ETF	127.89	127.9	127.89	127.9	1500.0
2006-01-27 08:24:00	SPY	ETF	127.91	127.91	127.89	127.89	4000.0
2006-01-27 08:25:00	SPY	ETF	127.88	127.88	127.85	127.87	11400.0
2006-01-27 08:26:00	SPY	ETF	127.85	127.86	127.85	127.85	3100.0

> showing 50 of 26,734 rows — these rows as CSV

> unlock the full archive -- $79 one-time