PREVIEW / etf_1hour / 2005-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-23.parquet
  size:    28 KB
  rows:    818

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-02-23 08:00:00	SPY	ETF	118.76	119.12	118.74	119.05	1287000.0
2005-02-23 09:00:00	SPY	ETF	119.05	119.18	118.93	118.97	10832300.0
2005-02-23 10:00:00	SPY	ETF	118.97	119.1	118.71	118.85	11654600.0
2005-02-23 11:00:00	SPY	ETF	118.86	119.28	118.79	119.19	8710100.0
2005-02-23 12:00:00	SPY	ETF	119.2	119.23	119.05	119.14	5371800.0
2005-02-23 13:00:00	SPY	ETF	119.14	119.19	118.89	119.11	5987300.0
2005-02-23 14:00:00	SPY	ETF	119.11	119.38	118.92	119.3	9991000.0
2005-02-23 15:00:00	SPY	ETF	119.31	119.57	118.6247	119.33	12224700.0
2005-02-23 16:00:00	SPY	ETF	119.35	119.52	119.28	119.49	866800.0
2005-02-23 17:00:00	SPY	ETF	119.5	119.54	119.5	119.51	9000.0
2005-02-23 18:00:00	SPY	ETF	119.5	119.5	119.45	119.47	7200.0
2005-02-23 19:00:00	SPY	ETF	119.45	119.45	119.45	119.45	2000.0
2005-02-23 09:00:00	QQQ	ETF	37.03	37.07	36.87	36.91	11846000.0
2005-02-23 10:00:00	QQQ	ETF	36.91	37.76	36.72	36.8	18826200.0
2005-02-23 11:00:00	QQQ	ETF	36.79	37.03	36.77	36.94	14724400.0
2005-02-23 12:00:00	QQQ	ETF	36.95	36.96	36.85	36.88	5535100.0
2005-02-23 13:00:00	QQQ	ETF	36.87	36.95	36.71	36.83	9587100.0
2005-02-23 14:00:00	QQQ	ETF	36.83	36.93	36.7	36.91	13912200.0
2005-02-23 15:00:00	QQQ	ETF	36.9	37.05	36.87	36.92	13277000.0
2005-02-23 08:00:00	IWM	ETF	61.595	61.87	61.59	61.845	48600.0
2005-02-23 09:00:00	IWM	ETF	61.835	62.1	61.715	61.895	2421800.0
2005-02-23 10:00:00	IWM	ETF	61.88	61.98	61.66	61.825	3912800.0
2005-02-23 11:00:00	IWM	ETF	61.815	62.285	61.775	62.15	2047400.0
2005-02-23 12:00:00	IWM	ETF	62.12	62.16	61.99	62.075	1424600.0
2005-02-23 13:00:00	IWM	ETF	62.08	62.1	61.865	61.96	1562000.0
2005-02-23 14:00:00	IWM	ETF	61.955	62.055	61.685	61.91	3002800.0
2005-02-23 15:00:00	IWM	ETF	61.935	62.04	61.785	61.85	2213800.0
2005-02-23 16:00:00	IWM	ETF	61.855	62.005	61.84	62.005	525000.0
2005-02-23 18:00:00	IWM	ETF	61.915	61.915	61.915	61.915	2000.0
2005-02-23 08:00:00	DIA	ETF	106.19	106.44	106.19	106.4	27900.0
2005-02-23 09:00:00	DIA	ETF	106.42	106.51	106.32	106.35	845900.0
2005-02-23 10:00:00	DIA	ETF	106.36	106.5	106.19	106.33	965400.0
2005-02-23 11:00:00	DIA	ETF	106.31	106.69	106.27	106.64	901500.0
2005-02-23 12:00:00	DIA	ETF	106.64	106.7	106.52	106.57	337100.0
2005-02-23 13:00:00	DIA	ETF	106.58	106.61	106.37	106.56	1263400.0
2005-02-23 14:00:00	DIA	ETF	106.56	106.79	106.42	106.73	1032000.0
2005-02-23 15:00:00	DIA	ETF	106.75	106.95	106.67	106.72	1057700.0
2005-02-23 16:00:00	DIA	ETF	106.73	106.84	106.73	106.84	4400.0
2005-02-23 09:00:00	GLD	ETF	43.29	43.32	43.21	43.28	412800.0
2005-02-23 10:00:00	GLD	ETF	43.26	43.31	43.15	43.2	229400.0
2005-02-23 11:00:00	GLD	ETF	43.2	43.39	43.17	43.39	136400.0
2005-02-23 12:00:00	GLD	ETF	43.39	43.55	43.36	43.48	318400.0
2005-02-23 13:00:00	GLD	ETF	43.47	43.52	43.434	43.5	79600.0
2005-02-23 14:00:00	GLD	ETF	43.49	43.52	43.45	43.47	206300.0
2005-02-23 15:00:00	GLD	ETF	43.46	43.47	43.4	43.42	140800.0
2005-02-23 08:00:00	TLT	ETF	90.56	91.05	90.48	91.05	68600.0
2005-02-23 09:00:00	TLT	ETF	91.05	91.17	91.0	91.0	239500.0
2005-02-23 10:00:00	TLT	ETF	91.0315	91.14	91.0	91.11	108800.0
2005-02-23 11:00:00	TLT	ETF	91.07	91.09	91.0	91.09	52700.0
2005-02-23 12:00:00	TLT	ETF	91.09	91.1	90.8	90.8	66400.0

> showing 50 of 818 rows — these rows as CSV

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