PREVIEW / etf_1hour / 2016-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-19.parquet
  size:    272 KB
  rows:    8,830

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-12-19 04:00:00	SPY	ETF	225.5	225.5	225.49	225.49	4000.0
2016-12-19 05:00:00	SPY	ETF	225.63	225.63	225.63	225.63	100.0
2016-12-19 06:00:00	SPY	ETF	225.52	225.53	225.42	225.42	41270.0
2016-12-19 07:00:00	SPY	ETF	225.46	225.51	225.4	225.5	77132.0
2016-12-19 08:00:00	SPY	ETF	225.63	225.63	225.04	225.31	7338391.0
2016-12-19 09:00:00	SPY	ETF	225.32	225.77	225.08	225.52	8708151.0
2016-12-19 10:00:00	SPY	ETF	225.52	225.92	225.42	225.835	9795814.0
2016-12-19 11:00:00	SPY	ETF	225.83	226.02	225.3	225.31	9498390.0
2016-12-19 12:00:00	SPY	ETF	225.31	225.69	225.26	225.61	8513091.0
2016-12-19 13:00:00	SPY	ETF	225.61	225.8	225.46	225.79	8631975.0
2016-12-19 14:00:00	SPY	ETF	225.79	225.9	225.39	225.425	9294304.0
2016-12-19 15:00:00	SPY	ETF	225.42	225.55	225.11	225.49	18617325.0
2016-12-19 16:00:00	SPY	ETF	225.5	225.76	225.43	225.72	8503406.0
2016-12-19 17:00:00	SPY	ETF	225.68	225.72	225.53	225.68	304211.0
2016-12-19 18:00:00	SPY	ETF	225.68	225.82	225.68	225.78	59288.0
2016-12-19 19:00:00	SPY	ETF	225.75	225.8	225.68	225.79	40278.0
2016-12-19 04:00:00	QQQ	ETF	119.78	119.78	119.72	119.77	800.0
2016-12-19 06:00:00	QQQ	ETF	119.81	119.82	119.81	119.81	5661.0
2016-12-19 07:00:00	QQQ	ETF	119.76	119.8	119.76	119.8	10725.0
2016-12-19 08:00:00	QQQ	ETF	119.75	119.83	119.6226	119.78	93439.0
2016-12-19 09:00:00	QQQ	ETF	119.8	120.28	119.55	120.17	1897268.0
2016-12-19 10:00:00	QQQ	ETF	120.18	120.67	120.12	120.55	3021977.0
2016-12-19 11:00:00	QQQ	ETF	120.54	120.83	120.33	120.3399	2961621.0
2016-12-19 12:00:00	QQQ	ETF	120.32	120.57	120.3035	120.465	956061.0
2016-12-19 13:00:00	QQQ	ETF	120.465	120.5165	120.29	120.4764	1069076.0
2016-12-19 14:00:00	QQQ	ETF	120.47	120.53	120.12	120.15	1264227.0
2016-12-19 15:00:00	QQQ	ETF	120.14	120.2	119.895	120.09	2568566.0
2016-12-19 16:00:00	QQQ	ETF	120.09	120.646	120.09	120.2	411744.0
2016-12-19 17:00:00	QQQ	ETF	120.13	120.3	120.13	120.3	612.0
2016-12-19 18:00:00	QQQ	ETF	120.27	120.27	120.25	120.25	3400.0
2016-12-19 19:00:00	QQQ	ETF	120.29	120.35	120.23	120.25	14454.0
2016-12-19 07:00:00	IWM	ETF	136.23	136.23	136.21	136.23	3370.0
2016-12-19 08:00:00	IWM	ETF	136.21	136.22	136.05	136.12	14956.0
2016-12-19 09:00:00	IWM	ETF	136.13	136.9	135.99	136.47	2940468.0
2016-12-19 10:00:00	IWM	ETF	136.46	137.0	135.91	136.93	5416350.0
2016-12-19 11:00:00	IWM	ETF	136.93	137.11	136.15	136.19	3912582.0
2016-12-19 12:00:00	IWM	ETF	136.18	136.78	136.125	136.75	3677286.0
2016-12-19 13:00:00	IWM	ETF	136.74	137.19	136.71	137.13	4714954.0
2016-12-19 14:00:00	IWM	ETF	137.13	137.14	136.58	136.6	2506721.0
2016-12-19 15:00:00	IWM	ETF	136.58	136.83	136.2	136.76	5129557.0
2016-12-19 16:00:00	IWM	ETF	136.76	136.92	136.72	136.76	1992409.0
2016-12-19 17:00:00	IWM	ETF	136.79	136.79	136.75	136.75	8408.0
2016-12-19 18:00:00	IWM	ETF	136.81	136.84	136.81	136.84	2600.0
2016-12-19 19:00:00	IWM	ETF	136.85	136.89	136.85	136.89	400.0
2016-12-19 05:00:00	DIA	ETF	198.49	198.54	198.49	198.54	300.0
2016-12-19 06:00:00	DIA	ETF	198.57	198.57	198.57	198.57	100.0
2016-12-19 07:00:00	DIA	ETF	198.53	198.54	198.53	198.54	653.0
2016-12-19 08:00:00	DIA	ETF	198.45	198.45	198.3	198.3	2296.0
2016-12-19 09:00:00	DIA	ETF	198.41	198.74	198.21	198.519	396237.0
2016-12-19 10:00:00	DIA	ETF	198.52	198.9	198.46	198.8	322217.0

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

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