PREVIEW / etf_1hour / 2014-05-16

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-16.parquet
  size:    211 KB
  rows:    6,734

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-05-16 04:00:00	SPY	ETF	187.17	187.33	187.17	187.33	5267.0
2014-05-16 05:00:00	SPY	ETF	187.33	187.38	187.06	187.06	14875.0
2014-05-16 06:00:00	SPY	ETF	187.06	187.06	186.8	186.99	36803.0
2014-05-16 07:00:00	SPY	ETF	186.96	187.28	186.9	187.05	408344.0
2014-05-16 08:00:00	SPY	ETF	187.03	187.38	186.9	187.22	1114189.0
2014-05-16 09:00:00	SPY	ETF	187.2	187.72	186.93	187.38	16122347.0
2014-05-16 10:00:00	SPY	ETF	187.39	187.47	186.72	187.23	16535028.0
2014-05-16 11:00:00	SPY	ETF	187.22	187.61	187.125	187.45	9493057.0
2014-05-16 12:00:00	SPY	ETF	187.46	187.56	187.24	187.29	7271989.0
2014-05-16 13:00:00	SPY	ETF	187.28	187.38	187.06	187.23	7157461.0
2014-05-16 14:00:00	SPY	ETF	187.24	187.86	187.09	187.86	8274243.0
2014-05-16 15:00:00	SPY	ETF	187.851	188.13	187.81	188.08	22292846.0
2014-05-16 16:00:00	SPY	ETF	188.09	188.16	187.3564	188.11	7960526.0
2014-05-16 17:00:00	SPY	ETF	188.09	188.17	188.05	188.05	199026.0
2014-05-16 18:00:00	SPY	ETF	188.05	188.18	188.04	188.18	34710.0
2014-05-16 19:00:00	SPY	ETF	188.15	188.23	188.1	188.14	37089.0
2014-05-16 06:00:00	QQQ	ETF	86.88	86.93	86.86	86.93	3100.0
2014-05-16 07:00:00	QQQ	ETF	86.96	87.08	86.94	86.98	22500.0
2014-05-16 08:00:00	QQQ	ETF	87.0	87.22	86.92	87.14	379573.0
2014-05-16 09:00:00	QQQ	ETF	87.14	87.32	86.81	87.15	5845145.0
2014-05-16 10:00:00	QQQ	ETF	87.16	87.22	86.64	86.87	14049202.0
2014-05-16 11:00:00	QQQ	ETF	86.88	87.09	86.83	87.03	3105354.0
2014-05-16 12:00:00	QQQ	ETF	87.0398	87.2	86.97	86.9841	2049484.0
2014-05-16 13:00:00	QQQ	ETF	86.98	87.15	86.84	87.07	3399087.0
2014-05-16 14:00:00	QQQ	ETF	87.075	87.5	87.0	87.499	5968838.0
2014-05-16 15:00:00	QQQ	ETF	87.5	87.76	87.49	87.7	11354680.0
2014-05-16 16:00:00	QQQ	ETF	87.7	87.71	86.9923	87.62	3581901.0
2014-05-16 17:00:00	QQQ	ETF	87.62	87.65	87.62	87.65	2922.0
2014-05-16 18:00:00	QQQ	ETF	87.65	87.69	87.6	87.6	3200.0
2014-05-16 19:00:00	QQQ	ETF	87.69	87.7	87.62	87.64	2138.0
2014-05-16 04:00:00	IWM	ETF	108.58	108.58	108.58	108.58	100.0
2014-05-16 06:00:00	IWM	ETF	108.58	108.58	108.58	108.58	200.0
2014-05-16 07:00:00	IWM	ETF	108.85	109.02	108.68	108.68	16664.0
2014-05-16 08:00:00	IWM	ETF	108.71	109.02	108.61	108.95	326899.0
2014-05-16 09:00:00	IWM	ETF	108.95	109.2	108.29	108.83	5477214.0
2014-05-16 10:00:00	IWM	ETF	108.84	108.92	108.03	108.5	5878106.0
2014-05-16 11:00:00	IWM	ETF	108.4975	108.87	108.41	108.59	3650213.0
2014-05-16 12:00:00	IWM	ETF	108.58	108.76	108.41	108.495	1629713.0
2014-05-16 13:00:00	IWM	ETF	108.49	108.71	108.29	108.51	2641544.0
2014-05-16 14:00:00	IWM	ETF	108.52	109.04	108.37	109.03	3366624.0
2014-05-16 15:00:00	IWM	ETF	109.04	109.62	109.02	109.56	10879303.0
2014-05-16 16:00:00	IWM	ETF	109.56	109.9	108.5378	109.57	2971854.0
2014-05-16 17:00:00	IWM	ETF	109.59	109.61	109.56	109.61	17904.0
2014-05-16 18:00:00	IWM	ETF	109.58	109.58	109.56	109.56	1200.0
2014-05-16 19:00:00	IWM	ETF	109.61	109.65	109.57	109.65	1628.0
2014-05-16 05:00:00	DIA	ETF	164.0	164.0	164.0	164.0	694.0
2014-05-16 08:00:00	DIA	ETF	164.12	164.15	163.9	164.13	6636.0
2014-05-16 09:00:00	DIA	ETF	164.12	164.39	163.92	164.18	824779.0
2014-05-16 10:00:00	DIA	ETF	164.2	164.27	163.77	164.05	811955.0
2014-05-16 11:00:00	DIA	ETF	164.05	164.29	163.98	164.16	464158.0

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

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