PREVIEW / etf_1hour / 2015-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-28.parquet
  size:    249 KB
  rows:    7,937

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
2015-12-28 04:00:00	SPY	ETF	205.75	205.75	204.91	205.06	7553.0
2015-12-28 05:00:00	SPY	ETF	204.9	204.96	204.83	204.84	9284.0
2015-12-28 06:00:00	SPY	ETF	204.87	204.9	204.75	204.8	30046.0
2015-12-28 07:00:00	SPY	ETF	204.8	204.85	204.42	204.59	142271.0
2015-12-28 08:00:00	SPY	ETF	204.76	204.82	204.5	204.73	557025.0
2015-12-28 09:00:00	SPY	ETF	204.72	205.05	204.53	204.73	7633852.0
2015-12-28 10:00:00	SPY	ETF	204.73	204.74	203.94	204.06	10514140.0
2015-12-28 11:00:00	SPY	ETF	204.065	204.68	203.99	204.46	9323532.0
2015-12-28 12:00:00	SPY	ETF	204.465	204.69	204.325	204.45	7590598.0
2015-12-28 13:00:00	SPY	ETF	204.45	205.26	204.44	204.72	8032805.0
2015-12-28 14:00:00	SPY	ETF	204.72	205.07	204.68	205.005	5521039.0
2015-12-28 15:00:00	SPY	ETF	205.0	205.23	204.8	205.19	12799867.0
2015-12-28 16:00:00	SPY	ETF	205.19	205.51	204.6975	205.42	3205405.0
2015-12-28 17:00:00	SPY	ETF	205.43	205.43	205.22	205.38	53312.0
2015-12-28 18:00:00	SPY	ETF	205.39	205.44	205.28	205.31	92641.0
2015-12-28 19:00:00	SPY	ETF	205.31	205.38	205.2	205.31	66499.0
2015-12-28 04:00:00	QQQ	ETF	112.4	112.4	112.35	112.35	300.0
2015-12-28 05:00:00	QQQ	ETF	112.19	112.19	112.17	112.17	900.0
2015-12-28 06:00:00	QQQ	ETF	112.23	112.23	112.1	112.1	1524.0
2015-12-28 07:00:00	QQQ	ETF	112.14	112.14	111.99	112.07	9525.0
2015-12-28 08:00:00	QQQ	ETF	112.1	112.24	112.05	112.21	185727.0
2015-12-28 09:00:00	QQQ	ETF	112.21	112.37	112.11	112.19	3212539.0
2015-12-28 10:00:00	QQQ	ETF	112.191	112.2	111.51	111.58	3771439.0
2015-12-28 11:00:00	QQQ	ETF	111.57	112.07	111.53	111.95	1830434.0
2015-12-28 12:00:00	QQQ	ETF	111.95	112.06	111.82	111.98	1213899.0
2015-12-28 13:00:00	QQQ	ETF	111.971	112.42	111.97	112.18	1580651.0
2015-12-28 14:00:00	QQQ	ETF	112.18	112.38	112.17	112.33	1700908.0
2015-12-28 15:00:00	QQQ	ETF	112.33	112.55	112.21	112.51	2511610.0
2015-12-28 16:00:00	QQQ	ETF	112.52	112.65	112.43	112.62	433716.0
2015-12-28 17:00:00	QQQ	ETF	112.53	112.65	112.53	112.62	430.0
2015-12-28 18:00:00	QQQ	ETF	112.61	112.61	112.54	112.54	4251.0
2015-12-28 19:00:00	QQQ	ETF	112.53	112.56	112.49	112.56	5200.0
2015-12-28 04:00:00	IWM	ETF	114.1	114.24	114.0	114.0	300.0
2015-12-28 05:00:00	IWM	ETF	113.92	113.96	113.92	113.96	200.0
2015-12-28 06:00:00	IWM	ETF	113.96	113.96	113.89	113.89	200.0
2015-12-28 07:00:00	IWM	ETF	113.85	113.85	113.76	113.81	13897.0
2015-12-28 08:00:00	IWM	ETF	113.84	113.9	113.81	113.88	86478.0
2015-12-28 09:00:00	IWM	ETF	113.9	114.07	113.6	113.64	1713255.0
2015-12-28 10:00:00	IWM	ETF	113.62	113.62	112.955	113.13	4016850.0
2015-12-28 11:00:00	IWM	ETF	113.12	113.55	113.055	113.265	2575718.0
2015-12-28 12:00:00	IWM	ETF	113.26	113.48	113.05	113.31	1604085.0
2015-12-28 13:00:00	IWM	ETF	113.3	113.9031	113.3	113.48	1839784.0
2015-12-28 14:00:00	IWM	ETF	113.49	113.83	113.46	113.785	1708295.0
2015-12-28 15:00:00	IWM	ETF	113.79	113.95	113.665	113.94	3035188.0
2015-12-28 16:00:00	IWM	ETF	113.96	114.03	113.86	114.0	775105.0
2015-12-28 17:00:00	IWM	ETF	113.94	113.97	113.94	113.97	406.0
2015-12-28 19:00:00	IWM	ETF	113.86	113.86	113.86	113.86	100.0
2015-12-28 07:00:00	DIA	ETF	174.42	174.42	174.25	174.35	400.0
2015-12-28 08:00:00	DIA	ETF	174.35	174.46	174.31	174.46	900.0
2015-12-28 09:00:00	DIA	ETF	174.35	174.8106	174.32	174.71	346802.0

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

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