PREVIEW / etf_1hour / 2011-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-26.parquet
  size:    184 KB
  rows:    5,716

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-26 04:00:00	SPY	ETF	113.6	114.55	113.25	114.55	26791.0
2011-09-26 05:00:00	SPY	ETF	114.46	114.8	114.33	114.46	36965.0
2011-09-26 06:00:00	SPY	ETF	114.36	115.09	114.28	114.86	213633.0
2011-09-26 07:00:00	SPY	ETF	114.89	115.69	114.88	115.1	1249361.0
2011-09-26 08:00:00	SPY	ETF	115.5	115.5	113.26	114.98	2801851.0
2011-09-26 09:00:00	SPY	ETF	114.98	115.16	113.71	113.73	27305117.0
2011-09-26 10:00:00	SPY	ETF	113.73	114.05	112.98	113.91	45570145.0
2011-09-26 11:00:00	SPY	ETF	113.91	115.07	113.3515	114.97	30060006.0
2011-09-26 12:00:00	SPY	ETF	114.97	115.0	114.04	114.3201	28524519.0
2011-09-26 13:00:00	SPY	ETF	114.32	114.325	113.72	114.21	26502244.0
2011-09-26 14:00:00	SPY	ETF	114.21	115.04	114.09	114.98	29936409.0
2011-09-26 15:00:00	SPY	ETF	114.99	116.4	114.96	116.21	50204765.0
2011-09-26 16:00:00	SPY	ETF	116.2	116.48	113.3515	116.43	13832882.0
2011-09-26 17:00:00	SPY	ETF	116.43	116.43	116.231	116.34	1006233.0
2011-09-26 18:00:00	SPY	ETF	116.34	116.39	116.25	116.32	134295.0
2011-09-26 19:00:00	SPY	ETF	116.33	116.37	116.14	116.16	225255.0
2011-09-26 04:00:00	QQQ	ETF	53.91	53.91	53.91	53.91	439.0
2011-09-26 05:00:00	QQQ	ETF	54.41	54.5	54.41	54.5	889.0
2011-09-26 06:00:00	QQQ	ETF	54.45	54.7	54.45	54.65	32375.0
2011-09-26 07:00:00	QQQ	ETF	54.71	54.93	54.66	54.66	734963.0
2011-09-26 08:00:00	QQQ	ETF	54.68	54.75	54.51	54.62	661376.0
2011-09-26 09:00:00	QQQ	ETF	54.62	54.72	53.75	53.7699	10368838.0
2011-09-26 10:00:00	QQQ	ETF	53.76	53.86	53.21	53.8	21139349.0
2011-09-26 11:00:00	QQQ	ETF	53.8	54.4398	53.72	54.3501	11332775.0
2011-09-26 12:00:00	QQQ	ETF	54.36	54.38	53.73	53.8401	9014331.0
2011-09-26 13:00:00	QQQ	ETF	53.8499	53.85	53.5	53.71	9157049.0
2011-09-26 14:00:00	QQQ	ETF	53.71	54.22	53.67	54.17	10631039.0
2011-09-26 15:00:00	QQQ	ETF	54.17	54.88	54.14	54.78	14092269.0
2011-09-26 16:00:00	QQQ	ETF	54.77	54.84	54.74	54.78	1608304.0
2011-09-26 17:00:00	QQQ	ETF	54.77	54.77	54.7	54.73	196459.0
2011-09-26 18:00:00	QQQ	ETF	54.75	54.77	54.72	54.74	64539.0
2011-09-26 19:00:00	QQQ	ETF	54.75	54.76	54.66	54.66	54094.0
2011-09-26 04:00:00	IWM	ETF	65.18	65.44	65.18	65.44	700.0
2011-09-26 05:00:00	IWM	ETF	65.91	66.0	65.75	65.75	400.0
2011-09-26 06:00:00	IWM	ETF	65.7	65.95	65.6	65.92	21100.0
2011-09-26 07:00:00	IWM	ETF	65.99	66.53	65.99	66.11	138769.0
2011-09-26 08:00:00	IWM	ETF	66.1	66.375	65.9	66.03	351191.0
2011-09-26 09:00:00	IWM	ETF	66.01	66.13	64.91	64.95	6654301.0
2011-09-26 10:00:00	IWM	ETF	64.95	65.21	64.28	65.15	11378110.0
2011-09-26 11:00:00	IWM	ETF	65.15	65.86	65.05	65.712	8844438.0
2011-09-26 12:00:00	IWM	ETF	65.73	65.765	64.82	65.0	6290470.0
2011-09-26 13:00:00	IWM	ETF	65.0	65.0	64.49	64.76	6869323.0
2011-09-26 14:00:00	IWM	ETF	64.78	65.43	64.69	65.25	10224261.0
2011-09-26 15:00:00	IWM	ETF	65.26	66.48	65.26	66.39	17745283.0
2011-09-26 16:00:00	IWM	ETF	66.39	66.52	66.3	66.41	1118944.0
2011-09-26 17:00:00	IWM	ETF	66.4	66.43	66.35	66.36	35077.0
2011-09-26 18:00:00	IWM	ETF	66.34	66.38	66.3	66.36	22733.0
2011-09-26 19:00:00	IWM	ETF	66.36	66.45	66.33	66.33	2790.0
2011-09-26 04:00:00	DIA	ETF	108.1	108.2	108.1	108.2	1500.0
2011-09-26 05:00:00	DIA	ETF	108.15	108.45	108.15	108.4	7000.0

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

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