PREVIEW / etf_1hour / 2014-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-04.parquet
  size:    225 KB
  rows:    7,057

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-04 04:00:00	SPY	ETF	192.99	193.02	192.73	192.84	24721.0
2014-08-04 05:00:00	SPY	ETF	192.9	193.05	192.85	193.03	18851.0
2014-08-04 06:00:00	SPY	ETF	193.03	193.17	193.01	193.07	94456.0
2014-08-04 07:00:00	SPY	ETF	193.05	193.21	193.01	193.1	271911.0
2014-08-04 08:00:00	SPY	ETF	193.08	193.15	192.27	192.89	689098.0
2014-08-04 09:00:00	SPY	ETF	192.88	193.05	192.63	192.96	12275039.0
2014-08-04 10:00:00	SPY	ETF	192.96	193.09	192.05	192.15	13849375.0
2014-08-04 11:00:00	SPY	ETF	192.15	192.8	192.09	192.62	9873088.0
2014-08-04 12:00:00	SPY	ETF	192.62	193.03	192.51	192.945	8471195.0
2014-08-04 13:00:00	SPY	ETF	192.95	193.41	192.8	193.2875	7651512.0
2014-08-04 14:00:00	SPY	ETF	193.29	193.91	193.28	193.805	9456074.0
2014-08-04 15:00:00	SPY	ETF	193.8075	194.3	193.75	193.88	19168576.0
2014-08-04 16:00:00	SPY	ETF	193.88	193.9	192.4987	193.72	4325065.0
2014-08-04 17:00:00	SPY	ETF	193.72	193.89	193.61	193.68	3592981.0
2014-08-04 18:00:00	SPY	ETF	193.68	193.68	193.47	193.59	191013.0
2014-08-04 19:00:00	SPY	ETF	193.59	193.71	193.59	193.66	63743.0
2014-08-04 04:00:00	QQQ	ETF	94.78	94.78	94.78	94.78	500.0
2014-08-04 06:00:00	QQQ	ETF	94.96	95.01	94.91	94.93	18802.0
2014-08-04 07:00:00	QQQ	ETF	94.96	95.02	94.94	94.99	24373.0
2014-08-04 08:00:00	QQQ	ETF	94.99	95.03	94.92	94.93	220385.0
2014-08-04 09:00:00	QQQ	ETF	94.92	95.18	94.65	95.12	3867103.0
2014-08-04 10:00:00	QQQ	ETF	95.12	95.18	94.52	94.59	5824585.0
2014-08-04 11:00:00	QQQ	ETF	94.58	95.06	94.533	95.02	3192114.0
2014-08-04 12:00:00	QQQ	ETF	95.02	95.24	94.95	95.1855	2294137.0
2014-08-04 13:00:00	QQQ	ETF	95.18	95.26	95.05	95.175	1722625.0
2014-08-04 14:00:00	QQQ	ETF	95.175	95.46	95.17	95.418	2676395.0
2014-08-04 15:00:00	QQQ	ETF	95.41	95.69	95.32	95.33	8437003.0
2014-08-04 16:00:00	QQQ	ETF	95.325	95.4372	94.8714	95.22	1982802.0
2014-08-04 17:00:00	QQQ	ETF	95.21	95.22	95.19	95.21	45393.0
2014-08-04 18:00:00	QQQ	ETF	95.2	95.24	95.17	95.17	6848.0
2014-08-04 19:00:00	QQQ	ETF	95.22	95.24	95.2	95.2	9242.0
2014-08-04 04:00:00	IWM	ETF	110.97	111.09	110.97	111.09	484.0
2014-08-04 05:00:00	IWM	ETF	111.2	111.2	111.2	111.2	100.0
2014-08-04 06:00:00	IWM	ETF	111.1	111.28	111.1	111.28	5400.0
2014-08-04 07:00:00	IWM	ETF	111.29	111.34	111.26	111.28	16250.0
2014-08-04 08:00:00	IWM	ETF	111.3	111.32	111.18	111.24	319711.0
2014-08-04 09:00:00	IWM	ETF	111.21	111.34	110.82	111.1	4299641.0
2014-08-04 10:00:00	IWM	ETF	111.1	111.28	110.02	110.16	6335716.0
2014-08-04 11:00:00	IWM	ETF	110.15	110.68	109.89	110.62	4536850.0
2014-08-04 12:00:00	IWM	ETF	110.61	110.85	110.51	110.8	1651177.0
2014-08-04 13:00:00	IWM	ETF	110.8	111.19	110.56	111.12	2497324.0
2014-08-04 14:00:00	IWM	ETF	111.11	111.47	111.06	111.4	2459875.0
2014-08-04 15:00:00	IWM	ETF	111.393	111.795	111.38	111.63	5416022.0
2014-08-04 16:00:00	IWM	ETF	111.63	111.68	110.6444	111.51	1034299.0
2014-08-04 17:00:00	IWM	ETF	111.52	111.55	111.48	111.48	174371.0
2014-08-04 18:00:00	IWM	ETF	111.52	111.52	111.52	111.52	1375.0
2014-08-04 19:00:00	IWM	ETF	111.52	111.55	111.52	111.52	1630.0
2014-08-04 20:00:00	IWM	ETF	111.6789	111.6789	111.6789	111.6789	150000.0
2014-08-04 07:00:00	DIA	ETF	164.96	164.96	164.96	164.96	100.0
2014-08-04 08:00:00	DIA	ETF	164.95	164.95	164.86	164.9	3800.0

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

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