PREVIEW / etf_1hour / 2004-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-01.parquet
  size:    24 KB
  rows:    677

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
2004-06-01 08:00:00	SPY	ETF	112.29	112.36	112.22	112.35	69500.0
2004-06-01 09:00:00	SPY	ETF	112.35	112.73	112.35	112.68	3225000.0
2004-06-01 10:00:00	SPY	ETF	112.65	112.86	112.36	112.54	8157100.0
2004-06-01 11:00:00	SPY	ETF	112.55	112.59	112.08	112.28	6003600.0
2004-06-01 12:00:00	SPY	ETF	112.28	112.45	112.14	112.33	2130500.0
2004-06-01 13:00:00	SPY	ETF	112.33	112.43	112.16	112.21	1668500.0
2004-06-01 14:00:00	SPY	ETF	112.22	112.33	111.87	112.16	7981200.0
2004-06-01 15:00:00	SPY	ETF	112.17	112.79	112.06	112.69	6693300.0
2004-06-01 16:00:00	SPY	ETF	112.68	112.81	112.26	112.73	3216900.0
2004-06-01 17:00:00	SPY	ETF	112.73	112.73	112.66	112.7	15000.0
2004-06-01 18:00:00	SPY	ETF	112.7	112.8	112.69	112.69	5500.0
2004-06-01 19:00:00	SPY	ETF	112.73	112.75	112.68	112.68	5700.0
2004-06-01 08:00:00	QQQ	ETF	36.5	36.5	36.23	36.25	266100.0
2004-06-01 09:00:00	QQQ	ETF	36.24	36.47	36.23	36.451	10685600.0
2004-06-01 10:00:00	QQQ	ETF	36.45	36.53	36.28	36.358	19098500.0
2004-06-01 11:00:00	QQQ	ETF	36.358	36.4	36.12	36.23	14998700.0
2004-06-01 12:00:00	QQQ	ETF	36.23	36.34	36.18	36.29	7127200.0
2004-06-01 13:00:00	QQQ	ETF	36.3	36.34	36.18	36.24	4999600.0
2004-06-01 14:00:00	QQQ	ETF	36.24	36.29	36.11	36.24	8626500.0
2004-06-01 15:00:00	QQQ	ETF	36.25	36.54	36.21	36.52	20678000.0
2004-06-01 16:00:00	QQQ	ETF	36.52	36.55	36.48	36.5	2242800.0
2004-06-01 17:00:00	QQQ	ETF	36.5	36.5	36.47	36.5	54300.0
2004-06-01 18:00:00	QQQ	ETF	36.49	36.49	36.45	36.46	66200.0
2004-06-01 19:00:00	QQQ	ETF	36.46	36.5	36.43	36.49	36700.0
2004-06-01 08:00:00	IWM	ETF	56.32	56.37	56.32	56.37	1200.0
2004-06-01 09:00:00	IWM	ETF	56.37	56.83	56.36	56.82	1301800.0
2004-06-01 10:00:00	IWM	ETF	56.82	57.035	56.675	56.795	1754200.0
2004-06-01 11:00:00	IWM	ETF	56.78	56.8	56.44	56.615	1356800.0
2004-06-01 12:00:00	IWM	ETF	56.62	56.745	56.56	56.74	296600.0
2004-06-01 13:00:00	IWM	ETF	56.7	56.74	56.54	56.625	1284600.0
2004-06-01 14:00:00	IWM	ETF	56.615	56.68	56.45	56.655	1226200.0
2004-06-01 15:00:00	IWM	ETF	56.67	57.2	56.6	57.195	2980000.0
2004-06-01 16:00:00	IWM	ETF	57.18	57.34	57.18	57.265	569600.0
2004-06-01 08:00:00	DIA	ETF	101.81	101.86	101.77	101.84	26700.0
2004-06-01 09:00:00	DIA	ETF	101.83	102.1	101.8	102.05	783400.0
2004-06-01 10:00:00	DIA	ETF	102.09	102.27	101.87	102.02	971400.0
2004-06-01 11:00:00	DIA	ETF	102.04	102.06	101.62	101.8	1266000.0
2004-06-01 12:00:00	DIA	ETF	101.83	101.94	101.7	101.85	129100.0
2004-06-01 13:00:00	DIA	ETF	101.85	101.94	101.75	101.76	130700.0
2004-06-01 14:00:00	DIA	ETF	101.75	101.82	101.46	101.73	420700.0
2004-06-01 15:00:00	DIA	ETF	101.71	102.23	101.57	102.13	1087000.0
2004-06-01 16:00:00	DIA	ETF	102.13	102.22	102.11	102.17	92500.0
2004-06-01 17:00:00	DIA	ETF	102.15	102.15	102.15	102.15	200.0
2004-06-01 18:00:00	DIA	ETF	102.25	102.25	102.25	102.25	400.0
2004-06-01 19:00:00	DIA	ETF	102.17	102.17	102.17	102.17	400.0
2004-06-01 09:00:00	TLT	ETF	82.37	82.4	82.25	82.3	50100.0
2004-06-01 10:00:00	TLT	ETF	82.21	82.23	81.95	82.04	206600.0
2004-06-01 11:00:00	TLT	ETF	82.06	82.06	81.7	81.8	85500.0
2004-06-01 12:00:00	TLT	ETF	81.81	81.88	81.75	81.85	57300.0
2004-06-01 13:00:00	TLT	ETF	81.86	81.93	81.84	81.93	58800.0

> showing 50 of 677 rows — these rows as CSV

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