PREVIEW / etf_1hour / 2006-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-18.parquet
  size:    52 KB
  rows:    1,649

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-09-18 06:00:00	SPY	ETF	132.09	132.09	132.09	132.09	900.0
2006-09-18 07:00:00	SPY	ETF	132.05	132.12	132.0	132.06	65700.0
2006-09-18 08:00:00	SPY	ETF	132.05	132.06	131.86	131.96	2068200.0
2006-09-18 09:00:00	SPY	ETF	131.95	131.99	131.65	131.94	6651600.0
2006-09-18 10:00:00	SPY	ETF	131.94	132.22	131.85	131.96	10400700.0
2006-09-18 11:00:00	SPY	ETF	131.97	132.33	131.9	132.22	7333000.0
2006-09-18 12:00:00	SPY	ETF	132.22	132.31	132.08	132.29	5394900.0
2006-09-18 13:00:00	SPY	ETF	132.29	132.39	131.8	131.9	11151000.0
2006-09-18 14:00:00	SPY	ETF	131.9	131.95	131.69	131.84	6443400.0
2006-09-18 15:00:00	SPY	ETF	131.84	132.12	131.81	132.02	8434100.0
2006-09-18 16:00:00	SPY	ETF	132.02	132.19	131.99	132.16	2547300.0
2006-09-18 17:00:00	SPY	ETF	132.12	132.12	132.01	132.05	1014100.0
2006-09-18 18:00:00	SPY	ETF	132.05	132.06	132.04	132.06	2400.0
2006-09-18 19:00:00	SPY	ETF	132.06	132.08	132.06	132.08	21500.0
2006-09-18 09:00:00	QQQ	ETF	40.12	40.28	40.03	40.23	11609800.0
2006-09-18 10:00:00	QQQ	ETF	40.23	40.37	40.18	40.2	16041900.0
2006-09-18 11:00:00	QQQ	ETF	40.21	40.4	40.15	40.33	12324500.0
2006-09-18 12:00:00	QQQ	ETF	40.34	40.38	40.22	40.37	9309600.0
2006-09-18 13:00:00	QQQ	ETF	40.37	40.4	40.07	40.1	16896500.0
2006-09-18 14:00:00	QQQ	ETF	40.09	40.2	39.94	40.04	22731100.0
2006-09-18 15:00:00	QQQ	ETF	40.04	40.14	39.98	40.12	14454200.0
2006-09-18 07:00:00	IWM	ETF	72.5	72.5	72.5	72.5	100.0
2006-09-18 08:00:00	IWM	ETF	72.52	72.52	72.44	72.45	73500.0
2006-09-18 09:00:00	IWM	ETF	72.36	72.58	72.14	72.55	6467800.0
2006-09-18 10:00:00	IWM	ETF	72.54	72.75	72.38	72.42	6504700.0
2006-09-18 11:00:00	IWM	ETF	72.41	72.95	72.38	72.86	4423800.0
2006-09-18 12:00:00	IWM	ETF	72.85	73.04	72.73	73.01	2700000.0
2006-09-18 13:00:00	IWM	ETF	73.02	73.07	72.52	72.56	4960700.0
2006-09-18 14:00:00	IWM	ETF	72.55	72.63	72.28	72.44	4381300.0
2006-09-18 15:00:00	IWM	ETF	72.44	72.61	72.33	72.54	3251600.0
2006-09-18 16:00:00	IWM	ETF	72.54	72.86	72.43	72.66	4427600.0
2006-09-18 18:00:00	IWM	ETF	72.63	72.63	72.63	72.63	400.0
2006-09-18 08:00:00	DIA	ETF	115.7	115.7	115.5	115.5	4100.0
2006-09-18 09:00:00	DIA	ETF	115.5	115.5	115.27	115.43	1004400.0
2006-09-18 10:00:00	DIA	ETF	115.43	115.72	115.39	115.47	790900.0
2006-09-18 11:00:00	DIA	ETF	115.47	115.76	115.41	115.69	720700.0
2006-09-18 12:00:00	DIA	ETF	115.69	115.75	115.5292	115.68	258300.0
2006-09-18 13:00:00	DIA	ETF	115.71	115.79	115.27	115.35	1303100.0
2006-09-18 14:00:00	DIA	ETF	115.3525	115.44	115.13	115.35	1511800.0
2006-09-18 15:00:00	DIA	ETF	115.35	115.58	115.3	115.43	818100.0
2006-09-18 16:00:00	DIA	ETF	115.45	115.54	115.43	115.46	220300.0
2006-09-18 17:00:00	DIA	ETF	115.45	115.49	115.45	115.45	300400.0
2006-09-18 18:00:00	DIA	ETF	115.45	115.45	115.45	115.45	300.0
2006-09-18 08:00:00	GLD	ETF	57.83	57.83	57.39	57.5	52100.0
2006-09-18 09:00:00	GLD	ETF	57.62	57.87	57.41	57.7707	1132800.0
2006-09-18 10:00:00	GLD	ETF	57.79	57.83	57.46	57.55	716900.0
2006-09-18 11:00:00	GLD	ETF	57.54	57.7501	57.46	57.74	381700.0
2006-09-18 12:00:00	GLD	ETF	57.74	58.38	57.7099	58.27	737400.0
2006-09-18 13:00:00	GLD	ETF	58.27	58.39	58.1602	58.36	504800.0
2006-09-18 14:00:00	GLD	ETF	58.3698	58.3698	58.02	58.09	519100.0

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

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