PREVIEW / etf_1hour / 2005-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-09.parquet
  size:    29 KB
  rows:    856

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-05-09 04:00:00	SPY	ETF	117.29	117.34	117.29	117.32	29200.0
2005-05-09 06:00:00	SPY	ETF	117.27	117.35	117.27	117.35	12400.0
2005-05-09 07:00:00	SPY	ETF	117.28	117.29	117.26	117.29	184800.0
2005-05-09 08:00:00	SPY	ETF	117.27	117.33	117.25	117.25	265100.0
2005-05-09 09:00:00	SPY	ETF	117.25	117.37	117.14	117.33	4150200.0
2005-05-09 10:00:00	SPY	ETF	117.33	117.42	117.05	117.26	6248000.0
2005-05-09 11:00:00	SPY	ETF	117.23	117.74	117.16	117.61	7057300.0
2005-05-09 12:00:00	SPY	ETF	117.61	117.85	117.57	117.75	5379600.0
2005-05-09 13:00:00	SPY	ETF	117.75	117.95	117.65	117.92	4541000.0
2005-05-09 14:00:00	SPY	ETF	117.92	117.94	117.6	117.72	4923500.0
2005-05-09 15:00:00	SPY	ETF	117.72	118.03	117.49	118.01	8309300.0
2005-05-09 16:00:00	SPY	ETF	118.03	118.07	117.77	117.84	1101300.0
2005-05-09 17:00:00	SPY	ETF	117.83	117.84	117.8	117.83	12400.0
2005-05-09 18:00:00	SPY	ETF	117.82	117.83	117.8	117.8	5000.0
2005-05-09 19:00:00	SPY	ETF	117.8	117.8	117.79	117.79	1100.0
2005-05-09 09:00:00	QQQ	ETF	35.88	35.9	35.76	35.83	9964500.0
2005-05-09 10:00:00	QQQ	ETF	35.83	35.85	35.66	35.72	10906000.0
2005-05-09 11:00:00	QQQ	ETF	35.72	35.97	35.7	35.91	11446600.0
2005-05-09 12:00:00	QQQ	ETF	35.91	36.0	35.9	35.98	6105400.0
2005-05-09 13:00:00	QQQ	ETF	35.98	36.05	35.93	36.05	5624000.0
2005-05-09 14:00:00	QQQ	ETF	36.04	36.05	35.92	35.94	6686600.0
2005-05-09 15:00:00	QQQ	ETF	35.95	36.06	35.87	36.03	10458600.0
2005-05-09 08:00:00	IWM	ETF	59.385	59.385	59.385	59.385	2000.0
2005-05-09 09:00:00	IWM	ETF	59.34	59.5	59.175	59.265	1620400.0
2005-05-09 10:00:00	IWM	ETF	59.275	59.38	59.035	59.285	3339000.0
2005-05-09 11:00:00	IWM	ETF	59.295	59.645	59.245	59.565	2442600.0
2005-05-09 12:00:00	IWM	ETF	59.55	59.74	59.545	59.685	1674600.0
2005-05-09 13:00:00	IWM	ETF	59.68	59.855	59.595	59.835	2338800.0
2005-05-09 14:00:00	IWM	ETF	59.855	59.855	59.59	59.665	1146200.0
2005-05-09 15:00:00	IWM	ETF	59.68	59.95	59.485	59.935	4541200.0
2005-05-09 16:00:00	IWM	ETF	59.94	60.14	59.8016	59.89	605000.0
2005-05-09 17:00:00	IWM	ETF	59.885	59.915	59.885	59.905	2600.0
2005-05-09 07:00:00	DIA	ETF	103.59	103.6	103.59	103.59	3000.0
2005-05-09 08:00:00	DIA	ETF	103.51	103.51	103.48	103.48	300.0
2005-05-09 09:00:00	DIA	ETF	103.46	103.53	103.36	103.48	231400.0
2005-05-09 10:00:00	DIA	ETF	103.49	103.54	103.21	103.34	565100.0
2005-05-09 11:00:00	DIA	ETF	103.34	103.74	103.29	103.63	566600.0
2005-05-09 12:00:00	DIA	ETF	103.59	103.8	103.56	103.75	443800.0
2005-05-09 13:00:00	DIA	ETF	103.73	103.88	103.622	103.84	271900.0
2005-05-09 14:00:00	DIA	ETF	103.86	103.87	103.56	103.63	717000.0
2005-05-09 15:00:00	DIA	ETF	103.65	103.86	103.42	103.84	1034100.0
2005-05-09 16:00:00	DIA	ETF	103.9	103.91	103.72	103.76	61700.0
2005-05-09 17:00:00	DIA	ETF	103.75	103.75	103.75	103.75	1000.0
2005-05-09 18:00:00	DIA	ETF	103.71	103.71	103.71	103.71	4900.0
2005-05-09 19:00:00	DIA	ETF	103.75	103.75	103.75	103.75	400.0
2005-05-09 09:00:00	GLD	ETF	42.54	42.56	42.49	42.51	93200.0
2005-05-09 10:00:00	GLD	ETF	42.5	42.55	42.48	42.52	220200.0
2005-05-09 11:00:00	GLD	ETF	42.54	42.61	42.54	42.592	57600.0
2005-05-09 12:00:00	GLD	ETF	42.61	42.61	42.55	42.57	32400.0
2005-05-09 13:00:00	GLD	ETF	42.56	42.58	42.53	42.54	63900.0

> showing 50 of 856 rows — these rows as CSV

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