PREVIEW / etf_1hour / 2011-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-22.parquet
  size:    199 KB
  rows:    6,243

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-22 04:00:00	SPY	ETF	115.27	115.27	114.27	114.5	74258.0
2011-09-22 05:00:00	SPY	ETF	114.48	114.49	114.05	114.23	67162.0
2011-09-22 06:00:00	SPY	ETF	114.25	114.3	113.3	113.4	427279.0
2011-09-22 07:00:00	SPY	ETF	113.45	113.76	113.18	113.73	1704883.0
2011-09-22 08:00:00	SPY	ETF	113.71	115.54	112.65	112.96	8784180.0
2011-09-22 09:00:00	SPY	ETF	112.94	114.0	112.665	112.73	55523315.0
2011-09-22 10:00:00	SPY	ETF	112.75	114.21	112.7	113.3	71279648.0
2011-09-22 11:00:00	SPY	ETF	113.3085	113.55	112.77	112.77	50922452.0
2011-09-22 12:00:00	SPY	ETF	112.77	113.44	112.37	113.36	43785739.0
2011-09-22 13:00:00	SPY	ETF	113.36	113.42	111.8	111.82	45802092.0
2011-09-22 14:00:00	SPY	ETF	111.82	113.29	111.67	112.01	75060296.0
2011-09-22 15:00:00	SPY	ETF	112.01	113.55	111.3	112.9	101451765.0
2011-09-22 16:00:00	SPY	ETF	112.89	116.601	112.692	113.38	36747912.0
2011-09-22 17:00:00	SPY	ETF	113.39	116.601	112.8837	113.5	16314768.0
2011-09-22 18:00:00	SPY	ETF	113.5	113.65	112.8	113.3	703364.0
2011-09-22 19:00:00	SPY	ETF	113.38	113.75	113.15	113.66	294511.0
2011-09-22 04:00:00	QQQ	ETF	55.0	55.0	54.48	54.58	7190.0
2011-09-22 05:00:00	QQQ	ETF	54.42	54.5	54.33	54.35	29015.0
2011-09-22 06:00:00	QQQ	ETF	54.26	54.35	53.8	53.83	51650.0
2011-09-22 07:00:00	QQQ	ETF	53.91	54.18	53.77	54.11	238244.0
2011-09-22 08:00:00	QQQ	ETF	54.15	54.21	53.74	53.87	1661385.0
2011-09-22 09:00:00	QQQ	ETF	53.86	54.22	53.5	53.6	14466275.0
2011-09-22 10:00:00	QQQ	ETF	53.61	54.46	53.58	54.025	21578065.0
2011-09-22 11:00:00	QQQ	ETF	54.02	54.15	53.75	53.7599	12471136.0
2011-09-22 12:00:00	QQQ	ETF	53.75	54.05	53.51	53.97	8847070.0
2011-09-22 13:00:00	QQQ	ETF	53.974	54.0	53.02	53.0294	9478457.0
2011-09-22 14:00:00	QQQ	ETF	53.03	53.71	52.94	53.175	21366347.0
2011-09-22 15:00:00	QQQ	ETF	53.17	53.85	52.75	53.57	25153185.0
2011-09-22 16:00:00	QQQ	ETF	53.57	55.3919	53.2789	53.71	4404301.0
2011-09-22 17:00:00	QQQ	ETF	53.72	53.8	53.65	53.7	65932.0
2011-09-22 18:00:00	QQQ	ETF	53.73	53.81	53.71	53.72	32743.0
2011-09-22 19:00:00	QQQ	ETF	53.68	53.88	53.63	53.82	48270.0
2011-09-22 04:00:00	IWM	ETF	65.45	65.45	65.0	65.08	6223.0
2011-09-22 05:00:00	IWM	ETF	65.01	65.21	64.94	65.05	5221.0
2011-09-22 06:00:00	IWM	ETF	64.81	64.81	64.11	64.11	2400.0
2011-09-22 07:00:00	IWM	ETF	64.25	64.54	64.05	64.42	68216.0
2011-09-22 08:00:00	IWM	ETF	64.5	64.61	63.92	64.04	1342198.0
2011-09-22 09:00:00	IWM	ETF	64.02	65.2	63.96	64.54	15993659.0
2011-09-22 10:00:00	IWM	ETF	64.53	65.92	64.52	65.085	24135315.0
2011-09-22 11:00:00	IWM	ETF	65.08	65.32	64.66	64.67	12986832.0
2011-09-22 12:00:00	IWM	ETF	64.67	65.35	64.35	65.28	13191189.0
2011-09-22 13:00:00	IWM	ETF	65.27	65.33	64.0	64.01	11060346.0
2011-09-22 14:00:00	IWM	ETF	64.02	65.06	63.9	64.17	19405595.0
2011-09-22 15:00:00	IWM	ETF	64.16	64.71	63.49	64.65	28367564.0
2011-09-22 16:00:00	IWM	ETF	64.64	65.04	64.0	65.03	8484951.0
2011-09-22 17:00:00	IWM	ETF	65.03	65.18	64.97	65.18	433217.0
2011-09-22 18:00:00	IWM	ETF	65.16	65.32	65.16	65.25	203627.0
2011-09-22 19:00:00	IWM	ETF	65.21	65.25	65.1	65.1	5500.0
2011-09-22 04:00:00	DIA	ETF	110.27	110.27	109.0	109.0	8500.0
2011-09-22 05:00:00	DIA	ETF	109.1	109.1	108.85	108.9	7200.0

> showing 50 of 6,243 rows — these rows as CSV

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