PREVIEW / etf_1hour / 2010-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-02.parquet
  size:    155 KB
  rows:    4,797

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
2010-07-02 04:00:00	SPY	ETF	102.82	102.82	102.82	102.82	100.0
2010-07-02 05:00:00	SPY	ETF	102.71	102.8	102.64	102.8	3000.0
2010-07-02 06:00:00	SPY	ETF	102.8	102.88	102.67	102.67	25300.0
2010-07-02 07:00:00	SPY	ETF	102.67	103.03	102.66	103.02	678577.0
2010-07-02 08:00:00	SPY	ETF	103.0	103.75	102.27	102.67	21383999.0
2010-07-02 09:00:00	SPY	ETF	102.66	103.42	102.62	102.95	33859321.0
2010-07-02 10:00:00	SPY	ETF	102.95	103.13	102.45	102.59	32808377.0
2010-07-02 11:00:00	SPY	ETF	102.59	102.74	101.8	102.1081	27219692.0
2010-07-02 12:00:00	SPY	ETF	102.1001	102.35	101.85	101.885	14392629.0
2010-07-02 13:00:00	SPY	ETF	101.885	102.26	101.62	102.21	24652632.0
2010-07-02 14:00:00	SPY	ETF	102.22	102.27	101.91	102.195	16737554.0
2010-07-02 15:00:00	SPY	ETF	102.19	103.11	102.11	102.26	36910511.0
2010-07-02 16:00:00	SPY	ETF	102.26	103.0486	101.87	101.93	19998601.0
2010-07-02 17:00:00	SPY	ETF	101.95	101.96	101.86	101.94	207300.0
2010-07-02 18:00:00	SPY	ETF	101.95	102.2	101.87	101.94	62846.0
2010-07-02 19:00:00	SPY	ETF	101.92	101.94	101.86	101.9	30614.0
2010-07-02 05:00:00	QQQ	ETF	42.58	42.62	42.58	42.62	3200.0
2010-07-02 06:00:00	QQQ	ETF	42.59	42.59	42.59	42.59	200.0
2010-07-02 07:00:00	QQQ	ETF	42.59	42.72	42.57	42.71	49941.0
2010-07-02 08:00:00	QQQ	ETF	42.73	42.95	42.41	42.56	2794475.0
2010-07-02 09:00:00	QQQ	ETF	42.55	42.83	42.53	42.64	13384982.0
2010-07-02 10:00:00	QQQ	ETF	42.64	42.73	42.45	42.49	9172250.0
2010-07-02 11:00:00	QQQ	ETF	42.5	42.6	42.25	42.36	9271723.0
2010-07-02 12:00:00	QQQ	ETF	42.37	42.48	42.23	42.26	5925416.0
2010-07-02 13:00:00	QQQ	ETF	42.2696	42.44	42.09	42.41	8789883.0
2010-07-02 14:00:00	QQQ	ETF	42.42	42.47	42.29	42.4319	6136238.0
2010-07-02 15:00:00	QQQ	ETF	42.43	42.81	42.38	42.47	12163083.0
2010-07-02 16:00:00	QQQ	ETF	42.47	42.6429	42.32	42.36	3363536.0
2010-07-02 17:00:00	QQQ	ETF	42.35	42.45	42.35	42.37	62251.0
2010-07-02 18:00:00	QQQ	ETF	42.37	42.46	42.35	42.42	20521.0
2010-07-02 19:00:00	QQQ	ETF	42.42	42.42	42.33	42.33	15653.0
2010-07-02 05:00:00	IWM	ETF	60.43	60.48	60.43	60.48	11500.0
2010-07-02 06:00:00	IWM	ETF	60.45	60.45	60.45	60.45	300.0
2010-07-02 07:00:00	IWM	ETF	60.5	60.71	60.47	60.69	75434.0
2010-07-02 08:00:00	IWM	ETF	61.35	61.35	60.36	60.61	1732759.0
2010-07-02 09:00:00	IWM	ETF	60.6	61.0	60.18	60.36	8892025.0
2010-07-02 10:00:00	IWM	ETF	60.35	60.56	60.0001	60.1	10790103.0
2010-07-02 11:00:00	IWM	ETF	60.11	60.21	59.42	59.67	10284078.0
2010-07-02 12:00:00	IWM	ETF	59.66	59.98	59.59	59.75	4755721.0
2010-07-02 13:00:00	IWM	ETF	59.75	59.89	59.52	59.85	6060781.0
2010-07-02 14:00:00	IWM	ETF	59.85	59.87	59.56	59.758	5234541.0
2010-07-02 15:00:00	IWM	ETF	59.75	60.33	59.67	59.82	15395942.0
2010-07-02 16:00:00	IWM	ETF	59.82	60.4496	59.56	59.67	4185755.0
2010-07-02 17:00:00	IWM	ETF	60.4497	60.4497	59.56	59.6	1024064.0
2010-07-02 18:00:00	IWM	ETF	59.58	59.66	59.55	59.63	12402.0
2010-07-02 19:00:00	IWM	ETF	59.64	59.69	59.6	59.6	3900.0
2010-07-02 08:00:00	DIA	ETF	97.51	98.15	96.93	97.23	138885.0
2010-07-02 09:00:00	DIA	ETF	97.35	97.74	97.24	97.43	1841089.0
2010-07-02 10:00:00	DIA	ETF	97.42	97.51	96.96	97.0	2256016.0
2010-07-02 11:00:00	DIA	ETF	97.01	97.13	96.33	96.61	1656838.0

> showing 50 of 4,797 rows — these rows as CSV

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