PREVIEW / etf_1hour / 2012-02-24

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-24.parquet
  size:    180 KB
  rows:    5,570

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-02-24 04:00:00	SPY	ETF	137.0	137.29	137.0	137.21	32066.0
2012-02-24 05:00:00	SPY	ETF	137.21	137.29	137.09	137.09	68600.0
2012-02-24 06:00:00	SPY	ETF	137.1	137.21	137.1	137.17	49950.0
2012-02-24 07:00:00	SPY	ETF	137.17	137.23	137.0	137.02	202897.0
2012-02-24 08:00:00	SPY	ETF	137.03	137.2	136.89	137.0	757772.0
2012-02-24 09:00:00	SPY	ETF	137.0	137.02	136.73	136.98	15703651.0
2012-02-24 10:00:00	SPY	ETF	136.97	137.09	136.77	136.82	16870069.0
2012-02-24 11:00:00	SPY	ETF	136.83	137.16	136.81	137.15	14659758.0
2012-02-24 12:00:00	SPY	ETF	137.1562	137.17	137.09	137.12	7343552.0
2012-02-24 13:00:00	SPY	ETF	137.115	137.2	136.865	136.98	11936785.0
2012-02-24 14:00:00	SPY	ETF	136.98	137.04	136.63	136.76	12245340.0
2012-02-24 15:00:00	SPY	ETF	136.7725	136.9	136.69	136.87	20752495.0
2012-02-24 16:00:00	SPY	ETF	136.88	136.93	136.77	136.8	4278467.0
2012-02-24 17:00:00	SPY	ETF	136.8	136.93	136.78	136.88	110936.0
2012-02-24 18:00:00	SPY	ETF	136.88	136.91	136.84	136.88	24775.0
2012-02-24 19:00:00	SPY	ETF	136.89	136.94	136.85	136.94	39775.0
2012-02-24 05:00:00	QQQ	ETF	63.96	63.96	63.96	63.96	200.0
2012-02-24 06:00:00	QQQ	ETF	64.01	64.02	64.01	64.01	3150.0
2012-02-24 07:00:00	QQQ	ETF	63.98	64.03	63.9	63.91	50200.0
2012-02-24 08:00:00	QQQ	ETF	63.91	63.94	63.89	63.92	158000.0
2012-02-24 09:00:00	QQQ	ETF	63.91	63.96	63.81	63.92	5220178.0
2012-02-24 10:00:00	QQQ	ETF	63.92	63.98	63.8	63.82	6005824.0
2012-02-24 11:00:00	QQQ	ETF	63.82	64.01	63.81	64.0	4759445.0
2012-02-24 12:00:00	QQQ	ETF	64.0007	64.07	63.98	64.04	2580273.0
2012-02-24 13:00:00	QQQ	ETF	64.04	64.07	63.96	63.99	4096943.0
2012-02-24 14:00:00	QQQ	ETF	63.99	64.05	63.83	63.9	3789422.0
2012-02-24 15:00:00	QQQ	ETF	63.8965	63.97	63.87	63.95	5532858.0
2012-02-24 16:00:00	QQQ	ETF	63.95	63.97	63.83	63.84	1010703.0
2012-02-24 17:00:00	QQQ	ETF	63.86	63.9	63.82	63.9	28506.0
2012-02-24 18:00:00	QQQ	ETF	63.89	63.89	63.84	63.88	4946.0
2012-02-24 19:00:00	QQQ	ETF	63.88	63.9	63.86	63.9	3970.0
2012-02-24 04:00:00	IWM	ETF	83.05	83.05	83.05	83.05	132.0
2012-02-24 07:00:00	IWM	ETF	83.11	83.17	83.02	83.02	4550.0
2012-02-24 08:00:00	IWM	ETF	82.98	83.0	82.89	82.93	27945.0
2012-02-24 09:00:00	IWM	ETF	82.89	82.95	82.56	82.83	5224342.0
2012-02-24 10:00:00	IWM	ETF	82.83	82.92	82.47	82.526	5025922.0
2012-02-24 11:00:00	IWM	ETF	82.52	82.97	82.51	82.96	4761133.0
2012-02-24 12:00:00	IWM	ETF	82.95	83.0299	82.89	82.94	3680599.0
2012-02-24 13:00:00	IWM	ETF	82.94	83.03	82.76	82.86	3009844.0
2012-02-24 14:00:00	IWM	ETF	82.85	82.9	82.49	82.59	3798750.0
2012-02-24 15:00:00	IWM	ETF	82.59	82.7	82.51	82.61	5868653.0
2012-02-24 16:00:00	IWM	ETF	82.61	82.9463	82.51	82.6	1290652.0
2012-02-24 17:00:00	IWM	ETF	82.58	82.61	82.53	82.54	38700.0
2012-02-24 19:00:00	IWM	ETF	82.55	82.58	82.55	82.58	982.0
2012-02-24 04:00:00	DIA	ETF	129.98	129.98	129.98	129.98	200.0
2012-02-24 07:00:00	DIA	ETF	129.91	129.91	129.91	129.91	100.0
2012-02-24 08:00:00	DIA	ETF	129.85	129.86	129.78	129.84	9200.0
2012-02-24 09:00:00	DIA	ETF	129.77	129.872	129.54	129.76	403370.0
2012-02-24 10:00:00	DIA	ETF	129.74	129.9	129.46	129.51	755694.0
2012-02-24 11:00:00	DIA	ETF	129.52	129.88	129.52	129.86	454619.0

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

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