PREVIEW / etf_1hour / 2010-09-03

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-03.parquet
  size:    164 KB
  rows:    5,028

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-09-03 04:00:00	SPY	ETF	109.34	109.42	109.34	109.42	800.0
2010-09-03 05:00:00	SPY	ETF	109.47	109.63	109.47	109.63	25120.0
2010-09-03 06:00:00	SPY	ETF	109.63	109.74	109.6	109.6	700.0
2010-09-03 07:00:00	SPY	ETF	109.6	109.61	109.33	109.35	537519.0
2010-09-03 08:00:00	SPY	ETF	109.36	110.93	109.32	110.71	14320896.0
2010-09-03 09:00:00	SPY	ETF	110.71	110.99	110.51	110.91	29710700.0
2010-09-03 10:00:00	SPY	ETF	110.9	110.91	109.95	110.15	45285459.0
2010-09-03 11:00:00	SPY	ETF	110.15	110.43	110.04	110.29	17621493.0
2010-09-03 12:00:00	SPY	ETF	110.285	110.67	110.25	110.595	12188106.0
2010-09-03 13:00:00	SPY	ETF	110.59	110.84	110.55	110.8	14020739.0
2010-09-03 14:00:00	SPY	ETF	110.795	110.85	110.5	110.52	17702450.0
2010-09-03 15:00:00	SPY	ETF	110.51	110.94	110.25	110.91	37233850.0
2010-09-03 16:00:00	SPY	ETF	110.91	111.02	109.4809	111.0	23011617.0
2010-09-03 17:00:00	SPY	ETF	110.98	111.03	110.91	110.92	133126.0
2010-09-03 18:00:00	SPY	ETF	110.92	110.98	110.92	110.96	38586.0
2010-09-03 19:00:00	SPY	ETF	110.97	110.98	110.92	110.98	32922.0
2010-09-03 06:00:00	QQQ	ETF	45.35	45.38	45.3	45.3	2700.0
2010-09-03 07:00:00	QQQ	ETF	45.3	45.3	45.18	45.19	392183.0
2010-09-03 08:00:00	QQQ	ETF	45.2	45.88	45.18	45.79	4408355.0
2010-09-03 09:00:00	QQQ	ETF	45.79	46.02	45.69	46.0	8756301.0
2010-09-03 10:00:00	QQQ	ETF	45.99	45.99	45.55	45.6419	13549446.0
2010-09-03 11:00:00	QQQ	ETF	45.645	45.78	45.58	45.72	4559892.0
2010-09-03 12:00:00	QQQ	ETF	45.72	45.91	45.7	45.8691	7503456.0
2010-09-03 13:00:00	QQQ	ETF	45.86	45.985	45.85	45.98	4925814.0
2010-09-03 14:00:00	QQQ	ETF	45.98	46.01	45.84	45.85	5597454.0
2010-09-03 15:00:00	QQQ	ETF	45.845	46.02	45.825	46.01	8100735.0
2010-09-03 16:00:00	QQQ	ETF	46.0	46.05	45.9302	46.01	2644221.0
2010-09-03 17:00:00	QQQ	ETF	46.0	46.01	45.99	46.01	20170.0
2010-09-03 18:00:00	QQQ	ETF	46.01	46.02	45.98	45.99	18020.0
2010-09-03 19:00:00	QQQ	ETF	45.98	46.05	45.97	46.05	52303.0
2010-09-03 06:00:00	IWM	ETF	63.37	63.37	63.37	63.37	299.0
2010-09-03 07:00:00	IWM	ETF	63.37	63.37	63.14	63.15	108929.0
2010-09-03 08:00:00	IWM	ETF	63.15	64.33	63.15	64.2	1863343.0
2010-09-03 09:00:00	IWM	ETF	64.2	64.53	64.09	64.46	7906498.0
2010-09-03 10:00:00	IWM	ETF	64.46	64.46	63.63	63.849	10680475.0
2010-09-03 11:00:00	IWM	ETF	63.84	63.94	63.61	63.79	5301245.0
2010-09-03 12:00:00	IWM	ETF	63.79	63.97	63.76	63.92	2827775.0
2010-09-03 13:00:00	IWM	ETF	63.92	64.13	63.9	64.0801	4178114.0
2010-09-03 14:00:00	IWM	ETF	64.09	64.3	64.01	64.095	3971952.0
2010-09-03 15:00:00	IWM	ETF	64.091	64.47	64.03	64.3199	8878387.0
2010-09-03 16:00:00	IWM	ETF	64.32	64.46	64.24	64.4	2284811.0
2010-09-03 18:00:00	IWM	ETF	64.35	64.37	64.35	64.35	960.0
2010-09-03 19:00:00	IWM	ETF	64.34	64.35	64.34	64.34	400.0
2010-09-03 07:00:00	DIA	ETF	103.29	103.29	103.2	103.2	1000.0
2010-09-03 08:00:00	DIA	ETF	103.2	104.53	103.19	104.4	194688.0
2010-09-03 09:00:00	DIA	ETF	104.39	104.63	104.18	104.62	1119627.0
2010-09-03 10:00:00	DIA	ETF	104.59	104.59	103.6836	103.84	1617785.0
2010-09-03 11:00:00	DIA	ETF	103.84	104.075	103.73	103.98	551885.0
2010-09-03 12:00:00	DIA	ETF	103.97	104.3	103.94	104.26	316251.0
2010-09-03 13:00:00	DIA	ETF	104.2564	104.45	104.22	104.4139	427142.0

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

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