PREVIEW / etf_1hour / 2013-10-03

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-03.parquet
  size:    209 KB
  rows:    6,482

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-10-03 04:00:00	SPY	ETF	168.47	168.61	168.34	168.46	55746.0
2013-10-03 05:00:00	SPY	ETF	168.46	168.54	168.22	168.24	16503.0
2013-10-03 06:00:00	SPY	ETF	168.24	168.39	168.24	168.37	74577.0
2013-10-03 07:00:00	SPY	ETF	168.36	168.57	168.31	168.53	215416.0
2013-10-03 08:00:00	SPY	ETF	168.5	168.87	168.31	168.82	1083328.0
2013-10-03 09:00:00	SPY	ETF	168.81	168.94	168.25	168.35	13604986.0
2013-10-03 10:00:00	SPY	ETF	168.35	168.35	167.53	167.77	24614207.0
2013-10-03 11:00:00	SPY	ETF	167.76	167.93	166.89	166.99	24103784.0
2013-10-03 12:00:00	SPY	ETF	166.99	167.64	166.84	167.59	26951170.0
2013-10-03 13:00:00	SPY	ETF	167.6	168.24	167.465	168.18	22277535.0
2013-10-03 14:00:00	SPY	ETF	168.18	168.18	167.35	167.87	21424316.0
2013-10-03 15:00:00	SPY	ETF	167.8799	168.06	167.56	167.67	22992471.0
2013-10-03 16:00:00	SPY	ETF	167.67	169.2295	167.27	167.285	10978720.0
2013-10-03 17:00:00	SPY	ETF	167.285	167.7261	167.28	167.33	1228910.0
2013-10-03 18:00:00	SPY	ETF	167.35	167.55	167.33	167.44	114472.0
2013-10-03 19:00:00	SPY	ETF	167.48	167.5	167.43	167.46	20425.0
2013-10-03 04:00:00	QQQ	ETF	79.45	79.45	79.34	79.4	22200.0
2013-10-03 05:00:00	QQQ	ETF	79.41	79.45	79.3	79.3	34100.0
2013-10-03 06:00:00	QQQ	ETF	79.31	79.36	79.3	79.36	55700.0
2013-10-03 07:00:00	QQQ	ETF	79.35	79.45	79.35	79.41	25140.0
2013-10-03 08:00:00	QQQ	ETF	79.4	79.59	79.35	79.58	173485.0
2013-10-03 09:00:00	QQQ	ETF	79.57	79.72	79.31	79.39	3338937.0
2013-10-03 10:00:00	QQQ	ETF	79.39	79.39	78.8	78.9996	6120258.0
2013-10-03 11:00:00	QQQ	ETF	78.99	79.11	78.32	78.37	5948983.0
2013-10-03 12:00:00	QQQ	ETF	78.36	78.68	78.3	78.6499	4635306.0
2013-10-03 13:00:00	QQQ	ETF	78.65	78.97	78.56	78.95	4087591.0
2013-10-03 14:00:00	QQQ	ETF	78.95	78.95	78.47	78.69	5064112.0
2013-10-03 15:00:00	QQQ	ETF	78.68	78.831	78.62	78.72	3678518.0
2013-10-03 16:00:00	QQQ	ETF	78.72	79.6794	78.56	78.56	6727146.0
2013-10-03 17:00:00	QQQ	ETF	78.56	78.8586	78.53	78.56	376563.0
2013-10-03 18:00:00	QQQ	ETF	78.56	78.69	78.56	78.64	11607.0
2013-10-03 19:00:00	QQQ	ETF	78.67	78.67	78.64	78.66	5755.0
2013-10-03 04:00:00	IWM	ETF	107.01	107.01	107.01	107.01	200.0
2013-10-03 05:00:00	IWM	ETF	106.8	106.8	106.8	106.8	300.0
2013-10-03 06:00:00	IWM	ETF	106.7	106.7	106.62	106.66	300.0
2013-10-03 07:00:00	IWM	ETF	106.67	106.88	106.67	106.78	121750.0
2013-10-03 08:00:00	IWM	ETF	106.8	107.12	106.735	107.11	510790.0
2013-10-03 09:00:00	IWM	ETF	107.08	107.36	106.78	106.86	3960146.0
2013-10-03 10:00:00	IWM	ETF	106.86	106.86	105.95	106.17	9489520.0
2013-10-03 11:00:00	IWM	ETF	106.16	106.38	105.73	105.79	6351250.0
2013-10-03 12:00:00	IWM	ETF	105.78	106.06	105.6	106.01	6810990.0
2013-10-03 13:00:00	IWM	ETF	106.01	106.58	105.93	106.51	6782508.0
2013-10-03 14:00:00	IWM	ETF	106.52	106.52	105.96	106.38	5170405.0
2013-10-03 15:00:00	IWM	ETF	106.37	106.48	106.23	106.28	6614824.0
2013-10-03 16:00:00	IWM	ETF	106.29	106.47	106.0144	106.09	1540026.0
2013-10-03 17:00:00	IWM	ETF	106.09	106.4585	106.08	106.19	237797.0
2013-10-03 18:00:00	IWM	ETF	106.14	106.16	106.14	106.15	8343.0
2013-10-03 19:00:00	IWM	ETF	106.15	106.15	106.06	106.13	2700.0
2013-10-03 08:00:00	DIA	ETF	150.53	150.64	150.46	150.64	5921.0
2013-10-03 09:00:00	DIA	ETF	150.66	150.76	150.17	150.3299	681514.0

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

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