PREVIEW / etf_1hour / 2015-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-13.parquet
  size:    241 KB
  rows:    7,649

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-10-13 04:00:00	SPY	ETF	200.83	201.14	200.36	200.81	59108.0
2015-10-13 05:00:00	SPY	ETF	200.73	200.74	200.45	200.55	18976.0
2015-10-13 06:00:00	SPY	ETF	200.57	201.06	200.57	200.99	66737.0
2015-10-13 07:00:00	SPY	ETF	200.98	201.11	200.72	200.77	204574.0
2015-10-13 08:00:00	SPY	ETF	200.79	201.11	200.43	200.55	1272673.0
2015-10-13 09:00:00	SPY	ETF	200.58	201.27	200.47	201.17	11109455.0
2015-10-13 10:00:00	SPY	ETF	201.18	201.98	201.11	201.94	12479111.0
2015-10-13 11:00:00	SPY	ETF	201.93	202.16	201.47	201.58	10007052.0
2015-10-13 12:00:00	SPY	ETF	201.58	201.71	201.01	201.01	6112430.0
2015-10-13 13:00:00	SPY	ETF	201.01	201.14	200.74	200.8	8359204.0
2015-10-13 14:00:00	SPY	ETF	200.795	201.06	200.54	201.04	8525560.0
2015-10-13 15:00:00	SPY	ETF	201.045	201.05	200.05	200.22	18836072.0
2015-10-13 16:00:00	SPY	ETF	200.21	200.43	199.86	199.96	6984956.0
2015-10-13 17:00:00	SPY	ETF	200.03	200.06	199.51	199.83	266400.0
2015-10-13 18:00:00	SPY	ETF	199.84	199.91	199.76	199.91	69471.0
2015-10-13 19:00:00	SPY	ETF	199.91	200.01	199.88	199.99	59155.0
2015-10-13 04:00:00	QQQ	ETF	106.45	106.45	106.05	106.21	18048.0
2015-10-13 05:00:00	QQQ	ETF	106.09	106.09	106.07	106.07	6850.0
2015-10-13 06:00:00	QQQ	ETF	106.13	106.33	106.13	106.33	6450.0
2015-10-13 07:00:00	QQQ	ETF	106.33	106.4	106.21	106.21	19472.0
2015-10-13 08:00:00	QQQ	ETF	106.23	106.4	106.07	106.14	96503.0
2015-10-13 09:00:00	QQQ	ETF	106.14	106.64	106.08	106.57	3098461.0
2015-10-13 10:00:00	QQQ	ETF	106.56	107.19	106.49	107.16	4379471.0
2015-10-13 11:00:00	QQQ	ETF	107.16	107.26	106.78	106.86	2821056.0
2015-10-13 12:00:00	QQQ	ETF	106.87	106.99	106.57	106.57	2178381.0
2015-10-13 13:00:00	QQQ	ETF	106.57	106.67	106.361	106.48	2518746.0
2015-10-13 14:00:00	QQQ	ETF	106.49	106.63	106.25	106.62	2345809.0
2015-10-13 15:00:00	QQQ	ETF	106.61	106.6169	106.0	106.09	5883111.0
2015-10-13 16:00:00	QQQ	ETF	106.08	106.24	105.94	106.02	730542.0
2015-10-13 17:00:00	QQQ	ETF	106.05	106.14	105.96	105.96	86922.0
2015-10-13 18:00:00	QQQ	ETF	105.95	105.95	105.83	105.92	48679.0
2015-10-13 19:00:00	QQQ	ETF	105.9	105.96	105.89	105.96	12800.0
2015-10-13 04:00:00	IWM	ETF	115.46	115.46	115.07	115.07	1361.0
2015-10-13 06:00:00	IWM	ETF	115.22	115.31	115.22	115.31	2100.0
2015-10-13 07:00:00	IWM	ETF	115.32	115.38	115.2	115.23	43715.0
2015-10-13 08:00:00	IWM	ETF	115.23	115.32	115.05	115.05	104588.0
2015-10-13 09:00:00	IWM	ETF	115.07	115.75	115.05	115.58	3520148.0
2015-10-13 10:00:00	IWM	ETF	115.58	116.3	115.54	116.14	5363407.0
2015-10-13 11:00:00	IWM	ETF	116.13	116.24	115.62	115.69	3589982.0
2015-10-13 12:00:00	IWM	ETF	115.71	115.7899	114.99	115.02	2060967.0
2015-10-13 13:00:00	IWM	ETF	114.995	115.06	114.64	114.6936	3200887.0
2015-10-13 14:00:00	IWM	ETF	114.69	114.74	114.31	114.72	3832310.0
2015-10-13 15:00:00	IWM	ETF	114.72	114.73	113.93	113.97	6399178.0
2015-10-13 16:00:00	IWM	ETF	113.98	114.03	113.79	113.88	1615683.0
2015-10-13 17:00:00	IWM	ETF	113.86	113.86	113.75	113.75	19736.0
2015-10-13 18:00:00	IWM	ETF	113.86	113.86	113.79	113.79	1040.0
2015-10-13 19:00:00	IWM	ETF	113.87	113.87	113.79	113.8	1900.0
2015-10-13 04:00:00	DIA	ETF	170.67	171.0	170.37	170.37	53200.0
2015-10-13 05:00:00	DIA	ETF	170.37	170.37	170.37	170.37	400.0
2015-10-13 07:00:00	DIA	ETF	170.4	170.4	170.4	170.4	700.0

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

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