PREVIEW / etf_1hour / 2013-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-23.parquet
  size:    202 KB
  rows:    6,343

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
2013-04-23 04:00:00	SPY	ETF	155.65	155.77	155.35	155.42	41495.0
2013-04-23 05:00:00	SPY	ETF	155.55	156.0	155.55	155.87	60798.0
2013-04-23 06:00:00	SPY	ETF	155.86	156.15	155.81	156.15	72412.0
2013-04-23 07:00:00	SPY	ETF	156.15	156.51	156.15	156.5	538990.0
2013-04-23 08:00:00	SPY	ETF	156.5	156.87	155.7	156.62	1902118.0
2013-04-23 09:00:00	SPY	ETF	156.62	157.48	156.57	157.231	20565138.0
2013-04-23 10:00:00	SPY	ETF	157.2335	157.72	157.17	157.52	21641198.0
2013-04-23 11:00:00	SPY	ETF	157.51	157.88	157.51	157.85	11453614.0
2013-04-23 12:00:00	SPY	ETF	157.85	157.93	157.67	157.78	6809069.0
2013-04-23 13:00:00	SPY	ETF	157.775	157.85	156.17	157.72	54345314.0
2013-04-23 14:00:00	SPY	ETF	157.71	157.74	157.24	157.56	13671983.0
2013-04-23 15:00:00	SPY	ETF	157.565	157.89	157.52	157.82	19159278.0
2013-04-23 16:00:00	SPY	ETF	157.82	158.09	156.2094	157.98	11254369.0
2013-04-23 17:00:00	SPY	ETF	157.99	158.06	157.8	157.8	375118.0
2013-04-23 18:00:00	SPY	ETF	157.8	157.9	157.72	157.75	139559.0
2013-04-23 19:00:00	SPY	ETF	157.76	157.83	157.64	157.66	114426.0
2013-04-23 04:00:00	QQQ	ETF	68.49	68.49	68.43	68.43	1000.0
2013-04-23 06:00:00	QQQ	ETF	68.72	68.76	68.71	68.75	2200.0
2013-04-23 07:00:00	QQQ	ETF	68.84	69.04	68.84	69.03	81500.0
2013-04-23 08:00:00	QQQ	ETF	69.03	69.17	68.95	69.08	335617.0
2013-04-23 09:00:00	QQQ	ETF	69.08	69.46	69.04	69.38	6470455.0
2013-04-23 10:00:00	QQQ	ETF	69.39	69.55	69.34	69.46	4750079.0
2013-04-23 11:00:00	QQQ	ETF	69.46	69.65	69.45	69.6301	2770255.0
2013-04-23 12:00:00	QQQ	ETF	69.6301	69.7	69.53	69.579	2107312.0
2013-04-23 13:00:00	QQQ	ETF	69.5701	69.6199	68.82	69.49	14452483.0
2013-04-23 14:00:00	QQQ	ETF	69.5	69.51	69.15	69.389	3370223.0
2013-04-23 15:00:00	QQQ	ETF	69.385	69.52	69.353	69.43	5697398.0
2013-04-23 16:00:00	QQQ	ETF	69.43	70.46	68.8198	69.72	6738578.0
2013-04-23 17:00:00	QQQ	ETF	69.72	69.81	69.41	69.5	554292.0
2013-04-23 18:00:00	QQQ	ETF	69.4	69.46	69.32	69.33	172871.0
2013-04-23 19:00:00	QQQ	ETF	69.34	69.37	69.24	69.26	76615.0
2013-04-23 04:00:00	IWM	ETF	90.41	90.41	90.39	90.39	1000.0
2013-04-23 05:00:00	IWM	ETF	90.56	90.84	90.55	90.84	3000.0
2013-04-23 07:00:00	IWM	ETF	91.0	91.2	91.0	91.18	63393.0
2013-04-23 08:00:00	IWM	ETF	91.22	91.48	91.19	91.3	299242.0
2013-04-23 09:00:00	IWM	ETF	91.31	92.0	91.31	91.7899	6872000.0
2013-04-23 10:00:00	IWM	ETF	91.79	91.98	91.7	91.88	4154346.0
2013-04-23 11:00:00	IWM	ETF	91.88	92.18	91.88	92.16	3192721.0
2013-04-23 12:00:00	IWM	ETF	92.17	92.2	92.03	92.1	1937428.0
2013-04-23 13:00:00	IWM	ETF	92.1	92.19	91.15	91.96	14307812.0
2013-04-23 14:00:00	IWM	ETF	91.96	91.98	91.6	91.8699	3304472.0
2013-04-23 15:00:00	IWM	ETF	91.87	92.34	91.84	92.33	6618612.0
2013-04-23 16:00:00	IWM	ETF	92.323	92.48	92.0886	92.48	1987284.0
2013-04-23 17:00:00	IWM	ETF	92.46	92.47	92.3	92.3	32900.0
2013-04-23 18:00:00	IWM	ETF	92.27	92.42	92.27	92.31	7700.0
2013-04-23 19:00:00	IWM	ETF	92.25	92.28	92.19	92.2	10150.0
2013-04-23 06:00:00	DIA	ETF	145.2	145.35	145.2	145.35	670.0
2013-04-23 07:00:00	DIA	ETF	145.82	145.83	145.78	145.78	5700.0
2013-04-23 08:00:00	DIA	ETF	145.84	146.03	145.78	145.85	14600.0
2013-04-23 09:00:00	DIA	ETF	145.91	146.59	145.9	146.52	1080640.0

> showing 50 of 6,343 rows — these rows as CSV

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