PREVIEW / etf_1hour / 2012-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-09.parquet
  size:    183 KB
  rows:    5,635

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
2012-03-09 04:00:00	SPY	ETF	137.0	137.06	136.95	136.95	5645.0
2012-03-09 05:00:00	SPY	ETF	136.97	137.03	136.9	137.01	15400.0
2012-03-09 06:00:00	SPY	ETF	136.96	137.09	136.92	137.09	11919.0
2012-03-09 07:00:00	SPY	ETF	137.07	137.12	136.98	137.06	386989.0
2012-03-09 08:00:00	SPY	ETF	137.06	137.74	137.02	137.46	5879263.0
2012-03-09 09:00:00	SPY	ETF	137.45	137.52	137.13	137.235	14583963.0
2012-03-09 10:00:00	SPY	ETF	137.24	137.93	137.21	137.86	25857938.0
2012-03-09 11:00:00	SPY	ETF	137.86	137.9	137.69	137.8401	11415026.0
2012-03-09 12:00:00	SPY	ETF	137.85	137.87	137.72	137.8	6289324.0
2012-03-09 13:00:00	SPY	ETF	137.79	137.89	137.73	137.84	6319758.0
2012-03-09 14:00:00	SPY	ETF	137.86	137.9	137.35	137.47	15571883.0
2012-03-09 15:00:00	SPY	ETF	137.47	137.63	137.35	137.56	24828237.0
2012-03-09 16:00:00	SPY	ETF	137.56	137.78	137.25	137.68	10987878.0
2012-03-09 17:00:00	SPY	ETF	137.67	137.71	137.57	137.65	201430.0
2012-03-09 18:00:00	SPY	ETF	137.66	137.69	137.59	137.68	15737.0
2012-03-09 19:00:00	SPY	ETF	137.69	137.7	137.65	137.7	12062.0
2012-03-09 06:00:00	QQQ	ETF	64.75	64.75	64.75	64.75	100.0
2012-03-09 07:00:00	QQQ	ETF	64.75	64.79	64.72	64.76	22426.0
2012-03-09 08:00:00	QQQ	ETF	64.76	64.99	64.75	64.91	714487.0
2012-03-09 09:00:00	QQQ	ETF	64.9	65.03	64.8	64.84	5089476.0
2012-03-09 10:00:00	QQQ	ETF	64.8387	65.09	64.83	65.06	9161883.0
2012-03-09 11:00:00	QQQ	ETF	65.06	65.07	64.99	65.048	3117383.0
2012-03-09 12:00:00	QQQ	ETF	65.045	65.07	65.0	65.0586	1832823.0
2012-03-09 13:00:00	QQQ	ETF	65.05	65.12	65.0216	65.09	3670936.0
2012-03-09 14:00:00	QQQ	ETF	65.0938	65.14	64.93	64.97	6430134.0
2012-03-09 15:00:00	QQQ	ETF	64.97	65.04	64.92	65.01	7985109.0
2012-03-09 16:00:00	QQQ	ETF	65.01	65.05	64.97	64.99	1928636.0
2012-03-09 17:00:00	QQQ	ETF	65.0	65.02	64.96	65.02	90725.0
2012-03-09 18:00:00	QQQ	ETF	65.01	65.03	65.01	65.02	6105.0
2012-03-09 19:00:00	QQQ	ETF	65.05	65.06	65.02	65.06	4530.0
2012-03-09 06:00:00	IWM	ETF	80.4	80.4	80.4	80.4	3941.0
2012-03-09 07:00:00	IWM	ETF	80.5	80.52	80.4	80.46	40081.0
2012-03-09 08:00:00	IWM	ETF	80.46	80.88	80.42	80.65	882277.0
2012-03-09 09:00:00	IWM	ETF	80.65	81.02	80.46	80.78	5393268.0
2012-03-09 10:00:00	IWM	ETF	80.77	82.0	80.72	81.88	13407879.0
2012-03-09 11:00:00	IWM	ETF	81.88	82.14	81.83	82.09	7721371.0
2012-03-09 12:00:00	IWM	ETF	82.09	82.15	81.9699	81.99	2783917.0
2012-03-09 13:00:00	IWM	ETF	81.98	82.04	81.73	81.91	3750315.0
2012-03-09 14:00:00	IWM	ETF	81.91	81.95	81.38	81.46	6541752.0
2012-03-09 15:00:00	IWM	ETF	81.46	81.6329	81.35	81.62	10962107.0
2012-03-09 16:00:00	IWM	ETF	81.62	81.85	80.5	81.83	4602579.0
2012-03-09 17:00:00	IWM	ETF	81.84	81.92	81.79	81.79	19156.0
2012-03-09 18:00:00	IWM	ETF	81.84	81.94	81.84	81.94	49896.0
2012-03-09 19:00:00	IWM	ETF	81.82	81.91	81.82	81.9	3215.0
2012-03-09 07:00:00	DIA	ETF	129.05	129.05	129.05	129.05	200.0
2012-03-09 08:00:00	DIA	ETF	129.08	129.6	129.08	129.29	825835.0
2012-03-09 09:00:00	DIA	ETF	129.3	129.32	129.06	129.08	920642.0
2012-03-09 10:00:00	DIA	ETF	129.06	129.59	129.0512	129.51	1235870.0
2012-03-09 11:00:00	DIA	ETF	129.51	129.53	129.31	129.41	578808.0
2012-03-09 12:00:00	DIA	ETF	129.42	129.45	129.33	129.36	358093.0

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

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