PREVIEW / etf_1hour / 2011-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-23.parquet
  size:    177 KB
  rows:    5,364

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-03-23 04:00:00	SPY	ETF	128.95	129.14	128.91	128.99	3140.0
2011-03-23 05:00:00	SPY	ETF	128.93	129.71	128.93	129.71	2200.0
2011-03-23 06:00:00	SPY	ETF	129.64	129.7	129.58	129.62	56378.0
2011-03-23 07:00:00	SPY	ETF	129.6	129.66	128.95	129.03	1211218.0
2011-03-23 08:00:00	SPY	ETF	129.03	129.415	128.85	128.94	2145906.0
2011-03-23 09:00:00	SPY	ETF	128.93	129.11	128.56	128.88	16391069.0
2011-03-23 10:00:00	SPY	ETF	128.86	128.87	128.32	128.535	23961718.0
2011-03-23 11:00:00	SPY	ETF	128.53	129.3045	128.53	128.81	18511923.0
2011-03-23 12:00:00	SPY	ETF	128.81	129.3	128.72	129.19	15073905.0
2011-03-23 13:00:00	SPY	ETF	129.18	129.57	129.08	129.445	18657083.0
2011-03-23 14:00:00	SPY	ETF	129.45	129.87	129.33	129.77	15205430.0
2011-03-23 15:00:00	SPY	ETF	129.78	130.0	129.65	129.66	27930575.0
2011-03-23 16:00:00	SPY	ETF	129.66	129.8104	128.4175	129.57	7453174.0
2011-03-23 17:00:00	SPY	ETF	129.56	129.57	129.39	129.46	183198.0
2011-03-23 18:00:00	SPY	ETF	129.42	129.68	129.38	129.6	362841.0
2011-03-23 19:00:00	SPY	ETF	129.59	129.73	129.57	129.66	94549.0
2011-03-23 06:00:00	QQQ	ETF	55.5	55.5	55.45	55.48	300.0
2011-03-23 07:00:00	QQQ	ETF	55.48	55.51	55.19	55.23	338261.0
2011-03-23 08:00:00	QQQ	ETF	55.21	55.4	55.2	55.21	1238738.0
2011-03-23 09:00:00	QQQ	ETF	55.2	55.29	55.0	55.15	9314193.0
2011-03-23 10:00:00	QQQ	ETF	55.11	55.16	54.82	55.0	13622362.0
2011-03-23 11:00:00	QQQ	ETF	55.01	55.38	55.01	55.2722	5299394.0
2011-03-23 12:00:00	QQQ	ETF	55.28	55.57	55.25	55.45	4542852.0
2011-03-23 13:00:00	QQQ	ETF	55.45	55.59	55.39	55.5299	4290619.0
2011-03-23 14:00:00	QQQ	ETF	55.53	55.82	55.45	55.7601	6642465.0
2011-03-23 15:00:00	QQQ	ETF	55.77	55.87	55.7	55.71	8232941.0
2011-03-23 16:00:00	QQQ	ETF	55.71	55.7804	55.4021	55.65	2770042.0
2011-03-23 17:00:00	QQQ	ETF	55.61	55.64	55.57	55.64	32559.0
2011-03-23 18:00:00	QQQ	ETF	55.61	55.71	55.61	55.65	71110.0
2011-03-23 19:00:00	QQQ	ETF	55.64	55.69	55.64	55.66	13841.0
2011-03-23 04:00:00	IWM	ETF	80.53	80.64	80.53	80.64	900.0
2011-03-23 05:00:00	IWM	ETF	80.67	80.67	80.67	80.67	1500.0
2011-03-23 06:00:00	IWM	ETF	81.16	81.18	81.15	81.18	2000.0
2011-03-23 07:00:00	IWM	ETF	81.16	81.16	80.72	80.77	34200.0
2011-03-23 08:00:00	IWM	ETF	80.75	81.33	80.71	80.72	260098.0
2011-03-23 09:00:00	IWM	ETF	80.72	80.8	80.11	80.43	7026177.0
2011-03-23 10:00:00	IWM	ETF	80.42	80.45	79.85	79.93	7091578.0
2011-03-23 11:00:00	IWM	ETF	79.94	80.69	79.93	80.55	6867440.0
2011-03-23 12:00:00	IWM	ETF	80.56	80.94	80.51	80.8	3652436.0
2011-03-23 13:00:00	IWM	ETF	80.8	81.1	80.71	80.98	4799706.0
2011-03-23 14:00:00	IWM	ETF	80.98	81.32	80.9	81.25	4808114.0
2011-03-23 15:00:00	IWM	ETF	81.25	81.36	81.1	81.1	9208364.0
2011-03-23 16:00:00	IWM	ETF	81.11	81.22	80.52	81.04	3163934.0
2011-03-23 17:00:00	IWM	ETF	81.04	81.04	80.93	80.98	87757.0
2011-03-23 18:00:00	IWM	ETF	80.98	81.02	80.96	81.0	22900.0
2011-03-23 19:00:00	IWM	ETF	81.0	81.09	80.99	81.0	28332.0
2011-03-23 04:00:00	DIA	ETF	119.64	119.64	119.62	119.62	1400.0
2011-03-23 05:00:00	DIA	ETF	120.27	120.29	120.27	120.29	800.0
2011-03-23 06:00:00	DIA	ETF	120.16	120.22	120.16	120.22	700.0
2011-03-23 07:00:00	DIA	ETF	120.01	120.01	119.83	119.83	1500.0

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

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