PREVIEW / etf_1hour / 2013-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-08.parquet
  size:    214 KB
  rows:    6,717

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-11-08 04:00:00	SPY	ETF	175.45	175.56	175.45	175.49	43901.0
2013-11-08 05:00:00	SPY	ETF	175.47	175.5	175.4	175.45	37996.0
2013-11-08 06:00:00	SPY	ETF	175.45	175.46	175.27	175.32	34803.0
2013-11-08 07:00:00	SPY	ETF	175.32	175.45	175.09	175.13	243634.0
2013-11-08 08:00:00	SPY	ETF	175.14	175.5	174.15	174.76	6232581.0
2013-11-08 09:00:00	SPY	ETF	174.74	175.53	174.66	175.01	19910101.0
2013-11-08 10:00:00	SPY	ETF	175.01	176.27	174.98	176.192	24402219.0
2013-11-08 11:00:00	SPY	ETF	176.2	176.37	175.97	176.23	13019686.0
2013-11-08 12:00:00	SPY	ETF	176.24	176.53	176.23	176.48	8574390.0
2013-11-08 13:00:00	SPY	ETF	176.475	176.78	176.31	176.57	10350650.0
2013-11-08 14:00:00	SPY	ETF	176.5689	176.75	176.53	176.685	8075437.0
2013-11-08 15:00:00	SPY	ETF	176.68	177.25	176.4	177.23	32188320.0
2013-11-08 16:00:00	SPY	ETF	177.24	177.31	176.4	177.05	10785174.0
2013-11-08 17:00:00	SPY	ETF	177.05	177.24	177.05	177.11	924044.0
2013-11-08 18:00:00	SPY	ETF	177.16	177.18	177.1	177.14	8818.0
2013-11-08 19:00:00	SPY	ETF	177.17	177.25	177.15	177.19	22675.0
2013-11-08 04:00:00	QQQ	ETF	81.74	81.81	81.74	81.78	21000.0
2013-11-08 05:00:00	QQQ	ETF	81.77	81.79	81.77	81.78	5700.0
2013-11-08 06:00:00	QQQ	ETF	81.77	81.77	81.72	81.75	10800.0
2013-11-08 07:00:00	QQQ	ETF	81.76	81.79	81.63	81.64	65425.0
2013-11-08 08:00:00	QQQ	ETF	81.63	81.81	81.28	81.57	1061759.0
2013-11-08 09:00:00	QQQ	ETF	81.56	81.93	81.51	81.6	5576790.0
2013-11-08 10:00:00	QQQ	ETF	81.6	82.25	81.59	82.13	7556086.0
2013-11-08 11:00:00	QQQ	ETF	82.125	82.33	82.03	82.28	2991606.0
2013-11-08 12:00:00	QQQ	ETF	82.28	82.4	82.28	82.35	2223865.0
2013-11-08 13:00:00	QQQ	ETF	82.35	82.5	82.29	82.42	1957611.0
2013-11-08 14:00:00	QQQ	ETF	82.41	82.46	82.36	82.39	1861802.0
2013-11-08 15:00:00	QQQ	ETF	82.39	82.56	82.26	82.54	7019004.0
2013-11-08 16:00:00	QQQ	ETF	82.55	82.56	82.48	82.49	968431.0
2013-11-08 17:00:00	QQQ	ETF	82.5	82.55	82.47	82.47	55126.0
2013-11-08 18:00:00	QQQ	ETF	82.52	82.52	82.45	82.45	1906.0
2013-11-08 19:00:00	QQQ	ETF	82.46	82.5	82.45	82.5	5688.0
2013-11-08 04:00:00	IWM	ETF	107.64	107.69	107.64	107.69	1120.0
2013-11-08 05:00:00	IWM	ETF	107.69	107.69	107.69	107.69	100.0
2013-11-08 07:00:00	IWM	ETF	107.7	107.73	107.49	107.49	78900.0
2013-11-08 08:00:00	IWM	ETF	107.47	107.68	106.95	107.35	922504.0
2013-11-08 09:00:00	IWM	ETF	107.35	108.13	107.3	107.75	7649008.0
2013-11-08 10:00:00	IWM	ETF	107.7399	108.96	107.7399	108.705	9512650.0
2013-11-08 11:00:00	IWM	ETF	108.71	109.19	108.65	109.07	4087093.0
2013-11-08 12:00:00	IWM	ETF	109.08	109.27	108.96	109.23	3094825.0
2013-11-08 13:00:00	IWM	ETF	109.23	109.46	109.13	109.16	2828584.0
2013-11-08 14:00:00	IWM	ETF	109.16	109.29	109.02	109.07	2338431.0
2013-11-08 15:00:00	IWM	ETF	109.061	109.32	108.85	109.25	7714722.0
2013-11-08 16:00:00	IWM	ETF	109.25	109.2816	107.2078	109.13	6494379.0
2013-11-08 17:00:00	IWM	ETF	109.14	109.23	109.14	109.2	1500.0
2013-11-08 18:00:00	IWM	ETF	109.14	109.14	109.14	109.14	500.0
2013-11-08 19:00:00	IWM	ETF	109.24	109.24	109.24	109.24	100.0
2013-11-08 07:00:00	DIA	ETF	156.14	156.14	155.85	155.85	2089.0
2013-11-08 08:00:00	DIA	ETF	155.84	156.07	155.3	155.62	28290.0
2013-11-08 09:00:00	DIA	ETF	155.57	156.13	155.57	155.7	1179268.0

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

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