PREVIEW / etf_1hour / 2002-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-15.parquet
  size:    16 KB
  rows:    377

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-15 08:00:00	SPY	ETF	90.84	91.17	90.35	90.35	24300.0
2002-11-15 09:00:00	SPY	ETF	90.23	91.15	89.97	90.75	9581800.0
2002-11-15 10:00:00	SPY	ETF	90.82	90.84	90.09	90.39	4558900.0
2002-11-15 11:00:00	SPY	ETF	90.31	90.45	89.95	90.2	2977900.0
2002-11-15 12:00:00	SPY	ETF	90.17	90.46	90.0	90.25	1891100.0
2002-11-15 13:00:00	SPY	ETF	90.26	90.83	90.15	90.67	2506900.0
2002-11-15 14:00:00	SPY	ETF	90.67	91.46	90.55	91.11	5690200.0
2002-11-15 15:00:00	SPY	ETF	91.1	91.55	91.01	91.38	4708000.0
2002-11-15 16:00:00	SPY	ETF	91.45	91.5	91.3	91.32	4918600.0
2002-11-15 17:00:00	SPY	ETF	91.31	91.41	91.27	91.3	18000.0
2002-11-15 18:00:00	SPY	ETF	91.3	91.3	91.3	91.3	600.0
2002-11-15 08:00:00	QQQ	ETF	26.1	26.19	25.86	25.87	160900.0
2002-11-15 09:00:00	QQQ	ETF	25.88	26.29	25.81	26.12	14895200.0
2002-11-15 10:00:00	QQQ	ETF	26.13	26.17	25.75	25.86	15628800.0
2002-11-15 11:00:00	QQQ	ETF	25.86	25.97	25.75	25.87	4856800.0
2002-11-15 12:00:00	QQQ	ETF	25.86	25.99	25.8	25.9	2990500.0
2002-11-15 13:00:00	QQQ	ETF	25.9	26.16	25.85	26.08	5303000.0
2002-11-15 14:00:00	QQQ	ETF	26.09	26.43	26.03	26.28	8826300.0
2002-11-15 15:00:00	QQQ	ETF	26.31	26.45	26.21	26.38	10159200.0
2002-11-15 16:00:00	QQQ	ETF	26.39	26.47	26.32	26.4	3779300.0
2002-11-15 17:00:00	QQQ	ETF	26.39	26.43	26.35	26.4	80600.0
2002-11-15 18:00:00	QQQ	ETF	26.42	26.43	26.37	26.41	17100.0
2002-11-15 19:00:00	QQQ	ETF	26.42	26.43	26.42	26.43	1200.0
2002-11-15 09:00:00	IWM	ETF	38.175	38.55	38.175	38.5	258000.0
2002-11-15 10:00:00	IWM	ETF	38.51	38.51	38.3	38.375	412600.0
2002-11-15 11:00:00	IWM	ETF	38.365	38.38	38.255	38.285	131000.0
2002-11-15 12:00:00	IWM	ETF	38.275	38.375	38.275	38.37	56800.0
2002-11-15 13:00:00	IWM	ETF	38.33	38.54	38.265	38.51	170600.0
2002-11-15 14:00:00	IWM	ETF	38.53	38.75	38.48	38.63	199800.0
2002-11-15 15:00:00	IWM	ETF	38.64	38.74	38.555	38.555	442600.0
2002-11-15 16:00:00	IWM	ETF	38.53	38.93	38.385	38.93	91600.0
2002-11-15 17:00:00	IWM	ETF	38.4	38.45	38.4	38.45	6800.0
2002-11-15 08:00:00	DIA	ETF	85.54	85.58	85.15	85.15	9900.0
2002-11-15 09:00:00	DIA	ETF	84.92	85.8	84.74	85.43	1551400.0
2002-11-15 10:00:00	DIA	ETF	85.4	85.59	84.82	85.08	1212400.0
2002-11-15 11:00:00	DIA	ETF	85.1	85.11	84.71	84.85	583800.0
2002-11-15 12:00:00	DIA	ETF	84.89	85.08	84.75	84.82	445400.0
2002-11-15 13:00:00	DIA	ETF	84.82	85.27	84.68	85.08	660500.0
2002-11-15 14:00:00	DIA	ETF	85.08	85.73	84.94	85.5	1036700.0
2002-11-15 15:00:00	DIA	ETF	85.51	85.98	85.37	85.86	1222700.0
2002-11-15 16:00:00	DIA	ETF	85.91	85.91	85.75	85.8	127500.0
2002-11-15 17:00:00	DIA	ETF	85.75	85.8	85.75	85.8	300.0
2002-11-15 18:00:00	DIA	ETF	85.85	85.85	85.85	85.85	100.0
2002-11-15 09:00:00	TLT	ETF	86.54	86.54	86.26	86.26	62700.0
2002-11-15 10:00:00	TLT	ETF	86.52	86.75	86.52	86.75	28400.0
2002-11-15 11:00:00	TLT	ETF	86.7	86.99	86.7	86.99	4300.0
2002-11-15 12:00:00	TLT	ETF	86.96	86.99	86.81	86.91	1100.0
2002-11-15 13:00:00	TLT	ETF	86.87	87.13	86.87	87.13	5600.0
2002-11-15 14:00:00	TLT	ETF	87.17	87.23	87.09	87.09	3800.0
2002-11-15 15:00:00	TLT	ETF	87.1	87.14	86.95	87.11	4300.0

> showing 50 of 377 rows — these rows as CSV

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