PREVIEW / etf_1hour / 2017-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-05.parquet
  size:    280 KB
  rows:    9,034

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-05 04:00:00	SPY	ETF	235.24	235.32	235.2	235.23	9534.0
2017-04-05 05:00:00	SPY	ETF	235.34	235.54	235.34	235.47	22105.0
2017-04-05 06:00:00	SPY	ETF	235.42	235.54	235.4	235.45	156816.0
2017-04-05 07:00:00	SPY	ETF	235.45	235.68	235.26	235.64	226929.0
2017-04-05 08:00:00	SPY	ETF	235.44	236.18	235.3	236.11	813210.0
2017-04-05 09:00:00	SPY	ETF	236.11	236.93	236.04	236.875	8322088.0
2017-04-05 10:00:00	SPY	ETF	236.875	237.39	236.72	237.1	12793783.0
2017-04-05 11:00:00	SPY	ETF	237.105	237.19	236.41	236.75	10041535.0
2017-04-05 12:00:00	SPY	ETF	236.76	237.2	236.71	237.0835	5109290.0
2017-04-05 13:00:00	SPY	ETF	237.08	237.35	237.08	237.24	4923533.0
2017-04-05 14:00:00	SPY	ETF	237.24	237.25	236.02	236.1	14007696.0
2017-04-05 15:00:00	SPY	ETF	236.1	236.33	234.54	234.77	35659044.0
2017-04-05 16:00:00	SPY	ETF	234.77	236.2	234.29	234.43	9514075.0
2017-04-05 17:00:00	SPY	ETF	234.78	234.82	234.35	234.43	314872.0
2017-04-05 18:00:00	SPY	ETF	234.44	234.6	234.3	234.57	376878.0
2017-04-05 19:00:00	SPY	ETF	234.56	234.64	234.3	234.31	112369.0
2017-04-05 04:00:00	QQQ	ETF	132.37	132.42	132.37	132.42	3100.0
2017-04-05 05:00:00	QQQ	ETF	132.53	132.54	132.46	132.46	10200.0
2017-04-05 06:00:00	QQQ	ETF	132.45	132.51	132.44	132.5	8148.0
2017-04-05 07:00:00	QQQ	ETF	132.48	132.57	132.38	132.53	27348.0
2017-04-05 08:00:00	QQQ	ETF	132.45	132.65	132.39	132.59	164109.0
2017-04-05 09:00:00	QQQ	ETF	132.59	133.03	132.56	132.97	2750288.0
2017-04-05 10:00:00	QQQ	ETF	132.965	133.32	132.85	133.28	3651971.0
2017-04-05 11:00:00	QQQ	ETF	133.28	133.39	133.0	133.185	2407127.0
2017-04-05 12:00:00	QQQ	ETF	133.19	133.44	133.17	133.37	1212183.0
2017-04-05 13:00:00	QQQ	ETF	133.38	133.48	133.36	133.42	1579551.0
2017-04-05 14:00:00	QQQ	ETF	133.41	133.41	132.75	132.77	4083142.0
2017-04-05 15:00:00	QQQ	ETF	132.77	132.91	131.72	131.97	8634698.0
2017-04-05 16:00:00	QQQ	ETF	131.97	132.01	131.76	131.79	1043510.0
2017-04-05 17:00:00	QQQ	ETF	131.82	131.86	131.77	131.79	9034.0
2017-04-05 18:00:00	QQQ	ETF	131.83	131.9	131.77	131.89	17033.0
2017-04-05 19:00:00	QQQ	ETF	131.91	131.95	131.77	131.77	24280.0
2017-04-05 04:00:00	IWM	ETF	135.77	135.77	135.77	135.77	255.0
2017-04-05 06:00:00	IWM	ETF	135.91	135.91	135.91	135.91	306.0
2017-04-05 07:00:00	IWM	ETF	135.97	136.2	135.83	136.2	11568.0
2017-04-05 08:00:00	IWM	ETF	136.14	136.81	136.08	136.75	281676.0
2017-04-05 09:00:00	IWM	ETF	136.76	137.3333	136.67	137.17	4630579.0
2017-04-05 10:00:00	IWM	ETF	137.17	137.43	136.45	136.62	4815207.0
2017-04-05 11:00:00	IWM	ETF	136.62	136.67	135.54	135.97	4966068.0
2017-04-05 12:00:00	IWM	ETF	135.98	136.51	135.925	136.39	1999187.0
2017-04-05 13:00:00	IWM	ETF	136.39	136.59	136.17	136.27	1711534.0
2017-04-05 14:00:00	IWM	ETF	136.25	136.37	134.92	135.08	5706177.0
2017-04-05 15:00:00	IWM	ETF	135.07	135.39	134.08	134.32	13417500.0
2017-04-05 16:00:00	IWM	ETF	134.32	134.4	133.75	133.77	1773163.0
2017-04-05 17:00:00	IWM	ETF	133.78	133.89	133.73	133.83	10569.0
2017-04-05 18:00:00	IWM	ETF	133.84	134.0	133.84	134.0	7304.0
2017-04-05 19:00:00	IWM	ETF	133.96	134.04	133.87	133.87	10428.0
2017-04-05 07:00:00	DIA	ETF	206.9	206.9	206.9	206.9	100.0
2017-04-05 08:00:00	DIA	ETF	206.94	207.5	206.79	207.5	34993.0
2017-04-05 09:00:00	DIA	ETF	207.37	208.18	207.37	208.16	483403.0

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

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