PREVIEW / etf_1hour / 2004-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-13.parquet
  size:    26 KB
  rows:    709

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-10-13 08:00:00	SPY	ETF	112.97	113.09	112.93	113.09	278000.0
2004-10-13 09:00:00	SPY	ETF	113.08	113.11	112.74	112.86	7155200.0
2004-10-13 10:00:00	SPY	ETF	112.83	112.85	112.24	112.3	9284700.0
2004-10-13 11:00:00	SPY	ETF	112.3	112.34	112.05	112.19	7290800.0
2004-10-13 12:00:00	SPY	ETF	112.19	112.33	112.06	112.22	2922500.0
2004-10-13 13:00:00	SPY	ETF	112.22	112.27	111.32	111.47	10439100.0
2004-10-13 14:00:00	SPY	ETF	111.47	111.71	111.39	111.59	6477600.0
2004-10-13 15:00:00	SPY	ETF	111.6	111.83	111.42	111.67	6497100.0
2004-10-13 16:00:00	SPY	ETF	111.68	111.74	111.41	111.49	1944300.0
2004-10-13 17:00:00	SPY	ETF	111.51	111.51	111.4	111.42	173500.0
2004-10-13 18:00:00	SPY	ETF	111.42	111.47	111.37	111.37	38500.0
2004-10-13 19:00:00	SPY	ETF	111.44	111.44	111.41	111.41	1500.0
2004-10-13 08:00:00	QQQ	ETF	36.01	36.07	35.99	36.06	533400.0
2004-10-13 09:00:00	QQQ	ETF	36.07	36.14	35.98	36.051	16295100.0
2004-10-13 10:00:00	QQQ	ETF	36.051	36.09	35.78	35.87	24881700.0
2004-10-13 11:00:00	QQQ	ETF	35.88	35.93	35.76	35.861	13722700.0
2004-10-13 12:00:00	QQQ	ETF	35.86	35.88	35.78	35.86	8610700.0
2004-10-13 13:00:00	QQQ	ETF	35.851	35.88	35.43	35.525	24710100.0
2004-10-13 14:00:00	QQQ	ETF	35.51	35.66	35.45	35.574	17359900.0
2004-10-13 15:00:00	QQQ	ETF	35.577	35.68	35.53	35.66	17347600.0
2004-10-13 16:00:00	QQQ	ETF	35.66	35.7	35.56	35.59	4967300.0
2004-10-13 17:00:00	QQQ	ETF	35.58	35.59	35.51	35.55	371500.0
2004-10-13 18:00:00	QQQ	ETF	35.525	35.54	35.49	35.52	45200.0
2004-10-13 19:00:00	QQQ	ETF	35.51	35.53	35.5	35.52	12900.0
2004-10-13 08:00:00	IWM	ETF	57.865	57.925	57.865	57.87	20000.0
2004-10-13 09:00:00	IWM	ETF	57.87	57.975	57.58	57.68	2125200.0
2004-10-13 10:00:00	IWM	ETF	57.67	57.685	57.115	57.22	3518400.0
2004-10-13 11:00:00	IWM	ETF	57.23	57.235	56.985	57.15	1797600.0
2004-10-13 12:00:00	IWM	ETF	57.14	57.2	57.06	57.12	827200.0
2004-10-13 13:00:00	IWM	ETF	57.12	57.18	56.625	56.705	2468400.0
2004-10-13 14:00:00	IWM	ETF	56.705	56.965	56.585	56.86	2714200.0
2004-10-13 15:00:00	IWM	ETF	56.87	56.95	56.755	56.755	1923200.0
2004-10-13 16:00:00	IWM	ETF	56.755	56.76	56.55	56.61	574200.0
2004-10-13 17:00:00	IWM	ETF	56.51	56.6	56.51	56.6	403200.0
2004-10-13 18:00:00	IWM	ETF	56.625	56.625	56.625	56.625	1000.0
2004-10-13 08:00:00	DIA	ETF	101.32	101.52	101.32	101.49	48400.0
2004-10-13 09:00:00	DIA	ETF	101.46	101.49	101.21	101.3	556900.0
2004-10-13 10:00:00	DIA	ETF	101.3	101.33	100.8	100.82	1502600.0
2004-10-13 11:00:00	DIA	ETF	100.82	100.85	100.55	100.65	1214900.0
2004-10-13 12:00:00	DIA	ETF	100.65	100.77	100.56	100.64	246900.0
2004-10-13 13:00:00	DIA	ETF	100.63	100.68	99.77	99.92	1740100.0
2004-10-13 14:00:00	DIA	ETF	99.92	100.26	99.82	100.15	1607000.0
2004-10-13 15:00:00	DIA	ETF	100.15	100.28	99.95	100.18	803400.0
2004-10-13 16:00:00	DIA	ETF	100.18	100.2	100.03	100.03	58100.0
2004-10-13 08:00:00	TLT	ETF	87.95	87.95	87.95	87.95	5000.0
2004-10-13 09:00:00	TLT	ETF	87.95	88.04	87.95	88.02	51100.0
2004-10-13 10:00:00	TLT	ETF	88.04	88.22	88.04	88.22	61800.0
2004-10-13 11:00:00	TLT	ETF	88.21	88.29	88.18	88.28	50700.0
2004-10-13 12:00:00	TLT	ETF	88.24	88.31	88.22	88.28	160100.0
2004-10-13 13:00:00	TLT	ETF	88.3	88.51	88.3	88.5	106900.0

> showing 50 of 709 rows — these rows as CSV

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