PREVIEW / etf_1hour / 2016-03-29

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-29.parquet
  size:    252 KB
  rows:    8,033

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-29 04:00:00	SPY	ETF	203.55	203.69	203.42	203.55	57903.0
2016-03-29 05:00:00	SPY	ETF	203.56	203.56	202.83	202.94	65764.0
2016-03-29 06:00:00	SPY	ETF	202.94	203.04	202.7	202.74	104396.0
2016-03-29 07:00:00	SPY	ETF	202.76	202.83	202.55	202.78	249417.0
2016-03-29 08:00:00	SPY	ETF	202.82	203.55	202.58	202.72	450813.0
2016-03-29 09:00:00	SPY	ETF	202.72	202.89	202.4	202.8	7277927.0
2016-03-29 10:00:00	SPY	ETF	202.8	203.13	202.8	202.975	10085474.0
2016-03-29 11:00:00	SPY	ETF	202.98	203.28	202.86	203.125	7925667.0
2016-03-29 12:00:00	SPY	ETF	203.125	204.44	203.06	204.13	17177753.0
2016-03-29 13:00:00	SPY	ETF	204.13	204.39	203.835	204.32	9735856.0
2016-03-29 14:00:00	SPY	ETF	204.31	205.09	204.28	204.89	12585816.0
2016-03-29 15:00:00	SPY	ETF	204.9	205.21	204.82	205.15	20003941.0
2016-03-29 16:00:00	SPY	ETF	205.16	205.38	204.313	205.33	3612984.0
2016-03-29 17:00:00	SPY	ETF	205.33	205.35	205.12	205.32	198385.0
2016-03-29 18:00:00	SPY	ETF	205.31	205.37	205.18	205.26	162311.0
2016-03-29 19:00:00	SPY	ETF	205.26	205.54	205.26	205.5	188116.0
2016-03-29 05:00:00	QQQ	ETF	106.98	107.04	106.92	106.92	1098.0
2016-03-29 06:00:00	QQQ	ETF	106.97	107.02	106.96	106.97	1299.0
2016-03-29 07:00:00	QQQ	ETF	106.82	106.93	106.79	106.93	32255.0
2016-03-29 08:00:00	QQQ	ETF	106.9	106.95	106.83	106.9	26303.0
2016-03-29 09:00:00	QQQ	ETF	106.87	107.04	106.735	106.97	2031573.0
2016-03-29 10:00:00	QQQ	ETF	106.98	107.48	106.98	107.41	2624466.0
2016-03-29 11:00:00	QQQ	ETF	107.42	107.71	107.39	107.62	2096732.0
2016-03-29 12:00:00	QQQ	ETF	107.61	108.34	107.55	108.18	4367200.0
2016-03-29 13:00:00	QQQ	ETF	108.2	108.45	108.07	108.39	2999484.0
2016-03-29 14:00:00	QQQ	ETF	108.387	108.9	108.37	108.68	5086814.0
2016-03-29 15:00:00	QQQ	ETF	108.68	108.88	108.65	108.8	4908975.0
2016-03-29 16:00:00	QQQ	ETF	108.81	108.88	107.089	108.85	966899.0
2016-03-29 17:00:00	QQQ	ETF	108.79	108.79	108.73	108.74	45766.0
2016-03-29 18:00:00	QQQ	ETF	108.79	108.83	108.76	108.82	29726.0
2016-03-29 19:00:00	QQQ	ETF	108.8	108.93	108.8	108.93	16811.0
2016-03-29 05:00:00	IWM	ETF	107.12	107.12	107.12	107.12	100.0
2016-03-29 07:00:00	IWM	ETF	106.77	106.9	106.77	106.9	2600.0
2016-03-29 08:00:00	IWM	ETF	106.83	106.97	106.81	106.97	64089.0
2016-03-29 09:00:00	IWM	ETF	106.88	107.38	106.77	107.35	2068895.0
2016-03-29 10:00:00	IWM	ETF	107.36	107.62	107.23	107.4897	2749158.0
2016-03-29 11:00:00	IWM	ETF	107.5	108.27	107.44	107.98	3833039.0
2016-03-29 12:00:00	IWM	ETF	107.98	108.95	107.95	108.7	7108422.0
2016-03-29 13:00:00	IWM	ETF	108.7	109.17	108.54	109.02	3494283.0
2016-03-29 14:00:00	IWM	ETF	109.03	110.16	108.975	110.01	7877858.0
2016-03-29 15:00:00	IWM	ETF	110.02	110.32	109.88	110.31	8354123.0
2016-03-29 16:00:00	IWM	ETF	110.32	110.5	110.1898	110.4	1969799.0
2016-03-29 17:00:00	IWM	ETF	110.42	110.5	110.42	110.5	6100.0
2016-03-29 18:00:00	IWM	ETF	110.46	110.5	110.46	110.46	2750.0
2016-03-29 19:00:00	IWM	ETF	110.43	110.47	110.42	110.47	15070.0
2016-03-29 07:00:00	DIA	ETF	174.6	174.6	174.6	174.6	2000.0
2016-03-29 08:00:00	DIA	ETF	174.63	174.63	174.49	174.49	500.0
2016-03-29 09:00:00	DIA	ETF	174.49	174.57	174.06	174.48	965292.0
2016-03-29 10:00:00	DIA	ETF	174.48	174.86	174.48	174.74	749858.0
2016-03-29 11:00:00	DIA	ETF	174.74	174.9	174.62	174.75	444386.0

> showing 50 of 8,033 rows — these rows as CSV

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