PREVIEW / etf_1hour / 2011-03-11

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-11.parquet
  size:    184 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
2011-03-11 04:00:00	SPY	ETF	129.85	129.85	129.3	129.31	7799.0
2011-03-11 05:00:00	SPY	ETF	129.15	129.38	128.92	129.38	34136.0
2011-03-11 06:00:00	SPY	ETF	129.29	129.61	128.99	129.5	270950.0
2011-03-11 07:00:00	SPY	ETF	129.45	129.79	129.27	129.71	1772060.0
2011-03-11 08:00:00	SPY	ETF	129.7	129.95	129.41	129.6	4787594.0
2011-03-11 09:00:00	SPY	ETF	129.59	130.26	129.38	130.03	40934448.0
2011-03-11 10:00:00	SPY	ETF	130.03	130.21	129.64	130.0701	29388757.0
2011-03-11 11:00:00	SPY	ETF	130.08	130.63	129.86	130.53	26946718.0
2011-03-11 12:00:00	SPY	ETF	130.53	130.78	130.46	130.65	15084658.0
2011-03-11 13:00:00	SPY	ETF	130.65	130.67	130.3	130.47	15675986.0
2011-03-11 14:00:00	SPY	ETF	130.47	130.95	130.44	130.89	15561519.0
2011-03-11 15:00:00	SPY	ETF	130.88	131.31	130.84	130.84	36972229.0
2011-03-11 16:00:00	SPY	ETF	130.85	138.8681	129.8	131.0	36516983.0
2011-03-11 17:00:00	SPY	ETF	131.0	131.17	130.99	131.15	196315.0
2011-03-11 18:00:00	SPY	ETF	131.15	131.15	130.84	131.04	323272.0
2011-03-11 19:00:00	SPY	ETF	131.04	131.07	130.94	131.0	48000.0
2011-03-11 04:00:00	QQQ	ETF	55.95	55.95	55.8	55.8	1502.0
2011-03-11 05:00:00	QQQ	ETF	55.7	55.88	55.69	55.88	14300.0
2011-03-11 06:00:00	QQQ	ETF	55.81	55.93	55.7	55.92	19139.0
2011-03-11 07:00:00	QQQ	ETF	55.83	56.0	55.75	55.97	176173.0
2011-03-11 08:00:00	QQQ	ETF	55.96	56.09	55.88	55.95	1066738.0
2011-03-11 09:00:00	QQQ	ETF	55.94	56.26	55.82	56.11	18958037.0
2011-03-11 10:00:00	QQQ	ETF	56.11	56.16	55.89	56.07	14632781.0
2011-03-11 11:00:00	QQQ	ETF	56.08	56.38	55.97	56.36	9633834.0
2011-03-11 12:00:00	QQQ	ETF	56.36	56.47	56.29	56.45	4690506.0
2011-03-11 13:00:00	QQQ	ETF	56.455	56.47	56.25	56.3211	5594653.0
2011-03-11 14:00:00	QQQ	ETF	56.32	56.52	56.29	56.49	5306445.0
2011-03-11 15:00:00	QQQ	ETF	56.49	56.66	56.47	56.47	11095827.0
2011-03-11 16:00:00	QQQ	ETF	56.47	56.67	56.41	56.63	1757762.0
2011-03-11 17:00:00	QQQ	ETF	56.64	56.67	56.5401	56.65	188998.0
2011-03-11 18:00:00	QQQ	ETF	56.65	56.66	56.49	56.65	29355.0
2011-03-11 19:00:00	QQQ	ETF	56.65	56.65	56.6	56.6	29351.0
2011-03-11 04:00:00	IWM	ETF	79.4	79.4	79.18	79.18	936.0
2011-03-11 05:00:00	IWM	ETF	79.06	79.06	79.0	79.0	250.0
2011-03-11 06:00:00	IWM	ETF	79.03	79.36	79.02	79.36	41050.0
2011-03-11 07:00:00	IWM	ETF	79.31	79.43	79.1	79.41	152275.0
2011-03-11 08:00:00	IWM	ETF	79.4	79.63	79.29	79.31	1279950.0
2011-03-11 09:00:00	IWM	ETF	79.31	80.12	79.22	79.71	12894165.0
2011-03-11 10:00:00	IWM	ETF	79.7	79.84	79.33	79.52	10770666.0
2011-03-11 11:00:00	IWM	ETF	79.53	80.11	79.44	80.08	10431354.0
2011-03-11 12:00:00	IWM	ETF	80.09	80.34	79.96	80.15	7443038.0
2011-03-11 13:00:00	IWM	ETF	80.15	80.19	79.79	80.03	5698499.0
2011-03-11 14:00:00	IWM	ETF	80.03	80.36	80.01	80.302	3981985.0
2011-03-11 15:00:00	IWM	ETF	80.3	80.7	79.9231	80.16	13737667.0
2011-03-11 16:00:00	IWM	ETF	80.15	80.37	80.06	80.23	2005771.0
2011-03-11 17:00:00	IWM	ETF	80.3	80.31	80.21	80.25	20078.0
2011-03-11 18:00:00	IWM	ETF	80.26	80.26	80.22	80.23	5600.0
2011-03-11 19:00:00	IWM	ETF	80.26	80.26	80.19	80.24	2100.0
2011-03-11 04:00:00	DIA	ETF	119.48	119.48	119.15	119.15	1600.0
2011-03-11 05:00:00	DIA	ETF	119.1	119.17	119.0	119.17	5900.0

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

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