PREVIEW / etf_1hour / 2010-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-18.parquet
  size:    172 KB
  rows:    5,196

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-05-18 04:00:00	SPY	ETF	114.46	114.47	114.35	114.35	2708.0
2010-05-18 05:00:00	SPY	ETF	114.15	114.32	114.1	114.3	7052.0
2010-05-18 06:00:00	SPY	ETF	114.32	114.56	114.3	114.48	39172.0
2010-05-18 07:00:00	SPY	ETF	114.54	114.75	114.44	114.67	1091338.0
2010-05-18 08:00:00	SPY	ETF	114.66	114.94	113.549	114.85	5647343.0
2010-05-18 09:00:00	SPY	ETF	114.84	115.22	114.7	114.81	32208498.0
2010-05-18 10:00:00	SPY	ETF	114.81	114.99	113.78	114.1	52882859.0
2010-05-18 11:00:00	SPY	ETF	114.09	114.46	113.56	113.7	36052098.0
2010-05-18 12:00:00	SPY	ETF	113.69	114.25	113.32	113.6601	32268150.0
2010-05-18 13:00:00	SPY	ETF	113.66	113.8	112.81	112.82	59130950.0
2010-05-18 14:00:00	SPY	ETF	112.83	113.31	112.18	112.35	56712215.0
2010-05-18 15:00:00	SPY	ETF	112.35	112.92	112.03	112.41	75150517.0
2010-05-18 16:00:00	SPY	ETF	112.41	115.03	112.03	112.05	7746746.0
2010-05-18 17:00:00	SPY	ETF	112.05	112.25	111.5	111.7	819231.0
2010-05-18 18:00:00	SPY	ETF	111.67	112.43	111.65	111.65	213161.0
2010-05-18 19:00:00	SPY	ETF	111.67	111.67	111.31	111.34	265837.0
2010-05-18 04:00:00	QQQ	ETF	47.37	47.37	47.3	47.34	2200.0
2010-05-18 05:00:00	QQQ	ETF	47.29	47.29	47.29	47.29	200.0
2010-05-18 07:00:00	QQQ	ETF	47.37	47.46	47.37	47.41	224669.0
2010-05-18 08:00:00	QQQ	ETF	47.41	47.48	47.32	47.47	3029262.0
2010-05-18 09:00:00	QQQ	ETF	47.47	47.58	47.33	47.37	11781893.0
2010-05-18 10:00:00	QQQ	ETF	47.3701	47.5	46.6	46.82	29389669.0
2010-05-18 11:00:00	QQQ	ETF	46.82	47.06	46.68	46.75	17571568.0
2010-05-18 12:00:00	QQQ	ETF	46.75	46.99	46.59	46.811	17250254.0
2010-05-18 13:00:00	QQQ	ETF	46.81	47.0	46.47	46.49	18229343.0
2010-05-18 14:00:00	QQQ	ETF	46.48	46.69	46.22	46.37	17364467.0
2010-05-18 15:00:00	QQQ	ETF	46.36	46.65	46.235	46.43	26120737.0
2010-05-18 16:00:00	QQQ	ETF	46.43	46.92	46.3117	46.38	4218569.0
2010-05-18 17:00:00	QQQ	ETF	46.37	46.39	46.2	46.27	160559.0
2010-05-18 18:00:00	QQQ	ETF	46.25	46.32	46.24	46.24	65839.0
2010-05-18 19:00:00	QQQ	ETF	46.26	46.27	46.14	46.14	53385.0
2010-05-18 07:00:00	IWM	ETF	70.11	70.26	70.1	70.18	128020.0
2010-05-18 08:00:00	IWM	ETF	70.17	70.42	70.16	70.38	1498908.0
2010-05-18 09:00:00	IWM	ETF	70.38	70.8	70.25	70.35	10871779.0
2010-05-18 10:00:00	IWM	ETF	70.35	70.47	69.24	69.58	10026678.0
2010-05-18 11:00:00	IWM	ETF	69.57	69.95	69.19	69.35	7904565.0
2010-05-18 12:00:00	IWM	ETF	69.35	69.9	69.05	69.51	8756374.0
2010-05-18 13:00:00	IWM	ETF	69.51	69.62	68.84	68.85	10827050.0
2010-05-18 14:00:00	IWM	ETF	68.85	69.12	68.24	68.41	11657885.0
2010-05-18 15:00:00	IWM	ETF	68.41	69.0	68.13	68.45	16327784.0
2010-05-18 16:00:00	IWM	ETF	68.45	70.75	68.24	68.27	1579836.0
2010-05-18 17:00:00	IWM	ETF	68.21	68.22	67.93	68.0	91065.0
2010-05-18 18:00:00	IWM	ETF	68.05	68.07	67.98	68.05	4415.0
2010-05-18 19:00:00	IWM	ETF	67.97	67.97	67.65	67.65	4735.0
2010-05-18 06:00:00	DIA	ETF	106.93	106.95	106.93	106.95	1154.0
2010-05-18 07:00:00	DIA	ETF	106.97	107.06	106.86	107.04	4629.0
2010-05-18 08:00:00	DIA	ETF	107.03	107.27	106.97	107.2	38565.0
2010-05-18 09:00:00	DIA	ETF	107.25	107.51	107.14	107.26	1662810.0
2010-05-18 10:00:00	DIA	ETF	107.26	107.46	106.6	106.83	3157973.0
2010-05-18 11:00:00	DIA	ETF	106.82	107.14	106.4	106.49	2247990.0

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

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