PREVIEW / etf_1hour / 2012-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-01.parquet
  size:    185 KB
  rows:    5,736

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-01 04:00:00	SPY	ETF	136.98	137.1	136.81	137.06	63358.0
2012-03-01 05:00:00	SPY	ETF	136.98	137.16	136.95	137.02	48480.0
2012-03-01 06:00:00	SPY	ETF	137.08	137.31	137.02	137.31	178488.0
2012-03-01 07:00:00	SPY	ETF	137.25	137.34	137.07	137.26	368313.0
2012-03-01 08:00:00	SPY	ETF	137.2	137.4	137.2	137.29	2442482.0
2012-03-01 09:00:00	SPY	ETF	137.29	137.82	136.87	137.78	18345892.0
2012-03-01 10:00:00	SPY	ETF	137.78	137.78	137.12	137.47	33038098.0
2012-03-01 11:00:00	SPY	ETF	137.47	137.76	137.34	137.7	15781637.0
2012-03-01 12:00:00	SPY	ETF	137.69	137.86	137.61	137.75	8150586.0
2012-03-01 13:00:00	SPY	ETF	137.75	137.99	137.68	137.91	13728454.0
2012-03-01 14:00:00	SPY	ETF	137.91	137.99	137.67	137.78	7441245.0
2012-03-01 15:00:00	SPY	ETF	137.77	137.87	137.27	137.73	36042085.0
2012-03-01 16:00:00	SPY	ETF	137.72	138.2	137.4707	137.99	8380618.0
2012-03-01 17:00:00	SPY	ETF	137.98	138.06	137.96	138.04	327624.0
2012-03-01 18:00:00	SPY	ETF	138.03	138.13	138.03	138.13	116674.0
2012-03-01 19:00:00	SPY	ETF	138.13	138.17	138.05	138.07	166758.0
2012-03-01 06:00:00	QQQ	ETF	64.6	64.7	64.59	64.7	29220.0
2012-03-01 07:00:00	QQQ	ETF	64.68	64.69	64.59	64.65	165908.0
2012-03-01 08:00:00	QQQ	ETF	64.65	64.73	64.63	64.66	839404.0
2012-03-01 09:00:00	QQQ	ETF	64.67	64.83	64.52	64.78	7805317.0
2012-03-01 10:00:00	QQQ	ETF	64.78	64.78	64.46	64.58	18926852.0
2012-03-01 11:00:00	QQQ	ETF	64.58	64.82	64.53	64.79	6708469.0
2012-03-01 12:00:00	QQQ	ETF	64.78	64.86	64.7399	64.838	3335619.0
2012-03-01 13:00:00	QQQ	ETF	64.84	64.97	64.7993	64.93	4870701.0
2012-03-01 14:00:00	QQQ	ETF	64.935	64.98	64.86	64.91	3424570.0
2012-03-01 15:00:00	QQQ	ETF	64.91	64.96	64.68	64.92	9022195.0
2012-03-01 16:00:00	QQQ	ETF	64.92	65.06	64.8418	65.0	985014.0
2012-03-01 17:00:00	QQQ	ETF	65.0	65.04	64.92	65.04	219757.0
2012-03-01 18:00:00	QQQ	ETF	65.03	65.03	64.99	65.02	53165.0
2012-03-01 19:00:00	QQQ	ETF	65.03	65.05	64.99	65.02	21878.0
2012-03-01 06:00:00	IWM	ETF	81.17	81.32	81.17	81.32	3446.0
2012-03-01 07:00:00	IWM	ETF	81.36	81.37	81.16	81.21	23134.0
2012-03-01 08:00:00	IWM	ETF	81.22	81.36	80.99	81.32	209730.0
2012-03-01 09:00:00	IWM	ETF	81.33	81.95	80.99	81.83	7285026.0
2012-03-01 10:00:00	IWM	ETF	81.85	81.943	81.36	81.8301	13374613.0
2012-03-01 11:00:00	IWM	ETF	81.84	81.92	81.48	81.8	5848181.0
2012-03-01 12:00:00	IWM	ETF	81.8	82.19	81.72	82.12	4287424.0
2012-03-01 13:00:00	IWM	ETF	82.13	82.37	82.0299	82.15	4899011.0
2012-03-01 14:00:00	IWM	ETF	82.15	82.24	81.88	82.02	5408915.0
2012-03-01 15:00:00	IWM	ETF	82.03	82.06	81.42	81.43	15095113.0
2012-03-01 16:00:00	IWM	ETF	81.43	82.35	81.42	81.7	7387313.0
2012-03-01 17:00:00	IWM	ETF	81.7	81.75	81.68	81.75	5225.0
2012-03-01 18:00:00	IWM	ETF	81.73	81.75	81.47	81.75	8942.0
2012-03-01 19:00:00	IWM	ETF	81.75	81.75	81.75	81.75	3014.0
2012-03-01 06:00:00	DIA	ETF	129.57	129.57	129.57	129.57	100.0
2012-03-01 07:00:00	DIA	ETF	129.67	129.7	129.51	129.55	1150.0
2012-03-01 08:00:00	DIA	ETF	129.63	129.76	129.63	129.66	11150.0
2012-03-01 09:00:00	DIA	ETF	129.68	130.16	129.57	130.09	860185.0
2012-03-01 10:00:00	DIA	ETF	130.07	130.09	129.51	129.7198	1656525.0
2012-03-01 11:00:00	DIA	ETF	129.72	129.84	129.54	129.77	742215.0

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

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