PREVIEW / etf_1hour / 2005-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-21.parquet
  size:    33 KB
  rows:    994

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
2005-09-21 05:00:00	SPY	ETF	122.22	122.22	122.22	122.22	200.0
2005-09-21 06:00:00	SPY	ETF	122.12	122.12	122.12	122.12	200.0
2005-09-21 07:00:00	SPY	ETF	122.05	122.06	121.85	121.93	221600.0
2005-09-21 08:00:00	SPY	ETF	121.97	122.05	121.76	121.83	2436200.0
2005-09-21 09:00:00	SPY	ETF	121.83	121.87	121.49	121.64	9796900.0
2005-09-21 10:00:00	SPY	ETF	121.65	121.82	121.37	121.79	20568200.0
2005-09-21 11:00:00	SPY	ETF	121.79	121.85	121.27	121.28	10553700.0
2005-09-21 12:00:00	SPY	ETF	121.31	121.69	121.2	121.43	6105500.0
2005-09-21 13:00:00	SPY	ETF	121.43	121.57	120.94	121.15	10926600.0
2005-09-21 14:00:00	SPY	ETF	121.15	121.53	120.95	121.4	12837100.0
2005-09-21 15:00:00	SPY	ETF	121.39	121.5	120.86	120.89	15052800.0
2005-09-21 16:00:00	SPY	ETF	120.89	120.99	120.77	120.85	2073900.0
2005-09-21 17:00:00	SPY	ETF	120.89	120.93	120.83	120.84	277900.0
2005-09-21 18:00:00	SPY	ETF	120.83	120.83	120.7	120.78	29700.0
2005-09-21 19:00:00	SPY	ETF	120.79	120.83	120.77	120.82	17700.0
2005-09-21 09:00:00	QQQ	ETF	38.82	38.87	38.61	38.69	15938800.0
2005-09-21 10:00:00	QQQ	ETF	38.69	38.83	38.62	38.8	19594600.0
2005-09-21 11:00:00	QQQ	ETF	38.8	38.82	38.56	38.59	13136800.0
2005-09-21 12:00:00	QQQ	ETF	38.58	38.69	38.54	38.67	9206400.0
2005-09-21 13:00:00	QQQ	ETF	38.67	38.71	38.48	38.55	10289600.0
2005-09-21 14:00:00	QQQ	ETF	38.55	38.71	38.5	38.67	11427900.0
2005-09-21 15:00:00	QQQ	ETF	38.67	38.68	38.47	38.5	18060200.0
2005-09-21 08:00:00	IWM	ETF	65.5	65.51	65.46	65.51	13100.0
2005-09-21 09:00:00	IWM	ETF	65.52	65.54	65.04	65.12	3895000.0
2005-09-21 10:00:00	IWM	ETF	65.13	65.57	65.11	65.54	4864200.0
2005-09-21 11:00:00	IWM	ETF	65.54	65.61	64.99	65.0	3774300.0
2005-09-21 12:00:00	IWM	ETF	65.0	65.26	64.94	65.25	1852200.0
2005-09-21 13:00:00	IWM	ETF	65.25	65.31	64.76	64.84	2252200.0
2005-09-21 14:00:00	IWM	ETF	64.84	65.21	64.82	65.13	2986300.0
2005-09-21 15:00:00	IWM	ETF	65.13	65.16	64.73	64.75	4835800.0
2005-09-21 16:00:00	IWM	ETF	64.75	64.83	64.55	64.65	350700.0
2005-09-21 17:00:00	IWM	ETF	64.65	64.67	64.55	64.59	1133800.0
2005-09-21 08:00:00	DIA	ETF	104.66	104.72	104.51	104.56	25100.0
2005-09-21 09:00:00	DIA	ETF	104.58	104.6	104.15	104.29	1792000.0
2005-09-21 10:00:00	DIA	ETF	104.3	104.49	104.1	104.43	1981800.0
2005-09-21 11:00:00	DIA	ETF	104.43	104.49	104.0	104.04	1391900.0
2005-09-21 12:00:00	DIA	ETF	104.05	104.17	103.92	104.11	686900.0
2005-09-21 13:00:00	DIA	ETF	104.11	104.33	103.72	103.85	696500.0
2005-09-21 14:00:00	DIA	ETF	103.84	104.33	103.7	104.21	2247400.0
2005-09-21 15:00:00	DIA	ETF	104.19	104.24	103.67	103.71	1195400.0
2005-09-21 16:00:00	DIA	ETF	103.74	104.1406	103.63	103.72	220900.0
2005-09-21 17:00:00	DIA	ETF	103.68	103.72	103.6	103.7	14900.0
2005-09-21 19:00:00	DIA	ETF	103.68	103.68	103.68	103.68	100.0
2005-09-21 08:00:00	GLD	ETF	46.45	46.86	46.4	46.75	36400.0
2005-09-21 09:00:00	GLD	ETF	46.66	46.7	46.5	46.66	772400.0
2005-09-21 10:00:00	GLD	ETF	46.66	46.85	46.65	46.78	1377100.0
2005-09-21 11:00:00	GLD	ETF	46.78	46.8	46.64	46.74	274700.0
2005-09-21 12:00:00	GLD	ETF	46.74	46.849	46.73	46.8	231400.0
2005-09-21 13:00:00	GLD	ETF	46.8	46.85	46.72	46.85	148300.0
2005-09-21 14:00:00	GLD	ETF	46.85	47.05	46.82	46.99	415100.0

> showing 50 of 994 rows — these rows as CSV

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