PREVIEW / etf_1hour / 2010-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-04.parquet
  size:    167 KB
  rows:    5,066

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-06-04 04:00:00	SPY	ETF	110.96	111.19	110.96	111.09	13000.0
2010-06-04 05:00:00	SPY	ETF	111.16	111.19	111.16	111.19	5100.0
2010-06-04 06:00:00	SPY	ETF	111.07	111.07	110.58	110.6	53921.0
2010-06-04 07:00:00	SPY	ETF	110.62	110.62	109.68	109.76	4145213.0
2010-06-04 08:00:00	SPY	ETF	109.76	110.55	108.17	108.63	21681342.0
2010-06-04 09:00:00	SPY	ETF	108.64	109.14	108.28	108.98	46262935.0
2010-06-04 10:00:00	SPY	ETF	108.98	109.33	108.7	108.84	40721339.0
2010-06-04 11:00:00	SPY	ETF	108.83	109.03	108.25	108.44	32702206.0
2010-06-04 12:00:00	SPY	ETF	108.4376	108.57	107.9	108.42	27293503.0
2010-06-04 13:00:00	SPY	ETF	108.42	108.45	107.65	107.76	26957203.0
2010-06-04 14:00:00	SPY	ETF	107.77	107.95	106.83	106.94	48271817.0
2010-06-04 15:00:00	SPY	ETF	106.925	107.64	106.465	107.01	91745711.0
2010-06-04 16:00:00	SPY	ETF	107.0	110.7281	106.7899	107.21	39407998.0
2010-06-04 17:00:00	SPY	ETF	107.2	110.7281	106.94	107.25	14781015.0
2010-06-04 18:00:00	SPY	ETF	107.25	110.7281	107.04	107.13	2810578.0
2010-06-04 19:00:00	SPY	ETF	107.12	107.25	107.11	107.22	101134.0
2010-06-04 05:00:00	QQQ	ETF	46.84	46.89	46.84	46.89	200.0
2010-06-04 06:00:00	QQQ	ETF	46.71	46.73	46.7	46.73	5352.0
2010-06-04 07:00:00	QQQ	ETF	46.6	46.6	46.18	46.25	3717504.0
2010-06-04 08:00:00	QQQ	ETF	46.25	46.7	45.63	45.74	8061125.0
2010-06-04 09:00:00	QQQ	ETF	45.75	46.2	45.58	46.12	17634392.0
2010-06-04 10:00:00	QQQ	ETF	46.119	46.29	46.0	46.03	13278154.0
2010-06-04 11:00:00	QQQ	ETF	46.03	46.12	45.79	45.91	7558431.0
2010-06-04 12:00:00	QQQ	ETF	45.9	45.9	45.63	45.79	6781901.0
2010-06-04 13:00:00	QQQ	ETF	45.79	45.8	45.39	45.4299	7371290.0
2010-06-04 14:00:00	QQQ	ETF	45.43	45.53	45.1	45.12	12838745.0
2010-06-04 15:00:00	QQQ	ETF	45.13	45.3	44.9375	45.12	26305876.0
2010-06-04 16:00:00	QQQ	ETF	45.12	46.6854	45.0725	45.22	3591943.0
2010-06-04 17:00:00	QQQ	ETF	45.2	45.25	45.18	45.2	25885.0
2010-06-04 18:00:00	QQQ	ETF	45.2	45.26	45.18	45.19	45387.0
2010-06-04 19:00:00	QQQ	ETF	45.2	45.24	45.15	45.22	21895.0
2010-06-04 04:00:00	IWM	ETF	67.13	67.13	67.13	67.13	933.0
2010-06-04 07:00:00	IWM	ETF	66.69	66.69	66.05	66.08	357194.0
2010-06-04 08:00:00	IWM	ETF	66.09	66.41	64.74	65.17	3836575.0
2010-06-04 09:00:00	IWM	ETF	65.17	65.7	64.99	65.61	12255703.0
2010-06-04 10:00:00	IWM	ETF	65.61	65.64	65.02	65.27	10275942.0
2010-06-04 11:00:00	IWM	ETF	65.27	65.37	64.78	64.99	8211389.0
2010-06-04 12:00:00	IWM	ETF	64.98	64.99	64.56	64.77	9486914.0
2010-06-04 13:00:00	IWM	ETF	64.77	64.78	64.27	64.34	8328407.0
2010-06-04 14:00:00	IWM	ETF	64.33	64.46	63.62	63.68	12238467.0
2010-06-04 15:00:00	IWM	ETF	63.67	63.98	63.37	63.56	24791944.0
2010-06-04 16:00:00	IWM	ETF	63.56	66.8305	63.45	63.83	7209622.0
2010-06-04 17:00:00	IWM	ETF	63.79	63.83	63.491	63.8	2505207.0
2010-06-04 18:00:00	IWM	ETF	63.83	63.83	63.7	63.72	14080.0
2010-06-04 19:00:00	IWM	ETF	63.77	63.77	63.67	63.67	3700.0
2010-06-04 06:00:00	DIA	ETF	102.64	102.64	102.5	102.5	2751.0
2010-06-04 07:00:00	DIA	ETF	102.4	102.4	101.84	101.88	9250.0
2010-06-04 08:00:00	DIA	ETF	102.04	102.11	100.61	101.0	179404.0
2010-06-04 09:00:00	DIA	ETF	100.94	101.18	100.58	100.94	2520946.0
2010-06-04 10:00:00	DIA	ETF	100.95	101.16	100.7	100.77	2490435.0

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

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