PREVIEW / etf_1hour / 2012-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-25.parquet
  size:    187 KB
  rows:    5,802

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-25 04:00:00	SPY	ETF	141.76	142.03	141.76	141.93	3612.0
2012-10-25 05:00:00	SPY	ETF	141.97	142.06	141.86	141.86	60000.0
2012-10-25 06:00:00	SPY	ETF	141.87	141.94	141.75	141.84	144850.0
2012-10-25 07:00:00	SPY	ETF	141.86	142.02	141.83	141.91	379265.0
2012-10-25 08:00:00	SPY	ETF	141.92	142.24	141.75	141.91	1222808.0
2012-10-25 09:00:00	SPY	ETF	141.9	142.28	141.78	141.9	16330649.0
2012-10-25 10:00:00	SPY	ETF	141.89	142.01	141.18	141.4	19976514.0
2012-10-25 11:00:00	SPY	ETF	141.4	141.54	140.57	140.895	23405335.0
2012-10-25 12:00:00	SPY	ETF	140.89	141.29	140.71	141.2701	15392327.0
2012-10-25 13:00:00	SPY	ETF	141.275	141.46	141.135	141.355	10091041.0
2012-10-25 14:00:00	SPY	ETF	141.355	141.51	141.08	141.24	10762148.0
2012-10-25 15:00:00	SPY	ETF	141.235	141.43	141.04	141.42	19634061.0
2012-10-25 16:00:00	SPY	ETF	141.42	141.68	140.33	140.95	13042388.0
2012-10-25 17:00:00	SPY	ETF	141.26	141.38	140.89	141.16	1075241.0
2012-10-25 18:00:00	SPY	ETF	141.15	141.33	141.06	141.25	160484.0
2012-10-25 19:00:00	SPY	ETF	141.28	141.31	141.04	141.27	129203.0
2012-10-25 04:00:00	QQQ	ETF	65.5	65.65	65.5	65.57	1600.0
2012-10-25 06:00:00	QQQ	ETF	65.57	65.6	65.54	65.56	700.0
2012-10-25 07:00:00	QQQ	ETF	65.59	65.68	65.58	65.64	53863.0
2012-10-25 08:00:00	QQQ	ETF	65.64	65.65	65.53	65.6	301510.0
2012-10-25 09:00:00	QQQ	ETF	65.61	65.72	65.41	65.46	4890860.0
2012-10-25 10:00:00	QQQ	ETF	65.46	65.65	65.21	65.3	4876178.0
2012-10-25 11:00:00	QQQ	ETF	65.29	65.38	64.97	65.12	4874971.0
2012-10-25 12:00:00	QQQ	ETF	65.1101	65.2	64.97	65.2	2801412.0
2012-10-25 13:00:00	QQQ	ETF	65.2	65.31	65.1	65.27	2060607.0
2012-10-25 14:00:00	QQQ	ETF	65.2764	65.34	65.1	65.22	3829025.0
2012-10-25 15:00:00	QQQ	ETF	65.215	65.25	65.04	65.16	6128559.0
2012-10-25 16:00:00	QQQ	ETF	65.16	65.3	64.0	64.87	16626714.0
2012-10-25 17:00:00	QQQ	ETF	64.87	64.99	64.63	64.93	3160832.0
2012-10-25 18:00:00	QQQ	ETF	64.92	65.11	64.9	65.11	162827.0
2012-10-25 19:00:00	QQQ	ETF	65.1	65.13	65.03	65.05	286850.0
2012-10-25 04:00:00	IWM	ETF	81.82	81.82	81.82	81.82	900.0
2012-10-25 06:00:00	IWM	ETF	81.64	81.65	81.62	81.62	400.0
2012-10-25 07:00:00	IWM	ETF	81.68	81.76	81.67	81.73	52761.0
2012-10-25 08:00:00	IWM	ETF	81.72	81.99	81.14	81.74	147626.0
2012-10-25 09:00:00	IWM	ETF	81.72	82.14	81.56	81.63	4666752.0
2012-10-25 10:00:00	IWM	ETF	81.62	81.67	81.01	81.24	5586108.0
2012-10-25 11:00:00	IWM	ETF	81.24	81.36	80.87	81.04	3414493.0
2012-10-25 12:00:00	IWM	ETF	81.04	81.28	80.89	81.26	2215040.0
2012-10-25 13:00:00	IWM	ETF	81.27	81.44	81.17	81.37	2157539.0
2012-10-25 14:00:00	IWM	ETF	81.37	81.5	81.19	81.34	2255633.0
2012-10-25 15:00:00	IWM	ETF	81.33	81.49	81.14	81.48	4129870.0
2012-10-25 16:00:00	IWM	ETF	81.49	81.65	80.97	81.47	1421877.0
2012-10-25 17:00:00	IWM	ETF	81.5	81.54	81.26	81.39	29990.0
2012-10-25 18:00:00	IWM	ETF	81.4	81.43	81.38	81.38	500.0
2012-10-25 19:00:00	IWM	ETF	81.35	81.35	81.35	81.35	2000.0
2012-10-25 06:00:00	DIA	ETF	131.0	131.04	131.0	131.04	1500.0
2012-10-25 07:00:00	DIA	ETF	131.05	131.2	131.05	131.18	23500.0
2012-10-25 08:00:00	DIA	ETF	131.16	131.52	131.01	131.18	39552.0
2012-10-25 09:00:00	DIA	ETF	131.17	131.35	131.06	131.22	1251698.0

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

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