PREVIEW / etf_1hour / 2011-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-25.parquet
  size:    178 KB
  rows:    5,460

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
2011-02-25 04:00:00	SPY	ETF	131.25	131.44	131.2	131.41	24567.0
2011-02-25 05:00:00	SPY	ETF	131.45	131.5	131.39	131.39	15900.0
2011-02-25 06:00:00	SPY	ETF	131.44	131.61	131.36	131.5	16912.0
2011-02-25 07:00:00	SPY	ETF	131.53	131.72	131.42	131.44	552264.0
2011-02-25 08:00:00	SPY	ETF	131.46	131.65	131.34	131.58	2134274.0
2011-02-25 09:00:00	SPY	ETF	131.58	131.93	131.39	131.92	20280459.0
2011-02-25 10:00:00	SPY	ETF	131.91	132.22	131.89	132.12	22182802.0
2011-02-25 11:00:00	SPY	ETF	132.11	132.18	131.66	131.86	20001331.0
2011-02-25 12:00:00	SPY	ETF	131.85	132.17	131.815	132.14	10121816.0
2011-02-25 13:00:00	SPY	ETF	132.13	132.38	132.09	132.25	13481923.0
2011-02-25 14:00:00	SPY	ETF	132.25	132.41	132.15	132.32	12844033.0
2011-02-25 15:00:00	SPY	ETF	132.32	132.37	132.14	132.32	27108849.0
2011-02-25 16:00:00	SPY	ETF	132.32	132.33	130.9435	132.12	11906902.0
2011-02-25 17:00:00	SPY	ETF	132.13	132.34	132.09	132.29	248872.0
2011-02-25 18:00:00	SPY	ETF	132.29	132.32	132.07	132.15	176568.0
2011-02-25 19:00:00	SPY	ETF	132.16	132.28	132.16	132.28	29394.0
2011-02-25 04:00:00	QQQ	ETF	57.02	57.11	57.01	57.1	42049.0
2011-02-25 05:00:00	QQQ	ETF	57.08	57.12	57.08	57.12	1000.0
2011-02-25 06:00:00	QQQ	ETF	57.1	57.16	57.1	57.15	6200.0
2011-02-25 07:00:00	QQQ	ETF	57.12	57.2	57.12	57.13	169333.0
2011-02-25 08:00:00	QQQ	ETF	57.13	57.21	57.06	57.2	670980.0
2011-02-25 09:00:00	QQQ	ETF	57.2	57.44	57.12	57.41	9429309.0
2011-02-25 10:00:00	QQQ	ETF	57.42	57.69	57.38	57.65	10174411.0
2011-02-25 11:00:00	QQQ	ETF	57.6582	57.72	57.363	57.4698	11119340.0
2011-02-25 12:00:00	QQQ	ETF	57.46	57.64	57.4375	57.61	3658856.0
2011-02-25 13:00:00	QQQ	ETF	57.61	57.72	57.57	57.67	4250430.0
2011-02-25 14:00:00	QQQ	ETF	57.66	57.72	57.58	57.6501	3213208.0
2011-02-25 15:00:00	QQQ	ETF	57.65	57.68	57.6	57.64	6132136.0
2011-02-25 16:00:00	QQQ	ETF	57.64	57.68	56.8287	57.65	2608952.0
2011-02-25 17:00:00	QQQ	ETF	57.66	57.69	57.61	57.68	94397.0
2011-02-25 18:00:00	QQQ	ETF	57.68	57.69	57.64	57.64	30759.0
2011-02-25 19:00:00	QQQ	ETF	57.66	57.69	57.65	57.69	5700.0
2011-02-25 04:00:00	IWM	ETF	80.52	80.61	80.52	80.61	200.0
2011-02-25 05:00:00	IWM	ETF	80.59	80.6	80.59	80.6	15000.0
2011-02-25 06:00:00	IWM	ETF	80.64	80.77	80.61	80.75	4540.0
2011-02-25 07:00:00	IWM	ETF	80.74	80.84	80.65	80.65	62995.0
2011-02-25 08:00:00	IWM	ETF	80.67	80.8	80.5	80.71	478228.0
2011-02-25 09:00:00	IWM	ETF	80.7	81.06	80.58	80.94	5659428.0
2011-02-25 10:00:00	IWM	ETF	80.94	81.51	80.91	81.42	8506083.0
2011-02-25 11:00:00	IWM	ETF	81.43	81.63	81.02	81.23	6442596.0
2011-02-25 12:00:00	IWM	ETF	81.225	81.648	81.185	81.53	4525414.0
2011-02-25 13:00:00	IWM	ETF	81.54	81.885	81.47	81.72	4442525.0
2011-02-25 14:00:00	IWM	ETF	81.72	81.87	81.62	81.8619	3584133.0
2011-02-25 15:00:00	IWM	ETF	81.87	82.19	81.74	82.18	9670205.0
2011-02-25 16:00:00	IWM	ETF	82.17	82.25	80.65	82.16	2083814.0
2011-02-25 17:00:00	IWM	ETF	82.16	82.19	82.14	82.14	577.0
2011-02-25 18:00:00	IWM	ETF	82.16	82.17	82.15	82.17	12132.0
2011-02-25 19:00:00	IWM	ETF	82.18	82.18	82.13	82.13	1100.0
2011-02-25 07:00:00	DIA	ETF	120.95	121.09	120.92	120.92	10926.0
2011-02-25 08:00:00	DIA	ETF	120.93	121.1	120.89	121.02	52110.0

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

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