PREVIEW / etf_1hour / 2012-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-14.parquet
  size:    184 KB
  rows:    5,831

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-12-14 04:00:00	SPY	ETF	142.81	142.94	142.8	142.87	34402.0
2012-12-14 05:00:00	SPY	ETF	142.81	142.81	142.81	142.81	100.0
2012-12-14 06:00:00	SPY	ETF	142.91	142.94	142.83	142.93	22635.0
2012-12-14 07:00:00	SPY	ETF	142.9	142.92	142.6	142.6	259134.0
2012-12-14 08:00:00	SPY	ETF	142.62	142.9	142.32	142.46	2057156.0
2012-12-14 09:00:00	SPY	ETF	142.47	142.85	142.11	142.25	13002190.0
2012-12-14 10:00:00	SPY	ETF	142.25	142.53	142.14	142.35	20921025.0
2012-12-14 11:00:00	SPY	ETF	142.3501	142.425	142.02	142.23	15853363.0
2012-12-14 12:00:00	SPY	ETF	142.23	142.48	142.21	142.35	11109430.0
2012-12-14 13:00:00	SPY	ETF	142.35	142.44	142.21	142.42	7223800.0
2012-12-14 14:00:00	SPY	ETF	142.41	142.49	141.99	142.03	9430461.0
2012-12-14 15:00:00	SPY	ETF	142.031	142.25	141.88	142.11	28587937.0
2012-12-14 16:00:00	SPY	ETF	142.1	142.34	141.9723	142.33	23701940.0
2012-12-14 17:00:00	SPY	ETF	142.31	142.54	142.13	142.14	454945.0
2012-12-14 18:00:00	SPY	ETF	142.14	142.19	142.12	142.16	26890.0
2012-12-14 19:00:00	SPY	ETF	142.15	142.19	142.12	142.15	24415.0
2012-12-14 05:00:00	QQQ	ETF	65.33	65.33	65.33	65.33	900.0
2012-12-14 06:00:00	QQQ	ETF	65.33	65.36	65.33	65.36	200.0
2012-12-14 07:00:00	QQQ	ETF	65.34	65.34	65.14	65.14	137200.0
2012-12-14 08:00:00	QQQ	ETF	65.15	65.34	64.96	64.99	247961.0
2012-12-14 09:00:00	QQQ	ETF	65.0	65.08	64.66	64.83	7087540.0
2012-12-14 10:00:00	QQQ	ETF	64.82	64.96	64.74	64.86	7572278.0
2012-12-14 11:00:00	QQQ	ETF	64.86	64.88	64.7	64.81	5166572.0
2012-12-14 12:00:00	QQQ	ETF	64.82	64.99	64.815	64.91	3394937.0
2012-12-14 13:00:00	QQQ	ETF	64.9001	64.93	64.765	64.87	2379872.0
2012-12-14 14:00:00	QQQ	ETF	64.865	64.88	64.48	64.5	3752477.0
2012-12-14 15:00:00	QQQ	ETF	64.5	64.72	64.47	64.7	8483244.0
2012-12-14 16:00:00	QQQ	ETF	64.71	64.78	64.561	64.75	1123737.0
2012-12-14 17:00:00	QQQ	ETF	64.74	64.75	64.7	64.7	6277.0
2012-12-14 18:00:00	QQQ	ETF	64.7	64.74	64.7	64.7	11443.0
2012-12-14 19:00:00	QQQ	ETF	64.64	64.7	64.64	64.64	3100.0
2012-12-14 07:00:00	IWM	ETF	82.65	82.71	82.52	82.52	50675.0
2012-12-14 08:00:00	IWM	ETF	82.51	82.55	82.27	82.35	149934.0
2012-12-14 09:00:00	IWM	ETF	82.34	82.65	82.08	82.31	4334254.0
2012-12-14 10:00:00	IWM	ETF	82.31	82.68	82.23	82.56	4456619.0
2012-12-14 11:00:00	IWM	ETF	82.56	82.59	82.39	82.55	2778881.0
2012-12-14 12:00:00	IWM	ETF	82.55	82.81	82.541	82.66	3263210.0
2012-12-14 13:00:00	IWM	ETF	82.66	82.68	82.46	82.57	1229612.0
2012-12-14 14:00:00	IWM	ETF	82.58	82.58	82.25	82.3	2145452.0
2012-12-14 15:00:00	IWM	ETF	82.3	82.46	82.12	82.46	5763427.0
2012-12-14 16:00:00	IWM	ETF	82.45	82.7	82.294	82.65	1332739.0
2012-12-14 17:00:00	IWM	ETF	82.63	82.67	82.63	82.64	21513.0
2012-12-14 18:00:00	IWM	ETF	82.6	82.6	82.6	82.6	100.0
2012-12-14 19:00:00	IWM	ETF	82.59	82.59	82.53	82.55	5064.0
2012-12-14 07:00:00	DIA	ETF	132.04	132.04	131.92	131.92	754.0
2012-12-14 08:00:00	DIA	ETF	131.83	131.93	131.65	131.7	5000.0
2012-12-14 09:00:00	DIA	ETF	131.8	131.95	131.65	131.69	499582.0
2012-12-14 10:00:00	DIA	ETF	131.69	132.0	131.6501	131.84	513810.0
2012-12-14 11:00:00	DIA	ETF	131.83	131.91	131.46	131.61	340210.0
2012-12-14 12:00:00	DIA	ETF	131.62	131.82	131.6	131.693	244078.0

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

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