PREVIEW / etf_1hour / 2014-04-24

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-24.parquet
  size:    213 KB
  rows:    6,743

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-04-24 04:00:00	SPY	ETF	188.52	188.53	188.5	188.52	2842.0
2014-04-24 05:00:00	SPY	ETF	188.52	188.53	188.43	188.48	6783.0
2014-04-24 06:00:00	SPY	ETF	188.44	188.69	188.44	188.58	22672.0
2014-04-24 07:00:00	SPY	ETF	188.63	188.67	188.41	188.46	470715.0
2014-04-24 08:00:00	SPY	ETF	188.6	188.79	188.42	188.52	1051873.0
2014-04-24 09:00:00	SPY	ETF	188.52	188.54	187.06	187.47	18797545.0
2014-04-24 10:00:00	SPY	ETF	187.48	187.815	186.93	187.64	18742843.0
2014-04-24 11:00:00	SPY	ETF	187.64	188.3	187.53	188.0899	11523689.0
2014-04-24 12:00:00	SPY	ETF	188.08	188.24	187.95	188.17	7064898.0
2014-04-24 13:00:00	SPY	ETF	188.165	188.22	187.46	187.5	8585453.0
2014-04-24 14:00:00	SPY	ETF	187.5001	187.86	187.44	187.75	8050715.0
2014-04-24 15:00:00	SPY	ETF	187.74	187.96	187.67	187.82	9246376.0
2014-04-24 16:00:00	SPY	ETF	187.83	188.09	187.79	187.94	3455793.0
2014-04-24 17:00:00	SPY	ETF	187.92	187.95	187.83	187.83	103324.0
2014-04-24 18:00:00	SPY	ETF	187.81	187.82	187.65	187.79	50721.0
2014-04-24 19:00:00	SPY	ETF	187.76	187.84	187.76	187.79	8545.0
2014-04-24 04:00:00	QQQ	ETF	87.89	88.0	87.89	88.0	11121.0
2014-04-24 05:00:00	QQQ	ETF	87.98	87.98	87.94	87.96	4632.0
2014-04-24 06:00:00	QQQ	ETF	88.0	88.24	88.0	88.2	40234.0
2014-04-24 07:00:00	QQQ	ETF	88.2	88.2	88.06	88.12	173212.0
2014-04-24 08:00:00	QQQ	ETF	88.15	88.47	88.08	88.3	949187.0
2014-04-24 09:00:00	QQQ	ETF	88.29	88.32	86.93	87.14	15297749.0
2014-04-24 10:00:00	QQQ	ETF	87.14	87.371	86.65	87.35	12934108.0
2014-04-24 11:00:00	QQQ	ETF	87.34	87.74	87.24	87.6301	4691308.0
2014-04-24 12:00:00	QQQ	ETF	87.63	87.77	87.54	87.72	2157913.0
2014-04-24 13:00:00	QQQ	ETF	87.73	87.76	87.34	87.35	2901858.0
2014-04-24 14:00:00	QQQ	ETF	87.36	87.59	87.335	87.53	2884488.0
2014-04-24 15:00:00	QQQ	ETF	87.54	87.7	87.53	87.6	3935120.0
2014-04-24 16:00:00	QQQ	ETF	87.59	87.95	87.5555	87.84	947383.0
2014-04-24 17:00:00	QQQ	ETF	87.84	87.85	87.7	87.73	51074.0
2014-04-24 18:00:00	QQQ	ETF	87.71	87.74	87.62	87.68	18052.0
2014-04-24 19:00:00	QQQ	ETF	87.67	87.7	87.66	87.66	12900.0
2014-04-24 06:00:00	IWM	ETF	114.71	114.79	114.71	114.79	25500.0
2014-04-24 07:00:00	IWM	ETF	114.69	114.72	114.59	114.64	110266.0
2014-04-24 08:00:00	IWM	ETF	114.69	114.87	114.56	114.68	533826.0
2014-04-24 09:00:00	IWM	ETF	114.68	114.7	112.78	113.26	8020250.0
2014-04-24 10:00:00	IWM	ETF	113.26	113.84	112.68	113.54	11176879.0
2014-04-24 11:00:00	IWM	ETF	113.5499	114.29	113.38	114.02	5747346.0
2014-04-24 12:00:00	IWM	ETF	114.01	114.23	113.81	114.17	1700944.0
2014-04-24 13:00:00	IWM	ETF	114.18	114.245	113.35	113.38	2779216.0
2014-04-24 14:00:00	IWM	ETF	113.38	113.68	113.285	113.44	3400578.0
2014-04-24 15:00:00	IWM	ETF	113.44	113.72	113.43	113.63	4669497.0
2014-04-24 16:00:00	IWM	ETF	113.63	114.0978	113.58	113.7	2493261.0
2014-04-24 17:00:00	IWM	ETF	113.67	113.71	113.61	113.62	4370.0
2014-04-24 18:00:00	IWM	ETF	113.61	113.61	113.52	113.57	3991.0
2014-04-24 19:00:00	IWM	ETF	113.69	113.69	113.51	113.51	819.0
2014-04-24 07:00:00	DIA	ETF	165.3	165.32	165.18	165.18	2400.0
2014-04-24 08:00:00	DIA	ETF	165.25	165.38	165.14	165.16	8222.0
2014-04-24 09:00:00	DIA	ETF	165.15	165.15	164.2298	164.48	1012126.0
2014-04-24 10:00:00	DIA	ETF	164.47	164.75	164.19	164.6199	950702.0

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

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