PREVIEW / etf_1hour / 2002-06-19

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-06-19.parquet
  size:    14 KB
  rows:    312

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
2002-06-19 09:00:00	SPY	ETF	103.5	103.83	103.18	103.54	3008400.0
2002-06-19 10:00:00	SPY	ETF	103.54	103.72	103.23	103.5	2978400.0
2002-06-19 11:00:00	SPY	ETF	103.5	104.43	103.4	104.2	2824600.0
2002-06-19 12:00:00	SPY	ETF	104.18	104.24	103.34	103.48	2602600.0
2002-06-19 13:00:00	SPY	ETF	103.5	103.68	103.36	103.55	1088700.0
2002-06-19 14:00:00	SPY	ETF	103.56	103.62	102.64	102.83	2835500.0
2002-06-19 15:00:00	SPY	ETF	102.78	102.99	102.26	102.54	3681100.0
2002-06-19 16:00:00	SPY	ETF	102.5	103.29	102.24	102.5	2362500.0
2002-06-19 17:00:00	SPY	ETF	102.54	102.67	102.51	102.51	4900.0
2002-06-19 18:00:00	SPY	ETF	102.5	102.57	102.47	102.57	9500.0
2002-06-19 09:00:00	QQQ	ETF	28.1	28.2	27.85	27.95	16241300.0
2002-06-19 10:00:00	QQQ	ETF	27.95	28.11	27.78	28.02	15454200.0
2002-06-19 11:00:00	QQQ	ETF	28.04	28.23	27.97	28.13	8555400.0
2002-06-19 12:00:00	QQQ	ETF	28.13	28.13	27.81	27.89	9383500.0
2002-06-19 13:00:00	QQQ	ETF	27.89	27.98	27.79	27.84	5027700.0
2002-06-19 14:00:00	QQQ	ETF	27.84	27.88	27.36	27.42	15281500.0
2002-06-19 15:00:00	QQQ	ETF	27.42	27.52	27.25	27.32	14303500.0
2002-06-19 16:00:00	QQQ	ETF	27.33	27.35	27.2	27.28	2822000.0
2002-06-19 17:00:00	QQQ	ETF	27.28	27.33	27.27	27.3	412300.0
2002-06-19 18:00:00	QQQ	ETF	27.31	27.32	27.29	27.3	18200.0
2002-06-19 09:00:00	IWM	ETF	46.35	46.625	46.35	46.53	345000.0
2002-06-19 10:00:00	IWM	ETF	46.53	47.115	46.49	46.965	315400.0
2002-06-19 11:00:00	IWM	ETF	47.03	47.185	47.0	47.125	246600.0
2002-06-19 12:00:00	IWM	ETF	47.1	47.125	46.5	46.585	177000.0
2002-06-19 13:00:00	IWM	ETF	46.55	46.6	46.485	46.485	197400.0
2002-06-19 14:00:00	IWM	ETF	46.555	46.555	46.125	46.125	231600.0
2002-06-19 15:00:00	IWM	ETF	46.2	46.25	46.0	46.055	801000.0
2002-06-19 16:00:00	IWM	ETF	45.505	46.0	45.505	46.0	1200.0
2002-06-19 17:00:00	IWM	ETF	46.035	46.035	46.035	46.035	618800.0
2002-06-19 09:00:00	DIA	ETF	96.51	96.86	96.32	96.61	900800.0
2002-06-19 10:00:00	DIA	ETF	96.61	97.0	96.4	96.78	965300.0
2002-06-19 11:00:00	DIA	ETF	96.76	97.68	96.61	97.43	1247800.0
2002-06-19 12:00:00	DIA	ETF	97.43	97.5	96.5	96.69	910700.0
2002-06-19 13:00:00	DIA	ETF	96.65	96.82	96.51	96.61	879100.0
2002-06-19 14:00:00	DIA	ETF	96.71	96.72	95.92	96.15	1037200.0
2002-06-19 15:00:00	DIA	ETF	96.11	96.33	95.58	95.82	913100.0
2002-06-19 16:00:00	DIA	ETF	95.8	96.57	95.65	96.57	58100.0
2002-06-19 17:00:00	DIA	ETF	95.9	95.94	95.7	95.7	700.0

> showing 38 of 312 rows — these rows as CSV

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