PREVIEW / etf_1hour / 2011-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-28.parquet
  size:    181 KB
  rows:    5,633

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-10-28 04:00:00	SPY	ETF	128.5	128.69	128.29	128.54	19148.0
2011-10-28 05:00:00	SPY	ETF	128.59	128.59	128.18	128.46	10950.0
2011-10-28 06:00:00	SPY	ETF	128.41	128.41	127.9	128.14	229175.0
2011-10-28 07:00:00	SPY	ETF	128.11	128.33	127.91	128.06	595481.0
2011-10-28 08:00:00	SPY	ETF	128.03	128.24	127.9	128.06	2476653.0
2011-10-28 09:00:00	SPY	ETF	128.06	128.44	127.43	128.19	27827908.0
2011-10-28 10:00:00	SPY	ETF	128.19	128.57	127.8317	128.48	31947984.0
2011-10-28 11:00:00	SPY	ETF	128.48	128.73	128.09	128.1	42967824.0
2011-10-28 12:00:00	SPY	ETF	128.09	128.4	127.97	128.3589	17082232.0
2011-10-28 13:00:00	SPY	ETF	128.36	128.65	128.24	128.46	19047483.0
2011-10-28 14:00:00	SPY	ETF	128.454	128.53	128.14	128.32	14545319.0
2011-10-28 15:00:00	SPY	ETF	128.33	128.85	128.24	128.61	41837495.0
2011-10-28 16:00:00	SPY	ETF	128.6	128.83	128.17	128.37	18111109.0
2011-10-28 17:00:00	SPY	ETF	128.39	128.5476	128.2	128.39	4264935.0
2011-10-28 18:00:00	SPY	ETF	128.36	128.68	128.23	128.3	256833.0
2011-10-28 19:00:00	SPY	ETF	128.29	128.3	128.17	128.23	210430.0
2011-10-28 05:00:00	QQQ	ETF	58.74	58.74	58.74	58.74	200.0
2011-10-28 06:00:00	QQQ	ETF	58.48	58.57	58.48	58.57	7200.0
2011-10-28 07:00:00	QQQ	ETF	58.6	58.63	58.45	58.49	37506.0
2011-10-28 08:00:00	QQQ	ETF	58.56	58.62	58.47	58.58	533091.0
2011-10-28 09:00:00	QQQ	ETF	58.58	58.89	58.48	58.73	6474496.0
2011-10-28 10:00:00	QQQ	ETF	58.74	58.86	58.59	58.82	7697331.0
2011-10-28 11:00:00	QQQ	ETF	58.82	58.9173	58.61	58.64	5940870.0
2011-10-28 12:00:00	QQQ	ETF	58.63	58.71	58.535	58.689	3466088.0
2011-10-28 13:00:00	QQQ	ETF	58.69	58.85	58.66	58.79	3826922.0
2011-10-28 14:00:00	QQQ	ETF	58.78	58.83	58.67	58.79	2464300.0
2011-10-28 15:00:00	QQQ	ETF	58.795	59.01	58.75	58.91	8125803.0
2011-10-28 16:00:00	QQQ	ETF	58.91	59.03	58.83	58.84	2610283.0
2011-10-28 17:00:00	QQQ	ETF	58.84	58.85	58.82	58.85	12850.0
2011-10-28 18:00:00	QQQ	ETF	58.8	58.85	58.8	58.84	10980.0
2011-10-28 19:00:00	QQQ	ETF	58.81	58.83	58.74	58.78	23271.0
2011-10-28 04:00:00	IWM	ETF	76.5	76.5	76.5	76.5	100.0
2011-10-28 05:00:00	IWM	ETF	76.18	76.18	76.18	76.18	100.0
2011-10-28 06:00:00	IWM	ETF	76.0	76.0	76.0	76.0	7000.0
2011-10-28 07:00:00	IWM	ETF	76.13	76.26	75.91	76.0	39692.0
2011-10-28 08:00:00	IWM	ETF	76.04	76.23	75.97	76.12	305827.0
2011-10-28 09:00:00	IWM	ETF	76.12	76.78	75.89	76.28	9585826.0
2011-10-28 10:00:00	IWM	ETF	76.28	76.61	75.91	76.39	9601544.0
2011-10-28 11:00:00	IWM	ETF	76.4	76.92	76.14	76.21	8981385.0
2011-10-28 12:00:00	IWM	ETF	76.21	76.53	76.16	76.33	4123972.0
2011-10-28 13:00:00	IWM	ETF	76.3235	76.39	76.04	76.22	5069340.0
2011-10-28 14:00:00	IWM	ETF	76.22	76.27	75.76	75.869	7833463.0
2011-10-28 15:00:00	IWM	ETF	75.87	76.4	75.87	76.05	12485094.0
2011-10-28 16:00:00	IWM	ETF	76.03	76.4746	75.94	76.02	7901272.0
2011-10-28 17:00:00	IWM	ETF	75.96	76.0	75.9	75.95	20128.0
2011-10-28 18:00:00	IWM	ETF	75.95	76.0	75.92	75.96	10300.0
2011-10-28 19:00:00	IWM	ETF	75.92	75.94	75.85	75.88	13354.0
2011-10-28 04:00:00	DIA	ETF	121.5	121.5	121.5	121.5	100.0
2011-10-28 06:00:00	DIA	ETF	121.4	121.4	121.29	121.29	6000.0
2011-10-28 07:00:00	DIA	ETF	121.6	121.6	121.3	121.35	1900.0

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

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