PREVIEW / etf_1hour / 2005-02-24

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-24.parquet
  size:    29 KB
  rows:    825

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-24 08:00:00	SPY	ETF	119.28	119.33	119.24	119.32	288000.0
2005-02-24 09:00:00	SPY	ETF	119.31	119.41	118.98	119.08	9248100.0
2005-02-24 10:00:00	SPY	ETF	119.08	119.7	118.99	119.17	15389800.0
2005-02-24 11:00:00	SPY	ETF	119.18	119.68	119.15	119.3	6965000.0
2005-02-24 12:00:00	SPY	ETF	119.3	119.37	119.18	119.25	3829400.0
2005-02-24 13:00:00	SPY	ETF	119.25	119.64	119.18	119.55	4725700.0
2005-02-24 14:00:00	SPY	ETF	119.55	120.01	119.51	119.94	10034200.0
2005-02-24 15:00:00	SPY	ETF	119.93	120.32	119.9	120.26	14875000.0
2005-02-24 16:00:00	SPY	ETF	120.28	120.34	120.2	120.27	1574300.0
2005-02-24 17:00:00	SPY	ETF	120.27	120.29	120.26	120.27	37100.0
2005-02-24 18:00:00	SPY	ETF	120.27	120.28	120.21	120.21	14800.0
2005-02-24 09:00:00	QQQ	ETF	36.85	37.0	36.76	36.83	14963800.0
2005-02-24 10:00:00	QQQ	ETF	36.83	37.15	36.76	36.83	21339100.0
2005-02-24 11:00:00	QQQ	ETF	36.84	37.02	36.81	36.87	9996200.0
2005-02-24 12:00:00	QQQ	ETF	36.87	36.92	36.8	36.86	4946200.0
2005-02-24 13:00:00	QQQ	ETF	36.86	37.08	36.83	37.03	7675200.0
2005-02-24 14:00:00	QQQ	ETF	37.03	37.36	37.02	37.28	17892800.0
2005-02-24 15:00:00	QQQ	ETF	37.28	37.44	37.24	37.41	16590200.0
2005-02-24 08:00:00	IWM	ETF	61.775	61.825	61.72	61.78	30000.0
2005-02-24 09:00:00	IWM	ETF	61.825	62.0	61.475	61.51	1786400.0
2005-02-24 10:00:00	IWM	ETF	61.525	62.01	61.385	61.625	3822400.0
2005-02-24 11:00:00	IWM	ETF	61.62	61.89	61.55	61.735	1058400.0
2005-02-24 12:00:00	IWM	ETF	61.705	61.84	61.65	61.74	760400.0
2005-02-24 13:00:00	IWM	ETF	61.755	62.125	61.705	62.0	1358000.0
2005-02-24 14:00:00	IWM	ETF	62.0	62.35	61.98	62.295	3304600.0
2005-02-24 15:00:00	IWM	ETF	62.29	62.58	62.24	62.515	4175200.0
2005-02-24 16:00:00	IWM	ETF	62.54	62.565	62.475	62.53	238800.0
2005-02-24 17:00:00	IWM	ETF	62.55	62.55	62.55	62.55	1400.0
2005-02-24 08:00:00	DIA	ETF	106.65	106.68	106.65	106.65	2400.0
2005-02-24 09:00:00	DIA	ETF	106.68	106.75	106.42	106.5	763200.0
2005-02-24 10:00:00	DIA	ETF	106.47	107.0	106.36	106.58	1482100.0
2005-02-24 11:00:00	DIA	ETF	106.56	106.82	106.52	106.66	970100.0
2005-02-24 12:00:00	DIA	ETF	106.67	106.67	106.51	106.55	444400.0
2005-02-24 13:00:00	DIA	ETF	106.56	106.88	106.51	106.81	645200.0
2005-02-24 14:00:00	DIA	ETF	106.8	107.23	106.75	107.15	1331800.0
2005-02-24 15:00:00	DIA	ETF	107.15	107.55	107.11	107.42	1342200.0
2005-02-24 16:00:00	DIA	ETF	107.42	107.45	107.33	107.45	31400.0
2005-02-24 17:00:00	DIA	ETF	107.37	107.37	107.37	107.37	100.0
2005-02-24 19:00:00	DIA	ETF	107.42	107.42	107.42	107.42	100.0
2005-02-24 09:00:00	GLD	ETF	43.48	43.48	43.32	43.4	187300.0
2005-02-24 10:00:00	GLD	ETF	43.4	43.43	43.25	43.3	172900.0
2005-02-24 11:00:00	GLD	ETF	43.32	43.43	43.2	43.38	162300.0
2005-02-24 12:00:00	GLD	ETF	43.38	43.44	43.332	43.389	142300.0
2005-02-24 13:00:00	GLD	ETF	43.41	43.44	43.37	43.39	234800.0
2005-02-24 14:00:00	GLD	ETF	43.38	43.42	43.35	43.4	110700.0
2005-02-24 15:00:00	GLD	ETF	43.4	43.44	43.33	43.36	208700.0
2005-02-24 16:00:00	GLD	ETF	43.34	43.34	43.34	43.34	100.0
2005-02-24 08:00:00	TLT	ETF	91.05	91.21	91.05	91.15	2100.0
2005-02-24 09:00:00	TLT	ETF	91.18	91.33	91.16	91.25	121400.0
2005-02-24 10:00:00	TLT	ETF	91.23	91.23	90.71	90.73	86900.0

> showing 50 of 825 rows — these rows as CSV

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