PREVIEW / etf_1hour / 2011-08-24

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-24.parquet
  size:    185 KB
  rows:    5,679

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-08-24 04:00:00	SPY	ETF	115.45	115.67	114.99	115.54	17848.0
2011-08-24 05:00:00	SPY	ETF	115.46	115.9	115.46	115.74	7538.0
2011-08-24 06:00:00	SPY	ETF	115.6	115.68	115.22	115.3	157723.0
2011-08-24 07:00:00	SPY	ETF	115.27	115.82	115.25	115.4	922090.0
2011-08-24 08:00:00	SPY	ETF	115.39	116.51	115.36	116.32	7072536.0
2011-08-24 09:00:00	SPY	ETF	116.32	117.49	115.43	117.4	29794114.0
2011-08-24 10:00:00	SPY	ETF	117.43	117.94	116.58	116.58	53450687.0
2011-08-24 11:00:00	SPY	ETF	116.58	117.04	116.4	116.48	28939691.0
2011-08-24 12:00:00	SPY	ETF	116.48	116.72	115.95	116.67	22037455.0
2011-08-24 13:00:00	SPY	ETF	116.675	117.31	116.5	117.14	20397755.0
2011-08-24 14:00:00	SPY	ETF	117.14	117.37	116.73	117.31	18373671.0
2011-08-24 15:00:00	SPY	ETF	117.31	118.24	117.15	118.09	45209879.0
2011-08-24 16:00:00	SPY	ETF	118.06	118.15	117.61	117.68	17251684.0
2011-08-24 17:00:00	SPY	ETF	117.69	117.85	117.63	117.74	217438.0
2011-08-24 18:00:00	SPY	ETF	117.74	118.13	117.12	117.33	1746477.0
2011-08-24 19:00:00	SPY	ETF	117.28	117.41	117.2	117.36	359700.0
2011-08-24 04:00:00	QQQ	ETF	51.84	51.85	51.63	51.82	7971.0
2011-08-24 05:00:00	QQQ	ETF	52.0	52.0	52.0	52.0	200.0
2011-08-24 06:00:00	QQQ	ETF	51.9	51.9	51.7	51.79	28300.0
2011-08-24 07:00:00	QQQ	ETF	51.75	51.94	51.71	51.82	64388.0
2011-08-24 08:00:00	QQQ	ETF	51.8	52.27	51.8	52.21	1147568.0
2011-08-24 09:00:00	QQQ	ETF	52.21	52.65	52.01	52.62	8289922.0
2011-08-24 10:00:00	QQQ	ETF	52.62	53.42	52.03	52.04	14526851.0
2011-08-24 11:00:00	QQQ	ETF	52.0399	52.24	51.89	51.97	7186015.0
2011-08-24 12:00:00	QQQ	ETF	51.95	52.17	51.71	52.14	6727175.0
2011-08-24 13:00:00	QQQ	ETF	52.14	52.41	52.06	52.32	5927715.0
2011-08-24 14:00:00	QQQ	ETF	52.32	52.42	52.1	52.39	5621808.0
2011-08-24 15:00:00	QQQ	ETF	52.39	52.795	52.34	52.68	12177714.0
2011-08-24 16:00:00	QQQ	ETF	52.68	52.71	52.48	52.57	1248562.0
2011-08-24 17:00:00	QQQ	ETF	52.56	52.63	52.51	52.59	61593.0
2011-08-24 18:00:00	QQQ	ETF	52.59	52.69	51.9	52.08	1940463.0
2011-08-24 19:00:00	QQQ	ETF	52.08	52.28	51.95	52.1	725145.0
2011-08-24 04:00:00	IWM	ETF	67.3	67.41	67.3	67.41	3264.0
2011-08-24 05:00:00	IWM	ETF	67.78	67.78	67.78	67.78	200.0
2011-08-24 06:00:00	IWM	ETF	67.52	67.52	67.5	67.5	300.0
2011-08-24 07:00:00	IWM	ETF	67.41	67.81	67.41	67.52	24670.0
2011-08-24 08:00:00	IWM	ETF	67.57	68.38	67.51	68.25	930327.0
2011-08-24 09:00:00	IWM	ETF	68.25	69.12	67.92	69.09	9270607.0
2011-08-24 10:00:00	IWM	ETF	69.08	69.63	68.31	68.31	17691906.0
2011-08-24 11:00:00	IWM	ETF	68.32	68.73	68.07	68.15	6687700.0
2011-08-24 12:00:00	IWM	ETF	68.13	68.48	67.52	68.42	4866894.0
2011-08-24 13:00:00	IWM	ETF	68.42	68.71	68.13	68.54	3948509.0
2011-08-24 14:00:00	IWM	ETF	68.54	68.85	68.12	68.84	4846161.0
2011-08-24 15:00:00	IWM	ETF	68.84	69.39	68.72	69.2	10534424.0
2011-08-24 16:00:00	IWM	ETF	69.2	69.29	67.865	68.91	1570841.0
2011-08-24 17:00:00	IWM	ETF	68.91	69.06	68.9	69.01	13493.0
2011-08-24 18:00:00	IWM	ETF	68.94	69.01	68.72	68.81	36778.0
2011-08-24 19:00:00	IWM	ETF	68.82	68.82	68.67	68.76	42418.0
2011-08-24 07:00:00	DIA	ETF	110.5	110.5	110.5	110.5	100.0
2011-08-24 08:00:00	DIA	ETF	111.05	111.5	110.41	111.33	28100.0

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

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