PREVIEW / etf_1hour / 2011-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-01.parquet
  size:    184 KB
  rows:    5,546

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-03-01 04:00:00	SPY	ETF	133.9	134.01	133.73	133.8	34982.0
2011-03-01 05:00:00	SPY	ETF	133.71	133.81	133.7	133.8	3600.0
2011-03-01 06:00:00	SPY	ETF	133.76	133.76	133.57	133.62	103274.0
2011-03-01 07:00:00	SPY	ETF	133.64	133.64	133.2	133.46	1067585.0
2011-03-01 08:00:00	SPY	ETF	133.46	133.54	133.15	133.51	1950691.0
2011-03-01 09:00:00	SPY	ETF	133.51	133.69	132.97	133.07	19804248.0
2011-03-01 10:00:00	SPY	ETF	133.06	133.25	132.2	132.78	38740111.0
2011-03-01 11:00:00	SPY	ETF	132.78	132.93	131.96	132.01	26097346.0
2011-03-01 12:00:00	SPY	ETF	132.01	132.12	131.7	131.94	19431748.0
2011-03-01 13:00:00	SPY	ETF	131.93	131.99	131.44	131.64	20137691.0
2011-03-01 14:00:00	SPY	ETF	131.645	131.65	131.02	131.17	28280715.0
2011-03-01 15:00:00	SPY	ETF	131.17	131.37	130.92	130.92	37936774.0
2011-03-01 16:00:00	SPY	ETF	130.94	133.08	130.26	130.31	24972268.0
2011-03-01 17:00:00	SPY	ETF	130.31	130.31	130.14	130.23	28443019.0
2011-03-01 18:00:00	SPY	ETF	130.23	130.97	130.23	130.52	731649.0
2011-03-01 19:00:00	SPY	ETF	130.5	130.66	130.38	130.47	210561.0
2011-03-01 04:00:00	QQQ	ETF	58.03	58.25	58.03	58.25	1300.0
2011-03-01 05:00:00	QQQ	ETF	58.14	58.14	58.14	58.14	100.0
2011-03-01 06:00:00	QQQ	ETF	58.1	58.1	58.06	58.1	12000.0
2011-03-01 07:00:00	QQQ	ETF	58.07	58.09	57.86	57.97	548880.0
2011-03-01 08:00:00	QQQ	ETF	57.97	58.02	57.89	57.98	238321.0
2011-03-01 09:00:00	QQQ	ETF	57.98	58.03	57.67	57.75	9092165.0
2011-03-01 10:00:00	QQQ	ETF	57.75	57.84	57.3	57.64	12971718.0
2011-03-01 11:00:00	QQQ	ETF	57.64	57.71	57.19	57.22	8502707.0
2011-03-01 12:00:00	QQQ	ETF	57.22	57.24	57.06	57.1495	7196909.0
2011-03-01 13:00:00	QQQ	ETF	57.14	57.19	56.98	57.09	7554384.0
2011-03-01 14:00:00	QQQ	ETF	57.09	57.093	56.72	56.8	14529354.0
2011-03-01 15:00:00	QQQ	ETF	56.81	56.98	56.695	56.86	14837130.0
2011-03-01 16:00:00	QQQ	ETF	56.86	56.8874	56.66	56.68	2867012.0
2011-03-01 17:00:00	QQQ	ETF	56.68	56.68	56.6	56.61	84024.0
2011-03-01 18:00:00	QQQ	ETF	56.64	56.88	56.64	56.78	72249.0
2011-03-01 19:00:00	QQQ	ETF	56.77	56.82	56.69	56.73	17844.0
2011-03-01 04:00:00	IWM	ETF	82.97	82.99	82.97	82.99	800.0
2011-03-01 06:00:00	IWM	ETF	82.67	82.69	82.67	82.69	1300.0
2011-03-01 07:00:00	IWM	ETF	82.71	82.71	82.37	82.53	85500.0
2011-03-01 08:00:00	IWM	ETF	82.53	82.56	82.43	82.53	185641.0
2011-03-01 09:00:00	IWM	ETF	82.53	82.64	81.97	82.05	6693838.0
2011-03-01 10:00:00	IWM	ETF	82.04	82.28	81.46	82.06	11675135.0
2011-03-01 11:00:00	IWM	ETF	82.07	82.23	81.34	81.39	7180535.0
2011-03-01 12:00:00	IWM	ETF	81.39	81.5	81.101	81.32	6478534.0
2011-03-01 13:00:00	IWM	ETF	81.32	81.3301	80.87	81.0499	6537381.0
2011-03-01 14:00:00	IWM	ETF	81.0374	81.05	80.48	80.56	8663656.0
2011-03-01 15:00:00	IWM	ETF	80.57	80.89	80.35	80.57	14432767.0
2011-03-01 16:00:00	IWM	ETF	80.58	82.2725	80.2	80.22	3293089.0
2011-03-01 17:00:00	IWM	ETF	80.22	80.23	80.13	80.13	32360.0
2011-03-01 18:00:00	IWM	ETF	80.12	80.35	80.12	80.33	9559.0
2011-03-01 19:00:00	IWM	ETF	80.33	80.41	80.25	80.27	13790.0
2011-03-01 07:00:00	DIA	ETF	122.26	122.3	122.25	122.3	1950.0
2011-03-01 08:00:00	DIA	ETF	122.29	122.47	122.29	122.39	5650.0
2011-03-01 09:00:00	DIA	ETF	122.38	122.48	122.09	122.17	1053202.0

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

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