PREVIEW / etf_1hour / 2017-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-26.parquet
  size:    277 KB
  rows:    8,950

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-01-26 04:00:00	SPY	ETF	229.71	229.78	229.69	229.78	8199.0
2017-01-26 05:00:00	SPY	ETF	229.74	229.74	229.64	229.69	5800.0
2017-01-26 06:00:00	SPY	ETF	229.68	229.68	229.47	229.55	4657.0
2017-01-26 07:00:00	SPY	ETF	229.6	229.6	229.43	229.44	126929.0
2017-01-26 08:00:00	SPY	ETF	229.52	229.58	229.32	229.52	457343.0
2017-01-26 09:00:00	SPY	ETF	229.5	229.66	229.24	229.56	5930949.0
2017-01-26 10:00:00	SPY	ETF	229.555	229.71	229.3	229.39	7980851.0
2017-01-26 11:00:00	SPY	ETF	229.39	229.54	229.26	229.32	5939180.0
2017-01-26 12:00:00	SPY	ETF	229.33	229.4	229.14	229.29	4159415.0
2017-01-26 13:00:00	SPY	ETF	229.29	229.34	229.01	229.32	6860438.0
2017-01-26 14:00:00	SPY	ETF	229.315	229.52	229.22	229.375	6593587.0
2017-01-26 15:00:00	SPY	ETF	229.37	229.43	229.085	229.3	13585322.0
2017-01-26 16:00:00	SPY	ETF	229.31	229.53	229.2666	229.48	6479104.0
2017-01-26 17:00:00	SPY	ETF	229.47	229.56	229.2666	229.43	336260.0
2017-01-26 18:00:00	SPY	ETF	229.43	229.48	229.31	229.33	94499.0
2017-01-26 19:00:00	SPY	ETF	229.33	229.33	229.22	229.26	30107.0
2017-01-26 04:00:00	QQQ	ETF	125.71	125.82	125.69	125.74	3302.0
2017-01-26 06:00:00	QQQ	ETF	125.7	125.7	125.62	125.63	54497.0
2017-01-26 07:00:00	QQQ	ETF	125.65	125.71	125.61	125.61	56541.0
2017-01-26 08:00:00	QQQ	ETF	125.67	125.67	125.52	125.59	135499.0
2017-01-26 09:00:00	QQQ	ETF	125.59	125.82	125.48	125.64	2216214.0
2017-01-26 10:00:00	QQQ	ETF	125.64	125.69	125.4	125.4381	2910764.0
2017-01-26 11:00:00	QQQ	ETF	125.44	125.63	125.3438	125.509	1838532.0
2017-01-26 12:00:00	QQQ	ETF	125.51	125.635	125.45	125.58	1233528.0
2017-01-26 13:00:00	QQQ	ETF	125.58	125.65	125.44	125.56	909744.0
2017-01-26 14:00:00	QQQ	ETF	125.57	125.76	125.5361	125.629	1165185.0
2017-01-26 15:00:00	QQQ	ETF	125.62	125.65	125.46	125.53	2264412.0
2017-01-26 16:00:00	QQQ	ETF	125.54	125.8	125.31	125.47	1774823.0
2017-01-26 17:00:00	QQQ	ETF	125.4	125.5434	125.28	125.36	276163.0
2017-01-26 18:00:00	QQQ	ETF	125.35	125.38	125.25	125.31	31113.0
2017-01-26 19:00:00	QQQ	ETF	125.35	125.36	125.29	125.36	10715.0
2017-01-26 04:00:00	IWM	ETF	137.6	137.6	137.6	137.6	100.0
2017-01-26 05:00:00	IWM	ETF	137.55	137.55	137.55	137.55	900.0
2017-01-26 06:00:00	IWM	ETF	137.5	137.5	137.46	137.46	799.0
2017-01-26 07:00:00	IWM	ETF	137.45	137.5	137.38	137.38	24494.0
2017-01-26 08:00:00	IWM	ETF	137.39	137.47	137.23	137.43	87894.0
2017-01-26 09:00:00	IWM	ETF	137.44	137.5	136.99	137.43	2722399.0
2017-01-26 10:00:00	IWM	ETF	137.42	137.47	136.58	136.66	3052341.0
2017-01-26 11:00:00	IWM	ETF	136.66	136.975	136.5	136.82	2562487.0
2017-01-26 12:00:00	IWM	ETF	136.83	136.84	136.48	136.7099	1538759.0
2017-01-26 13:00:00	IWM	ETF	136.71	136.73	136.42	136.67	1578938.0
2017-01-26 14:00:00	IWM	ETF	136.68	136.85	136.57	136.66	1905955.0
2017-01-26 15:00:00	IWM	ETF	136.65	136.77	136.53	136.71	3782348.0
2017-01-26 16:00:00	IWM	ETF	136.72	136.83	136.66	136.8	991815.0
2017-01-26 17:00:00	IWM	ETF	136.73	136.82	136.72	136.72	1836.0
2017-01-26 18:00:00	IWM	ETF	136.74	136.74	136.66	136.71	5454.0
2017-01-26 19:00:00	IWM	ETF	136.7	136.7	136.45	136.45	12912.0
2017-01-26 04:00:00	DIA	ETF	200.59	200.87	200.59	200.87	450.0
2017-01-26 07:00:00	DIA	ETF	200.8	200.8	200.59	200.59	1764.0
2017-01-26 08:00:00	DIA	ETF	200.75	200.75	200.51	200.65	2764.0

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

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