PREVIEW / etf_1hour / 2011-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-23.parquet
  size:    186 KB
  rows:    5,760

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-23 04:00:00	SPY	ETF	114.5	115.1	114.49	114.58	15537.0
2011-08-23 05:00:00	SPY	ETF	114.52	114.8	114.3	114.65	4200.0
2011-08-23 06:00:00	SPY	ETF	114.69	114.7	114.31	114.36	240156.0
2011-08-23 07:00:00	SPY	ETF	114.41	114.72	113.83	113.9	1138640.0
2011-08-23 08:00:00	SPY	ETF	113.88	114.68	112.73	113.34	6612133.0
2011-08-23 09:00:00	SPY	ETF	113.34	113.65	112.58	113.17	44164148.0
2011-08-23 10:00:00	SPY	ETF	113.18	114.5	113.11	113.87	54749237.0
2011-08-23 11:00:00	SPY	ETF	113.87	115.31	113.75	115.24	37295814.0
2011-08-23 12:00:00	SPY	ETF	115.24	115.519	114.84	115.37	26013638.0
2011-08-23 13:00:00	SPY	ETF	115.37	115.59	114.38	114.73	33169938.0
2011-08-23 14:00:00	SPY	ETF	114.73	115.48	114.36	115.41	34984625.0
2011-08-23 15:00:00	SPY	ETF	115.42	116.54	115.41	116.48	66784591.0
2011-08-23 16:00:00	SPY	ETF	116.48	116.61	116.0	116.57	17682083.0
2011-08-23 17:00:00	SPY	ETF	116.57	116.69	112.7152	116.54	3304025.0
2011-08-23 18:00:00	SPY	ETF	116.54	116.54	116.28	116.28	824410.0
2011-08-23 19:00:00	SPY	ETF	116.3	116.32	116.07	116.16	273346.0
2011-08-23 04:00:00	QQQ	ETF	51.09	51.13	50.93	50.93	6873.0
2011-08-23 06:00:00	QQQ	ETF	50.93	50.93	50.87	50.87	900.0
2011-08-23 07:00:00	QQQ	ETF	50.84	51.02	50.67	50.69	163485.0
2011-08-23 08:00:00	QQQ	ETF	50.7	50.86	50.46	50.52	460673.0
2011-08-23 09:00:00	QQQ	ETF	50.53	50.94	50.34	50.79	10576920.0
2011-08-23 10:00:00	QQQ	ETF	50.78	51.285	50.74	51.0	12276809.0
2011-08-23 11:00:00	QQQ	ETF	51.0	51.58	50.89	51.55	7762230.0
2011-08-23 12:00:00	QQQ	ETF	51.55	51.74	51.4	51.661	5638222.0
2011-08-23 13:00:00	QQQ	ETF	51.67	51.79	51.27	51.44	8687452.0
2011-08-23 14:00:00	QQQ	ETF	51.45	51.89	51.3207	51.86	7677666.0
2011-08-23 15:00:00	QQQ	ETF	51.87	52.28	51.86	52.27	14888260.0
2011-08-23 16:00:00	QQQ	ETF	52.28	52.34	52.19	52.26	2164807.0
2011-08-23 17:00:00	QQQ	ETF	52.28	52.3	52.2	52.24	63340.0
2011-08-23 18:00:00	QQQ	ETF	52.26	52.26	52.11	52.12	136053.0
2011-08-23 19:00:00	QQQ	ETF	52.12	52.12	52.04	52.08	72688.0
2011-08-23 04:00:00	IWM	ETF	66.34	66.68	66.34	66.53	4520.0
2011-08-23 05:00:00	IWM	ETF	66.34	66.6	66.34	66.6	700.0
2011-08-23 06:00:00	IWM	ETF	66.23	66.23	66.23	66.23	200.0
2011-08-23 07:00:00	IWM	ETF	66.24	66.45	65.78	65.95	68022.0
2011-08-23 08:00:00	IWM	ETF	65.88	66.23	65.55	65.6	882335.0
2011-08-23 09:00:00	IWM	ETF	65.6	65.76	64.86	65.43	12025847.0
2011-08-23 10:00:00	IWM	ETF	65.43	66.37	65.42	65.84	13292955.0
2011-08-23 11:00:00	IWM	ETF	65.84	66.93	65.75	66.85	8243804.0
2011-08-23 12:00:00	IWM	ETF	66.85	67.44	66.77	67.34	7165656.0
2011-08-23 13:00:00	IWM	ETF	67.35	67.45	66.74	67.02	9386266.0
2011-08-23 14:00:00	IWM	ETF	67.03	67.54	66.65	67.51	8718414.0
2011-08-23 15:00:00	IWM	ETF	67.5	68.3	67.5	68.2	18313461.0
2011-08-23 16:00:00	IWM	ETF	68.2	68.37	66.8124	68.32	2278701.0
2011-08-23 17:00:00	IWM	ETF	68.32	68.4	68.32	68.34	17550.0
2011-08-23 18:00:00	IWM	ETF	68.31	68.31	68.22	68.22	2800.0
2011-08-23 19:00:00	IWM	ETF	68.19	68.3	68.12	68.16	4863.0
2011-08-23 04:00:00	DIA	ETF	109.62	109.62	109.62	109.62	150.0
2011-08-23 05:00:00	DIA	ETF	109.8	109.95	109.8	109.95	3000.0
2011-08-23 07:00:00	DIA	ETF	109.96	109.96	109.41	109.41	6000.0

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

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