PREVIEW / etf_1hour / 2016-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-26.parquet
  size:    255 KB
  rows:    8,191

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
2016-10-26 04:00:00	SPY	ETF	213.62	213.64	213.31	213.42	14804.0
2016-10-26 05:00:00	SPY	ETF	213.27	213.39	213.07	213.39	13424.0
2016-10-26 06:00:00	SPY	ETF	213.34	213.45	213.3	213.4	41482.0
2016-10-26 07:00:00	SPY	ETF	213.4	213.5	213.3	213.49	221573.0
2016-10-26 08:00:00	SPY	ETF	213.43	213.818	213.38	213.43	414491.0
2016-10-26 09:00:00	SPY	ETF	213.44	213.48	212.93	213.14	11221991.0
2016-10-26 10:00:00	SPY	ETF	213.145	214.295	213.02	214.23	13962353.0
2016-10-26 11:00:00	SPY	ETF	214.2201	214.42	214.07	214.1	11442128.0
2016-10-26 12:00:00	SPY	ETF	214.095	214.21	213.99	214.03	6117565.0
2016-10-26 13:00:00	SPY	ETF	214.03	214.11	213.26	213.41	6926537.0
2016-10-26 14:00:00	SPY	ETF	213.41	213.87	213.15	213.79	7463016.0
2016-10-26 15:00:00	SPY	ETF	213.79	213.99	213.63	213.74	10708956.0
2016-10-26 16:00:00	SPY	ETF	213.75	214.0	213.6893	213.81	4934715.0
2016-10-26 17:00:00	SPY	ETF	213.77	213.86	213.76	213.8	601563.0
2016-10-26 18:00:00	SPY	ETF	213.79	213.82	213.71	213.79	78701.0
2016-10-26 19:00:00	SPY	ETF	213.76	213.81	213.73	213.79	19317.0
2016-10-26 04:00:00	QQQ	ETF	118.78	118.78	118.6	118.6	5500.0
2016-10-26 05:00:00	QQQ	ETF	118.41	118.51	118.41	118.48	998.0
2016-10-26 06:00:00	QQQ	ETF	118.53	118.53	118.49	118.49	11460.0
2016-10-26 07:00:00	QQQ	ETF	118.53	118.58	118.51	118.58	118199.0
2016-10-26 08:00:00	QQQ	ETF	118.5	118.69	118.5	118.57	83001.0
2016-10-26 09:00:00	QQQ	ETF	118.55	118.56	118.08	118.23	3170891.0
2016-10-26 10:00:00	QQQ	ETF	118.23	118.85	118.15	118.82	3158951.0
2016-10-26 11:00:00	QQQ	ETF	118.83	119.03	118.69	118.72	1721877.0
2016-10-26 12:00:00	QQQ	ETF	118.72	118.8	118.64	118.66	1280633.0
2016-10-26 13:00:00	QQQ	ETF	118.67	118.72	118.12	118.2	1807280.0
2016-10-26 14:00:00	QQQ	ETF	118.2	118.48	118.03	118.45	1813303.0
2016-10-26 15:00:00	QQQ	ETF	118.44	118.53	118.33	118.39	4289216.0
2016-10-26 16:00:00	QQQ	ETF	118.39	118.43	118.3	118.36	749010.0
2016-10-26 17:00:00	QQQ	ETF	118.31	118.41	118.31	118.37	1412.0
2016-10-26 18:00:00	QQQ	ETF	118.37	118.41	118.33	118.38	9389.0
2016-10-26 19:00:00	QQQ	ETF	118.36	118.4	118.34	118.35	1553.0
2016-10-26 04:00:00	IWM	ETF	120.59	120.59	120.22	120.22	848.0
2016-10-26 05:00:00	IWM	ETF	120.22	120.22	120.03	120.03	1550.0
2016-10-26 06:00:00	IWM	ETF	120.24	120.24	120.18	120.18	887.0
2016-10-26 07:00:00	IWM	ETF	120.26	120.28	120.21	120.26	99034.0
2016-10-26 08:00:00	IWM	ETF	120.28	120.42	120.19	120.28	64469.0
2016-10-26 09:00:00	IWM	ETF	120.25	120.67	120.08	120.24	2784444.0
2016-10-26 10:00:00	IWM	ETF	120.23	120.88	120.15	120.7999	4186445.0
2016-10-26 11:00:00	IWM	ETF	120.8	121.0	120.44	120.489	2001907.0
2016-10-26 12:00:00	IWM	ETF	120.485	120.57	120.35	120.35	995457.0
2016-10-26 13:00:00	IWM	ETF	120.35	120.4499	119.58	119.68	3806638.0
2016-10-26 14:00:00	IWM	ETF	119.68	119.82	119.46	119.79	3391140.0
2016-10-26 15:00:00	IWM	ETF	119.78	119.86	119.68	119.76	3270062.0
2016-10-26 16:00:00	IWM	ETF	119.73	120.35	119.67	119.73	749534.0
2016-10-26 17:00:00	IWM	ETF	119.7	119.77	119.7	119.77	26482.0
2016-10-26 18:00:00	IWM	ETF	119.73	119.77	119.7	119.77	488803.0
2016-10-26 19:00:00	IWM	ETF	119.73	119.73	119.7	119.7	1393.0
2016-10-26 04:00:00	DIA	ETF	181.0	181.0	181.0	181.0	200.0
2016-10-26 06:00:00	DIA	ETF	180.86	180.88	180.86	180.88	3000.0

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

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