PREVIEW / etf_1hour / 2006-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-06.parquet
  size:    40 KB
  rows:    1,210

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-06 04:00:00	SPY	ETF	127.37	127.37	127.37	127.37	60000.0
2006-01-06 07:00:00	SPY	ETF	127.53	127.65	127.53	127.65	150800.0
2006-01-06 08:00:00	SPY	ETF	127.65	128.06	127.48	128.01	4301300.0
2006-01-06 09:00:00	SPY	ETF	128.02	128.13	127.39	127.85	12028800.0
2006-01-06 10:00:00	SPY	ETF	127.85	127.87	127.43	127.6	11043300.0
2006-01-06 11:00:00	SPY	ETF	127.61	128.04	127.45	127.89	7582500.0
2006-01-06 12:00:00	SPY	ETF	127.89	128.14	127.87	128.0	4108200.0
2006-01-06 13:00:00	SPY	ETF	128.0	128.5	127.95	128.38	6601500.0
2006-01-06 14:00:00	SPY	ETF	128.39	128.57	128.29	128.43	8236000.0
2006-01-06 15:00:00	SPY	ETF	128.42	128.58	128.33	128.42	6631500.0
2006-01-06 16:00:00	SPY	ETF	128.44	128.62	128.4	128.52	766300.0
2006-01-06 17:00:00	SPY	ETF	128.53	128.53	128.41	128.47	19200.0
2006-01-06 18:00:00	SPY	ETF	128.48	128.5	128.45	128.48	5000.0
2006-01-06 19:00:00	SPY	ETF	128.5	128.5	128.5	128.5	600.0
2006-01-06 09:00:00	QQQ	ETF	42.26	42.34	42.15	42.21	14983700.0
2006-01-06 10:00:00	QQQ	ETF	42.2	42.21	42.06	42.18	12757900.0
2006-01-06 11:00:00	QQQ	ETF	42.18	42.33	42.11	42.29	8632300.0
2006-01-06 12:00:00	QQQ	ETF	42.29	42.5	42.29	42.43	13462500.0
2006-01-06 13:00:00	QQQ	ETF	42.43	42.59	42.36	42.56	12206800.0
2006-01-06 14:00:00	QQQ	ETF	42.57	42.7	42.53	42.62	12690400.0
2006-01-06 15:00:00	QQQ	ETF	42.62	42.68	42.55	42.66	15480500.0
2006-01-06 07:00:00	IWM	ETF	68.91	68.91	68.87	68.87	14000.0
2006-01-06 08:00:00	IWM	ETF	68.95	69.6	68.91	69.15	325900.0
2006-01-06 09:00:00	IWM	ETF	69.17	69.23	68.79	69.0	2184700.0
2006-01-06 10:00:00	IWM	ETF	69.0	69.0	68.68	68.87	2953700.0
2006-01-06 11:00:00	IWM	ETF	68.86	69.12	68.76	69.09	3930300.0
2006-01-06 12:00:00	IWM	ETF	69.1	69.35	69.08	69.29	2244200.0
2006-01-06 13:00:00	IWM	ETF	69.28	69.62	69.22	69.53	3037600.0
2006-01-06 14:00:00	IWM	ETF	69.53	69.64	69.45	69.56	4642400.0
2006-01-06 15:00:00	IWM	ETF	69.57	69.65	69.45	69.53	3741200.0
2006-01-06 16:00:00	IWM	ETF	69.51	69.78	69.47	69.61	269900.0
2006-01-06 17:00:00	IWM	ETF	69.65	69.65	69.61	69.61	2901300.0
2006-01-06 07:00:00	DIA	ETF	109.09	109.15	109.08	109.15	8900.0
2006-01-06 08:00:00	DIA	ETF	109.1	109.36	109.04	109.27	149600.0
2006-01-06 09:00:00	DIA	ETF	109.27	109.41	109.04	109.12	1198800.0
2006-01-06 10:00:00	DIA	ETF	109.11	109.11	108.79	108.92	772500.0
2006-01-06 11:00:00	DIA	ETF	108.92	109.33	108.76	109.19	1230300.0
2006-01-06 12:00:00	DIA	ETF	109.1801	109.4	109.16	109.19	1098400.0
2006-01-06 13:00:00	DIA	ETF	109.2	109.62	109.12	109.53	685600.0
2006-01-06 14:00:00	DIA	ETF	109.51	109.7	109.45	109.57	1829300.0
2006-01-06 15:00:00	DIA	ETF	109.59	109.69	109.45	109.5	1472800.0
2006-01-06 16:00:00	DIA	ETF	109.5	109.56	109.47	109.54	363100.0
2006-01-06 17:00:00	DIA	ETF	109.51	109.51	109.47	109.47	500.0
2006-01-06 18:00:00	DIA	ETF	109.46	109.46	109.45	109.45	400.0
2006-01-06 08:00:00	GLD	ETF	52.76	53.05	52.75	53.01	137900.0
2006-01-06 09:00:00	GLD	ETF	53.06	53.29	53.04	53.29	670600.0
2006-01-06 10:00:00	GLD	ETF	53.28	53.65	53.23	53.65	1321800.0
2006-01-06 11:00:00	GLD	ETF	53.65	53.65	53.41	53.62	560300.0
2006-01-06 12:00:00	GLD	ETF	53.6199	53.84	53.58	53.8	621100.0
2006-01-06 13:00:00	GLD	ETF	53.82	53.84	53.71	53.83	352000.0

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

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