PREVIEW / etf_1hour / 2016-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-27.parquet
  size:    275 KB
  rows:    8,912

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-06-27 04:00:00	SPY	ETF	202.3	202.5	201.52	201.86	181705.0
2016-06-27 05:00:00	SPY	ETF	201.76	202.14	201.46	201.55	60838.0
2016-06-27 06:00:00	SPY	ETF	201.53	201.6	200.88	200.9	223021.0
2016-06-27 07:00:00	SPY	ETF	200.88	201.2	200.54	200.66	755789.0
2016-06-27 08:00:00	SPY	ETF	200.66	201.52	200.57	201.41	2305579.0
2016-06-27 09:00:00	SPY	ETF	201.42	201.66	200.27	200.47	33976067.0
2016-06-27 10:00:00	SPY	ETF	200.46	200.86	198.71	198.84	43525186.0
2016-06-27 11:00:00	SPY	ETF	198.84	200.07	198.65	199.75	29997902.0
2016-06-27 12:00:00	SPY	ETF	199.75	200.17	199.37	199.73	18786937.0
2016-06-27 13:00:00	SPY	ETF	199.74	200.18	199.19	199.44	16092223.0
2016-06-27 14:00:00	SPY	ETF	199.44	199.75	198.88	199.02	23039116.0
2016-06-27 15:00:00	SPY	ETF	199.02	199.9664	198.66	199.59	46096773.0
2016-06-27 16:00:00	SPY	ETF	199.59	199.6341	198.66	198.72	25398676.0
2016-06-27 17:00:00	SPY	ETF	198.75	198.83	198.67	198.77	861061.0
2016-06-27 18:00:00	SPY	ETF	198.77	199.6	198.77	199.42	1337216.0
2016-06-27 19:00:00	SPY	ETF	199.4	199.59	199.28	199.46	108244.0
2016-06-27 04:00:00	QQQ	ETF	103.93	103.98	103.77	103.77	2433.0
2016-06-27 05:00:00	QQQ	ETF	103.66	103.7	103.4	103.49	11232.0
2016-06-27 06:00:00	QQQ	ETF	103.45	103.55	103.15	103.24	56569.0
2016-06-27 07:00:00	QQQ	ETF	103.24	103.32	102.95	103.03	218044.0
2016-06-27 08:00:00	QQQ	ETF	103.02	103.43	103.0	103.38	236939.0
2016-06-27 09:00:00	QQQ	ETF	103.38	103.6	102.81	102.94	5038859.0
2016-06-27 10:00:00	QQQ	ETF	102.94	103.15	101.83	101.9	8962650.0
2016-06-27 11:00:00	QQQ	ETF	101.905	102.555	101.77	102.34	6836491.0
2016-06-27 12:00:00	QQQ	ETF	102.33	102.672	102.18	102.45	3871619.0
2016-06-27 13:00:00	QQQ	ETF	102.45	102.67	102.0841	102.18	3590469.0
2016-06-27 14:00:00	QQQ	ETF	102.19	102.34	101.84	101.94	3723610.0
2016-06-27 15:00:00	QQQ	ETF	101.94	102.46	101.75	102.29	8666863.0
2016-06-27 16:00:00	QQQ	ETF	102.28	102.29	101.9	101.9	2007186.0
2016-06-27 17:00:00	QQQ	ETF	101.85	101.99	101.79	101.92	18969.0
2016-06-27 18:00:00	QQQ	ETF	101.94	102.28	101.94	102.27	42204.0
2016-06-27 19:00:00	QQQ	ETF	102.27	102.36	102.22	102.29	36628.0
2016-06-27 04:00:00	IWM	ETF	111.42	111.5	110.66	110.83	3983.0
2016-06-27 05:00:00	IWM	ETF	111.0	111.0	110.76	110.76	3302.0
2016-06-27 06:00:00	IWM	ETF	110.71	110.71	110.52	110.52	14266.0
2016-06-27 07:00:00	IWM	ETF	110.46	110.67	110.23	110.26	106346.0
2016-06-27 08:00:00	IWM	ETF	110.52	110.72	110.25	110.61	474347.0
2016-06-27 09:00:00	IWM	ETF	110.62	111.07	110.13	110.14	7277285.0
2016-06-27 10:00:00	IWM	ETF	110.13	110.43	108.35	108.41	13239307.0
2016-06-27 11:00:00	IWM	ETF	108.41	109.26	108.21	109.11	10045006.0
2016-06-27 12:00:00	IWM	ETF	109.11	109.57	108.84	109.48	3831316.0
2016-06-27 13:00:00	IWM	ETF	109.48	109.66	108.8901	109.02	4548836.0
2016-06-27 14:00:00	IWM	ETF	109.01	109.07	108.19	108.375	5254331.0
2016-06-27 15:00:00	IWM	ETF	108.375	109.01	108.35	108.68	8116577.0
2016-06-27 16:00:00	IWM	ETF	108.68	108.72	107.9	107.9	1821865.0
2016-06-27 17:00:00	IWM	ETF	107.93	108.06	107.9	108.0	24690.0
2016-06-27 18:00:00	IWM	ETF	108.08	108.49	108.08	108.4	8815.0
2016-06-27 19:00:00	IWM	ETF	108.46	108.57	108.45	108.57	4433.0
2016-06-27 04:00:00	DIA	ETF	173.05	173.05	172.56	172.56	400.0
2016-06-27 05:00:00	DIA	ETF	172.66	172.66	172.66	172.66	100.0

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

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