PREVIEW / etf_1hour / 2017-03-29

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-29.parquet
  size:    270 KB
  rows:    8,737

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
2017-03-29 04:00:00	SPY	ETF	235.26	235.43	235.07	235.07	1873.0
2017-03-29 05:00:00	SPY	ETF	235.03	235.08	234.89	234.93	5309.0
2017-03-29 06:00:00	SPY	ETF	234.96	234.96	234.77	234.88	44132.0
2017-03-29 07:00:00	SPY	ETF	234.92	234.99	234.82	234.97	86377.0
2017-03-29 08:00:00	SPY	ETF	234.92	235.12	234.85	235.0	142504.0
2017-03-29 09:00:00	SPY	ETF	235.0	235.26	234.725	235.2559	7252156.0
2017-03-29 10:00:00	SPY	ETF	235.26	235.719	235.07	235.595	10152410.0
2017-03-29 11:00:00	SPY	ETF	235.58	235.63	235.03	235.33	5988301.0
2017-03-29 12:00:00	SPY	ETF	235.32	235.51	235.17	235.23	3514117.0
2017-03-29 13:00:00	SPY	ETF	235.24	235.6	235.21	235.59	3368708.0
2017-03-29 14:00:00	SPY	ETF	235.59	235.75	235.43	235.675	4992571.0
2017-03-29 15:00:00	SPY	ETF	235.675	235.81	235.45	235.59	11533201.0
2017-03-29 16:00:00	SPY	ETF	235.59	235.71	235.2651	235.49	12299692.0
2017-03-29 17:00:00	SPY	ETF	235.49	235.54	235.3117	235.54	1103720.0
2017-03-29 18:00:00	SPY	ETF	235.48	235.59	235.42	235.56	24455.0
2017-03-29 19:00:00	SPY	ETF	235.56	235.6	235.52	235.57	45603.0
2017-03-29 04:00:00	QQQ	ETF	131.76	131.85	131.71	131.78	26559.0
2017-03-29 05:00:00	QQQ	ETF	131.7	131.7	131.59	131.62	36700.0
2017-03-29 06:00:00	QQQ	ETF	131.61	131.61	131.57	131.59	8999.0
2017-03-29 07:00:00	QQQ	ETF	131.65	131.66	131.6	131.63	22832.0
2017-03-29 08:00:00	QQQ	ETF	131.62	131.75	131.59	131.71	98140.0
2017-03-29 09:00:00	QQQ	ETF	131.73	131.97	131.59	131.96	1525373.0
2017-03-29 10:00:00	QQQ	ETF	131.97	132.13	131.85	132.02	2076344.0
2017-03-29 11:00:00	QQQ	ETF	132.025	132.06	131.7389	131.851	1546975.0
2017-03-29 12:00:00	QQQ	ETF	131.869	132.03	131.82	131.89	1062776.0
2017-03-29 13:00:00	QQQ	ETF	131.89	132.14	131.88	132.12	896032.0
2017-03-29 14:00:00	QQQ	ETF	132.1155	132.21	132.03	132.18	1038513.0
2017-03-29 15:00:00	QQQ	ETF	132.18	132.3	132.1436	132.25	2920840.0
2017-03-29 16:00:00	QQQ	ETF	132.23	132.35	132.2146	132.3	1343913.0
2017-03-29 17:00:00	QQQ	ETF	132.27	132.4	132.0	132.24	50875.0
2017-03-29 18:00:00	QQQ	ETF	132.23	132.31	132.13	132.28	21664.0
2017-03-29 19:00:00	QQQ	ETF	132.3	132.35	132.3	132.32	6847.0
2017-03-29 04:00:00	IWM	ETF	135.87	135.87	135.65	135.65	2958.0
2017-03-29 05:00:00	IWM	ETF	135.33	135.33	135.33	135.33	5000.0
2017-03-29 06:00:00	IWM	ETF	135.3	135.3	135.3	135.3	4995.0
2017-03-29 07:00:00	IWM	ETF	135.32	135.4	135.26	135.4	20929.0
2017-03-29 08:00:00	IWM	ETF	135.37	135.6	135.3	135.57	56388.0
2017-03-29 09:00:00	IWM	ETF	135.55	135.9	135.3	135.9	2257273.0
2017-03-29 10:00:00	IWM	ETF	135.9	136.42	135.75	136.24	4021146.0
2017-03-29 11:00:00	IWM	ETF	136.23	136.3	135.82	136.055	2045284.0
2017-03-29 12:00:00	IWM	ETF	136.05	136.22	135.85	135.88	1768039.0
2017-03-29 13:00:00	IWM	ETF	135.88	136.35	135.87	136.3	1294034.0
2017-03-29 14:00:00	IWM	ETF	136.3	136.49	136.16	136.44	1482094.0
2017-03-29 15:00:00	IWM	ETF	136.45	136.48	136.16	136.28	4179501.0
2017-03-29 16:00:00	IWM	ETF	136.27	136.36	136.22	136.35	724983.0
2017-03-29 17:00:00	IWM	ETF	136.32	136.38	136.3	136.38	14082.0
2017-03-29 18:00:00	IWM	ETF	136.29	136.29	136.29	136.29	1243.0
2017-03-29 19:00:00	IWM	ETF	136.3	136.35	136.26	136.35	987.0
2017-03-29 04:00:00	DIA	ETF	206.6	206.6	206.6	206.6	400.0
2017-03-29 06:00:00	DIA	ETF	206.62	206.62	206.62	206.62	250.0

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

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