PREVIEW / etf_1hour / 2016-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-27.parquet
  size:    253 KB
  rows:    8,119

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-27 04:00:00	SPY	ETF	189.03	189.13	188.62	188.8	34889.0
2016-01-27 05:00:00	SPY	ETF	188.9	189.3	188.66	189.21	17770.0
2016-01-27 06:00:00	SPY	ETF	189.09	189.27	188.67	188.91	69990.0
2016-01-27 07:00:00	SPY	ETF	188.98	189.45	188.87	189.38	484289.0
2016-01-27 08:00:00	SPY	ETF	189.38	189.89	188.88	189.74	1098122.0
2016-01-27 09:00:00	SPY	ETF	189.72	189.99	189.33	189.59	10578841.0
2016-01-27 10:00:00	SPY	ETF	189.58	189.69	188.55	189.22	19929840.0
2016-01-27 11:00:00	SPY	ETF	189.225	191.24	189.02	191.009	19419984.0
2016-01-27 12:00:00	SPY	ETF	190.995	191.56	190.76	190.77	12442785.0
2016-01-27 13:00:00	SPY	ETF	190.76	191.09	190.435	190.96	11486707.0
2016-01-27 14:00:00	SPY	ETF	190.96	191.49	188.37	188.58	47157367.0
2016-01-27 15:00:00	SPY	ETF	188.57	188.59	187.06	188.12	52183449.0
2016-01-27 16:00:00	SPY	ETF	188.13	188.5	187.94	188.39	7631145.0
2016-01-27 17:00:00	SPY	ETF	188.36	188.79	188.13	188.57	868712.0
2016-01-27 18:00:00	SPY	ETF	188.59	188.83	187.83	187.92	368274.0
2016-01-27 19:00:00	SPY	ETF	187.95	187.99	187.17	187.79	271364.0
2016-01-27 20:00:00	SPY	ETF	188.1368	188.1368	188.1368	188.1368	90000.0
2016-01-27 04:00:00	QQQ	ETF	102.21	102.24	101.99	101.99	7762.0
2016-01-27 05:00:00	QQQ	ETF	102.05	102.3	102.05	102.3	7550.0
2016-01-27 06:00:00	QQQ	ETF	102.23	102.26	102.05	102.13	12850.0
2016-01-27 07:00:00	QQQ	ETF	102.19	102.52	102.11	102.51	38530.0
2016-01-27 08:00:00	QQQ	ETF	102.52	102.78	102.41	102.69	322061.0
2016-01-27 09:00:00	QQQ	ETF	102.68	102.79	102.12	102.1901	5245418.0
2016-01-27 10:00:00	QQQ	ETF	102.19	102.23	101.37	101.76	6543079.0
2016-01-27 11:00:00	QQQ	ETF	101.76	102.66	101.63	102.551	4416216.0
2016-01-27 12:00:00	QQQ	ETF	102.56	102.99	102.48	102.49	3945660.0
2016-01-27 13:00:00	QQQ	ETF	102.49	102.66	102.15	102.45	3817129.0
2016-01-27 14:00:00	QQQ	ETF	102.455	102.76	100.87	100.98	10510242.0
2016-01-27 15:00:00	QQQ	ETF	100.97	100.98	100.15	100.58	11596673.0
2016-01-27 16:00:00	QQQ	ETF	100.59	101.16	100.41	101.16	1090736.0
2016-01-27 17:00:00	QQQ	ETF	101.18	101.59	101.05	101.4	104821.0
2016-01-27 18:00:00	QQQ	ETF	101.4	101.54	101.05	101.05	223028.0
2016-01-27 19:00:00	QQQ	ETF	101.07	101.15	100.77	101.05	83464.0
2016-01-27 04:00:00	IWM	ETF	100.0	100.0	100.0	100.0	100.0
2016-01-27 06:00:00	IWM	ETF	100.28	100.28	100.07	100.16	4700.0
2016-01-27 07:00:00	IWM	ETF	100.2	100.52	100.2	100.48	104544.0
2016-01-27 08:00:00	IWM	ETF	100.44	100.85	100.44	100.75	170241.0
2016-01-27 09:00:00	IWM	ETF	100.75	101.03	100.46	100.6	3423196.0
2016-01-27 10:00:00	IWM	ETF	100.6	100.83	100.0439	100.62	5535970.0
2016-01-27 11:00:00	IWM	ETF	100.61	101.45	100.41	101.2407	3810787.0
2016-01-27 12:00:00	IWM	ETF	101.24	101.59	100.75	100.9	3393417.0
2016-01-27 13:00:00	IWM	ETF	100.89	101.1	100.54	101.06	3690806.0
2016-01-27 14:00:00	IWM	ETF	101.07	101.28	99.805	99.905	10373438.0
2016-01-27 15:00:00	IWM	ETF	99.88	99.89	99.06	99.675	11038826.0
2016-01-27 16:00:00	IWM	ETF	99.67	99.83	99.48	99.75	1419150.0
2016-01-27 17:00:00	IWM	ETF	99.75	99.97	99.75	99.9	220665.0
2016-01-27 18:00:00	IWM	ETF	99.8	99.81	99.61	99.73	16100.0
2016-01-27 19:00:00	IWM	ETF	99.6	99.6	99.21	99.5	4449.0
2016-01-27 20:00:00	IWM	ETF	99.6049	99.6049	99.6049	99.6049	300000.0
2016-01-27 07:00:00	DIA	ETF	160.59	160.71	160.59	160.71	300.0

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

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