PREVIEW / etf_1hour / 2001-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-01.parquet
  size:    12 KB
  rows:    261

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
2001-10-01 09:00:00	SPY	ETF	103.9	104.1	103.52	103.7	4106000.0
2001-10-01 10:00:00	SPY	ETF	103.7	103.73	102.83	103.08	3950200.0
2001-10-01 11:00:00	SPY	ETF	103.04	103.45	102.97	103.39	2342800.0
2001-10-01 12:00:00	SPY	ETF	103.43	103.95	103.21	103.95	1874600.0
2001-10-01 13:00:00	SPY	ETF	103.95	104.32	103.7	104.0	2197600.0
2001-10-01 14:00:00	SPY	ETF	103.99	104.04	103.69	103.9	1825400.0
2001-10-01 15:00:00	SPY	ETF	103.92	104.12	103.51	104.0	3089900.0
2001-10-01 16:00:00	SPY	ETF	104.05	104.3	103.63	104.19	563300.0
2001-10-01 17:00:00	SPY	ETF	104.18	104.27	104.18	104.27	10700.0
2001-10-01 18:00:00	SPY	ETF	104.58	104.58	104.58	104.58	400.0
2001-10-01 09:00:00	QQQ	ETF	28.85	28.98	28.54	28.62	9904800.0
2001-10-01 10:00:00	QQQ	ETF	28.6	28.67	28.16	28.25	11761300.0
2001-10-01 11:00:00	QQQ	ETF	28.25	28.44	28.17	28.4	5776100.0
2001-10-01 12:00:00	QQQ	ETF	28.39	28.75	28.23	28.72	3913800.0
2001-10-01 13:00:00	QQQ	ETF	28.72	28.97	28.56	28.75	6571100.0
2001-10-01 14:00:00	QQQ	ETF	28.75	28.83	28.53	28.65	4962100.0
2001-10-01 15:00:00	QQQ	ETF	28.66	28.68	28.37	28.61	8041900.0
2001-10-01 16:00:00	QQQ	ETF	28.64	28.74	28.51	28.67	790700.0
2001-10-01 17:00:00	QQQ	ETF	28.75	28.81	28.6	28.69	12300.0
2001-10-01 18:00:00	QQQ	ETF	28.68	28.68	28.58	28.63	15000.0
2001-10-01 09:00:00	IWM	ETF	40.1	40.145	39.605	39.605	26000.0
2001-10-01 10:00:00	IWM	ETF	39.575	39.625	39.025	39.12	501600.0
2001-10-01 11:00:00	IWM	ETF	39.16	39.37	39.06	39.345	113800.0
2001-10-01 12:00:00	IWM	ETF	39.35	39.45	39.325	39.45	32200.0
2001-10-01 13:00:00	IWM	ETF	39.475	39.73	39.45	39.685	17200.0
2001-10-01 14:00:00	IWM	ETF	39.57	39.6	39.35	39.475	19800.0
2001-10-01 15:00:00	IWM	ETF	39.45	39.645	39.375	39.625	114600.0
2001-10-01 16:00:00	IWM	ETF	39.725	39.75	39.6	39.6	64000.0
2001-10-01 09:00:00	DIA	ETF	87.85	88.34	87.85	88.09	663900.0
2001-10-01 10:00:00	DIA	ETF	88.02	88.11	87.35	87.5	1244500.0
2001-10-01 11:00:00	DIA	ETF	87.45	87.91	87.45	87.91	882700.0
2001-10-01 12:00:00	DIA	ETF	87.9	88.32	87.68	88.25	367600.0
2001-10-01 13:00:00	DIA	ETF	88.26	88.62	88.15	88.34	929400.0
2001-10-01 14:00:00	DIA	ETF	88.25	88.35	88.0	88.09	466700.0
2001-10-01 15:00:00	DIA	ETF	88.18	88.5	87.85	88.41	700200.0
2001-10-01 16:00:00	DIA	ETF	88.48	88.7	88.42	88.58	103100.0
2001-10-01 17:00:00	DIA	ETF	88.58	88.58	88.58	88.58	100.0

> showing 37 of 261 rows — these rows as CSV

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