PREVIEW / etf_1hour / 2009-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-15.parquet
  size:    142 KB
  rows:    4,356

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-07-15 04:00:00	SPY	ETF	91.39	91.59	91.39	91.59	1200.0
2009-07-15 05:00:00	SPY	ETF	91.59	91.67	91.59	91.67	3011.0
2009-07-15 06:00:00	SPY	ETF	91.67	91.8	91.65	91.67	25249.0
2009-07-15 07:00:00	SPY	ETF	91.68	91.75	91.43	91.63	623753.0
2009-07-15 08:00:00	SPY	ETF	91.63	91.95	90.63	91.74	2503465.0
2009-07-15 09:00:00	SPY	ETF	91.74	92.19	91.68	92.09	23176334.0
2009-07-15 10:00:00	SPY	ETF	92.09	92.4	92.07	92.24	27508975.0
2009-07-15 11:00:00	SPY	ETF	92.24	92.76	92.24	92.59	22151685.0
2009-07-15 12:00:00	SPY	ETF	92.5999	92.8	92.53	92.6695	15840925.0
2009-07-15 13:00:00	SPY	ETF	92.67	93.0	92.63	92.9	15286723.0
2009-07-15 14:00:00	SPY	ETF	92.9099	93.38	92.77	93.35	33278259.0
2009-07-15 15:00:00	SPY	ETF	93.3501	93.51	93.03	93.33	52011592.0
2009-07-15 16:00:00	SPY	ETF	93.32	93.4319	92.28	93.1	10237976.0
2009-07-15 17:00:00	SPY	ETF	93.11	93.23	93.11	93.19	550581.0
2009-07-15 18:00:00	SPY	ETF	93.18	93.19	92.82	92.91	852400.0
2009-07-15 19:00:00	SPY	ETF	92.88	92.96	92.76	92.9	121531.0
2009-07-15 04:00:00	QQQ	ETF	36.28	36.28	36.28	36.28	100.0
2009-07-15 06:00:00	QQQ	ETF	36.32	36.35	36.3	36.3	2500.0
2009-07-15 07:00:00	QQQ	ETF	36.29	36.32	36.18	36.25	413182.0
2009-07-15 08:00:00	QQQ	ETF	36.26	36.4	36.23	36.26	754421.0
2009-07-15 09:00:00	QQQ	ETF	36.26	36.55	36.14	36.41	35311001.0
2009-07-15 10:00:00	QQQ	ETF	36.41	36.61	36.41	36.57	20155686.0
2009-07-15 11:00:00	QQQ	ETF	36.57	36.74	36.57	36.651	21754975.0
2009-07-15 12:00:00	QQQ	ETF	36.66	36.73	36.64	36.68	10092940.0
2009-07-15 13:00:00	QQQ	ETF	36.68	36.81	36.64	36.77	10300862.0
2009-07-15 14:00:00	QQQ	ETF	36.76	36.9	36.72	36.89	16741102.0
2009-07-15 15:00:00	QQQ	ETF	36.9	36.93	36.69	36.89	26830464.0
2009-07-15 16:00:00	QQQ	ETF	36.89	36.93	35.7359	36.83	11791880.0
2009-07-15 17:00:00	QQQ	ETF	36.85	36.88	36.83	36.86	327988.0
2009-07-15 18:00:00	QQQ	ETF	36.83	36.92	35.74	36.78	196683.0
2009-07-15 19:00:00	QQQ	ETF	36.78	36.8	36.73	36.8	51964.0
2009-07-15 05:00:00	IWM	ETF	50.25	50.25	50.25	50.25	100.0
2009-07-15 06:00:00	IWM	ETF	50.33	50.33	50.33	50.33	3000.0
2009-07-15 07:00:00	IWM	ETF	50.31	50.34	50.2	50.24	14200.0
2009-07-15 08:00:00	IWM	ETF	50.25	50.4	50.25	50.31	86112.0
2009-07-15 09:00:00	IWM	ETF	50.31	50.82	50.26	50.7	6126036.0
2009-07-15 10:00:00	IWM	ETF	50.691	51.09	50.691	50.9	8038300.0
2009-07-15 11:00:00	IWM	ETF	50.9	51.17	50.88	51.05	4901209.0
2009-07-15 12:00:00	IWM	ETF	51.0592	51.19	51.02	51.12	3570830.0
2009-07-15 13:00:00	IWM	ETF	51.12	51.45	51.08	51.3301	4610286.0
2009-07-15 14:00:00	IWM	ETF	51.34	51.5	51.26	51.49	5901601.0
2009-07-15 15:00:00	IWM	ETF	51.49	51.62	50.65	51.44	11111456.0
2009-07-15 16:00:00	IWM	ETF	51.43	51.52	49.6536	51.32	8458714.0
2009-07-15 17:00:00	IWM	ETF	51.41	51.44	51.4	51.42	3372.0
2009-07-15 18:00:00	IWM	ETF	51.38	51.48	51.15	51.33	9594.0
2009-07-15 19:00:00	IWM	ETF	51.25	51.33	51.24	51.33	2700.0
2009-07-15 06:00:00	DIA	ETF	84.5	84.5	84.5	84.5	425.0
2009-07-15 07:00:00	DIA	ETF	84.43	84.45	84.28	84.31	1750.0
2009-07-15 08:00:00	DIA	ETF	84.44	84.62	84.41	84.5	55459.0
2009-07-15 09:00:00	DIA	ETF	84.51	85.1	84.51	85.01	1953788.0

> showing 50 of 4,356 rows — these rows as CSV

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