PREVIEW / etf_1hour / 2006-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-20.parquet
  size:    40 KB
  rows:    1,261

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-03-20 06:00:00	SPY	ETF	131.39	131.39	131.39	131.39	700.0
2006-03-20 07:00:00	SPY	ETF	130.76	130.85	130.76	130.81	46500.0
2006-03-20 08:00:00	SPY	ETF	130.76	130.85	130.68	130.75	809200.0
2006-03-20 09:00:00	SPY	ETF	130.75	130.9	130.59	130.7	5176000.0
2006-03-20 10:00:00	SPY	ETF	130.7	130.76	130.21	130.4	13223700.0
2006-03-20 11:00:00	SPY	ETF	130.41	130.6	130.35	130.57	5656400.0
2006-03-20 12:00:00	SPY	ETF	130.55	130.66	130.37	130.63	4307400.0
2006-03-20 13:00:00	SPY	ETF	130.62	130.63	130.31	130.37	2969500.0
2006-03-20 14:00:00	SPY	ETF	130.34	130.5	130.28	130.35	2986200.0
2006-03-20 15:00:00	SPY	ETF	130.37	130.55	130.29	130.4	5114300.0
2006-03-20 16:00:00	SPY	ETF	130.39	130.494	130.36	130.37	1094300.0
2006-03-20 17:00:00	SPY	ETF	130.42	130.45	130.31	130.4	705400.0
2006-03-20 18:00:00	SPY	ETF	130.4	130.4	130.36	130.36	2700.0
2006-03-20 19:00:00	SPY	ETF	130.35	130.36	130.33	130.33	16300.0
2006-03-20 09:00:00	QQQ	ETF	41.58	41.68	41.51	41.58	8343200.0
2006-03-20 10:00:00	QQQ	ETF	41.57	41.61	41.4	41.45	12029200.0
2006-03-20 11:00:00	QQQ	ETF	41.45	41.58	41.42	41.56	7790000.0
2006-03-20 12:00:00	QQQ	ETF	41.56	41.66	41.47	41.64	8037000.0
2006-03-20 13:00:00	QQQ	ETF	41.64	41.65	41.46	41.52	6554000.0
2006-03-20 14:00:00	QQQ	ETF	41.52	41.58	41.48	41.49	4445400.0
2006-03-20 15:00:00	QQQ	ETF	41.5	41.6	41.46	41.56	8085300.0
2006-03-20 07:00:00	IWM	ETF	74.17	74.17	74.17	74.17	100.0
2006-03-20 08:00:00	IWM	ETF	74.16	74.22	74.15	74.2	579100.0
2006-03-20 09:00:00	IWM	ETF	74.2	74.33	74.05	74.16	1901000.0
2006-03-20 10:00:00	IWM	ETF	74.17	74.23	73.75	73.88	4497600.0
2006-03-20 11:00:00	IWM	ETF	73.88	74.05	73.71	74.0	3736500.0
2006-03-20 12:00:00	IWM	ETF	74.0	74.17	73.9	74.17	2447800.0
2006-03-20 13:00:00	IWM	ETF	74.17	74.17	73.95	74.12	1883700.0
2006-03-20 14:00:00	IWM	ETF	74.12	74.24	73.96	73.99	2075600.0
2006-03-20 15:00:00	IWM	ETF	73.99	74.32	73.92	74.07	6826500.0
2006-03-20 16:00:00	IWM	ETF	74.09	74.09	74.0	74.04	372200.0
2006-03-20 17:00:00	IWM	ETF	74.01	74.02	74.01	74.01	4100.0
2006-03-20 07:00:00	DIA	ETF	112.78	112.8	112.78	112.8	400.0
2006-03-20 08:00:00	DIA	ETF	112.8	112.92	112.76	112.76	20100.0
2006-03-20 09:00:00	DIA	ETF	112.76	113.01	112.67	112.8599	671000.0
2006-03-20 10:00:00	DIA	ETF	112.86	112.91	112.5	112.6	1746100.0
2006-03-20 11:00:00	DIA	ETF	112.61	112.77	112.56	112.72	1147000.0
2006-03-20 12:00:00	DIA	ETF	112.74	112.86	112.58	112.83	482500.0
2006-03-20 13:00:00	DIA	ETF	112.82	112.82	112.59	112.64	409700.0
2006-03-20 14:00:00	DIA	ETF	112.66	112.77	112.55	112.61	855500.0
2006-03-20 15:00:00	DIA	ETF	112.62	112.77	112.59	112.7	1305500.0
2006-03-20 16:00:00	DIA	ETF	112.7	112.73	112.67	112.69	69000.0
2006-03-20 17:00:00	DIA	ETF	112.63	112.75	112.63	112.74	100500.0
2006-03-20 18:00:00	DIA	ETF	112.78	112.78	112.78	112.78	900.0
2006-03-20 08:00:00	GLD	ETF	55.06	55.14	54.79	54.8	35900.0
2006-03-20 09:00:00	GLD	ETF	54.89	55.31	54.89	55.28	368200.0
2006-03-20 10:00:00	GLD	ETF	55.28	55.4	55.06	55.14	503300.0
2006-03-20 11:00:00	GLD	ETF	55.13	55.37	55.1	55.32	267200.0
2006-03-20 12:00:00	GLD	ETF	55.3184	55.35	55.1	55.12	157500.0
2006-03-20 13:00:00	GLD	ETF	55.12	55.3	55.12	55.23	159800.0

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

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