PREVIEW / etf_1hour / 2006-01-19

all etf 1-hour files

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

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-19 05:00:00	SPY	ETF	128.04	128.04	127.97	127.97	300.0
2006-01-19 06:00:00	SPY	ETF	128.1	128.11	128.1	128.11	4000.0
2006-01-19 07:00:00	SPY	ETF	128.07	128.14	128.0	128.13	48500.0
2006-01-19 08:00:00	SPY	ETF	128.13	128.26	128.02	128.2	1253700.0
2006-01-19 09:00:00	SPY	ETF	128.22	128.25	127.97	128.02	6882000.0
2006-01-19 10:00:00	SPY	ETF	128.04	128.14	127.86	127.92	14359400.0
2006-01-19 11:00:00	SPY	ETF	127.93	128.16	127.81	128.12	9178100.0
2006-01-19 12:00:00	SPY	ETF	128.1	128.45	128.01	128.41	9040600.0
2006-01-19 13:00:00	SPY	ETF	128.41	128.77	128.38	128.71	9727900.0
2006-01-19 14:00:00	SPY	ETF	128.71	128.75	128.43	128.62	8679100.0
2006-01-19 15:00:00	SPY	ETF	128.61	128.63	128.25	128.38	11261300.0
2006-01-19 16:00:00	SPY	ETF	128.37	128.4	128.23	128.35	899700.0
2006-01-19 17:00:00	SPY	ETF	128.36	128.37	128.25	128.34	255100.0
2006-01-19 18:00:00	SPY	ETF	128.36	128.36	128.3	128.32	265600.0
2006-01-19 19:00:00	SPY	ETF	128.35	128.36	128.29	128.31	28000.0
2006-01-19 09:00:00	QQQ	ETF	42.4	42.45	42.33	42.37	16856700.0
2006-01-19 10:00:00	QQQ	ETF	42.37	42.49	42.34	42.35	13022800.0
2006-01-19 11:00:00	QQQ	ETF	42.35	42.5	42.29	42.48	10966600.0
2006-01-19 12:00:00	QQQ	ETF	42.49	42.69	42.44	42.66	16789300.0
2006-01-19 13:00:00	QQQ	ETF	42.66	42.78	42.65	42.75	11639600.0
2006-01-19 14:00:00	QQQ	ETF	42.75	42.82	42.6	42.66	13005700.0
2006-01-19 15:00:00	QQQ	ETF	42.66	42.67	42.46	42.53	14055700.0
2006-01-19 08:00:00	IWM	ETF	70.01	70.12	70.01	70.09	273700.0
2006-01-19 09:00:00	IWM	ETF	70.09	70.34	69.94	70.28	3826300.0
2006-01-19 10:00:00	IWM	ETF	70.28	70.5	70.19	70.34	4706700.0
2006-01-19 11:00:00	IWM	ETF	70.34	70.69	70.28	70.68	2295200.0
2006-01-19 12:00:00	IWM	ETF	70.69	71.04	70.62	70.99	5094500.0
2006-01-19 13:00:00	IWM	ETF	70.98	71.17	70.98	71.06	3062400.0
2006-01-19 14:00:00	IWM	ETF	71.06	71.12	70.87	71.05	3419100.0
2006-01-19 15:00:00	IWM	ETF	71.05	71.06	70.82	70.95	3262600.0
2006-01-19 16:00:00	IWM	ETF	70.95	71.02	70.87	70.95	256200.0
2006-01-19 17:00:00	IWM	ETF	70.99	70.99	70.98	70.98	1300.0
2006-01-19 18:00:00	IWM	ETF	71.02	71.02	71.02	71.02	400.0
2006-01-19 08:00:00	DIA	ETF	108.93	108.97	108.83	108.86	70500.0
2006-01-19 09:00:00	DIA	ETF	108.87	108.87	108.69	108.75	762400.0
2006-01-19 10:00:00	DIA	ETF	108.75	108.81	108.57	108.6	846600.0
2006-01-19 11:00:00	DIA	ETF	108.59	108.77	108.54	108.75	623400.0
2006-01-19 12:00:00	DIA	ETF	108.75	108.96	108.68	108.94	423700.0
2006-01-19 13:00:00	DIA	ETF	108.93	109.18	108.93	109.17	675600.0
2006-01-19 14:00:00	DIA	ETF	109.15	109.17	108.87	109.03	648500.0
2006-01-19 15:00:00	DIA	ETF	109.01	109.03	108.72	108.77	491800.0
2006-01-19 16:00:00	DIA	ETF	108.76	108.77	108.64	108.73	33900.0
2006-01-19 07:00:00	GLD	ETF	54.43	54.43	54.43	54.43	100.0
2006-01-19 08:00:00	GLD	ETF	54.59	54.8	54.47	54.7	49000.0
2006-01-19 09:00:00	GLD	ETF	54.75	55.18	54.75	55.108	833900.0
2006-01-19 10:00:00	GLD	ETF	55.11	55.27	54.98	55.12	885500.0
2006-01-19 11:00:00	GLD	ETF	55.11	55.24	54.97	55.1502	566800.0
2006-01-19 12:00:00	GLD	ETF	55.15	55.53	55.1	55.49	729100.0
2006-01-19 13:00:00	GLD	ETF	55.5	55.71	55.45	55.59	791600.0
2006-01-19 14:00:00	GLD	ETF	55.59	55.71	55.55	55.58	751200.0

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

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