PREVIEW / etf_1hour / 2012-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-07.parquet
  size:    187 KB
  rows:    5,798

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-02-07 04:00:00	SPY	ETF	134.25	134.37	134.16	134.37	15500.0
2012-02-07 05:00:00	SPY	ETF	134.39	134.39	134.18	134.18	11090.0
2012-02-07 06:00:00	SPY	ETF	134.2	134.24	134.01	134.01	123650.0
2012-02-07 07:00:00	SPY	ETF	134.0	134.0	133.77	133.91	311287.0
2012-02-07 08:00:00	SPY	ETF	133.93	134.28	133.84	134.09	1563089.0
2012-02-07 09:00:00	SPY	ETF	134.08	134.29	133.78	133.93	18108319.0
2012-02-07 10:00:00	SPY	ETF	133.93	134.59	133.64	134.56	25944128.0
2012-02-07 11:00:00	SPY	ETF	134.5675	134.82	134.53	134.66	20716059.0
2012-02-07 12:00:00	SPY	ETF	134.66	134.8	134.65	134.79	7661262.0
2012-02-07 13:00:00	SPY	ETF	134.78	134.89	134.61	134.8126	13735234.0
2012-02-07 14:00:00	SPY	ETF	134.82	134.85	134.55	134.59	10104954.0
2012-02-07 15:00:00	SPY	ETF	134.59	135.02	134.59	134.78	26270838.0
2012-02-07 16:00:00	SPY	ETF	134.77	134.94	134.6	134.89	9983678.0
2012-02-07 17:00:00	SPY	ETF	134.88	134.9	134.1	134.83	494992.0
2012-02-07 18:00:00	SPY	ETF	134.8	134.86	134.72	134.73	153495.0
2012-02-07 19:00:00	SPY	ETF	134.73	134.85	134.72	134.85	113475.0
2012-02-07 04:00:00	QQQ	ETF	61.94	61.96	61.94	61.96	200.0
2012-02-07 06:00:00	QQQ	ETF	61.96	61.98	61.88	61.88	85779.0
2012-02-07 07:00:00	QQQ	ETF	61.85	61.86	61.77	61.8	20744.0
2012-02-07 08:00:00	QQQ	ETF	61.82	61.95	61.78	61.9	144387.0
2012-02-07 09:00:00	QQQ	ETF	61.9	62.01	61.7293	61.86	7372111.0
2012-02-07 10:00:00	QQQ	ETF	61.85	62.13	61.67	62.11	6053413.0
2012-02-07 11:00:00	QQQ	ETF	62.12	62.24	62.09	62.16	5792884.0
2012-02-07 12:00:00	QQQ	ETF	62.16	62.25	62.15	62.21	2388747.0
2012-02-07 13:00:00	QQQ	ETF	62.21	62.23	62.06	62.1496	3707168.0
2012-02-07 14:00:00	QQQ	ETF	62.15	62.162	62.02	62.04	3338583.0
2012-02-07 15:00:00	QQQ	ETF	62.04	62.2	62.02	62.12	7694467.0
2012-02-07 16:00:00	QQQ	ETF	62.12	62.1701	62.07	62.1	886646.0
2012-02-07 17:00:00	QQQ	ETF	62.1	62.12	62.06	62.1	16436.0
2012-02-07 18:00:00	QQQ	ETF	62.1	62.1	62.05	62.08	25619.0
2012-02-07 19:00:00	QQQ	ETF	62.12	62.12	62.06	62.09	19200.0
2012-02-07 06:00:00	IWM	ETF	82.3	82.3	82.3	82.3	100.0
2012-02-07 07:00:00	IWM	ETF	82.15	82.4	82.13	82.37	16500.0
2012-02-07 08:00:00	IWM	ETF	82.32	82.6	82.25	82.48	338800.0
2012-02-07 09:00:00	IWM	ETF	82.45	82.67	82.22	82.35	4768790.0
2012-02-07 10:00:00	IWM	ETF	82.35	82.75	82.08	82.74	8957941.0
2012-02-07 11:00:00	IWM	ETF	82.74	82.99	82.65	82.72	6323395.0
2012-02-07 12:00:00	IWM	ETF	82.72	82.77	82.53	82.75	2689242.0
2012-02-07 13:00:00	IWM	ETF	82.75	82.81	82.5	82.71	2471359.0
2012-02-07 14:00:00	IWM	ETF	82.7	82.79	82.39	82.45	3305900.0
2012-02-07 15:00:00	IWM	ETF	82.45	82.78	82.45	82.6	7955430.0
2012-02-07 16:00:00	IWM	ETF	82.6	82.8	82.5869	82.77	692414.0
2012-02-07 17:00:00	IWM	ETF	82.77	82.79	82.6055	82.72	74790.0
2012-02-07 19:00:00	IWM	ETF	82.69	82.73	82.69	82.73	300.0
2012-02-07 07:00:00	DIA	ETF	127.82	127.83	127.72	127.83	1400.0
2012-02-07 08:00:00	DIA	ETF	127.75	128.03	127.75	127.83	14120.0
2012-02-07 09:00:00	DIA	ETF	127.92	128.04	127.58	127.73	411811.0
2012-02-07 10:00:00	DIA	ETF	127.72	128.41	127.55	128.38	1190692.0
2012-02-07 11:00:00	DIA	ETF	128.3899	128.58	128.37	128.45	960844.0
2012-02-07 12:00:00	DIA	ETF	128.45	128.5799	128.43	128.56	355562.0

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

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