PREVIEW / etf_1hour / 2013-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-22.parquet
  size:    201 KB
  rows:    6,263

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
2013-08-22 04:00:00	SPY	ETF	164.72	164.98	164.64	164.95	38931.0
2013-08-22 05:00:00	SPY	ETF	164.95	165.04	164.8	164.82	57500.0
2013-08-22 06:00:00	SPY	ETF	164.81	164.94	164.76	164.8	140225.0
2013-08-22 07:00:00	SPY	ETF	164.79	164.93	164.63	164.65	411724.0
2013-08-22 08:00:00	SPY	ETF	164.65	165.12	164.64	165.01	1572070.0
2013-08-22 09:00:00	SPY	ETF	165.02	165.5	164.87	165.39	13883914.0
2013-08-22 10:00:00	SPY	ETF	165.38	165.97	165.28	165.7401	18113794.0
2013-08-22 11:00:00	SPY	ETF	165.75	165.85	165.44	165.67	10493518.0
2013-08-22 12:00:00	SPY	ETF	165.66	165.82	165.3	165.41	8280491.0
2013-08-22 13:00:00	SPY	ETF	165.41	165.85	165.35	165.81	6053527.0
2013-08-22 14:00:00	SPY	ETF	165.82	166.0	165.72	165.79	7362221.0
2013-08-22 15:00:00	SPY	ETF	165.781	166.3	165.71	165.99	19863162.0
2013-08-22 16:00:00	SPY	ETF	166.02	166.2	164.582	166.12	8243285.0
2013-08-22 17:00:00	SPY	ETF	166.12	166.16	166.1	166.12	60185.0
2013-08-22 18:00:00	SPY	ETF	166.09	166.19	166.06	166.17	59820.0
2013-08-22 19:00:00	SPY	ETF	166.18	166.25	166.16	166.2	30555.0
2013-08-22 04:00:00	QQQ	ETF	75.2	75.67	75.2	75.67	35800.0
2013-08-22 05:00:00	QQQ	ETF	75.64	75.7	75.62	75.62	8600.0
2013-08-22 06:00:00	QQQ	ETF	75.6	75.65	75.59	75.62	28300.0
2013-08-22 07:00:00	QQQ	ETF	75.61	75.65	75.56	75.56	141845.0
2013-08-22 08:00:00	QQQ	ETF	75.61	75.74	75.55	75.71	174925.0
2013-08-22 09:00:00	QQQ	ETF	75.72	76.05	75.68	75.96	3503887.0
2013-08-22 10:00:00	QQQ	ETF	75.96	76.21	75.85	76.11	3933338.0
2013-08-22 11:00:00	QQQ	ETF	76.11	76.15	75.925	75.9801	2895533.0
2013-08-22 12:00:00	QQQ	ETF	75.98	75.995	75.95	75.95	369768.0
2013-08-22 13:00:00	QQQ	ETF	75.95	75.95	75.95	75.95	5900.0
2013-08-22 15:00:00	QQQ	ETF	76.0	76.19	75.98	76.15	4804584.0
2013-08-22 16:00:00	QQQ	ETF	76.14	76.28	75.976	76.22	1164740.0
2013-08-22 17:00:00	QQQ	ETF	76.22	76.24	76.18	76.22	2050.0
2013-08-22 18:00:00	QQQ	ETF	76.22	76.28	76.22	76.28	16500.0
2013-08-22 19:00:00	QQQ	ETF	76.28	76.29	76.26	76.29	9690.0
2013-08-22 04:00:00	IWM	ETF	102.27	102.27	102.27	102.27	100.0
2013-08-22 06:00:00	IWM	ETF	102.06	102.06	102.06	102.06	500.0
2013-08-22 07:00:00	IWM	ETF	101.72	101.81	101.63	101.63	159225.0
2013-08-22 08:00:00	IWM	ETF	101.79	101.94	101.61	101.88	99206.0
2013-08-22 09:00:00	IWM	ETF	101.88	102.46	101.79	102.38	3195843.0
2013-08-22 10:00:00	IWM	ETF	102.37	102.8	102.2	102.62	4292453.0
2013-08-22 11:00:00	IWM	ETF	102.63	102.73	102.37	102.66	2803576.0
2013-08-22 12:00:00	IWM	ETF	102.67	102.77	102.1901	102.37	2134186.0
2013-08-22 13:00:00	IWM	ETF	102.36	102.86	102.28	102.75	2234758.0
2013-08-22 14:00:00	IWM	ETF	102.76	102.85	102.66	102.66	1350898.0
2013-08-22 15:00:00	IWM	ETF	102.65	102.99	102.55	102.88	5668879.0
2013-08-22 16:00:00	IWM	ETF	102.89	103.03	102.84	102.87	943669.0
2013-08-22 17:00:00	IWM	ETF	102.91	102.91	102.9	102.9	2932.0
2013-08-22 18:00:00	IWM	ETF	102.87	102.94	102.87	102.94	2740.0
2013-08-22 19:00:00	IWM	ETF	102.98	102.98	102.97	102.98	1500.0
2013-08-22 07:00:00	DIA	ETF	148.82	148.85	148.82	148.82	3600.0
2013-08-22 08:00:00	DIA	ETF	148.78	149.06	148.74	149.0	9297.0
2013-08-22 09:00:00	DIA	ETF	148.99	149.12	148.77	148.94	662494.0
2013-08-22 10:00:00	DIA	ETF	148.9465	149.3699	148.83	149.2	961262.0

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

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