PREVIEW / etf_1hour / 2012-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-01.parquet
  size:    184 KB
  rows:    5,743

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-11-01 04:00:00	SPY	ETF	141.15	141.15	140.77	140.93	29160.0
2012-11-01 05:00:00	SPY	ETF	140.94	140.94	140.74	140.83	1000.0
2012-11-01 06:00:00	SPY	ETF	140.89	141.19	140.89	141.17	95435.0
2012-11-01 07:00:00	SPY	ETF	141.17	141.41	141.12	141.38	373994.0
2012-11-01 08:00:00	SPY	ETF	141.35	141.62	141.19	141.48	1509541.0
2012-11-01 09:00:00	SPY	ETF	141.48	142.31	141.18	142.16	12643289.0
2012-11-01 10:00:00	SPY	ETF	142.16	142.948	142.14	142.79	19489946.0
2012-11-01 11:00:00	SPY	ETF	142.79	143.01	142.57	142.86	11911001.0
2012-11-01 12:00:00	SPY	ETF	142.86	142.93	142.62	142.67	8337769.0
2012-11-01 13:00:00	SPY	ETF	142.66	142.74	142.51	142.56	7429385.0
2012-11-01 14:00:00	SPY	ETF	142.5636	142.9	142.47	142.82	11366474.0
2012-11-01 15:00:00	SPY	ETF	142.8201	142.92	142.58	142.88	17921869.0
2012-11-01 16:00:00	SPY	ETF	142.87	143.15	141.3476	143.07	7153032.0
2012-11-01 17:00:00	SPY	ETF	143.06	143.09	141.348	143.03	1514572.0
2012-11-01 18:00:00	SPY	ETF	143.03	143.05	142.94	142.95	58652.0
2012-11-01 19:00:00	SPY	ETF	142.95	143.05	142.9	143.05	27691.0
2012-11-01 06:00:00	QQQ	ETF	64.91	65.03	64.91	64.99	7600.0
2012-11-01 07:00:00	QQQ	ETF	65.01	65.12	64.97	65.11	25095.0
2012-11-01 08:00:00	QQQ	ETF	65.1	65.5	65.05	65.15	123984.0
2012-11-01 09:00:00	QQQ	ETF	65.16	65.5	65.12	65.46	3325123.0
2012-11-01 10:00:00	QQQ	ETF	65.47	65.93	65.46	65.89	5168686.0
2012-11-01 11:00:00	QQQ	ETF	65.89	66.0	65.76	65.94	3562045.0
2012-11-01 12:00:00	QQQ	ETF	65.945	65.98	65.8	65.82	1764179.0
2012-11-01 13:00:00	QQQ	ETF	65.815	65.8699	65.73	65.82	2086917.0
2012-11-01 14:00:00	QQQ	ETF	65.8101	65.96	65.76	65.93	2215830.0
2012-11-01 15:00:00	QQQ	ETF	65.93	65.97	65.78	65.89	4795135.0
2012-11-01 16:00:00	QQQ	ETF	65.89	66.11	64.9405	66.08	2836993.0
2012-11-01 17:00:00	QQQ	ETF	66.07	66.08	66.01	66.06	230815.0
2012-11-01 18:00:00	QQQ	ETF	66.07	66.07	66.01	66.03	73660.0
2012-11-01 19:00:00	QQQ	ETF	66.01	66.06	66.01	66.05	11649.0
2012-11-01 07:00:00	IWM	ETF	81.43	81.6	81.43	81.59	26100.0
2012-11-01 08:00:00	IWM	ETF	81.59	82.28	81.45	81.64	281413.0
2012-11-01 09:00:00	IWM	ETF	81.6	82.27	81.52	82.18	4083208.0
2012-11-01 10:00:00	IWM	ETF	82.17	82.71	82.14	82.49	10293332.0
2012-11-01 11:00:00	IWM	ETF	82.48	82.66	82.38	82.57	8196304.0
2012-11-01 12:00:00	IWM	ETF	82.57	82.6	82.11	82.12	6145244.0
2012-11-01 13:00:00	IWM	ETF	82.12	82.12	81.92	82.02	6522582.0
2012-11-01 14:00:00	IWM	ETF	82.03	82.57	82.0	82.515	5304842.0
2012-11-01 15:00:00	IWM	ETF	82.51	82.58	82.31	82.51	9577443.0
2012-11-01 16:00:00	IWM	ETF	82.5	82.62	81.63	82.62	5217401.0
2012-11-01 17:00:00	IWM	ETF	82.55	82.55	82.55	82.55	16200.0
2012-11-01 18:00:00	IWM	ETF	82.55	82.55	82.55	82.55	500.0
2012-11-01 19:00:00	IWM	ETF	82.55	82.56	82.38	82.51	19402.0
2012-11-01 09:00:00	DIA	ETF	130.87	131.97	130.87	131.85	605410.0
2012-11-01 10:00:00	DIA	ETF	131.89	132.436	131.88	132.25	795251.0
2012-11-01 11:00:00	DIA	ETF	132.245	132.28	132.02	132.0901	485132.0
2012-11-01 12:00:00	DIA	ETF	132.08	132.17	131.85	131.87	393597.0
2012-11-01 13:00:00	DIA	ETF	131.87	131.95	131.72	131.81	287163.0
2012-11-01 14:00:00	DIA	ETF	131.811	132.03	131.7	131.97	390132.0
2012-11-01 15:00:00	DIA	ETF	131.97	132.03	131.7	131.99	777545.0

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

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