PREVIEW / etf_1hour / 2014-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-07.parquet
  size:    230 KB
  rows:    7,259

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
2014-10-07 04:00:00	SPY	ETF	195.81	195.81	195.0	195.16	7991.0
2014-10-07 05:00:00	SPY	ETF	195.2	195.41	195.06	195.4	44667.0
2014-10-07 06:00:00	SPY	ETF	195.38	195.49	195.3	195.39	49285.0
2014-10-07 07:00:00	SPY	ETF	195.41	195.73	195.3	195.72	617563.0
2014-10-07 08:00:00	SPY	ETF	195.9026	195.92	195.35	195.76	923866.0
2014-10-07 09:00:00	SPY	ETF	195.74	195.79	194.53	195.02	17655552.0
2014-10-07 10:00:00	SPY	ETF	195.0239	195.72	194.96	195.12	21843932.0
2014-10-07 11:00:00	SPY	ETF	195.11	195.2	194.56	195.07	15194149.0
2014-10-07 12:00:00	SPY	ETF	195.08	195.5	194.86	195.0	10860467.0
2014-10-07 13:00:00	SPY	ETF	195.0	195.32	194.74	195.06	8773890.0
2014-10-07 14:00:00	SPY	ETF	195.06	195.13	194.225	194.33	15277948.0
2014-10-07 15:00:00	SPY	ETF	194.32	194.47	193.25	193.26	38084716.0
2014-10-07 16:00:00	SPY	ETF	193.24	196.272	193.03	193.07	14652548.0
2014-10-07 17:00:00	SPY	ETF	193.05	193.14	193.01	193.14	191244.0
2014-10-07 18:00:00	SPY	ETF	193.18	193.24	193.15	193.17	181850.0
2014-10-07 19:00:00	SPY	ETF	193.17	193.4	193.17	193.36	134500.0
2014-10-07 20:00:00	SPY	ETF	193.302	193.302	193.302	193.302	244500.0
2014-10-07 04:00:00	QQQ	ETF	97.61	97.61	97.39	97.45	2900.0
2014-10-07 05:00:00	QQQ	ETF	97.45	97.46	97.39	97.39	9000.0
2014-10-07 06:00:00	QQQ	ETF	97.57	97.63	97.53	97.55	4540.0
2014-10-07 07:00:00	QQQ	ETF	97.58	97.74	97.51	97.74	45688.0
2014-10-07 08:00:00	QQQ	ETF	97.72	97.85	97.7	97.75	132029.0
2014-10-07 09:00:00	QQQ	ETF	97.73	97.79	97.1	97.3	7130094.0
2014-10-07 10:00:00	QQQ	ETF	97.29	97.7799	97.26	97.36	6960396.0
2014-10-07 11:00:00	QQQ	ETF	97.36	97.435	97.08	97.38	4903759.0
2014-10-07 12:00:00	QQQ	ETF	97.38	97.61	97.23	97.265	3125848.0
2014-10-07 13:00:00	QQQ	ETF	97.27	97.405	97.1	97.315	3480056.0
2014-10-07 14:00:00	QQQ	ETF	97.3172	97.35	96.89	96.95	4124616.0
2014-10-07 15:00:00	QQQ	ETF	96.9401	97.07	96.56	96.57	8393413.0
2014-10-07 16:00:00	QQQ	ETF	96.57	97.2631	96.51	96.52	1350257.0
2014-10-07 17:00:00	QQQ	ETF	96.51	96.58	96.45	96.55	165174.0
2014-10-07 18:00:00	QQQ	ETF	96.55	96.62	96.55	96.62	24647.0
2014-10-07 19:00:00	QQQ	ETF	96.61	96.7	96.58	96.69	32040.0
2014-10-07 04:00:00	IWM	ETF	108.31	108.31	107.96	107.96	2014.0
2014-10-07 05:00:00	IWM	ETF	107.9	107.95	107.87	107.95	1600.0
2014-10-07 06:00:00	IWM	ETF	107.97	107.97	107.97	107.97	700.0
2014-10-07 07:00:00	IWM	ETF	108.09	108.18	108.01	108.18	23961.0
2014-10-07 08:00:00	IWM	ETF	108.16	108.35	108.13	108.2	212347.0
2014-10-07 09:00:00	IWM	ETF	108.25	108.3	107.54	108.1	4883286.0
2014-10-07 10:00:00	IWM	ETF	108.1	108.5	107.93	107.97	5814303.0
2014-10-07 11:00:00	IWM	ETF	107.98	108.25	107.72	108.13	4687474.0
2014-10-07 12:00:00	IWM	ETF	108.14	108.471	107.96	108.15	2939748.0
2014-10-07 13:00:00	IWM	ETF	108.17	108.1851	107.76	107.92	2495082.0
2014-10-07 14:00:00	IWM	ETF	107.91	107.94	107.45	107.48	4665472.0
2014-10-07 15:00:00	IWM	ETF	107.48	107.57	106.85	106.9	7686475.0
2014-10-07 16:00:00	IWM	ETF	106.91	107.15	106.71	106.8	2145380.0
2014-10-07 17:00:00	IWM	ETF	106.79	106.82	106.69	106.78	18414.0
2014-10-07 18:00:00	IWM	ETF	106.79	107.0	106.79	106.91	5862.0
2014-10-07 19:00:00	IWM	ETF	106.98	106.98	106.86	106.91	1435.0
2014-10-07 08:00:00	DIA	ETF	169.11	169.11	169.1	169.1	2350.0

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

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