PREVIEW / etf_1hour / 2016-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-14.parquet
  size:    246 KB
  rows:    7,954

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-03-14 04:00:00	SPY	ETF	202.28	202.65	202.25	202.25	34674.0
2016-03-14 05:00:00	SPY	ETF	202.41	202.6	202.23	202.23	18736.0
2016-03-14 06:00:00	SPY	ETF	202.2	202.39	202.1	202.25	28288.0
2016-03-14 07:00:00	SPY	ETF	202.25	202.28	201.98	202.01	347067.0
2016-03-14 08:00:00	SPY	ETF	202.05	202.64	201.99	202.06	744105.0
2016-03-14 09:00:00	SPY	ETF	202.06	202.4	201.8	201.85	9357072.0
2016-03-14 10:00:00	SPY	ETF	201.85	202.5263	201.77	202.185	10691116.0
2016-03-14 11:00:00	SPY	ETF	202.18	202.45	202.04	202.1	6363656.0
2016-03-14 12:00:00	SPY	ETF	202.1	202.65	202.01	202.61	6595587.0
2016-03-14 13:00:00	SPY	ETF	202.61	202.75	202.5299	202.59	6518202.0
2016-03-14 14:00:00	SPY	ETF	202.58	202.925	202.38	202.84	10272902.0
2016-03-14 15:00:00	SPY	ETF	202.84	203.04	202.48	202.495	16688909.0
2016-03-14 16:00:00	SPY	ETF	202.5	202.64	202.43	202.46	4319026.0
2016-03-14 17:00:00	SPY	ETF	202.51	202.54	202.45	202.45	50313.0
2016-03-14 18:00:00	SPY	ETF	202.47	202.53	202.42	202.51	45247.0
2016-03-14 19:00:00	SPY	ETF	202.51	202.56	202.47	202.5	77296.0
2016-03-14 04:00:00	QQQ	ETF	106.43	106.43	106.22	106.22	460.0
2016-03-14 05:00:00	QQQ	ETF	106.38	106.38	106.38	106.38	300.0
2016-03-14 06:00:00	QQQ	ETF	106.15	106.25	106.15	106.21	1450.0
2016-03-14 07:00:00	QQQ	ETF	106.22	106.22	106.01	106.01	10387.0
2016-03-14 08:00:00	QQQ	ETF	106.16	106.16	106.0	106.04	102900.0
2016-03-14 09:00:00	QQQ	ETF	106.05	106.4	106.01	106.19	3074415.0
2016-03-14 10:00:00	QQQ	ETF	106.19	106.69	106.17	106.51	3309123.0
2016-03-14 11:00:00	QQQ	ETF	106.51	106.75	106.465	106.55	2044558.0
2016-03-14 12:00:00	QQQ	ETF	106.55	106.84	106.515	106.8	1912579.0
2016-03-14 13:00:00	QQQ	ETF	106.81	106.84	106.71	106.72	1219957.0
2016-03-14 14:00:00	QQQ	ETF	106.72	106.8299	106.545	106.81	1807320.0
2016-03-14 15:00:00	QQQ	ETF	106.81	106.92	106.63	106.64	3443889.0
2016-03-14 16:00:00	QQQ	ETF	106.62	106.72	106.5061	106.63	1957005.0
2016-03-14 17:00:00	QQQ	ETF	106.64	106.64	106.57	106.62	17330.0
2016-03-14 18:00:00	QQQ	ETF	106.58	106.63	106.57	106.6	55173.0
2016-03-14 19:00:00	QQQ	ETF	106.66	106.66	106.6	106.63	5676.0
2016-03-14 05:00:00	IWM	ETF	108.0	108.0	108.0	108.0	2500.0
2016-03-14 06:00:00	IWM	ETF	107.99	108.09	107.99	108.02	4600.0
2016-03-14 07:00:00	IWM	ETF	107.96	108.04	107.88	107.88	10200.0
2016-03-14 08:00:00	IWM	ETF	107.9	107.97	107.83	107.83	37741.0
2016-03-14 09:00:00	IWM	ETF	107.82	108.05	107.6	107.66	3182802.0
2016-03-14 10:00:00	IWM	ETF	107.66	108.08	107.56	107.82	3202762.0
2016-03-14 11:00:00	IWM	ETF	107.82	108.03	107.475	107.5	1701735.0
2016-03-14 12:00:00	IWM	ETF	107.5	107.835	107.4	107.835	1786784.0
2016-03-14 13:00:00	IWM	ETF	107.835	108.24	107.81	108.16	1993911.0
2016-03-14 14:00:00	IWM	ETF	108.17	108.34	108.02	108.25	1999208.0
2016-03-14 15:00:00	IWM	ETF	108.24	108.26	107.9	107.91	3471870.0
2016-03-14 16:00:00	IWM	ETF	107.92	107.9493	107.78	107.84	2500309.0
2016-03-14 17:00:00	IWM	ETF	107.82	108.0	107.82	107.9	36906.0
2016-03-14 18:00:00	IWM	ETF	107.85	107.85	107.82	107.84	5600.0
2016-03-14 19:00:00	IWM	ETF	107.84	107.84	107.82	107.83	1600.0
2016-03-14 08:00:00	DIA	ETF	171.77	171.77	171.56	171.77	2400.0
2016-03-14 09:00:00	DIA	ETF	171.55	172.1	171.55	171.78	306007.0
2016-03-14 10:00:00	DIA	ETF	171.76	172.39	171.74	172.09	492584.0

> showing 50 of 7,954 rows — these rows as CSV

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