PREVIEW / etf_1hour / 2017-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-12.parquet
  size:    271 KB
  rows:    8,754

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-04-12 04:00:00	SPY	ETF	235.4	235.48	235.24	235.3	6645.0
2017-04-12 05:00:00	SPY	ETF	235.21	235.38	235.14	235.14	8840.0
2017-04-12 06:00:00	SPY	ETF	235.17	235.17	234.89	234.89	6458.0
2017-04-12 07:00:00	SPY	ETF	234.97	235.03	234.7	234.78	226888.0
2017-04-12 08:00:00	SPY	ETF	234.82	235.06	234.61	234.69	276488.0
2017-04-12 09:00:00	SPY	ETF	234.69	234.87	234.38	234.6553	6628319.0
2017-04-12 10:00:00	SPY	ETF	234.65	234.96	234.18	234.265	9229808.0
2017-04-12 11:00:00	SPY	ETF	234.27	234.44	233.77	234.01	6056098.0
2017-04-12 12:00:00	SPY	ETF	234.0139	234.24	233.82	233.9398	4256131.0
2017-04-12 13:00:00	SPY	ETF	233.93	234.65	233.93	234.62	7626880.0
2017-04-12 14:00:00	SPY	ETF	234.6092	234.66	233.92	234.21	10054586.0
2017-04-12 15:00:00	SPY	ETF	234.205	234.36	233.86	234.1	20852766.0
2017-04-12 16:00:00	SPY	ETF	234.1	235.0235	233.92	233.92	12965738.0
2017-04-12 17:00:00	SPY	ETF	233.95	234.03	233.9	233.92	1970111.0
2017-04-12 18:00:00	SPY	ETF	233.89	234.14	233.89	234.08	120074.0
2017-04-12 19:00:00	SPY	ETF	234.08	234.1	234.0	234.0	26967.0
2017-04-12 04:00:00	QQQ	ETF	131.63	131.75	131.63	131.67	7198.0
2017-04-12 06:00:00	QQQ	ETF	131.55	131.55	131.51	131.51	600.0
2017-04-12 07:00:00	QQQ	ETF	131.45	131.46	131.36	131.39	2150.0
2017-04-12 08:00:00	QQQ	ETF	131.36	131.45	131.29	131.35	80589.0
2017-04-12 09:00:00	QQQ	ETF	131.37	131.54	131.21	131.394	2078923.0
2017-04-12 10:00:00	QQQ	ETF	131.395	131.5	131.055	131.1	2058656.0
2017-04-12 11:00:00	QQQ	ETF	131.11	131.25	130.78	130.939	1773693.0
2017-04-12 12:00:00	QQQ	ETF	130.94	131.05	130.78	130.851	1049593.0
2017-04-12 13:00:00	QQQ	ETF	130.86	131.28	130.83	131.26	1790585.0
2017-04-12 14:00:00	QQQ	ETF	131.27	131.29	130.86	131.04	1590662.0
2017-04-12 15:00:00	QQQ	ETF	131.04	131.12	130.8007	130.93	4218328.0
2017-04-12 16:00:00	QQQ	ETF	130.94	131.38	130.78	130.8	622855.0
2017-04-12 17:00:00	QQQ	ETF	130.78	130.87	130.77	130.81	1592.0
2017-04-12 18:00:00	QQQ	ETF	130.79	130.93	130.79	130.87	18297.0
2017-04-12 19:00:00	QQQ	ETF	130.88	130.9	130.84	130.84	5489.0
2017-04-12 04:00:00	IWM	ETF	137.14	137.18	137.14	137.14	700.0
2017-04-12 05:00:00	IWM	ETF	137.13	137.13	137.05	137.05	1600.0
2017-04-12 06:00:00	IWM	ETF	136.84	136.84	136.81	136.81	783.0
2017-04-12 07:00:00	IWM	ETF	136.94	136.95	136.63	136.74	25632.0
2017-04-12 08:00:00	IWM	ETF	136.75	136.9	136.62	136.65	76039.0
2017-04-12 09:00:00	IWM	ETF	136.67	136.73	136.23	136.32	2586013.0
2017-04-12 10:00:00	IWM	ETF	136.33	136.48	135.02	135.34	5430396.0
2017-04-12 11:00:00	IWM	ETF	135.34	135.62	135.02	135.24	3223272.0
2017-04-12 12:00:00	IWM	ETF	135.25	135.52	135.07	135.19	1694604.0
2017-04-12 13:00:00	IWM	ETF	135.19	135.93	135.19	135.917	2065901.0
2017-04-12 14:00:00	IWM	ETF	135.92	135.93	135.23	135.43	2788675.0
2017-04-12 15:00:00	IWM	ETF	135.425	135.47	134.92	135.09	5122997.0
2017-04-12 16:00:00	IWM	ETF	135.08	135.16	134.82	134.82	1191674.0
2017-04-12 17:00:00	IWM	ETF	134.82	135.0667	134.82	134.86	78699.0
2017-04-12 18:00:00	IWM	ETF	134.94	134.94	134.94	134.94	985.0
2017-04-12 19:00:00	IWM	ETF	134.97	134.97	134.97	134.97	977.0
2017-04-12 08:00:00	DIA	ETF	206.19	206.19	206.19	206.19	100.0
2017-04-12 09:00:00	DIA	ETF	206.29	206.3	205.91	206.02	214400.0
2017-04-12 10:00:00	DIA	ETF	206.02	206.21	205.7	205.77	203062.0

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

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