PREVIEW / etf_1hour / 2012-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-10.parquet
  size:    183 KB
  rows:    5,679

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
2012-10-10 04:00:00	SPY	ETF	144.23	144.23	144.07	144.2	4000.0
2012-10-10 05:00:00	SPY	ETF	144.15	144.15	143.83	143.89	138500.0
2012-10-10 06:00:00	SPY	ETF	143.99	144.11	143.99	144.08	23839.0
2012-10-10 07:00:00	SPY	ETF	144.06	144.29	144.05	144.25	146142.0
2012-10-10 08:00:00	SPY	ETF	144.25	144.32	144.0	144.12	529412.0
2012-10-10 09:00:00	SPY	ETF	144.12	144.27	143.77	143.9	13839063.0
2012-10-10 10:00:00	SPY	ETF	143.92	144.32	143.89	144.05	16652429.0
2012-10-10 11:00:00	SPY	ETF	144.05	144.12	143.51	143.635	13551425.0
2012-10-10 12:00:00	SPY	ETF	143.64	143.81	143.14	143.18	16792111.0
2012-10-10 13:00:00	SPY	ETF	143.18	143.49	143.1	143.26	17057204.0
2012-10-10 14:00:00	SPY	ETF	143.26	143.57	143.18	143.28	13150197.0
2012-10-10 15:00:00	SPY	ETF	143.28	143.5	143.09	143.33	22179515.0
2012-10-10 16:00:00	SPY	ETF	143.33	144.1946	142.74	142.95	6761370.0
2012-10-10 17:00:00	SPY	ETF	142.95	143.01	142.83	142.9	402895.0
2012-10-10 18:00:00	SPY	ETF	142.88	142.88	142.75	142.83	220404.0
2012-10-10 19:00:00	SPY	ETF	142.83	142.94	142.83	142.83	139412.0
2012-10-10 04:00:00	QQQ	ETF	67.21	67.21	67.15	67.15	300.0
2012-10-10 05:00:00	QQQ	ETF	67.01	67.02	67.01	67.02	300.0
2012-10-10 07:00:00	QQQ	ETF	67.1	67.26	67.1	67.25	75170.0
2012-10-10 08:00:00	QQQ	ETF	67.26	67.32	67.04	67.25	402052.0
2012-10-10 09:00:00	QQQ	ETF	67.25	67.36	67.04	67.23	4394000.0
2012-10-10 10:00:00	QQQ	ETF	67.23	67.43	67.18	67.2301	6321143.0
2012-10-10 11:00:00	QQQ	ETF	67.235	67.27	67.01	67.09	4869577.0
2012-10-10 12:00:00	QQQ	ETF	67.08	67.19	66.865	66.88	4758150.0
2012-10-10 13:00:00	QQQ	ETF	66.88	66.97	66.82	66.905	3325108.0
2012-10-10 14:00:00	QQQ	ETF	66.91	67.05	66.84	66.9	3321151.0
2012-10-10 15:00:00	QQQ	ETF	66.9	66.98	66.8	66.92	7283503.0
2012-10-10 16:00:00	QQQ	ETF	66.92	66.98	66.75	66.75	935385.0
2012-10-10 17:00:00	QQQ	ETF	66.83	66.95	66.81	66.81	14150.0
2012-10-10 18:00:00	QQQ	ETF	66.8	66.85	66.76	66.85	5537.0
2012-10-10 19:00:00	QQQ	ETF	66.85	66.86	66.81	66.84	13120.0
2012-10-10 07:00:00	IWM	ETF	82.53	82.62	82.5	82.59	46400.0
2012-10-10 08:00:00	IWM	ETF	82.66	82.7	82.54	82.58	54510.0
2012-10-10 09:00:00	IWM	ETF	82.59	82.77	82.36	82.48	3979411.0
2012-10-10 10:00:00	IWM	ETF	82.48	82.83	82.475	82.67	4924978.0
2012-10-10 11:00:00	IWM	ETF	82.67	82.73	82.3	82.38	3904001.0
2012-10-10 12:00:00	IWM	ETF	82.37	82.52	82.2	82.26	3998831.0
2012-10-10 13:00:00	IWM	ETF	82.27	82.57	82.18	82.3799	3582602.0
2012-10-10 14:00:00	IWM	ETF	82.38	82.56	82.23	82.32	2964264.0
2012-10-10 15:00:00	IWM	ETF	82.31	82.48	82.25	82.47	5472700.0
2012-10-10 16:00:00	IWM	ETF	82.46	82.51	82.17	82.24	1365482.0
2012-10-10 17:00:00	IWM	ETF	82.3	82.3	82.2	82.2	13700.0
2012-10-10 18:00:00	IWM	ETF	82.21	82.24	82.2	82.24	3157.0
2012-10-10 19:00:00	IWM	ETF	82.28	82.28	82.24	82.25	1628.0
2012-10-10 07:00:00	DIA	ETF	134.41	134.47	134.41	134.47	600.0
2012-10-10 08:00:00	DIA	ETF	134.46	134.52	134.29	134.38	10300.0
2012-10-10 09:00:00	DIA	ETF	134.38	134.46	133.91	134.05	738434.0
2012-10-10 10:00:00	DIA	ETF	134.04	134.36	134.04	134.0862	642310.0
2012-10-10 11:00:00	DIA	ETF	134.09	134.14	133.65	133.8	931063.0
2012-10-10 12:00:00	DIA	ETF	133.78	133.94	133.49	133.52	999477.0

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

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