PREVIEW / etf_1hour / 2015-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-07-10.parquet
  size:    246 KB
  rows:    7,919

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-07-10 04:00:00	SPY	ETF	206.97	207.2	206.59	206.59	59476.0
2015-07-10 05:00:00	SPY	ETF	206.6	206.91	206.44	206.8	81282.0
2015-07-10 06:00:00	SPY	ETF	206.8	207.26	206.8	207.2	168297.0
2015-07-10 07:00:00	SPY	ETF	207.2	207.4	206.99	207.2	1017884.0
2015-07-10 08:00:00	SPY	ETF	206.64	207.43	206.64	207.39	1388642.0
2015-07-10 09:00:00	SPY	ETF	207.38	207.49	206.85	206.88	18669789.0
2015-07-10 10:00:00	SPY	ETF	206.87	207.2	206.49	206.94	14927889.0
2015-07-10 11:00:00	SPY	ETF	206.945	207.74	206.9	207.57	15554870.0
2015-07-10 12:00:00	SPY	ETF	207.56	207.69	207.22	207.51	11092601.0
2015-07-10 13:00:00	SPY	ETF	207.51	207.61	207.11	207.26	11901202.0
2015-07-10 14:00:00	SPY	ETF	207.26	207.83	207.205	207.765	15948953.0
2015-07-10 15:00:00	SPY	ETF	207.76	207.98	207.44	207.46	29349063.0
2015-07-10 16:00:00	SPY	ETF	207.47	207.61	206.5	207.51	7537690.0
2015-07-10 17:00:00	SPY	ETF	207.51	207.65	204.9517	207.49	1078415.0
2015-07-10 18:00:00	SPY	ETF	207.48	207.86	207.41	207.747	127806.0
2015-07-10 19:00:00	SPY	ETF	207.7	207.79	207.68	207.79	21309.0
2015-07-10 04:00:00	QQQ	ETF	107.02	107.02	106.95	106.95	6850.0
2015-07-10 05:00:00	QQQ	ETF	106.9	107.09	106.9	107.09	11500.0
2015-07-10 06:00:00	QQQ	ETF	107.14	107.28	107.12	107.28	35098.0
2015-07-10 07:00:00	QQQ	ETF	107.29	107.37	107.24	107.31	113886.0
2015-07-10 08:00:00	QQQ	ETF	107.29	107.38	107.25	107.363	223154.0
2015-07-10 09:00:00	QQQ	ETF	107.36	107.475	107.19	107.2155	4449962.0
2015-07-10 10:00:00	QQQ	ETF	107.22	107.45	107.05	107.37	3532673.0
2015-07-10 11:00:00	QQQ	ETF	107.37	107.86	107.35	107.72	3262477.0
2015-07-10 12:00:00	QQQ	ETF	107.73	107.82	107.56	107.74	1292265.0
2015-07-10 13:00:00	QQQ	ETF	107.74	107.77	107.53	107.63	1313737.0
2015-07-10 14:00:00	QQQ	ETF	107.62	107.995	107.59	107.94	2068296.0
2015-07-10 15:00:00	QQQ	ETF	107.93	108.05	107.66	107.66	5036203.0
2015-07-10 16:00:00	QQQ	ETF	107.67	107.73	107.52	107.64	798806.0
2015-07-10 17:00:00	QQQ	ETF	107.65	107.75	107.65	107.75	92565.0
2015-07-10 18:00:00	QQQ	ETF	107.65	107.75	107.65	107.75	1926.0
2015-07-10 19:00:00	QQQ	ETF	107.71	107.73	107.71	107.73	4561.0
2015-07-10 05:00:00	IWM	ETF	123.39	123.39	123.39	123.39	500.0
2015-07-10 06:00:00	IWM	ETF	123.76	123.76	123.5	123.67	20000.0
2015-07-10 07:00:00	IWM	ETF	123.63	123.88	123.63	123.88	181097.0
2015-07-10 08:00:00	IWM	ETF	123.84	123.97	123.72	123.96	202735.0
2015-07-10 09:00:00	IWM	ETF	123.96	124.11	123.61	123.68	4196110.0
2015-07-10 10:00:00	IWM	ETF	123.69	123.87	123.36	123.7	2711117.0
2015-07-10 11:00:00	IWM	ETF	123.69	124.29	123.68	124.07	3176682.0
2015-07-10 12:00:00	IWM	ETF	124.08	124.14	123.76	123.965	1808762.0
2015-07-10 13:00:00	IWM	ETF	123.96	124.09	123.81	123.965	1980592.0
2015-07-10 14:00:00	IWM	ETF	123.96	124.14	123.915	124.12	1733872.0
2015-07-10 15:00:00	IWM	ETF	124.11	124.34	124.05	124.15	6090290.0
2015-07-10 16:00:00	IWM	ETF	124.14	124.1794	123.82	123.88	2917001.0
2015-07-10 17:00:00	IWM	ETF	123.89	124.14	123.85	123.92	40243.0
2015-07-10 19:00:00	IWM	ETF	124.0	124.05	124.0	124.0	914.0
2015-07-10 06:00:00	DIA	ETF	176.93	177.08	176.93	177.08	970.0
2015-07-10 07:00:00	DIA	ETF	177.1	177.21	177.0	177.07	7688.0
2015-07-10 08:00:00	DIA	ETF	176.96	177.25	176.96	177.25	13700.0
2015-07-10 09:00:00	DIA	ETF	177.25	177.54	177.0036	177.02	687880.0

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

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