PREVIEW / etf_1hour / 2009-11-27

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-27.parquet
  size:    101 KB
  rows:    2,975

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
2009-11-27 04:00:00	SPY	ETF	108.23	109.0	108.23	108.52	21007.0
2009-11-27 05:00:00	SPY	ETF	108.47	108.69	108.38	108.38	5701.0
2009-11-27 06:00:00	SPY	ETF	108.29	108.51	108.09	108.4	115671.0
2009-11-27 07:00:00	SPY	ETF	108.42	108.61	108.2	108.6	1201920.0
2009-11-27 08:00:00	SPY	ETF	108.45	111.14	108.08	108.51	4510557.0
2009-11-27 09:00:00	SPY	ETF	108.5	109.28	108.29	109.22	35376284.0
2009-11-27 10:00:00	SPY	ETF	109.21	110.18	109.17	109.99	29460688.0
2009-11-27 11:00:00	SPY	ETF	109.99	110.32	108.4	109.945	17767602.0
2009-11-27 12:00:00	SPY	ETF	109.94	110.2	109.5	109.57	21544990.0
2009-11-27 13:00:00	SPY	ETF	109.56	111.4581	109.34	109.4	10225918.0
2009-11-27 14:00:00	SPY	ETF	109.4	109.43	109.27	109.42	97673.0
2009-11-27 15:00:00	SPY	ETF	109.42	109.52	109.35	109.52	51249.0
2009-11-27 16:00:00	SPY	ETF	109.46	109.49	109.41	109.41	7800.0
2009-11-27 04:00:00	QQQ	ETF	43.03	43.03	43.0	43.0	420.0
2009-11-27 05:00:00	QQQ	ETF	43.03	43.06	42.97	42.99	4229.0
2009-11-27 06:00:00	QQQ	ETF	42.89	43.03	42.88	43.03	7751.0
2009-11-27 07:00:00	QQQ	ETF	43.04	43.08	42.94	43.04	343475.0
2009-11-27 08:00:00	QQQ	ETF	43.07	44.49	43.04	43.1	1220078.0
2009-11-27 09:00:00	QQQ	ETF	43.1	43.36	42.9	43.31	16465924.0
2009-11-27 10:00:00	QQQ	ETF	43.31	43.79	43.29	43.6965	13567545.0
2009-11-27 11:00:00	QQQ	ETF	43.69	43.83	43.635	43.7	12837917.0
2009-11-27 12:00:00	QQQ	ETF	43.7	43.78	43.5	43.52	11414420.0
2009-11-27 13:00:00	QQQ	ETF	43.53	43.5974	43.33	43.39	3050236.0
2009-11-27 14:00:00	QQQ	ETF	43.39	43.41	43.28	43.36	105578.0
2009-11-27 15:00:00	QQQ	ETF	43.36	43.45	43.36	43.41	7710.0
2009-11-27 16:00:00	QQQ	ETF	43.41	43.43	43.4	43.43	17395.0
2009-11-27 04:00:00	IWM	ETF	58.0	58.0	56.98	56.98	3411.0
2009-11-27 06:00:00	IWM	ETF	57.11	57.11	57.09	57.09	15496.0
2009-11-27 07:00:00	IWM	ETF	57.16	57.4	57.1	57.23	110408.0
2009-11-27 08:00:00	IWM	ETF	57.38	58.64	56.93	57.27	852349.0
2009-11-27 09:00:00	IWM	ETF	57.25	58.16	57.04	57.9	14928133.0
2009-11-27 10:00:00	IWM	ETF	57.9	58.41	57.83	58.36	14563516.0
2009-11-27 11:00:00	IWM	ETF	58.36	58.67	58.28	58.34	7941730.0
2009-11-27 12:00:00	IWM	ETF	58.34	58.41	57.86	57.9	7501156.0
2009-11-27 13:00:00	IWM	ETF	57.9	58.2218	57.1	57.73	2710147.0
2009-11-27 14:00:00	IWM	ETF	57.75	57.83	57.74	57.77	7600.0
2009-11-27 15:00:00	IWM	ETF	57.77	57.84	57.56	57.7	6971.0
2009-11-27 04:00:00	DIA	ETF	103.07	103.07	103.07	103.07	500.0
2009-11-27 06:00:00	DIA	ETF	102.5	102.5	102.5	102.5	100.0
2009-11-27 07:00:00	DIA	ETF	102.35	102.55	102.25	102.55	9253.0
2009-11-27 08:00:00	DIA	ETF	102.55	102.87	102.38	102.49	157030.0
2009-11-27 09:00:00	DIA	ETF	102.47	102.97	102.23	102.9	2900492.0
2009-11-27 10:00:00	DIA	ETF	102.9	103.63	102.88	103.42	3842289.0
2009-11-27 11:00:00	DIA	ETF	103.44	103.84	103.25	103.46	2840036.0
2009-11-27 12:00:00	DIA	ETF	103.46	103.75	103.15	103.22	1980118.0
2009-11-27 13:00:00	DIA	ETF	103.22	103.24	102.97	103.19	127393.0
2009-11-27 14:00:00	DIA	ETF	103.19	103.22	103.19	103.2	1000.0
2009-11-27 04:00:00	GLD	ETF	113.02	113.8	112.95	113.3	34790.0
2009-11-27 05:00:00	GLD	ETF	113.4	114.16	113.25	114.16	26400.0
2009-11-27 06:00:00	GLD	ETF	114.11	114.18	113.65	114.1	40330.0

> showing 50 of 2,975 rows — these rows as CSV

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