PREVIEW / etf_1hour / 2015-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-13.parquet
  size:    245 KB
  rows:    7,855

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-11-13 04:00:00	SPY	ETF	205.04	205.26	204.76	204.88	5608.0
2015-11-13 05:00:00	SPY	ETF	204.93	204.93	204.78	204.88	8700.0
2015-11-13 06:00:00	SPY	ETF	204.68	204.68	204.11	204.41	84655.0
2015-11-13 07:00:00	SPY	ETF	204.41	204.58	204.36	204.4	299337.0
2015-11-13 08:00:00	SPY	ETF	204.4	205.27	204.08	204.49	1537876.0
2015-11-13 09:00:00	SPY	ETF	204.48	204.67	203.88	204.06	14773038.0
2015-11-13 10:00:00	SPY	ETF	204.041	204.24	203.01	203.61	26122616.0
2015-11-13 11:00:00	SPY	ETF	203.61	203.86	202.875	203.85	17652820.0
2015-11-13 12:00:00	SPY	ETF	203.85	204.41	203.48	203.72	15457247.0
2015-11-13 13:00:00	SPY	ETF	203.72	203.81	203.11	203.255	13919205.0
2015-11-13 14:00:00	SPY	ETF	203.26	203.43	202.51	202.67	16863185.0
2015-11-13 15:00:00	SPY	ETF	202.67	203.05	202.435	202.54	33926701.0
2015-11-13 16:00:00	SPY	ETF	202.56	202.73	201.92	201.97	8456361.0
2015-11-13 17:00:00	SPY	ETF	202.0	202.04	201.2	201.34	2075563.0
2015-11-13 18:00:00	SPY	ETF	201.38	201.44	200.83	201.0	321902.0
2015-11-13 19:00:00	SPY	ETF	201.05	201.15	200.76	200.9	122522.0
2015-11-13 04:00:00	QQQ	ETF	111.92	111.97	111.74	111.79	415.0
2015-11-13 05:00:00	QQQ	ETF	111.91	111.91	111.8	111.8	17600.0
2015-11-13 06:00:00	QQQ	ETF	111.67	111.7	111.45	111.58	103170.0
2015-11-13 07:00:00	QQQ	ETF	111.58	111.66	111.56	111.6	102343.0
2015-11-13 08:00:00	QQQ	ETF	111.55	111.77	111.45	111.66	173769.0
2015-11-13 09:00:00	QQQ	ETF	111.66	111.76	111.17	111.33	4587997.0
2015-11-13 10:00:00	QQQ	ETF	111.32	111.3901	110.57	110.88	8283717.0
2015-11-13 11:00:00	QQQ	ETF	110.88	110.8895	110.38	110.84	5447613.0
2015-11-13 12:00:00	QQQ	ETF	110.85	111.18	110.63	110.77	3638904.0
2015-11-13 13:00:00	QQQ	ETF	110.77	110.8355	110.39	110.54	3189291.0
2015-11-13 14:00:00	QQQ	ETF	110.53	110.59	110.01	110.14	5266007.0
2015-11-13 15:00:00	QQQ	ETF	110.134	110.35	109.78	109.85	13163943.0
2015-11-13 16:00:00	QQQ	ETF	109.85	110.2972	109.57	109.6	1263193.0
2015-11-13 17:00:00	QQQ	ETF	109.63	109.63	109.02	109.15	212673.0
2015-11-13 18:00:00	QQQ	ETF	109.15	109.19	108.8	108.91	62656.0
2015-11-13 19:00:00	QQQ	ETF	108.96	109.0	108.85	108.9	19795.0
2015-11-13 06:00:00	IWM	ETF	114.51	114.51	114.51	114.51	100.0
2015-11-13 07:00:00	IWM	ETF	114.63	114.71	114.57	114.64	7846.0
2015-11-13 08:00:00	IWM	ETF	114.62	114.68	114.34	114.55	67137.0
2015-11-13 09:00:00	IWM	ETF	114.52	114.75	114.28	114.41	3612133.0
2015-11-13 10:00:00	IWM	ETF	114.41	114.74	113.66	114.73	8227360.0
2015-11-13 11:00:00	IWM	ETF	114.735	115.08	114.11	115.055	5675928.0
2015-11-13 12:00:00	IWM	ETF	115.0571	115.34	114.71	114.935	5119751.0
2015-11-13 13:00:00	IWM	ETF	114.94	114.98	114.24	114.24	2869997.0
2015-11-13 14:00:00	IWM	ETF	114.24	114.38	114.0	114.0941	3656003.0
2015-11-13 15:00:00	IWM	ETF	114.1	114.32	113.92	114.02	7301098.0
2015-11-13 16:00:00	IWM	ETF	114.0	114.1071	113.61	113.61	1572964.0
2015-11-13 17:00:00	IWM	ETF	113.7	113.86	113.42	113.42	22712.0
2015-11-13 18:00:00	IWM	ETF	113.59	113.59	113.2	113.34	11190.0
2015-11-13 19:00:00	IWM	ETF	113.4	113.5	113.4	113.5	1173.0
2015-11-13 06:00:00	DIA	ETF	174.2	174.2	174.1	174.1	7500.0
2015-11-13 07:00:00	DIA	ETF	174.27	174.27	174.24	174.24	1000.0
2015-11-13 08:00:00	DIA	ETF	174.2	174.5	174.05	174.45	23100.0
2015-11-13 09:00:00	DIA	ETF	174.37	174.55	173.7201	173.82	605299.0

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

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