PREVIEW / etf_1hour / 2011-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-28.parquet
  size:    185 KB
  rows:    5,664

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
2011-09-28 04:00:00	SPY	ETF	117.56	117.62	117.2	117.62	10452.0
2011-09-28 05:00:00	SPY	ETF	117.52	118.3	117.52	118.3	29200.0
2011-09-28 06:00:00	SPY	ETF	118.32	118.72	118.07	118.52	403872.0
2011-09-28 07:00:00	SPY	ETF	118.5	118.56	118.04	118.14	933550.0
2011-09-28 08:00:00	SPY	ETF	118.14	118.5	117.67	117.86	5396602.0
2011-09-28 09:00:00	SPY	ETF	117.86	118.49	117.55	118.25	25630624.0
2011-09-28 10:00:00	SPY	ETF	118.24	118.25	116.9	117.29	45328589.0
2011-09-28 11:00:00	SPY	ETF	117.28	117.98	116.86	117.79	39250354.0
2011-09-28 12:00:00	SPY	ETF	117.78	117.88	117.1	117.48	21320515.0
2011-09-28 13:00:00	SPY	ETF	117.47	117.49	116.05	116.11	32362625.0
2011-09-28 14:00:00	SPY	ETF	116.11	116.47	115.81	116.34	27919346.0
2011-09-28 15:00:00	SPY	ETF	116.35	117.5058	114.97	115.11	74155583.0
2011-09-28 16:00:00	SPY	ETF	115.11	118.3346	115.05	115.31	11026155.0
2011-09-28 17:00:00	SPY	ETF	115.32	115.37	115.23	115.29	1490381.0
2011-09-28 18:00:00	SPY	ETF	115.28	115.35	115.11	115.29	435836.0
2011-09-28 19:00:00	SPY	ETF	115.28	115.3	115.03	115.14	164570.0
2011-09-28 04:00:00	QQQ	ETF	55.24	55.24	55.24	55.24	100.0
2011-09-28 05:00:00	QQQ	ETF	55.4	55.69	55.4	55.69	1714.0
2011-09-28 06:00:00	QQQ	ETF	55.72	55.94	55.71	55.74	8510.0
2011-09-28 07:00:00	QQQ	ETF	55.75	55.86	55.68	55.72	105660.0
2011-09-28 08:00:00	QQQ	ETF	55.68	55.78	55.46	55.58	653417.0
2011-09-28 09:00:00	QQQ	ETF	55.58	55.97	55.485	55.79	9715009.0
2011-09-28 10:00:00	QQQ	ETF	55.78	55.79	55.23	55.43	14591658.0
2011-09-28 11:00:00	QQQ	ETF	55.42	55.67	55.22	55.598	7651408.0
2011-09-28 12:00:00	QQQ	ETF	55.61	55.65	55.28	55.48	5920990.0
2011-09-28 13:00:00	QQQ	ETF	55.48	55.48	54.87	54.92	9795100.0
2011-09-28 14:00:00	QQQ	ETF	54.9199	55.13	54.81	55.05	7809115.0
2011-09-28 15:00:00	QQQ	ETF	55.04	55.29	54.4	54.48	16362479.0
2011-09-28 16:00:00	QQQ	ETF	54.48	54.65	54.46	54.53	1809260.0
2011-09-28 17:00:00	QQQ	ETF	54.53	54.53	54.47	54.5	75960.0
2011-09-28 18:00:00	QQQ	ETF	54.48	54.57	54.45	54.53	9085.0
2011-09-28 19:00:00	QQQ	ETF	54.53	54.53	54.39	54.4	41031.0
2011-09-28 04:00:00	IWM	ETF	68.02	68.02	67.78	67.98	4390.0
2011-09-28 05:00:00	IWM	ETF	68.43	68.43	68.43	68.43	200.0
2011-09-28 06:00:00	IWM	ETF	68.58	68.58	68.58	68.58	100.0
2011-09-28 07:00:00	IWM	ETF	68.56	68.56	68.25	68.35	17200.0
2011-09-28 08:00:00	IWM	ETF	68.27	68.62	67.87	68.0	461137.0
2011-09-28 09:00:00	IWM	ETF	68.0	68.12	67.26	67.93	7094932.0
2011-09-28 10:00:00	IWM	ETF	67.93	67.938	66.72	66.95	13791580.0
2011-09-28 11:00:00	IWM	ETF	66.96	67.43	66.51	67.3416	8347937.0
2011-09-28 12:00:00	IWM	ETF	67.35	67.44	66.78	67.25	5457924.0
2011-09-28 13:00:00	IWM	ETF	67.252	67.26	66.07	66.1	9738726.0
2011-09-28 14:00:00	IWM	ETF	66.11	66.49	65.8	66.39	7613267.0
2011-09-28 15:00:00	IWM	ETF	66.39	66.71	65.1	65.22	19366813.0
2011-09-28 16:00:00	IWM	ETF	65.22	67.9183	65.0915	65.37	4470537.0
2011-09-28 17:00:00	IWM	ETF	65.37	65.37	65.28	65.35	106553.0
2011-09-28 18:00:00	IWM	ETF	65.28	65.54	65.19	65.19	22453.0
2011-09-28 19:00:00	IWM	ETF	65.2	65.3	65.08	65.14	8602.0
2011-09-28 07:00:00	DIA	ETF	112.59	112.75	112.3	112.64	11000.0
2011-09-28 08:00:00	DIA	ETF	112.44	112.5	112.01	112.16	25150.0

> showing 50 of 5,664 rows — these rows as CSV

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