PREVIEW / etf_1hour / 2002-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-01.parquet
  size:    15 KB
  rows:    364

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-11-01 08:00:00	SPY	ETF	88.35	88.84	88.12	88.36	48400.0
2002-11-01 09:00:00	SPY	ETF	88.28	88.63	88.09	88.33	3127000.0
2002-11-01 10:00:00	SPY	ETF	88.33	89.56	88.05	89.22	8957600.0
2002-11-01 11:00:00	SPY	ETF	89.23	89.8	89.2	89.51	7181300.0
2002-11-01 12:00:00	SPY	ETF	89.51	90.2	89.4	90.01	5362100.0
2002-11-01 13:00:00	SPY	ETF	90.01	90.07	89.45	89.7	2775500.0
2002-11-01 14:00:00	SPY	ETF	89.73	90.13	89.66	89.81	4095300.0
2002-11-01 15:00:00	SPY	ETF	89.8	90.82	89.8	90.55	9815100.0
2002-11-01 16:00:00	SPY	ETF	90.58	90.75	90.22	90.74	3680200.0
2002-11-01 17:00:00	SPY	ETF	90.71	91.03	90.7	90.95	112500.0
2002-11-01 18:00:00	SPY	ETF	90.99	91.15	90.99	91.14	22700.0
2002-11-01 08:00:00	QQQ	ETF	24.34	24.56	24.32	24.36	57700.0
2002-11-01 09:00:00	QQQ	ETF	24.33	24.43	24.2	24.33	6303400.0
2002-11-01 10:00:00	QQQ	ETF	24.33	24.93	24.14	24.83	19484600.0
2002-11-01 11:00:00	QQQ	ETF	24.83	25.01	24.79	24.9	13012400.0
2002-11-01 12:00:00	QQQ	ETF	24.9	25.19	24.85	25.04	10299200.0
2002-11-01 13:00:00	QQQ	ETF	25.06	25.11	24.88	24.95	7075100.0
2002-11-01 14:00:00	QQQ	ETF	24.97	25.15	24.96	25.04	6806800.0
2002-11-01 15:00:00	QQQ	ETF	25.05	25.4	25.02	25.3	12678800.0
2002-11-01 16:00:00	QQQ	ETF	25.3	25.72	24.89	25.68	5073700.0
2002-11-01 17:00:00	QQQ	ETF	25.68	25.77	25.65	25.74	463800.0
2002-11-01 18:00:00	QQQ	ETF	25.74	25.74	25.66	25.72	38000.0
2002-11-01 19:00:00	QQQ	ETF	25.73	25.75	25.73	25.75	3100.0
2002-11-01 09:00:00	IWM	ETF	37.135	37.35	36.975	37.175	235600.0
2002-11-01 10:00:00	IWM	ETF	37.105	37.615	37.105	37.615	353200.0
2002-11-01 11:00:00	IWM	ETF	37.595	37.7	37.525	37.605	246800.0
2002-11-01 12:00:00	IWM	ETF	37.545	37.8	37.545	37.75	875800.0
2002-11-01 13:00:00	IWM	ETF	37.75	37.775	37.645	37.71	194200.0
2002-11-01 14:00:00	IWM	ETF	37.755	37.8	37.69	37.8	313600.0
2002-11-01 15:00:00	IWM	ETF	37.8	38.225	37.79	38.165	985000.0
2002-11-01 16:00:00	IWM	ETF	38.12	38.23	37.66	38.23	1508200.0
2002-11-01 08:00:00	DIA	ETF	83.64	83.7	83.55	83.55	900.0
2002-11-01 09:00:00	DIA	ETF	83.55	83.8	83.21	83.44	1313200.0
2002-11-01 10:00:00	DIA	ETF	83.42	84.53	83.2	84.23	1908900.0
2002-11-01 11:00:00	DIA	ETF	84.27	84.87	84.2	84.54	1500300.0
2002-11-01 12:00:00	DIA	ETF	84.57	85.13	84.42	84.93	546700.0
2002-11-01 13:00:00	DIA	ETF	84.97	84.98	84.37	84.61	589800.0
2002-11-01 14:00:00	DIA	ETF	84.62	84.95	84.5	84.66	784300.0
2002-11-01 15:00:00	DIA	ETF	84.65	85.61	84.65	85.4	1807200.0
2002-11-01 16:00:00	DIA	ETF	85.45	85.9	85.2	85.9	303300.0
2002-11-01 17:00:00	DIA	ETF	85.9	86.15	85.9	86.12	5900.0
2002-11-01 18:00:00	DIA	ETF	86.0	86.12	85.76	86.1	7100.0
2002-11-01 19:00:00	DIA	ETF	86.1	86.1	86.1	86.1	400.0
2002-11-01 09:00:00	TLT	ETF	86.3	86.35	86.3	86.32	1100.0
2002-11-01 10:00:00	TLT	ETF	86.37	86.37	85.47	85.47	77300.0
2002-11-01 11:00:00	TLT	ETF	85.5	85.5	85.25	85.43	36200.0
2002-11-01 12:00:00	TLT	ETF	85.45	85.66	85.45	85.55	4900.0
2002-11-01 13:00:00	TLT	ETF	85.75	85.75	85.75	85.75	400.0
2002-11-01 14:00:00	TLT	ETF	85.82	86.0	85.82	86.0	2800.0
2002-11-01 15:00:00	TLT	ETF	85.94	86.93	85.89	85.98	2200.0

> showing 50 of 364 rows — these rows as CSV

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