PREVIEW / etf_1hour / 2012-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-23.parquet
  size:    184 KB
  rows:    5,675

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-23 04:00:00	SPY	ETF	136.2	136.65	136.2	136.43	56954.0
2012-02-23 05:00:00	SPY	ETF	136.4	136.47	136.1	136.16	41250.0
2012-02-23 06:00:00	SPY	ETF	136.16	136.16	136.1	136.1	1125.0
2012-02-23 07:00:00	SPY	ETF	136.13	136.2	135.97	136.1	831761.0
2012-02-23 08:00:00	SPY	ETF	136.1	136.36	136.07	136.27	2070412.0
2012-02-23 09:00:00	SPY	ETF	136.26	136.27	135.5	135.67	16930419.0
2012-02-23 10:00:00	SPY	ETF	135.67	136.37	135.65	136.34	30064337.0
2012-02-23 11:00:00	SPY	ETF	136.335	136.51	136.26	136.3901	19604640.0
2012-02-23 12:00:00	SPY	ETF	136.39	136.55	136.31	136.39	11019991.0
2012-02-23 13:00:00	SPY	ETF	136.3885	136.43	136.2	136.38	11156779.0
2012-02-23 14:00:00	SPY	ETF	136.39	136.53	136.27	136.415	13165124.0
2012-02-23 15:00:00	SPY	ETF	136.41	136.73	136.38	136.63	24384937.0
2012-02-23 16:00:00	SPY	ETF	136.63	136.83	135.7767	136.77	5029234.0
2012-02-23 17:00:00	SPY	ETF	136.77	136.92	136.77	136.86	373988.0
2012-02-23 18:00:00	SPY	ETF	136.9	137.03	136.89	136.98	136929.0
2012-02-23 19:00:00	SPY	ETF	137.0	137.05	136.93	137.03	79623.0
2012-02-23 04:00:00	QQQ	ETF	63.55	63.59	63.55	63.59	1500.0
2012-02-23 05:00:00	QQQ	ETF	63.43	63.43	63.43	63.43	200.0
2012-02-23 07:00:00	QQQ	ETF	63.44	63.45	63.41	63.41	37755.0
2012-02-23 08:00:00	QQQ	ETF	63.42	63.55	63.4	63.49	1379667.0
2012-02-23 09:00:00	QQQ	ETF	63.5	63.5	63.09	63.27	4740248.0
2012-02-23 10:00:00	QQQ	ETF	63.26	63.6617	63.26	63.64	7467341.0
2012-02-23 11:00:00	QQQ	ETF	63.65	63.8	63.61	63.69	7380839.0
2012-02-23 12:00:00	QQQ	ETF	63.7	63.74	63.52	63.57	5536898.0
2012-02-23 13:00:00	QQQ	ETF	63.57	63.63	63.38	63.53	6453386.0
2012-02-23 14:00:00	QQQ	ETF	63.53	63.66	63.44	63.57	5573440.0
2012-02-23 15:00:00	QQQ	ETF	63.58	63.81	63.53	63.73	7294858.0
2012-02-23 16:00:00	QQQ	ETF	63.73	63.8833	63.72	63.87	1388672.0
2012-02-23 17:00:00	QQQ	ETF	63.87	63.95	63.85	63.89	241809.0
2012-02-23 18:00:00	QQQ	ETF	63.89	63.95	63.88	63.94	105192.0
2012-02-23 19:00:00	QQQ	ETF	63.94	63.97	63.93	63.97	17807.0
2012-02-23 04:00:00	IWM	ETF	82.0	82.0	82.0	82.0	845.0
2012-02-23 05:00:00	IWM	ETF	81.9	81.9	81.71	81.79	5845.0
2012-02-23 06:00:00	IWM	ETF	81.84	81.84	81.79	81.79	826.0
2012-02-23 07:00:00	IWM	ETF	81.8	81.8	81.74	81.74	5213.0
2012-02-23 08:00:00	IWM	ETF	81.7	81.99	81.7	81.91	652144.0
2012-02-23 09:00:00	IWM	ETF	81.91	81.91	81.26	81.6	5828846.0
2012-02-23 10:00:00	IWM	ETF	81.59	82.28	81.59	82.26	9502532.0
2012-02-23 11:00:00	IWM	ETF	82.26	82.63	82.2	82.46	8383544.0
2012-02-23 12:00:00	IWM	ETF	82.47	82.78	82.39	82.6	4874490.0
2012-02-23 13:00:00	IWM	ETF	82.595	82.61	82.29	82.5	2889234.0
2012-02-23 14:00:00	IWM	ETF	82.5	82.6	82.39	82.55	3255586.0
2012-02-23 15:00:00	IWM	ETF	82.54	82.85	82.5	82.8	8614435.0
2012-02-23 16:00:00	IWM	ETF	82.79	82.9	82.73	82.84	2574972.0
2012-02-23 17:00:00	IWM	ETF	82.88	82.92	82.88	82.92	8800.0
2012-02-23 18:00:00	IWM	ETF	82.92	82.96	82.89	82.91	19594.0
2012-02-23 19:00:00	IWM	ETF	82.9	82.94	82.9	82.94	2400.0
2012-02-23 07:00:00	DIA	ETF	129.21	129.28	129.19	129.23	3200.0
2012-02-23 08:00:00	DIA	ETF	129.19	129.35	129.19	129.3	23924.0
2012-02-23 09:00:00	DIA	ETF	129.23	129.23	128.55	128.73	2362313.0

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

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