PREVIEW / etf_1hour / 2015-09-03

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-03.parquet
  size:    243 KB
  rows:    7,749

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
2015-09-03 04:00:00	SPY	ETF	196.11	196.34	196.02	196.31	19225.0
2015-09-03 05:00:00	SPY	ETF	196.34	196.64	196.06	196.21	36699.0
2015-09-03 06:00:00	SPY	ETF	196.26	196.45	196.1	196.31	161605.0
2015-09-03 07:00:00	SPY	ETF	196.17	196.38	195.86	196.23	240504.0
2015-09-03 08:00:00	SPY	ETF	196.49	197.62	196.06	196.43	3143361.0
2015-09-03 09:00:00	SPY	ETF	196.44	197.1	195.925	196.75	16152028.0
2015-09-03 10:00:00	SPY	ETF	196.75	197.95	196.42	197.89	22687743.0
2015-09-03 11:00:00	SPY	ETF	197.89	198.05	196.85	197.11	16738880.0
2015-09-03 12:00:00	SPY	ETF	197.1	197.21	196.3	196.483	11591739.0
2015-09-03 13:00:00	SPY	ETF	196.49	197.2	195.48	195.49	16864048.0
2015-09-03 14:00:00	SPY	ETF	195.495	196.46	195.2601	196.0392	19949630.0
2015-09-03 15:00:00	SPY	ETF	196.03	196.28	194.96	195.55	33427032.0
2015-09-03 16:00:00	SPY	ETF	195.53	195.7253	195.31	195.43	10361830.0
2015-09-03 17:00:00	SPY	ETF	195.44	195.51	195.39	195.44	96609.0
2015-09-03 18:00:00	SPY	ETF	195.44	195.66	195.4	195.62	80603.0
2015-09-03 19:00:00	SPY	ETF	195.61	195.67	195.52	195.61	12008.0
2015-09-03 04:00:00	QQQ	ETF	104.51	104.66	104.45	104.58	18774.0
2015-09-03 05:00:00	QQQ	ETF	104.67	104.72	104.41	104.41	8850.0
2015-09-03 06:00:00	QQQ	ETF	104.51	104.51	104.44	104.51	7300.0
2015-09-03 07:00:00	QQQ	ETF	104.44	104.53	104.3	104.49	19690.0
2015-09-03 08:00:00	QQQ	ETF	104.48	105.13	104.36	104.51	491087.0
2015-09-03 09:00:00	QQQ	ETF	104.52	104.73	104.03	104.2	6759264.0
2015-09-03 10:00:00	QQQ	ETF	104.21	104.91	104.03	104.88	6684190.0
2015-09-03 11:00:00	QQQ	ETF	104.881	105.02	104.23	104.42	4058299.0
2015-09-03 12:00:00	QQQ	ETF	104.41	104.47	103.92	104.05	2955751.0
2015-09-03 13:00:00	QQQ	ETF	104.055	104.06	103.38	103.39	4953810.0
2015-09-03 14:00:00	QQQ	ETF	103.39	104.0399	103.25	103.76	4353591.0
2015-09-03 15:00:00	QQQ	ETF	103.77	103.92	103.1	103.37	9445123.0
2015-09-03 16:00:00	QQQ	ETF	103.37	103.564	103.3	103.4	873588.0
2015-09-03 17:00:00	QQQ	ETF	103.36	103.37	103.29	103.3	3056.0
2015-09-03 18:00:00	QQQ	ETF	103.35	103.48	103.35	103.44	10331.0
2015-09-03 19:00:00	QQQ	ETF	103.47	103.48	103.43	103.48	17040.0
2015-09-03 04:00:00	IWM	ETF	114.19	114.19	114.1	114.1	200.0
2015-09-03 05:00:00	IWM	ETF	114.35	114.35	114.35	114.35	100.0
2015-09-03 06:00:00	IWM	ETF	114.28	114.28	114.28	114.28	200.0
2015-09-03 07:00:00	IWM	ETF	114.28	114.32	114.05	114.18	24900.0
2015-09-03 08:00:00	IWM	ETF	114.22	114.83	114.15	114.39	276770.0
2015-09-03 09:00:00	IWM	ETF	114.38	114.75	113.94	114.56	4082396.0
2015-09-03 10:00:00	IWM	ETF	114.56	115.09	114.28	115.06	3892871.0
2015-09-03 11:00:00	IWM	ETF	115.065	115.13	114.5043	114.69	2632093.0
2015-09-03 12:00:00	IWM	ETF	114.69	114.74	114.09	114.27	2514199.0
2015-09-03 13:00:00	IWM	ETF	114.27	114.28	113.61	113.855	3392186.0
2015-09-03 14:00:00	IWM	ETF	113.86	114.55	113.69	114.25	3349571.0
2015-09-03 15:00:00	IWM	ETF	114.26	114.39	113.55	113.73	7103649.0
2015-09-03 16:00:00	IWM	ETF	113.73	114.11	113.66	113.73	1615503.0
2015-09-03 19:00:00	IWM	ETF	113.83	113.85	113.83	113.85	700.0
2015-09-03 04:00:00	DIA	ETF	164.06	164.06	164.06	164.06	100.0
2015-09-03 07:00:00	DIA	ETF	164.0	164.05	163.93	164.01	6280.0
2015-09-03 08:00:00	DIA	ETF	164.1	165.0	164.06	164.55	40657.0
2015-09-03 09:00:00	DIA	ETF	164.38	164.73	163.93	164.45	849756.0

> showing 50 of 7,749 rows — these rows as CSV

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