PREVIEW / etf_1min / 2006-01-09

all etf 1-min files

  file:    by_date/etf_1min/2006/2006-01-09.parquet
  size:    371 KB
  rows:    26,516

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-09 06:38:00	SPY	ETF	128.34	128.34	128.34	128.34	100.0
2006-01-09 07:10:00	SPY	ETF	128.36	128.38	128.36	128.38	50000.0
2006-01-09 07:29:00	SPY	ETF	128.32	128.32	128.31	128.31	25000.0
2006-01-09 07:43:00	SPY	ETF	128.33	128.33	128.33	128.33	1000.0
2006-01-09 07:54:00	SPY	ETF	128.37	128.37	128.37	128.37	100.0
2006-01-09 08:00:00	SPY	ETF	128.37	128.37	128.32	128.32	81000.0
2006-01-09 08:01:00	SPY	ETF	128.4	128.42	128.33	128.34	14600.0
2006-01-09 08:02:00	SPY	ETF	128.42	128.42	128.42	128.42	100.0
2006-01-09 08:05:00	SPY	ETF	128.42	128.42	128.4	128.4	2600.0
2006-01-09 08:07:00	SPY	ETF	128.4	128.4	128.4	128.4	1400.0
2006-01-09 08:11:00	SPY	ETF	128.39	128.39	128.39	128.39	100.0
2006-01-09 08:12:00	SPY	ETF	128.38	128.38	128.37	128.37	1200.0
2006-01-09 08:18:00	SPY	ETF	128.38	128.38	128.38	128.38	800.0
2006-01-09 08:19:00	SPY	ETF	128.38	128.38	128.38	128.38	57400.0
2006-01-09 08:21:00	SPY	ETF	128.38	128.38	128.37	128.38	1200.0
2006-01-09 08:22:00	SPY	ETF	128.38	128.39	128.38	128.39	2600.0
2006-01-09 08:23:00	SPY	ETF	128.39	128.39	128.39	128.39	1400.0
2006-01-09 08:24:00	SPY	ETF	128.4	128.4	128.39	128.39	3000.0
2006-01-09 08:27:00	SPY	ETF	128.4	128.4	128.4	128.4	1000.0
2006-01-09 08:29:00	SPY	ETF	128.4	128.4	128.4	128.4	400.0
2006-01-09 08:32:00	SPY	ETF	128.38	128.38	128.38	128.38	200.0
2006-01-09 08:35:00	SPY	ETF	128.39	128.39	128.39	128.39	76000.0
2006-01-09 08:36:00	SPY	ETF	128.39	128.39	128.39	128.39	1000.0
2006-01-09 08:37:00	SPY	ETF	128.39	128.39	128.39	128.39	700.0
2006-01-09 08:40:00	SPY	ETF	128.4	128.4	128.4	128.4	4600.0
2006-01-09 08:41:00	SPY	ETF	128.4	128.42	128.4	128.42	1200.0
2006-01-09 08:44:00	SPY	ETF	128.4	128.4	128.4	128.4	1500.0
2006-01-09 08:47:00	SPY	ETF	128.39	128.39	128.38	128.38	2000.0
2006-01-09 08:48:00	SPY	ETF	128.38	128.38	128.38	128.38	2100.0
2006-01-09 08:49:00	SPY	ETF	128.38	128.38	128.38	128.38	17000.0
2006-01-09 08:50:00	SPY	ETF	128.37	128.38	128.37	128.38	2800.0
2006-01-09 08:51:00	SPY	ETF	128.38	128.38	128.38	128.38	11700.0
2006-01-09 08:59:00	SPY	ETF	128.38	128.38	128.37	128.37	700.0
2006-01-09 09:02:00	SPY	ETF	128.37	128.37	128.37	128.37	18000.0
2006-01-09 09:03:00	SPY	ETF	128.37	128.37	128.37	128.37	21000.0
2006-01-09 09:04:00	SPY	ETF	128.38	128.38	128.38	128.38	100.0
2006-01-09 09:08:00	SPY	ETF	128.39	128.39	128.39	128.39	500.0
2006-01-09 09:09:00	SPY	ETF	128.39	128.39	128.38	128.38	1900.0
2006-01-09 09:10:00	SPY	ETF	128.37	128.37	128.37	128.37	100.0
2006-01-09 09:15:00	SPY	ETF	128.39	128.39	128.39	128.39	100.0
2006-01-09 09:18:00	SPY	ETF	128.42	128.42	128.42	128.42	100.0
2006-01-09 09:20:00	SPY	ETF	128.42	128.44	128.42	128.44	4100.0
2006-01-09 09:22:00	SPY	ETF	128.44	128.44	128.38	128.38	501000.0
2006-01-09 09:24:00	SPY	ETF	128.42	128.44	128.42	128.44	3000.0
2006-01-09 09:26:00	SPY	ETF	128.43	128.44	128.43	128.44	800.0
2006-01-09 09:27:00	SPY	ETF	128.42	128.43	128.42	128.43	3100.0
2006-01-09 09:28:00	SPY	ETF	128.42	128.42	128.42	128.42	100.0
2006-01-09 09:30:00	SPY	ETF	128.42	128.45	128.39	128.43	237500.0
2006-01-09 09:31:00	SPY	ETF	128.44	128.48	128.43	128.44	142800.0
2006-01-09 09:32:00	SPY	ETF	128.44	128.49	128.44	128.46	89900.0

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

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