PREVIEW / etf_1hour / 2012-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-26.parquet
  size:    191 KB
  rows:    5,948

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-09-26 05:00:00	SPY	ETF	144.31	144.43	144.3	144.3	1600.0
2012-09-26 06:00:00	SPY	ETF	144.17	144.29	144.15	144.17	7400.0
2012-09-26 07:00:00	SPY	ETF	144.2	144.23	143.93	144.12	551342.0
2012-09-26 08:00:00	SPY	ETF	144.11	144.13	143.8	144.01	1206688.0
2012-09-26 09:00:00	SPY	ETF	144.01	144.19	143.56	143.76	18277780.0
2012-09-26 10:00:00	SPY	ETF	143.7601	143.83	142.95	143.065	28539028.0
2012-09-26 11:00:00	SPY	ETF	143.06	144.0839	143.05	143.45	25282086.0
2012-09-26 12:00:00	SPY	ETF	143.445	143.75	143.36	143.68	12585714.0
2012-09-26 13:00:00	SPY	ETF	143.68	144.0839	143.42	143.43	11218755.0
2012-09-26 14:00:00	SPY	ETF	143.42	143.78	143.41	143.54	11658043.0
2012-09-26 15:00:00	SPY	ETF	143.55	143.59	143.19	143.33	22534922.0
2012-09-26 16:00:00	SPY	ETF	143.32	144.1102	143.2	143.43	12317921.0
2012-09-26 17:00:00	SPY	ETF	143.47	143.51	143.44	143.51	952235.0
2012-09-26 18:00:00	SPY	ETF	143.51	143.58	143.48	143.5	80598.0
2012-09-26 19:00:00	SPY	ETF	143.52	143.61	143.45	143.48	139334.0
2012-09-26 04:00:00	QQQ	ETF	68.71	68.74	68.71	68.74	200.0
2012-09-26 06:00:00	QQQ	ETF	68.74	68.8	68.74	68.78	7200.0
2012-09-26 07:00:00	QQQ	ETF	68.78	68.78	68.62	68.68	134900.0
2012-09-26 08:00:00	QQQ	ETF	68.7	68.73	68.57	68.67	224042.0
2012-09-26 09:00:00	QQQ	ETF	68.67	68.71	68.37	68.44	4261072.0
2012-09-26 10:00:00	QQQ	ETF	68.44	68.47	67.85	67.9208	8384002.0
2012-09-26 11:00:00	QQQ	ETF	67.92	68.2088	67.92	68.15	4521226.0
2012-09-26 12:00:00	QQQ	ETF	68.14	68.29	68.06	68.21	3243604.0
2012-09-26 13:00:00	QQQ	ETF	68.21	68.4	68.15	68.1595	3145894.0
2012-09-26 14:00:00	QQQ	ETF	68.16	68.47	68.15	68.32	3366804.0
2012-09-26 15:00:00	QQQ	ETF	68.32	68.32	68.1	68.21	4394102.0
2012-09-26 16:00:00	QQQ	ETF	68.21	68.27	68.13	68.27	512815.0
2012-09-26 17:00:00	QQQ	ETF	68.26	68.28	68.1817	68.22	23034.0
2012-09-26 18:00:00	QQQ	ETF	68.28	68.33	68.28	68.28	17042.0
2012-09-26 19:00:00	QQQ	ETF	68.3	68.33	68.28	68.3	18528.0
2012-09-26 05:00:00	IWM	ETF	83.97	83.97	83.97	83.97	100.0
2012-09-26 06:00:00	IWM	ETF	83.96	83.99	83.9	83.92	8850.0
2012-09-26 07:00:00	IWM	ETF	83.91	83.95	83.79	83.83	30900.0
2012-09-26 08:00:00	IWM	ETF	83.83	83.94	83.68	83.79	126370.0
2012-09-26 09:00:00	IWM	ETF	83.8	83.93	83.59	83.6728	4815310.0
2012-09-26 10:00:00	IWM	ETF	83.67	83.74	82.9	82.93	8620762.0
2012-09-26 11:00:00	IWM	ETF	82.92	83.35	82.9	83.26	4290264.0
2012-09-26 12:00:00	IWM	ETF	83.26	83.45	83.14	83.31	2886391.0
2012-09-26 13:00:00	IWM	ETF	83.31	83.47	83.09	83.1	2496652.0
2012-09-26 14:00:00	IWM	ETF	83.09	83.43	83.05	83.16	3833942.0
2012-09-26 15:00:00	IWM	ETF	83.17	83.18	82.84	83.14	9244644.0
2012-09-26 16:00:00	IWM	ETF	83.14	83.14	82.9024	83.1	2649013.0
2012-09-26 17:00:00	IWM	ETF	83.06	83.11	83.06	83.1	56700.0
2012-09-26 18:00:00	IWM	ETF	83.13	83.18	83.08	83.08	2209.0
2012-09-26 19:00:00	IWM	ETF	83.16	83.16	83.11	83.12	3732.0
2012-09-26 07:00:00	DIA	ETF	134.36	134.36	134.36	134.36	100.0
2012-09-26 08:00:00	DIA	ETF	134.27	134.37	134.19	134.37	31928.0
2012-09-26 09:00:00	DIA	ETF	134.38	134.51	134.16	134.21	458411.0
2012-09-26 10:00:00	DIA	ETF	134.23	134.34	133.742	133.75	1685482.0
2012-09-26 11:00:00	DIA	ETF	133.76	134.22	133.76	134.11	785262.0

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

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