PREVIEW / etf_1hour / 2016-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-23.parquet
  size:    247 KB
  rows:    7,892

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
2016-03-23 04:00:00	SPY	ETF	204.66	204.97	204.63	204.72	34307.0
2016-03-23 05:00:00	SPY	ETF	204.94	204.94	204.67	204.84	6658.0
2016-03-23 06:00:00	SPY	ETF	204.79	204.82	204.65	204.65	30940.0
2016-03-23 07:00:00	SPY	ETF	204.71	204.9	204.7	204.85	280823.0
2016-03-23 08:00:00	SPY	ETF	204.87	204.94	204.455	204.55	496123.0
2016-03-23 09:00:00	SPY	ETF	204.53	204.55	203.73	203.89	8993042.0
2016-03-23 10:00:00	SPY	ETF	203.89	204.33	203.63	203.87	13177128.0
2016-03-23 11:00:00	SPY	ETF	203.88	204.06	203.36	203.55	11068821.0
2016-03-23 12:00:00	SPY	ETF	203.55	204.06	203.49	203.89	7819473.0
2016-03-23 13:00:00	SPY	ETF	203.89	204.0	203.63	203.819	3710781.0
2016-03-23 14:00:00	SPY	ETF	203.819	204.08	203.15	203.22	10163429.0
2016-03-23 15:00:00	SPY	ETF	203.21	203.47	203.01	203.24	17279808.0
2016-03-23 16:00:00	SPY	ETF	203.25	203.659	203.2092	203.29	6309073.0
2016-03-23 17:00:00	SPY	ETF	203.32	203.36	203.2092	203.3	588418.0
2016-03-23 18:00:00	SPY	ETF	203.28	203.28	203.18	203.22	77969.0
2016-03-23 19:00:00	SPY	ETF	203.25	203.32	203.17	203.26	61327.0
2016-03-23 04:00:00	QQQ	ETF	108.22	108.26	108.21	108.26	2300.0
2016-03-23 06:00:00	QQQ	ETF	108.2	108.2	108.2	108.2	600.0
2016-03-23 07:00:00	QQQ	ETF	108.22	108.32	108.21	108.28	36235.0
2016-03-23 08:00:00	QQQ	ETF	108.28	108.32	108.15	108.19	12901.0
2016-03-23 09:00:00	QQQ	ETF	108.14	108.14	107.5399	107.6301	2347220.0
2016-03-23 10:00:00	QQQ	ETF	107.64	107.89	107.46	107.52	3484858.0
2016-03-23 11:00:00	QQQ	ETF	107.52	107.62	107.21	107.32	3388080.0
2016-03-23 12:00:00	QQQ	ETF	107.32	107.575	107.27	107.485	1929228.0
2016-03-23 13:00:00	QQQ	ETF	107.485	107.6	107.398	107.5	1107054.0
2016-03-23 14:00:00	QQQ	ETF	107.5	107.68	107.14	107.19	2062794.0
2016-03-23 15:00:00	QQQ	ETF	107.2	107.26	106.99	107.22	4051169.0
2016-03-23 16:00:00	QQQ	ETF	107.23	108.0456	107.1921	107.29	1259173.0
2016-03-23 17:00:00	QQQ	ETF	107.24	107.31	107.24	107.25	7472.0
2016-03-23 18:00:00	QQQ	ETF	107.2	107.21	107.19	107.19	2457.0
2016-03-23 19:00:00	QQQ	ETF	107.2	107.25	107.17	107.23	5621.0
2016-03-23 07:00:00	IWM	ETF	108.85	109.02	108.85	109.01	24000.0
2016-03-23 08:00:00	IWM	ETF	108.97	109.0	108.75	108.76	34126.0
2016-03-23 09:00:00	IWM	ETF	108.76	108.76	108.07	108.18	3712071.0
2016-03-23 10:00:00	IWM	ETF	108.17	108.17	107.44	107.6	8216926.0
2016-03-23 11:00:00	IWM	ETF	107.6	107.93	107.28	107.58	4827898.0
2016-03-23 12:00:00	IWM	ETF	107.59	107.92	107.53	107.76	2264169.0
2016-03-23 13:00:00	IWM	ETF	107.745	107.78	107.37	107.515	1790948.0
2016-03-23 14:00:00	IWM	ETF	107.5	107.7421	107.17	107.23	3244155.0
2016-03-23 15:00:00	IWM	ETF	107.22	107.34	106.8	106.84	6318180.0
2016-03-23 16:00:00	IWM	ETF	106.85	107.05	106.8215	107.0	1385651.0
2016-03-23 17:00:00	IWM	ETF	107.0	107.05	106.94	107.01	9276.0
2016-03-23 18:00:00	IWM	ETF	106.97	106.97	106.9	106.9	1300.0
2016-03-23 19:00:00	IWM	ETF	106.9	106.95	106.86	106.95	4300.0
2016-03-23 08:00:00	DIA	ETF	175.67	175.67	175.67	175.67	300.0
2016-03-23 09:00:00	DIA	ETF	175.56	175.56	174.97	175.18	368224.0
2016-03-23 10:00:00	DIA	ETF	175.16	175.54	175.03	175.27	690513.0
2016-03-23 11:00:00	DIA	ETF	175.25	175.4	174.82	174.95	531415.0
2016-03-23 12:00:00	DIA	ETF	174.96	175.52	174.93	175.4	439676.0
2016-03-23 13:00:00	DIA	ETF	175.39	175.55	175.22	175.32	351292.0

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

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