PREVIEW / etf_1hour / 2014-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-18.parquet
  size:    219 KB
  rows:    6,968

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-08-18 04:00:00	SPY	ETF	196.25	196.8	196.25	196.66	37359.0
2014-08-18 05:00:00	SPY	ETF	196.68	196.7	196.55	196.59	86939.0
2014-08-18 06:00:00	SPY	ETF	196.57	196.81	196.57	196.74	270203.0
2014-08-18 07:00:00	SPY	ETF	196.74	196.97	196.67	196.95	403028.0
2014-08-18 08:00:00	SPY	ETF	196.94	196.98	196.71	196.92	513805.0
2014-08-18 09:00:00	SPY	ETF	196.93	197.12	196.69	197.105	9376404.0
2014-08-18 10:00:00	SPY	ETF	197.11	197.4	197.02	197.341	10290955.0
2014-08-18 11:00:00	SPY	ETF	197.35	197.39	197.2	197.32	7084050.0
2014-08-18 12:00:00	SPY	ETF	197.315	197.45	197.28	197.28	5284848.0
2014-08-18 13:00:00	SPY	ETF	197.28	197.37	197.21	197.295	4118341.0
2014-08-18 14:00:00	SPY	ETF	197.29	197.31	197.14	197.21	6355234.0
2014-08-18 15:00:00	SPY	ETF	197.22	197.38	197.13	197.36	16594654.0
2014-08-18 16:00:00	SPY	ETF	197.37	197.44	195.7401	197.44	9425916.0
2014-08-18 17:00:00	SPY	ETF	197.43	197.45	197.38	197.42	125515.0
2014-08-18 18:00:00	SPY	ETF	197.42	197.47	197.41	197.42	89926.0
2014-08-18 19:00:00	SPY	ETF	197.45	197.52	197.45	197.47	119022.0
2014-08-18 04:00:00	QQQ	ETF	97.7	97.9	97.7	97.85	9699.0
2014-08-18 05:00:00	QQQ	ETF	97.81	97.81	97.77	97.77	2600.0
2014-08-18 06:00:00	QQQ	ETF	97.82	97.87	97.82	97.87	15300.0
2014-08-18 07:00:00	QQQ	ETF	97.85	97.95	97.84	97.94	104520.0
2014-08-18 08:00:00	QQQ	ETF	97.95	97.95	97.86	97.91	106518.0
2014-08-18 09:00:00	QQQ	ETF	97.9	98.05	97.77	98.03	4151283.0
2014-08-18 10:00:00	QQQ	ETF	98.02	98.195	97.98	98.19	4391601.0
2014-08-18 11:00:00	QQQ	ETF	98.195	98.21	97.77	98.145	5865398.0
2014-08-18 12:00:00	QQQ	ETF	98.14	98.24	98.09	98.09	4621172.0
2014-08-18 13:00:00	QQQ	ETF	98.095	98.23	98.06	98.17	2547522.0
2014-08-18 14:00:00	QQQ	ETF	98.175	98.205	98.09	98.13	1858314.0
2014-08-18 15:00:00	QQQ	ETF	98.135	98.19	98.05	98.15	9122394.0
2014-08-18 16:00:00	QQQ	ETF	98.15	98.1868	98.0885	98.14	2446863.0
2014-08-18 17:00:00	QQQ	ETF	98.15	98.19	98.14	98.18	20316.0
2014-08-18 18:00:00	QQQ	ETF	98.18	98.18	98.18	98.18	2628.0
2014-08-18 19:00:00	QQQ	ETF	98.19	98.21	98.15	98.15	10877.0
2014-08-18 04:00:00	IWM	ETF	113.9	114.37	113.9	114.37	840.0
2014-08-18 06:00:00	IWM	ETF	114.37	114.5	114.37	114.4	16200.0
2014-08-18 07:00:00	IWM	ETF	114.42	114.61	114.42	114.52	179200.0
2014-08-18 08:00:00	IWM	ETF	114.51	114.54	114.39	114.49	137643.0
2014-08-18 09:00:00	IWM	ETF	114.49	114.55	114.09	114.39	4842683.0
2014-08-18 10:00:00	IWM	ETF	114.41	114.93	114.26	114.91	5195374.0
2014-08-18 11:00:00	IWM	ETF	114.91	114.97	114.74	114.79	2642182.0
2014-08-18 12:00:00	IWM	ETF	114.8	115.135	114.795	114.89	2674559.0
2014-08-18 13:00:00	IWM	ETF	114.89	114.95	114.77	114.79	1123818.0
2014-08-18 14:00:00	IWM	ETF	114.795	114.85	114.665	114.725	1450845.0
2014-08-18 15:00:00	IWM	ETF	114.729	115.08	114.685	115.05	4065357.0
2014-08-18 16:00:00	IWM	ETF	115.05	115.08	114.83	114.9	6262963.0
2014-08-18 17:00:00	IWM	ETF	114.9	114.97	114.89	114.96	18175.0
2014-08-18 18:00:00	IWM	ETF	115.01	115.01	115.01	115.01	100.0
2014-08-18 19:00:00	IWM	ETF	115.0	115.01	115.0	115.0	2300.0
2014-08-18 07:00:00	DIA	ETF	167.25	167.25	167.25	167.25	550.0
2014-08-18 08:00:00	DIA	ETF	167.26	167.3	167.19	167.3	3000.0
2014-08-18 09:00:00	DIA	ETF	167.2	167.68	167.2	167.66	570403.0

> showing 50 of 6,968 rows — these rows as CSV

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