PREVIEW / etf_1hour / 2018-04-18

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-18.parquet
  size:    299 KB
  rows:    9,788

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
2018-04-18 04:00:00	SPY	ETF	270.63	270.9	270.63	270.77	10150.0
2018-04-18 05:00:00	SPY	ETF	270.7	270.78	270.67	270.68	2955.0
2018-04-18 06:00:00	SPY	ETF	270.52	270.98	270.52	270.96	14449.0
2018-04-18 07:00:00	SPY	ETF	270.95	271.35	270.95	271.31	219374.0
2018-04-18 08:00:00	SPY	ETF	270.89	271.37	270.54	271.05	418353.0
2018-04-18 09:00:00	SPY	ETF	271.04	271.14	270.46	270.705	6463706.0
2018-04-18 10:00:00	SPY	ETF	270.7	270.98	269.87	270.95	9570859.0
2018-04-18 11:00:00	SPY	ETF	270.95	271.3	270.75	270.75	4887997.0
2018-04-18 12:00:00	SPY	ETF	270.76	271.14	270.6	270.915	5457286.0
2018-04-18 13:00:00	SPY	ETF	270.91	271.1569	270.54	270.571	5787139.0
2018-04-18 14:00:00	SPY	ETF	270.57	271.19	270.36	270.87	5760364.0
2018-04-18 15:00:00	SPY	ETF	270.87	271.13	270.34	270.37	11092553.0
2018-04-18 16:00:00	SPY	ETF	270.37	270.6	270.19	270.55	5656411.0
2018-04-18 17:00:00	SPY	ETF	270.57	270.68	270.39	270.63	434703.0
2018-04-18 18:00:00	SPY	ETF	270.63	270.72	270.58	270.64	138372.0
2018-04-18 19:00:00	SPY	ETF	270.7	270.8	270.65	270.8	34000.0
2018-04-18 04:00:00	QQQ	ETF	166.54	166.66	166.54	166.55	8568.0
2018-04-18 05:00:00	QQQ	ETF	166.56	166.63	166.37	166.38	30556.0
2018-04-18 06:00:00	QQQ	ETF	166.34	166.55	166.3	166.55	12099.0
2018-04-18 07:00:00	QQQ	ETF	166.56	166.79	166.51	166.67	103667.0
2018-04-18 08:00:00	QQQ	ETF	166.56	166.75	166.41	166.47	130096.0
2018-04-18 09:00:00	QQQ	ETF	166.45	166.48	165.7008	165.97	4565566.0
2018-04-18 10:00:00	QQQ	ETF	165.98	166.34	165.31	166.3	4246178.0
2018-04-18 11:00:00	QQQ	ETF	166.3	166.68	166.25	166.38	2316899.0
2018-04-18 12:00:00	QQQ	ETF	166.38	166.79	166.38	166.689	1665046.0
2018-04-18 13:00:00	QQQ	ETF	166.685	166.83	166.38	166.4174	1790074.0
2018-04-18 14:00:00	QQQ	ETF	166.41	167.0	166.25	166.71	2828263.0
2018-04-18 15:00:00	QQQ	ETF	166.71	166.93	166.38	166.4	4645118.0
2018-04-18 16:00:00	QQQ	ETF	166.4	166.5	166.34	166.47	2874161.0
2018-04-18 17:00:00	QQQ	ETF	166.52	166.69	166.52	166.69	20005.0
2018-04-18 18:00:00	QQQ	ETF	166.68	166.83	166.64	166.75	23853.0
2018-04-18 19:00:00	QQQ	ETF	166.76	166.92	166.76	166.92	20927.0
2018-04-18 04:00:00	IWM	ETF	157.55	157.61	157.51	157.51	2749.0
2018-04-18 06:00:00	IWM	ETF	157.47	157.61	157.47	157.61	2200.0
2018-04-18 07:00:00	IWM	ETF	157.61	157.84	157.61	157.75	37404.0
2018-04-18 08:00:00	IWM	ETF	157.77	157.8	157.64	157.68	19067.0
2018-04-18 09:00:00	IWM	ETF	157.6	157.7	157.24	157.48	1673312.0
2018-04-18 10:00:00	IWM	ETF	157.47	157.92	157.16	157.88	1692658.0
2018-04-18 11:00:00	IWM	ETF	157.88	158.16	157.79	157.8292	1381910.0
2018-04-18 12:00:00	IWM	ETF	157.84	158.24	157.84	158.21	1663790.0
2018-04-18 13:00:00	IWM	ETF	158.21	158.38	157.72	157.76	1621398.0
2018-04-18 14:00:00	IWM	ETF	157.75	158.08	157.57	157.79	1761745.0
2018-04-18 15:00:00	IWM	ETF	157.785	157.91	157.33	157.43	2624754.0
2018-04-18 16:00:00	IWM	ETF	157.43	158.15	157.38	157.65	1565384.0
2018-04-18 17:00:00	IWM	ETF	157.6	157.64	157.6	157.64	600.0
2018-04-18 18:00:00	IWM	ETF	157.69	157.79	157.68	157.73	9088.0
2018-04-18 19:00:00	IWM	ETF	157.76	157.84	157.73	157.82	6678.0
2018-04-18 07:00:00	DIA	ETF	248.0	248.24	248.0	248.15	6725.0
2018-04-18 08:00:00	DIA	ETF	248.2	248.26	248.04	248.13	7378.0
2018-04-18 09:00:00	DIA	ETF	248.19	248.2214	247.7	247.83	502308.0

> showing 50 of 9,788 rows — these rows as CSV

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