PREVIEW / etf_1hour / 2016-04-11

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-11.parquet
  size:    250 KB
  rows:    8,048

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-04-11 04:00:00	SPY	ETF	205.21	205.6	205.08	205.16	42962.0
2016-04-11 05:00:00	SPY	ETF	205.1	205.25	205.0	205.1	14351.0
2016-04-11 06:00:00	SPY	ETF	205.14	205.45	205.1	205.34	66827.0
2016-04-11 07:00:00	SPY	ETF	205.33	205.42	205.19	205.21	267639.0
2016-04-11 08:00:00	SPY	ETF	205.23	205.48	203.94	205.48	446061.0
2016-04-11 09:00:00	SPY	ETF	205.49	205.75	205.14	205.625	10564060.0
2016-04-11 10:00:00	SPY	ETF	205.63	206.07	204.97	204.99	13429447.0
2016-04-11 11:00:00	SPY	ETF	205.0	205.25	204.63	205.02	8273862.0
2016-04-11 12:00:00	SPY	ETF	205.02	205.4	204.87	205.375	6282363.0
2016-04-11 13:00:00	SPY	ETF	205.36	205.55	204.94	205.05	5533092.0
2016-04-11 14:00:00	SPY	ETF	205.06	205.32	204.8	205.2035	9692036.0
2016-04-11 15:00:00	SPY	ETF	205.21	205.24	203.91	203.98	19128219.0
2016-04-11 16:00:00	SPY	ETF	203.98	205.6055	203.7	203.75	3587937.0
2016-04-11 17:00:00	SPY	ETF	203.75	203.77	203.68	203.72	647804.0
2016-04-11 18:00:00	SPY	ETF	203.7	203.7	203.43	203.54	1119262.0
2016-04-11 19:00:00	SPY	ETF	203.57	203.71	203.54	203.63	58097.0
2016-04-11 04:00:00	QQQ	ETF	109.51	109.51	109.47	109.47	549.0
2016-04-11 06:00:00	QQQ	ETF	109.39	109.52	109.39	109.48	10499.0
2016-04-11 07:00:00	QQQ	ETF	109.41	109.54	109.41	109.44	29111.0
2016-04-11 08:00:00	QQQ	ETF	109.42	109.59	109.37	109.59	81436.0
2016-04-11 09:00:00	QQQ	ETF	109.6	109.72	109.3	109.67	3229544.0
2016-04-11 10:00:00	QQQ	ETF	109.675	110.02	109.42	109.448	3848874.0
2016-04-11 11:00:00	QQQ	ETF	109.44	109.64	109.1201	109.42	2583911.0
2016-04-11 12:00:00	QQQ	ETF	109.42	109.76	109.33	109.735	1616320.0
2016-04-11 13:00:00	QQQ	ETF	109.73	109.82	109.4	109.47	1369747.0
2016-04-11 14:00:00	QQQ	ETF	109.48	109.624	109.26	109.565	3007310.0
2016-04-11 15:00:00	QQQ	ETF	109.575	109.58	108.585	108.61	5602944.0
2016-04-11 16:00:00	QQQ	ETF	108.62	108.63	108.48	108.49	554973.0
2016-04-11 17:00:00	QQQ	ETF	108.47	108.48	108.45	108.48	954150.0
2016-04-11 18:00:00	QQQ	ETF	108.46	108.46	108.35	108.39	13836.0
2016-04-11 19:00:00	QQQ	ETF	108.41	108.46	108.39	108.44	12810.0
2016-04-11 04:00:00	IWM	ETF	109.84	109.84	109.84	109.84	100.0
2016-04-11 07:00:00	IWM	ETF	109.82	109.82	109.69	109.72	60704.0
2016-04-11 08:00:00	IWM	ETF	109.69	109.81	109.64	109.81	46774.0
2016-04-11 09:00:00	IWM	ETF	109.84	110.12	109.5599	110.06	2681289.0
2016-04-11 10:00:00	IWM	ETF	110.07	110.55	109.61	109.61	5436483.0
2016-04-11 11:00:00	IWM	ETF	109.6	109.6	108.83	109.1	4426325.0
2016-04-11 12:00:00	IWM	ETF	109.105	109.34	108.98	109.295	2114980.0
2016-04-11 13:00:00	IWM	ETF	109.29	109.64	109.26	109.305	1785880.0
2016-04-11 14:00:00	IWM	ETF	109.31	109.52	109.17	109.44	1800801.0
2016-04-11 15:00:00	IWM	ETF	109.45	109.48	108.75	108.77	4188616.0
2016-04-11 16:00:00	IWM	ETF	108.77	110.0366	108.47	108.5	805451.0
2016-04-11 17:00:00	IWM	ETF	108.51	108.52	108.47	108.47	5379.0
2016-04-11 18:00:00	IWM	ETF	108.46	108.51	108.46	108.51	800.0
2016-04-11 19:00:00	IWM	ETF	108.54	108.54	108.54	108.54	200.0
2016-04-11 08:00:00	DIA	ETF	176.15	176.3	176.15	176.3	625.0
2016-04-11 09:00:00	DIA	ETF	176.4	176.8724	176.12	176.83	428711.0
2016-04-11 10:00:00	DIA	ETF	176.87	177.17	176.05	176.06	695851.0
2016-04-11 11:00:00	DIA	ETF	176.07	176.35	175.8999	176.22	431881.0
2016-04-11 12:00:00	DIA	ETF	176.24	176.61	176.12	176.57	285513.0

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

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