PREVIEW / etf_1hour / 2010-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-06.parquet
  size:    162 KB
  rows:    4,927

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-08-06 04:00:00	SPY	ETF	113.0	113.04	112.94	113.0	1778.0
2010-08-06 05:00:00	SPY	ETF	112.86	112.87	112.86	112.87	1600.0
2010-08-06 06:00:00	SPY	ETF	112.94	113.0	112.85	112.98	77919.0
2010-08-06 07:00:00	SPY	ETF	112.96	113.18	112.91	113.12	1452262.0
2010-08-06 08:00:00	SPY	ETF	113.09	113.2	111.66	111.87	17256651.0
2010-08-06 09:00:00	SPY	ETF	111.86	112.56	111.67	112.5	31782092.0
2010-08-06 10:00:00	SPY	ETF	112.51	112.57	111.05	111.17	44819605.0
2010-08-06 11:00:00	SPY	ETF	111.18	111.46	110.92	111.28	32658855.0
2010-08-06 12:00:00	SPY	ETF	111.28	111.36	111.1	111.22	13644938.0
2010-08-06 13:00:00	SPY	ETF	111.2181	111.38	111.12	111.2698	14256401.0
2010-08-06 14:00:00	SPY	ETF	111.26	112.0	111.13	111.93	22326315.0
2010-08-06 15:00:00	SPY	ETF	111.93	112.43	111.8	112.39	46167035.0
2010-08-06 16:00:00	SPY	ETF	112.38	112.8237	111.103	112.41	9096559.0
2010-08-06 17:00:00	SPY	ETF	112.45	112.7	112.43	112.5	491584.0
2010-08-06 18:00:00	SPY	ETF	112.53	112.62	112.46	112.52	56334.0
2010-08-06 19:00:00	SPY	ETF	112.52	112.54	112.48	112.5	53556.0
2010-08-06 05:00:00	QQQ	ETF	46.76	46.76	46.73	46.73	19679.0
2010-08-06 07:00:00	QQQ	ETF	46.89	46.89	46.87	46.87	51814.0
2010-08-06 08:00:00	QQQ	ETF	46.89	46.95	46.28	46.36	3225690.0
2010-08-06 09:00:00	QQQ	ETF	46.37	46.82	46.29	46.8	9716613.0
2010-08-06 10:00:00	QQQ	ETF	46.81	46.85	46.1	46.16	15273417.0
2010-08-06 11:00:00	QQQ	ETF	46.15	46.37	46.05	46.31	7381590.0
2010-08-06 12:00:00	QQQ	ETF	46.3	46.35	46.19	46.3101	4558091.0
2010-08-06 13:00:00	QQQ	ETF	46.32	46.4	46.255	46.332	3602714.0
2010-08-06 14:00:00	QQQ	ETF	46.34	46.67	46.27	46.65	7070602.0
2010-08-06 15:00:00	QQQ	ETF	46.65	46.82	46.57	46.76	11513564.0
2010-08-06 16:00:00	QQQ	ETF	46.76	46.88	46.694	46.83	1934913.0
2010-08-06 17:00:00	QQQ	ETF	46.81	46.84	46.77	46.82	44523.0
2010-08-06 18:00:00	QQQ	ETF	46.83	46.83	46.8	46.8	11335.0
2010-08-06 19:00:00	QQQ	ETF	46.8	46.81	46.77	46.77	29391.0
2010-08-06 06:00:00	IWM	ETF	65.66	65.66	65.66	65.66	10000.0
2010-08-06 07:00:00	IWM	ETF	65.66	65.81	65.66	65.79	227300.0
2010-08-06 08:00:00	IWM	ETF	65.76	65.88	64.56	64.75	5152196.0
2010-08-06 09:00:00	IWM	ETF	64.73	65.35	64.37	65.34	9238101.0
2010-08-06 10:00:00	IWM	ETF	65.34	65.41	63.86	63.98	11336045.0
2010-08-06 11:00:00	IWM	ETF	63.99	64.61	63.91	64.44	6780845.0
2010-08-06 12:00:00	IWM	ETF	64.44	64.47	64.2	64.25	3521033.0
2010-08-06 13:00:00	IWM	ETF	64.25	64.4	64.11	64.29	3984342.0
2010-08-06 14:00:00	IWM	ETF	64.29	64.87	64.16	64.76	5649581.0
2010-08-06 15:00:00	IWM	ETF	64.77	65.19	64.66	65.13	9024986.0
2010-08-06 16:00:00	IWM	ETF	65.14	65.5184	64.9399	65.18	2722366.0
2010-08-06 17:00:00	IWM	ETF	65.18	65.32	65.16	65.32	10099.0
2010-08-06 18:00:00	IWM	ETF	65.19	65.32	65.19	65.2	940.0
2010-08-06 19:00:00	IWM	ETF	65.23	65.28	65.23	65.28	5700.0
2010-08-06 06:00:00	DIA	ETF	107.0	107.01	107.0	107.01	200.0
2010-08-06 07:00:00	DIA	ETF	107.01	107.01	106.97	107.01	1500.0
2010-08-06 08:00:00	DIA	ETF	107.02	107.2	105.56	106.11	87283.0
2010-08-06 09:00:00	DIA	ETF	106.04	106.67	105.84	106.67	1137545.0
2010-08-06 10:00:00	DIA	ETF	106.67	106.73	105.41	105.52	1772998.0
2010-08-06 11:00:00	DIA	ETF	105.51	105.75	105.31	105.6	992435.0

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

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