PREVIEW / etf_1hour / 2015-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-14.parquet
  size:    229 KB
  rows:    7,391

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-09-14 04:00:00	SPY	ETF	197.28	197.32	196.8	196.95	5108.0
2015-09-14 05:00:00	SPY	ETF	197.17	197.34	197.08	197.24	12946.0
2015-09-14 06:00:00	SPY	ETF	197.27	197.62	197.21	197.4	52697.0
2015-09-14 07:00:00	SPY	ETF	197.44	197.44	196.64	196.68	155055.0
2015-09-14 08:00:00	SPY	ETF	196.68	197.4	196.2	196.79	812878.0
2015-09-14 09:00:00	SPY	ETF	196.79	197.04	195.56	195.85	12296924.0
2015-09-14 10:00:00	SPY	ETF	195.86	196.54	195.77	196.23	12331523.0
2015-09-14 11:00:00	SPY	ETF	196.22	196.43	195.52	195.855	8742418.0
2015-09-14 12:00:00	SPY	ETF	195.85	195.94	195.43	195.655	5934926.0
2015-09-14 13:00:00	SPY	ETF	195.65	196.22	195.48	196.21	6193943.0
2015-09-14 14:00:00	SPY	ETF	196.205	196.21	195.65	195.85	9226312.0
2015-09-14 15:00:00	SPY	ETF	195.86	196.07	195.56	196.0	14013297.0
2015-09-14 16:00:00	SPY	ETF	196.04	196.26	195.9562	196.05	9135383.0
2015-09-14 17:00:00	SPY	ETF	196.04	196.12	196.04	196.09	51671.0
2015-09-14 18:00:00	SPY	ETF	196.07	196.3	196.01	196.18	54020.0
2015-09-14 19:00:00	SPY	ETF	196.2	196.29	196.1	196.29	24848.0
2015-09-14 04:00:00	QQQ	ETF	105.93	105.93	105.93	105.93	200.0
2015-09-14 05:00:00	QQQ	ETF	105.88	105.88	105.88	105.88	100.0
2015-09-14 06:00:00	QQQ	ETF	105.89	106.06	105.89	106.0	8450.0
2015-09-14 07:00:00	QQQ	ETF	105.99	105.99	105.7	105.7	46946.0
2015-09-14 08:00:00	QQQ	ETF	105.69	105.95	105.54	105.86	167881.0
2015-09-14 09:00:00	QQQ	ETF	105.86	105.99	105.06	105.18	4095898.0
2015-09-14 10:00:00	QQQ	ETF	105.16	105.45	105.1	105.24	3742815.0
2015-09-14 11:00:00	QQQ	ETF	105.24	105.39	104.87	105.08	2121892.0
2015-09-14 12:00:00	QQQ	ETF	105.0686	105.18	104.85	105.0	1673831.0
2015-09-14 13:00:00	QQQ	ETF	104.995	105.39	104.91	105.381	1751261.0
2015-09-14 14:00:00	QQQ	ETF	105.37	105.375	105.09	105.22	1616983.0
2015-09-14 15:00:00	QQQ	ETF	105.22	105.34	104.99	105.21	3105423.0
2015-09-14 16:00:00	QQQ	ETF	105.23	105.33	105.19	105.25	615237.0
2015-09-14 17:00:00	QQQ	ETF	105.25	105.25	105.24	105.24	4500.0
2015-09-14 18:00:00	QQQ	ETF	105.26	105.35	105.26	105.3	2561.0
2015-09-14 19:00:00	QQQ	ETF	105.35	105.39	105.27	105.39	12425.0
2015-09-14 04:00:00	IWM	ETF	115.48	115.48	115.48	115.48	200.0
2015-09-14 07:00:00	IWM	ETF	115.49	115.5	115.37	115.4	37556.0
2015-09-14 08:00:00	IWM	ETF	115.38	115.59	115.3	115.48	167171.0
2015-09-14 09:00:00	IWM	ETF	115.48	115.62	114.5	114.8	4471122.0
2015-09-14 10:00:00	IWM	ETF	114.8	115.09	114.72	114.9	2928321.0
2015-09-14 11:00:00	IWM	ETF	114.9	115.06	114.435	114.79	2035356.0
2015-09-14 12:00:00	IWM	ETF	114.79	114.88	114.55	114.71	1538785.0
2015-09-14 13:00:00	IWM	ETF	114.7	114.81	114.43	114.77	1509131.0
2015-09-14 14:00:00	IWM	ETF	114.7668	114.78	114.53	114.66	1087288.0
2015-09-14 15:00:00	IWM	ETF	114.6568	114.79	114.5	114.65	2583593.0
2015-09-14 16:00:00	IWM	ETF	114.68	114.79	114.65	114.66	1259676.0
2015-09-14 17:00:00	IWM	ETF	114.66	114.66	114.66	114.66	300.0
2015-09-14 04:00:00	DIA	ETF	164.69	164.69	164.39	164.39	1000.0
2015-09-14 07:00:00	DIA	ETF	164.45	164.45	164.45	164.45	100.0
2015-09-14 09:00:00	DIA	ETF	164.33	164.58	163.37	163.61	751886.0
2015-09-14 10:00:00	DIA	ETF	163.62	164.34	163.54	164.08	732172.0
2015-09-14 11:00:00	DIA	ETF	164.07	164.21	163.45	163.7	511289.0
2015-09-14 12:00:00	DIA	ETF	163.72	163.8	163.4	163.56	455943.0

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

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