PREVIEW / etf_1hour / 2010-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-29.parquet
  size:    171 KB
  rows:    5,223

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
2010-06-29 04:00:00	SPY	ETF	106.23	106.27	106.08	106.26	12736.0
2010-06-29 05:00:00	SPY	ETF	106.24	106.36	106.1	106.17	44575.0
2010-06-29 06:00:00	SPY	ETF	106.31	106.45	106.21	106.4	217050.0
2010-06-29 07:00:00	SPY	ETF	106.4	106.44	106.0	106.2	805249.0
2010-06-29 08:00:00	SPY	ETF	106.2	106.59	106.05	106.15	2242537.0
2010-06-29 09:00:00	SPY	ETF	106.15	106.32	105.15	105.35	42320005.0
2010-06-29 10:00:00	SPY	ETF	105.46	105.47	104.27	104.97	70230023.0
2010-06-29 11:00:00	SPY	ETF	104.98	105.72	104.64	104.67	32619233.0
2010-06-29 12:00:00	SPY	ETF	104.67	104.94	104.43	104.64	28908535.0
2010-06-29 13:00:00	SPY	ETF	104.64	104.7	104.12	104.615	29589676.0
2010-06-29 14:00:00	SPY	ETF	104.61	104.9	104.33	104.38	37284007.0
2010-06-29 15:00:00	SPY	ETF	104.38	104.71	103.55	104.22	98023893.0
2010-06-29 16:00:00	SPY	ETF	104.21	107.5114	103.9	103.93	26445674.0
2010-06-29 17:00:00	SPY	ETF	103.93	104.2	103.81	103.96	514458.0
2010-06-29 18:00:00	SPY	ETF	103.93	104.2	103.79	104.02	316824.0
2010-06-29 19:00:00	SPY	ETF	104.02	104.1	103.89	104.08	146112.0
2010-06-29 04:00:00	QQQ	ETF	44.55	44.55	44.43	44.45	8611.0
2010-06-29 05:00:00	QQQ	ETF	44.52	44.52	44.49	44.51	15600.0
2010-06-29 06:00:00	QQQ	ETF	44.6	44.6	44.6	44.6	100.0
2010-06-29 07:00:00	QQQ	ETF	44.6	44.6	44.42	44.53	204228.0
2010-06-29 08:00:00	QQQ	ETF	44.52	44.58	44.47	44.48	592278.0
2010-06-29 09:00:00	QQQ	ETF	44.48	44.53	43.81	43.9	17621989.0
2010-06-29 10:00:00	QQQ	ETF	43.9	43.98	43.45	43.83	31287914.0
2010-06-29 11:00:00	QQQ	ETF	43.83	43.98	43.67	43.7	11833151.0
2010-06-29 12:00:00	QQQ	ETF	43.7	43.83	43.61	43.65	6310196.0
2010-06-29 13:00:00	QQQ	ETF	43.66	43.69	43.47	43.6499	7433012.0
2010-06-29 14:00:00	QQQ	ETF	43.64	43.79	43.5	43.56	15278305.0
2010-06-29 15:00:00	QQQ	ETF	43.56	43.72	43.07	43.4	33367293.0
2010-06-29 16:00:00	QQQ	ETF	43.39	45.1283	43.09	43.36	6675299.0
2010-06-29 17:00:00	QQQ	ETF	43.36	43.41	43.32	43.32	156770.0
2010-06-29 18:00:00	QQQ	ETF	43.35	43.38	43.31	43.37	34684.0
2010-06-29 19:00:00	QQQ	ETF	43.38	43.42	43.35	43.39	40997.0
2010-06-29 04:00:00	IWM	ETF	63.36	63.36	63.34	63.35	1242.0
2010-06-29 05:00:00	IWM	ETF	63.33	63.33	63.33	63.33	200.0
2010-06-29 06:00:00	IWM	ETF	63.33	63.37	63.33	63.37	1000.0
2010-06-29 07:00:00	IWM	ETF	63.43	63.46	63.19	63.29	191549.0
2010-06-29 08:00:00	IWM	ETF	63.34	63.8	63.23	63.27	385169.0
2010-06-29 09:00:00	IWM	ETF	63.34	63.39	62.51	62.81	10405735.0
2010-06-29 10:00:00	IWM	ETF	62.81	62.82	62.1	62.73	18952197.0
2010-06-29 11:00:00	IWM	ETF	62.74	62.93	62.3	62.4301	9729488.0
2010-06-29 12:00:00	IWM	ETF	62.44	62.58	62.26	62.33	8293212.0
2010-06-29 13:00:00	IWM	ETF	62.339	62.4	61.95	62.13	8162888.0
2010-06-29 14:00:00	IWM	ETF	62.12	62.4	61.88	61.905	11678360.0
2010-06-29 15:00:00	IWM	ETF	61.91	62.13	61.38	61.82	28839215.0
2010-06-29 16:00:00	IWM	ETF	61.82	64.3248	61.6	61.68	5253603.0
2010-06-29 17:00:00	IWM	ETF	61.65	61.67	61.61	61.67	3800.0
2010-06-29 18:00:00	IWM	ETF	61.69	64.3248	61.62	61.73	2012154.0
2010-06-29 19:00:00	IWM	ETF	61.75	61.76	61.65	61.67	3295.0
2010-06-29 04:00:00	DIA	ETF	100.7	100.7	100.7	100.7	100.0
2010-06-29 06:00:00	DIA	ETF	100.37	100.44	100.37	100.44	200.0

> showing 50 of 5,223 rows — these rows as CSV

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