PREVIEW / etf_1hour / 2016-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-08.parquet
  size:    260 KB
  rows:    8,227

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-01-08 04:00:00	SPY	ETF	196.24	196.45	195.87	196.25	89472.0
2016-01-08 05:00:00	SPY	ETF	196.2	196.29	195.38	195.6	56424.0
2016-01-08 06:00:00	SPY	ETF	195.6	195.64	194.33	194.75	258146.0
2016-01-08 07:00:00	SPY	ETF	194.73	195.59	194.67	195.43	681156.0
2016-01-08 08:00:00	SPY	ETF	195.42	196.98	194.74	195.9	5997633.0
2016-01-08 09:00:00	SPY	ETF	195.9	196.11	194.73	195.4589	23470859.0
2016-01-08 10:00:00	SPY	ETF	195.46	195.46	194.1	194.31	27509294.0
2016-01-08 11:00:00	SPY	ETF	194.31	195.19	192.99	194.12	24331617.0
2016-01-08 12:00:00	SPY	ETF	194.125	194.85	193.95	194.3	13563600.0
2016-01-08 13:00:00	SPY	ETF	194.3	194.55	193.57	193.88	11567087.0
2016-01-08 14:00:00	SPY	ETF	193.89	194.25	193.16	193.355	21827799.0
2016-01-08 15:00:00	SPY	ETF	193.35	193.635	191.58	191.89	55054728.0
2016-01-08 16:00:00	SPY	ETF	191.92	193.7245	191.55	191.85	22037205.0
2016-01-08 17:00:00	SPY	ETF	191.85	192.05	191.83	191.95	785760.0
2016-01-08 18:00:00	SPY	ETF	191.95	192.17	191.95	192.1	149612.0
2016-01-08 19:00:00	SPY	ETF	192.1	192.12	191.75	191.75	94374.0
2016-01-08 20:00:00	SPY	ETF	191.9654	191.9654	191.9654	191.9654	200000.0
2016-01-08 04:00:00	QQQ	ETF	106.13	106.25	105.99	106.17	12045.0
2016-01-08 05:00:00	QQQ	ETF	106.11	106.11	105.7	105.82	600.0
2016-01-08 06:00:00	QQQ	ETF	105.72	105.79	105.3	105.39	15873.0
2016-01-08 07:00:00	QQQ	ETF	105.42	105.82	105.42	105.78	47928.0
2016-01-08 08:00:00	QQQ	ETF	105.65	106.65	105.45	105.88	1112181.0
2016-01-08 09:00:00	QQQ	ETF	105.91	106.29	104.8925	106.28	9418050.0
2016-01-08 10:00:00	QQQ	ETF	106.27	106.27	105.24	105.35	8037730.0
2016-01-08 11:00:00	QQQ	ETF	105.37	105.55	104.41	105.21	6650835.0
2016-01-08 12:00:00	QQQ	ETF	105.21	105.8	105.185	105.42	4192854.0
2016-01-08 13:00:00	QQQ	ETF	105.405	105.56	105.0	105.21	3941806.0
2016-01-08 14:00:00	QQQ	ETF	105.23	105.35	104.73	104.8501	5219592.0
2016-01-08 15:00:00	QQQ	ETF	104.8599	105.07	103.9	104.02	13905112.0
2016-01-08 16:00:00	QQQ	ETF	104.02	104.35	103.88	104.1	4414580.0
2016-01-08 17:00:00	QQQ	ETF	104.1	104.22	104.07	104.15	12594.0
2016-01-08 18:00:00	QQQ	ETF	104.14	104.18	104.01	104.07	20246.0
2016-01-08 19:00:00	QQQ	ETF	104.1	104.16	104.04	104.11	7065.0
2016-01-08 04:00:00	IWM	ETF	106.61	106.95	105.7	106.5	39975.0
2016-01-08 05:00:00	IWM	ETF	106.29	106.29	106.1	106.1	1100.0
2016-01-08 06:00:00	IWM	ETF	106.0	106.0	105.7	105.7	2860.0
2016-01-08 07:00:00	IWM	ETF	105.9	106.1	105.74	106.06	21016.0
2016-01-08 08:00:00	IWM	ETF	106.06	107.09	105.96	106.36	978875.0
2016-01-08 09:00:00	IWM	ETF	106.38	106.55	105.79	106.12	7383993.0
2016-01-08 10:00:00	IWM	ETF	106.11	106.12	104.9	105.025	9954447.0
2016-01-08 11:00:00	IWM	ETF	105.03	105.22	104.48	105.115	6878453.0
2016-01-08 12:00:00	IWM	ETF	105.12	105.47	105.0125	105.24	4089679.0
2016-01-08 13:00:00	IWM	ETF	105.25	105.36	104.84	104.89	3478750.0
2016-01-08 14:00:00	IWM	ETF	104.9	105.14	104.75	104.82	3871536.0
2016-01-08 15:00:00	IWM	ETF	104.81	104.941	103.66	103.83	10774048.0
2016-01-08 16:00:00	IWM	ETF	103.84	104.11	103.71	103.79	1754374.0
2016-01-08 17:00:00	IWM	ETF	103.87	104.0	103.77	103.95	17991.0
2016-01-08 18:00:00	IWM	ETF	103.9	103.9	103.84	103.85	1410.0
2016-01-08 20:00:00	IWM	ETF	103.8653	103.8653	103.8653	103.8653	140000.0
2016-01-08 04:00:00	DIA	ETF	167.0	167.0	167.0	167.0	200.0

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

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