PREVIEW / etf_1hour / 2016-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-14.parquet
  size:    258 KB
  rows:    8,212

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-14 04:00:00	SPY	ETF	188.94	189.55	188.45	189.18	43723.0
2016-01-14 05:00:00	SPY	ETF	189.15	189.4	188.5	188.63	45276.0
2016-01-14 06:00:00	SPY	ETF	188.69	188.77	188.09	188.61	289286.0
2016-01-14 07:00:00	SPY	ETF	188.68	189.66	188.6	189.54	646093.0
2016-01-14 08:00:00	SPY	ETF	189.55	190.0	188.55	189.79	5325772.0
2016-01-14 09:00:00	SPY	ETF	189.78	190.02	187.77	187.94	28301822.0
2016-01-14 10:00:00	SPY	ETF	187.94	191.67	187.66	190.835	60419094.0
2016-01-14 11:00:00	SPY	ETF	190.84	191.19	190.0	190.94	22973718.0
2016-01-14 12:00:00	SPY	ETF	190.93	191.78	190.46	191.1	20638291.0
2016-01-14 13:00:00	SPY	ETF	191.1	192.41	191.01	192.231	19387768.0
2016-01-14 14:00:00	SPY	ETF	192.24	193.03	191.83	192.95	25378583.0
2016-01-14 15:00:00	SPY	ETF	192.95	193.26	191.67	191.89	40510900.0
2016-01-14 16:00:00	SPY	ETF	191.88	192.36	191.68	191.77	13015046.0
2016-01-14 17:00:00	SPY	ETF	191.75	191.84	191.32	191.84	654938.0
2016-01-14 18:00:00	SPY	ETF	191.84	192.36	191.72	192.25	845543.0
2016-01-14 19:00:00	SPY	ETF	192.27	192.53	191.75	191.83	188559.0
2016-01-14 20:00:00	SPY	ETF	191.9702	191.9702	191.9702	191.9702	1000000.0
2016-01-14 04:00:00	QQQ	ETF	102.1	102.12	101.82	102.09	6200.0
2016-01-14 05:00:00	QQQ	ETF	102.16	102.16	101.7	101.77	5600.0
2016-01-14 06:00:00	QQQ	ETF	101.8	101.83	101.39	101.66	30483.0
2016-01-14 07:00:00	QQQ	ETF	101.72	102.31	101.66	102.24	42818.0
2016-01-14 08:00:00	QQQ	ETF	102.26	102.46	101.98	102.4	375933.0
2016-01-14 09:00:00	QQQ	ETF	102.39	102.58	100.835	100.91	10462564.0
2016-01-14 10:00:00	QQQ	ETF	100.91	103.471	100.67	102.91	19709609.0
2016-01-14 11:00:00	QQQ	ETF	102.91	103.23	102.48	103.21	7260030.0
2016-01-14 12:00:00	QQQ	ETF	103.215	103.76	102.99	103.41	5869227.0
2016-01-14 13:00:00	QQQ	ETF	103.4132	104.32	103.32	104.26	5753568.0
2016-01-14 14:00:00	QQQ	ETF	104.28	104.9	104.02	104.85	5444350.0
2016-01-14 15:00:00	QQQ	ETF	104.86	104.98	103.97	104.06	11816848.0
2016-01-14 16:00:00	QQQ	ETF	104.05	104.28	101.0	103.73	2770775.0
2016-01-14 17:00:00	QQQ	ETF	103.72	103.77	103.54	103.77	70447.0
2016-01-14 18:00:00	QQQ	ETF	103.81	104.08	103.81	104.0	564621.0
2016-01-14 19:00:00	QQQ	ETF	104.07	104.18	103.76	103.78	38159.0
2016-01-14 05:00:00	IWM	ETF	100.32	100.32	100.31	100.31	200.0
2016-01-14 06:00:00	IWM	ETF	100.44	100.49	100.04	100.36	86021.0
2016-01-14 07:00:00	IWM	ETF	100.35	100.92	100.34	100.89	271248.0
2016-01-14 08:00:00	IWM	ETF	100.86	101.21	100.7	101.03	382035.0
2016-01-14 09:00:00	IWM	ETF	101.01	101.15	99.37	99.43	6475799.0
2016-01-14 10:00:00	IWM	ETF	99.44	101.64	99.19	101.09	14483737.0
2016-01-14 11:00:00	IWM	ETF	101.085	101.25	100.161	100.85	8014076.0
2016-01-14 12:00:00	IWM	ETF	100.85	101.63	100.56	101.12	4670714.0
2016-01-14 13:00:00	IWM	ETF	101.13	102.31	101.03	102.0531	5880617.0
2016-01-14 14:00:00	IWM	ETF	102.06	102.655	101.64	102.62	6169030.0
2016-01-14 15:00:00	IWM	ETF	102.62	102.71	101.72	101.74	9545624.0
2016-01-14 16:00:00	IWM	ETF	101.74	102.17	101.52	101.64	3150379.0
2016-01-14 17:00:00	IWM	ETF	101.6	101.66	101.5	101.66	21819.0
2016-01-14 18:00:00	IWM	ETF	101.72	101.84	101.63	101.84	250765.0
2016-01-14 19:00:00	IWM	ETF	101.92	101.92	101.42	101.8	2771.0
2016-01-14 05:00:00	DIA	ETF	161.5	161.5	161.5	161.5	100.0
2016-01-14 06:00:00	DIA	ETF	160.99	161.3	160.91	161.18	5300.0

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

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