PREVIEW / etf_1hour / 2011-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-09.parquet
  size:    180 KB
  rows:    5,587

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
2011-09-09 04:00:00	SPY	ETF	119.2	119.2	118.7	118.82	3519.0
2011-09-09 05:00:00	SPY	ETF	118.95	119.07	118.59	118.65	61600.0
2011-09-09 06:00:00	SPY	ETF	118.59	118.97	118.4	118.5	126667.0
2011-09-09 07:00:00	SPY	ETF	118.51	118.75	118.32	118.6	539411.0
2011-09-09 08:00:00	SPY	ETF	118.6	119.5	118.5	118.6	2790115.0
2011-09-09 09:00:00	SPY	ETF	118.59	118.6	116.98	117.36	44872956.0
2011-09-09 10:00:00	SPY	ETF	117.36	118.07	117.15	117.645	37313736.0
2011-09-09 11:00:00	SPY	ETF	117.65	118.1	115.85	116.09	65422987.0
2011-09-09 12:00:00	SPY	ETF	116.0895	116.36	115.52	116.269	44980847.0
2011-09-09 13:00:00	SPY	ETF	116.28	116.66	115.75	115.9	30397453.0
2011-09-09 14:00:00	SPY	ETF	115.8999	116.16	115.35	115.489	43402128.0
2011-09-09 15:00:00	SPY	ETF	115.48	119.057	115.28	115.89	73639564.0
2011-09-09 16:00:00	SPY	ETF	115.92	119.057	115.5	116.39	30655285.0
2011-09-09 17:00:00	SPY	ETF	116.37	116.39	116.16	116.2	2457563.0
2011-09-09 18:00:00	SPY	ETF	116.17	116.21	115.86	116.05	258215.0
2011-09-09 19:00:00	SPY	ETF	116.08	116.25	116.06	116.2	97122.0
2011-09-09 04:00:00	QQQ	ETF	54.2	54.2	54.2	54.2	100.0
2011-09-09 05:00:00	QQQ	ETF	54.3	54.3	54.3	54.3	500.0
2011-09-09 06:00:00	QQQ	ETF	54.18	54.23	54.18	54.23	5500.0
2011-09-09 07:00:00	QQQ	ETF	54.2	54.3	54.08	54.26	29015.0
2011-09-09 08:00:00	QQQ	ETF	54.25	54.46	54.22	54.3	779726.0
2011-09-09 09:00:00	QQQ	ETF	54.29	54.29	53.69	53.83	7580860.0
2011-09-09 10:00:00	QQQ	ETF	53.83	54.2399	53.77	54.0501	7710142.0
2011-09-09 11:00:00	QQQ	ETF	54.05	54.21	53.15	53.27	10977552.0
2011-09-09 12:00:00	QQQ	ETF	53.28	53.8367	53.0	53.37	9269603.0
2011-09-09 13:00:00	QQQ	ETF	53.37	53.5	53.07	53.1	5009025.0
2011-09-09 14:00:00	QQQ	ETF	53.12	53.25	52.88	52.94	5911361.0
2011-09-09 15:00:00	QQQ	ETF	52.945	53.33	52.85	53.17	11932794.0
2011-09-09 16:00:00	QQQ	ETF	53.18	53.38	53.14	53.31	1700140.0
2011-09-09 17:00:00	QQQ	ETF	53.31	53.31	53.21	53.21	22522.0
2011-09-09 18:00:00	QQQ	ETF	53.2	53.28	53.18	53.28	28881.0
2011-09-09 19:00:00	QQQ	ETF	53.23	53.27	53.12	53.12	14340.0
2011-09-09 04:00:00	IWM	ETF	69.59	69.59	69.59	69.59	192.0
2011-09-09 05:00:00	IWM	ETF	69.57	69.57	69.57	69.57	100.0
2011-09-09 06:00:00	IWM	ETF	69.18	69.3	69.16	69.27	4700.0
2011-09-09 07:00:00	IWM	ETF	69.09	69.37	69.09	69.3	93569.0
2011-09-09 08:00:00	IWM	ETF	69.3	69.68	69.29	69.36	532681.0
2011-09-09 09:00:00	IWM	ETF	69.36	69.36	67.87	68.58	14679716.0
2011-09-09 10:00:00	IWM	ETF	68.58	69.12	68.26	68.71	8999970.0
2011-09-09 11:00:00	IWM	ETF	68.71	69.13	67.45	67.72	13007733.0
2011-09-09 12:00:00	IWM	ETF	67.72	67.9	67.13	67.83	10452015.0
2011-09-09 13:00:00	IWM	ETF	67.84	68.1	67.27	67.36	6847480.0
2011-09-09 14:00:00	IWM	ETF	67.35	67.488	66.75	66.91	11805727.0
2011-09-09 15:00:00	IWM	ETF	66.91	67.72	66.78	67.5	17242346.0
2011-09-09 16:00:00	IWM	ETF	67.5	69.5392	67.48	67.65	4001860.0
2011-09-09 17:00:00	IWM	ETF	67.64	67.66	67.5	67.5	22955.0
2011-09-09 18:00:00	IWM	ETF	67.58	67.58	67.55	67.55	2150.0
2011-09-09 19:00:00	IWM	ETF	67.51	67.59	67.5	67.53	1790.0
2011-09-09 06:00:00	DIA	ETF	112.1	112.1	112.1	112.1	4000.0
2011-09-09 07:00:00	DIA	ETF	112.57	112.57	112.57	112.57	171.0

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

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