PREVIEW / etf_1hour / 2013-05-16

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-16.parquet
  size:    204 KB
  rows:    6,401

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-05-16 04:00:00	SPY	ETF	165.9	165.9	165.57	165.79	6485.0
2013-05-16 05:00:00	SPY	ETF	165.71	165.73	165.65	165.71	4800.0
2013-05-16 06:00:00	SPY	ETF	165.71	165.92	165.71	165.91	75780.0
2013-05-16 07:00:00	SPY	ETF	165.91	166.05	165.85	166.05	315692.0
2013-05-16 08:00:00	SPY	ETF	166.03	166.15	165.56	165.77	1834364.0
2013-05-16 09:00:00	SPY	ETF	165.76	166.27	165.65	166.15	12236247.0
2013-05-16 10:00:00	SPY	ETF	166.15	166.16	165.57	165.95	19463385.0
2013-05-16 11:00:00	SPY	ETF	165.955	166.36	165.95	166.17	11826030.0
2013-05-16 12:00:00	SPY	ETF	166.17	166.19	165.95	166.0829	5868285.0
2013-05-16 13:00:00	SPY	ETF	166.0899	166.1528	165.94	165.96	8976704.0
2013-05-16 14:00:00	SPY	ETF	165.97	166.27	165.74	165.74	8230918.0
2013-05-16 15:00:00	SPY	ETF	165.75	165.86	165.09	165.31	29974759.0
2013-05-16 16:00:00	SPY	ETF	165.31	166.0	165.15	165.45	9062259.0
2013-05-16 17:00:00	SPY	ETF	165.46	165.48	165.37	165.4	148687.0
2013-05-16 18:00:00	SPY	ETF	165.41	165.42	165.3236	165.41	85304.0
2013-05-16 19:00:00	SPY	ETF	165.42	165.48	165.39	165.46	48434.0
2013-05-16 05:00:00	QQQ	ETF	73.65	73.69	73.65	73.69	4500.0
2013-05-16 06:00:00	QQQ	ETF	73.63	73.73	73.63	73.73	4400.0
2013-05-16 07:00:00	QQQ	ETF	73.7	73.84	73.7	73.82	156795.0
2013-05-16 08:00:00	QQQ	ETF	73.83	73.9	73.71	73.8	229757.0
2013-05-16 09:00:00	QQQ	ETF	73.76	73.98	73.71	73.93	3047896.0
2013-05-16 10:00:00	QQQ	ETF	73.93	73.93	73.67	73.81	5520111.0
2013-05-16 11:00:00	QQQ	ETF	73.8151	74.02	73.81	73.9699	1813957.0
2013-05-16 12:00:00	QQQ	ETF	73.9625	73.969	73.8	73.87	1551042.0
2013-05-16 13:00:00	QQQ	ETF	73.862	73.92	73.82	73.85	968725.0
2013-05-16 14:00:00	QQQ	ETF	73.86	74.095	73.8	73.81	3054302.0
2013-05-16 15:00:00	QQQ	ETF	73.805	73.87	73.55	73.59	5759059.0
2013-05-16 16:00:00	QQQ	ETF	73.59	74.0183	73.56	73.64	1842501.0
2013-05-16 17:00:00	QQQ	ETF	73.66	73.67	73.61	73.61	12444.0
2013-05-16 18:00:00	QQQ	ETF	73.64	73.64	73.58	73.61	53051.0
2013-05-16 19:00:00	QQQ	ETF	73.62	73.67	73.62	73.67	1800.0
2013-05-16 04:00:00	IWM	ETF	98.05	98.05	98.05	98.05	300.0
2013-05-16 07:00:00	IWM	ETF	98.07	98.16	98.03	98.16	37659.0
2013-05-16 08:00:00	IWM	ETF	98.17	98.26	97.87	97.93	536568.0
2013-05-16 09:00:00	IWM	ETF	97.92	98.29	97.87	98.16	3017249.0
2013-05-16 10:00:00	IWM	ETF	98.18	98.45	97.73	98.34	7935485.0
2013-05-16 11:00:00	IWM	ETF	98.35	98.56	98.345	98.39	3279054.0
2013-05-16 12:00:00	IWM	ETF	98.39	98.52	98.19	98.26	2498849.0
2013-05-16 13:00:00	IWM	ETF	98.27	98.42	98.23	98.28	2033658.0
2013-05-16 14:00:00	IWM	ETF	98.285	98.52	98.15	98.15	3249240.0
2013-05-16 15:00:00	IWM	ETF	98.15	98.2499	97.7	97.95	10350336.0
2013-05-16 16:00:00	IWM	ETF	97.95	98.08	97.8873	98.03	1101592.0
2013-05-16 17:00:00	IWM	ETF	98.03	98.07	98.03	98.07	2938.0
2013-05-16 18:00:00	IWM	ETF	98.03	98.05	98.03	98.03	15751.0
2013-05-16 19:00:00	IWM	ETF	98.05	98.05	97.99	97.99	4100.0
2013-05-16 06:00:00	DIA	ETF	152.61	152.61	152.61	152.61	100.0
2013-05-16 07:00:00	DIA	ETF	152.73	152.73	152.67	152.71	738.0
2013-05-16 08:00:00	DIA	ETF	152.74	152.74	152.51	152.63	12710.0
2013-05-16 09:00:00	DIA	ETF	152.61	153.01	152.56	152.92	1941280.0
2013-05-16 10:00:00	DIA	ETF	152.92	152.92	152.42	152.76	1544667.0

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

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