PREVIEW / etf_1hour / 2006-01-20

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-20.parquet
  size:    41 KB
  rows:    1,232

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-20 06:00:00	SPY	ETF	128.1	128.12	128.0	128.0	4600.0
2006-01-20 07:00:00	SPY	ETF	128.0	128.05	127.97	128.04	18400.0
2006-01-20 08:00:00	SPY	ETF	128.05	128.36	127.97	128.05	285300.0
2006-01-20 09:00:00	SPY	ETF	128.09	128.38	128.05	128.08	7669100.0
2006-01-20 10:00:00	SPY	ETF	128.08	128.15	127.26	127.49	19690800.0
2006-01-20 11:00:00	SPY	ETF	127.44	127.53	126.78	126.91	16029000.0
2006-01-20 12:00:00	SPY	ETF	126.91	127.2	126.74	126.88	13334500.0
2006-01-20 13:00:00	SPY	ETF	126.88	126.9	126.48	126.56	15138900.0
2006-01-20 14:00:00	SPY	ETF	126.56	127.04	126.42	126.44	13411900.0
2006-01-20 15:00:00	SPY	ETF	126.45	126.67	126.0	126.12	23522300.0
2006-01-20 16:00:00	SPY	ETF	126.13	126.17	125.81	126.05	2157000.0
2006-01-20 17:00:00	SPY	ETF	126.03	126.1	125.94	126.0	201300.0
2006-01-20 18:00:00	SPY	ETF	125.97	125.97	125.92	125.92	20600.0
2006-01-20 19:00:00	SPY	ETF	125.97	125.97	125.91	125.95	1600.0
2006-01-20 09:00:00	QQQ	ETF	42.44	42.49	42.34	42.38	9073700.0
2006-01-20 10:00:00	QQQ	ETF	42.37	42.38	41.82	41.99	35259700.0
2006-01-20 11:00:00	QQQ	ETF	41.99	42.07	41.73	41.76	20651700.0
2006-01-20 12:00:00	QQQ	ETF	41.75	42.0	41.34	41.52	26093400.0
2006-01-20 13:00:00	QQQ	ETF	41.51	41.61	41.37	41.42	26382700.0
2006-01-20 14:00:00	QQQ	ETF	41.42	41.57	41.35	41.39	19142600.0
2006-01-20 15:00:00	QQQ	ETF	41.39	41.53	41.15	41.3	37696200.0
2006-01-20 08:00:00	IWM	ETF	70.83	70.85	70.77	70.81	44100.0
2006-01-20 09:00:00	IWM	ETF	70.81	71.12	70.81	70.95	2475700.0
2006-01-20 10:00:00	IWM	ETF	70.91	70.94	70.55	70.58	4478400.0
2006-01-20 11:00:00	IWM	ETF	70.57	70.68	70.18	70.23	5479200.0
2006-01-20 12:00:00	IWM	ETF	70.23	70.5	70.2	70.28	3598200.0
2006-01-20 13:00:00	IWM	ETF	70.29	70.29	69.89	69.93	8360000.0
2006-01-20 14:00:00	IWM	ETF	69.94	70.19	69.85	70.01	4757200.0
2006-01-20 15:00:00	IWM	ETF	70.01	70.17	69.83	70.01	12844100.0
2006-01-20 16:00:00	IWM	ETF	70.03	70.21	70.0	70.1	822600.0
2006-01-20 17:00:00	IWM	ETF	70.17	70.17	70.17	70.17	3000.0
2006-01-20 18:00:00	IWM	ETF	70.12	70.12	70.1	70.1	300.0
2006-01-20 07:00:00	DIA	ETF	108.38	108.38	108.38	108.38	100.0
2006-01-20 08:00:00	DIA	ETF	108.37	108.41	108.32	108.33	11300.0
2006-01-20 09:00:00	DIA	ETF	108.46	108.5	108.01	108.04	3159000.0
2006-01-20 10:00:00	DIA	ETF	108.03	108.03	107.5	107.63	1732600.0
2006-01-20 11:00:00	DIA	ETF	107.63	107.68	107.23	107.31	1986900.0
2006-01-20 12:00:00	DIA	ETF	107.32	107.53	107.25	107.36	2789000.0
2006-01-20 13:00:00	DIA	ETF	107.37	107.38	107.0	107.03	1362800.0
2006-01-20 14:00:00	DIA	ETF	107.04	107.45	106.9	106.93	1209700.0
2006-01-20 15:00:00	DIA	ETF	106.93	107.07	106.51	106.62	2098900.0
2006-01-20 16:00:00	DIA	ETF	106.62	106.63	106.42	106.47	1978200.0
2006-01-20 17:00:00	DIA	ETF	106.46	106.48	106.3	106.45	181200.0
2006-01-20 18:00:00	DIA	ETF	106.41	106.41	106.33	106.33	1600.0
2006-01-20 08:00:00	GLD	ETF	55.62	56.21	55.62	56.21	51200.0
2006-01-20 09:00:00	GLD	ETF	56.13	56.48	56.04	56.45	2125100.0
2006-01-20 10:00:00	GLD	ETF	56.42	56.6	55.89	55.95	1280500.0
2006-01-20 11:00:00	GLD	ETF	55.94	56.19	55.21	55.71	1058700.0
2006-01-20 12:00:00	GLD	ETF	55.71	55.9	55.02	55.18	858400.0
2006-01-20 13:00:00	GLD	ETF	55.18	55.39	55.05	55.27	756900.0

> showing 50 of 1,232 rows — these rows as CSV

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