PREVIEW / etf_1hour / 2014-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-05.parquet
  size:    234 KB
  rows:    7,458

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-11-05 04:00:00	SPY	ETF	201.57	201.84	201.52	201.84	78828.0
2014-11-05 05:00:00	SPY	ETF	201.86	201.99	201.84	201.9	83751.0
2014-11-05 06:00:00	SPY	ETF	201.84	201.95	201.71	201.85	42239.0
2014-11-05 07:00:00	SPY	ETF	201.85	202.32	201.85	202.28	587953.0
2014-11-05 08:00:00	SPY	ETF	202.28	202.48	201.07	202.35	1263754.0
2014-11-05 09:00:00	SPY	ETF	202.36	202.59	201.76	201.92	15792544.0
2014-11-05 10:00:00	SPY	ETF	201.92	202.13	201.45	201.96	16385678.0
2014-11-05 11:00:00	SPY	ETF	201.96	202.21	201.84	202.175	9954832.0
2014-11-05 12:00:00	SPY	ETF	202.17	202.34	202.05	202.22	9509172.0
2014-11-05 13:00:00	SPY	ETF	202.224	202.35	201.64	201.81	9408061.0
2014-11-05 14:00:00	SPY	ETF	201.81	202.27	201.71	202.26	7155622.0
2014-11-05 15:00:00	SPY	ETF	202.27	202.44	201.98	202.37	15965880.0
2014-11-05 16:00:00	SPY	ETF	202.38	202.55	202.04	202.38	4939439.0
2014-11-05 17:00:00	SPY	ETF	202.38	202.44	202.36	202.42	23600.0
2014-11-05 18:00:00	SPY	ETF	202.41	202.41	202.25	202.3	118167.0
2014-11-05 19:00:00	SPY	ETF	202.3	202.34	202.16	202.16	121410.0
2014-11-05 04:00:00	QQQ	ETF	101.73	101.78	101.67	101.78	2650.0
2014-11-05 05:00:00	QQQ	ETF	101.76	101.83	101.76	101.81	17700.0
2014-11-05 06:00:00	QQQ	ETF	101.74	101.76	101.72	101.72	6035.0
2014-11-05 07:00:00	QQQ	ETF	101.74	101.94	101.74	101.93	91394.0
2014-11-05 08:00:00	QQQ	ETF	101.91	101.99	101.76	101.96	121351.0
2014-11-05 09:00:00	QQQ	ETF	101.95	102.05	101.31	101.41	5815570.0
2014-11-05 10:00:00	QQQ	ETF	101.39	101.6	101.09	101.39	4879142.0
2014-11-05 11:00:00	QQQ	ETF	101.395	101.59	101.33	101.56	2424601.0
2014-11-05 12:00:00	QQQ	ETF	101.559	101.64	101.4434	101.5	1680159.0
2014-11-05 13:00:00	QQQ	ETF	101.5	101.575	101.015	101.13	2461777.0
2014-11-05 14:00:00	QQQ	ETF	101.14	101.32	101.09	101.28	2405547.0
2014-11-05 15:00:00	QQQ	ETF	101.28	101.4	101.11	101.36	3779863.0
2014-11-05 16:00:00	QQQ	ETF	101.36	101.4	101.19	101.23	1698167.0
2014-11-05 17:00:00	QQQ	ETF	101.24	101.33	101.23	101.28	11609.0
2014-11-05 18:00:00	QQQ	ETF	101.28	101.3	101.22	101.22	11060.0
2014-11-05 19:00:00	QQQ	ETF	101.23	101.26	101.16	101.16	38173.0
2014-11-05 04:00:00	IWM	ETF	116.02	116.02	116.02	116.02	200.0
2014-11-05 06:00:00	IWM	ETF	116.4	116.4	116.28	116.28	600.0
2014-11-05 07:00:00	IWM	ETF	116.6	116.69	116.49	116.69	139944.0
2014-11-05 08:00:00	IWM	ETF	116.69	116.77	116.57	116.72	140211.0
2014-11-05 09:00:00	IWM	ETF	116.73	116.79	115.83	116.15	5455024.0
2014-11-05 10:00:00	IWM	ETF	116.15	116.5	115.94	116.32	4948499.0
2014-11-05 11:00:00	IWM	ETF	116.32	116.53	116.0	116.385	2756151.0
2014-11-05 12:00:00	IWM	ETF	116.385	116.69	116.14	116.22	2812998.0
2014-11-05 13:00:00	IWM	ETF	116.218	116.34	115.55	115.72	3085600.0
2014-11-05 14:00:00	IWM	ETF	115.72	116.05	115.661	116.03	2760607.0
2014-11-05 15:00:00	IWM	ETF	116.032	116.09	115.69	116.01	4339347.0
2014-11-05 16:00:00	IWM	ETF	116.02	116.12	115.9706	116.11	753569.0
2014-11-05 17:00:00	IWM	ETF	116.1	116.16	116.1	116.12	6412.0
2014-11-05 18:00:00	IWM	ETF	116.12	116.12	115.98	115.98	3802.0
2014-11-05 19:00:00	IWM	ETF	116.1	116.1	116.05	116.05	971.0
2014-11-05 04:00:00	DIA	ETF	173.41	173.84	173.41	173.84	200.0
2014-11-05 07:00:00	DIA	ETF	174.0	174.43	174.0	174.43	2876.0
2014-11-05 08:00:00	DIA	ETF	174.3	174.48	174.29	174.45	50849.0

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

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