PREVIEW / etf_1hour / 2013-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-21.parquet
  size:    210 KB
  rows:    6,672

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-21 04:00:00	SPY	ETF	174.27	174.3	174.25	174.28	14918.0
2013-10-21 05:00:00	SPY	ETF	174.26	174.26	174.19	174.23	11414.0
2013-10-21 06:00:00	SPY	ETF	174.21	174.21	174.08	174.11	21114.0
2013-10-21 07:00:00	SPY	ETF	174.09	174.3	174.06	174.25	104395.0
2013-10-21 08:00:00	SPY	ETF	174.25	174.38	174.15	174.36	336345.0
2013-10-21 09:00:00	SPY	ETF	174.36	174.68	174.24	174.6	10348671.0
2013-10-21 10:00:00	SPY	ETF	174.61	174.75	174.11	174.2	16506880.0
2013-10-21 11:00:00	SPY	ETF	174.21	174.42	174.17	174.37	9833661.0
2013-10-21 12:00:00	SPY	ETF	174.37	174.4927	174.32	174.47	4585839.0
2013-10-21 13:00:00	SPY	ETF	174.47	174.51	174.35	174.42	7353248.0
2013-10-21 14:00:00	SPY	ETF	174.42	174.42	174.01	174.0999	9319211.0
2013-10-21 15:00:00	SPY	ETF	174.095	174.4109	174.075	174.4	27308238.0
2013-10-21 16:00:00	SPY	ETF	174.39	174.5363	174.26	174.29	10756698.0
2013-10-21 17:00:00	SPY	ETF	174.31	174.4109	174.2627	174.32	3154780.0
2013-10-21 18:00:00	SPY	ETF	174.28	174.32	174.25	174.25	20858.0
2013-10-21 19:00:00	SPY	ETF	174.25	174.35	174.24	174.35	27668.0
2013-10-21 04:00:00	QQQ	ETF	82.18	82.22	82.17	82.19	12969.0
2013-10-21 05:00:00	QQQ	ETF	82.18	82.21	82.17	82.21	4900.0
2013-10-21 06:00:00	QQQ	ETF	82.2	82.2	82.16	82.16	41800.0
2013-10-21 07:00:00	QQQ	ETF	82.15	82.25	82.14	82.2	79375.0
2013-10-21 08:00:00	QQQ	ETF	82.2	82.27	82.19	82.26	118749.0
2013-10-21 09:00:00	QQQ	ETF	82.27	82.49	82.16	82.469	4817794.0
2013-10-21 10:00:00	QQQ	ETF	82.47	82.54	82.22	82.28	6034247.0
2013-10-21 11:00:00	QQQ	ETF	82.29	82.39	82.255	82.3751	2855496.0
2013-10-21 12:00:00	QQQ	ETF	82.37	82.44	82.33	82.43	2695958.0
2013-10-21 13:00:00	QQQ	ETF	82.42	82.43	82.3201	82.36	1793221.0
2013-10-21 14:00:00	QQQ	ETF	82.36	82.36	82.07	82.14	3384383.0
2013-10-21 15:00:00	QQQ	ETF	82.14	82.34	82.13	82.3	6302868.0
2013-10-21 16:00:00	QQQ	ETF	82.31	82.41	82.1141	82.31	1043860.0
2013-10-21 17:00:00	QQQ	ETF	82.32	82.36	82.3	82.36	39400.0
2013-10-21 18:00:00	QQQ	ETF	82.31	82.36	82.29	82.33	4420.0
2013-10-21 19:00:00	QQQ	ETF	82.32	82.38	82.32	82.38	13687.0
2013-10-21 07:00:00	IWM	ETF	110.72	110.72	110.68	110.68	1000.0
2013-10-21 08:00:00	IWM	ETF	110.7	110.79	110.7	110.77	136713.0
2013-10-21 09:00:00	IWM	ETF	110.78	111.08	110.645	111.015	3637123.0
2013-10-21 10:00:00	IWM	ETF	111.02	111.08	110.39	110.5	4458391.0
2013-10-21 11:00:00	IWM	ETF	110.498	110.64	110.41	110.6199	1860531.0
2013-10-21 12:00:00	IWM	ETF	110.62	110.89	110.59	110.8601	3100517.0
2013-10-21 13:00:00	IWM	ETF	110.86	110.87	110.53	110.58	2235576.0
2013-10-21 14:00:00	IWM	ETF	110.58	110.585	110.27	110.32	4118361.0
2013-10-21 15:00:00	IWM	ETF	110.3155	110.55	110.275	110.45	6794187.0
2013-10-21 16:00:00	IWM	ETF	110.45	110.9185	110.34	110.4	1066450.0
2013-10-21 17:00:00	IWM	ETF	110.41	110.41	110.41	110.41	5000.0
2013-10-21 18:00:00	IWM	ETF	110.39	110.41	110.39	110.41	1400.0
2013-10-21 19:00:00	IWM	ETF	110.41	110.46	110.38	110.42	4649.0
2013-10-21 07:00:00	DIA	ETF	153.45	153.45	153.45	153.45	700.0
2013-10-21 08:00:00	DIA	ETF	153.5	153.5	153.46	153.48	800.0
2013-10-21 09:00:00	DIA	ETF	153.5	153.74	153.33	153.632	623524.0
2013-10-21 10:00:00	DIA	ETF	153.61	153.76	153.27	153.39	729152.0
2013-10-21 11:00:00	DIA	ETF	153.38	153.6	153.35	153.57	455189.0

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

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