PREVIEW / etf_1hour / 2002-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-05.parquet
  size:    16 KB
  rows:    378

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-05 08:00:00	SPY	ETF	90.91	91.05	90.91	91.05	4700.0
2002-11-05 09:00:00	SPY	ETF	91.05	91.38	90.84	91.3	5087500.0
2002-11-05 10:00:00	SPY	ETF	91.33	91.85	91.12	91.81	5293500.0
2002-11-05 11:00:00	SPY	ETF	91.83	91.86	91.5	91.5	3109400.0
2002-11-05 12:00:00	SPY	ETF	91.51	91.69	91.23	91.55	3013700.0
2002-11-05 13:00:00	SPY	ETF	91.53	91.59	90.93	91.15	2658400.0
2002-11-05 14:00:00	SPY	ETF	91.12	91.83	91.08	91.74	3499000.0
2002-11-05 15:00:00	SPY	ETF	91.79	92.07	91.4	91.97	4102300.0
2002-11-05 16:00:00	SPY	ETF	91.96	92.05	91.76	91.93	6467000.0
2002-11-05 17:00:00	SPY	ETF	91.92	92.0	91.92	91.92	24400.0
2002-11-05 18:00:00	SPY	ETF	91.96	92.02	91.91	92.02	10500.0
2002-11-05 08:00:00	QQQ	ETF	25.7	25.75	25.7	25.71	17500.0
2002-11-05 09:00:00	QQQ	ETF	25.75	26.09	25.7	25.91	14903000.0
2002-11-05 10:00:00	QQQ	ETF	25.97	26.1	25.71	26.03	15456000.0
2002-11-05 11:00:00	QQQ	ETF	26.04	26.08	25.86	25.94	7374400.0
2002-11-05 12:00:00	QQQ	ETF	25.95	25.95	25.76	25.82	7113000.0
2002-11-05 13:00:00	QQQ	ETF	25.84	25.9	25.56	25.67	6337300.0
2002-11-05 14:00:00	QQQ	ETF	25.67	26.03	25.65	25.99	9796600.0
2002-11-05 15:00:00	QQQ	ETF	25.98	26.14	25.85	26.1	10361100.0
2002-11-05 16:00:00	QQQ	ETF	26.09	26.19	26.06	26.17	2121000.0
2002-11-05 17:00:00	QQQ	ETF	26.17	26.25	26.16	26.2	221200.0
2002-11-05 18:00:00	QQQ	ETF	26.18	26.2	26.17	26.18	13000.0
2002-11-05 19:00:00	QQQ	ETF	26.17	26.18	26.17	26.18	300.0
2002-11-05 09:00:00	IWM	ETF	38.525	38.55	38.375	38.535	250200.0
2002-11-05 10:00:00	IWM	ETF	38.625	38.625	38.35	38.515	485800.0
2002-11-05 11:00:00	IWM	ETF	38.515	38.525	38.37	38.37	434600.0
2002-11-05 12:00:00	IWM	ETF	38.375	38.38	38.265	38.335	135600.0
2002-11-05 13:00:00	IWM	ETF	38.38	38.385	38.165	38.215	230600.0
2002-11-05 14:00:00	IWM	ETF	38.295	38.5	38.255	38.45	96400.0
2002-11-05 15:00:00	IWM	ETF	38.41	38.59	38.375	38.59	170600.0
2002-11-05 16:00:00	IWM	ETF	38.67	38.67	38.47	38.52	9200.0
2002-11-05 17:00:00	IWM	ETF	38.505	38.505	38.505	38.505	649200.0
2002-11-05 08:00:00	DIA	ETF	85.58	85.69	85.58	85.69	2100.0
2002-11-05 09:00:00	DIA	ETF	85.79	86.31	85.5	86.31	1871800.0
2002-11-05 10:00:00	DIA	ETF	86.31	86.81	86.07	86.79	1829000.0
2002-11-05 11:00:00	DIA	ETF	86.71	86.86	86.4	86.49	920900.0
2002-11-05 12:00:00	DIA	ETF	86.44	86.59	86.18	86.43	1135700.0
2002-11-05 13:00:00	DIA	ETF	86.45	86.53	85.95	86.2	1562500.0
2002-11-05 14:00:00	DIA	ETF	86.19	86.8	86.15	86.67	909800.0
2002-11-05 15:00:00	DIA	ETF	86.69	87.05	86.43	86.96	1657500.0
2002-11-05 16:00:00	DIA	ETF	86.95	86.99	86.8	86.9	224800.0
2002-11-05 17:00:00	DIA	ETF	86.92	86.99	86.86	86.9	4800.0
2002-11-05 18:00:00	DIA	ETF	86.88	86.88	86.88	86.88	500.0
2002-11-05 09:00:00	TLT	ETF	85.6	85.6	85.41	85.41	3200.0
2002-11-05 10:00:00	TLT	ETF	85.39	85.4	85.34	85.36	2600.0
2002-11-05 12:00:00	TLT	ETF	85.38	85.38	85.19	85.19	5000.0
2002-11-05 13:00:00	TLT	ETF	85.2	85.2	85.11	85.11	3500.0
2002-11-05 14:00:00	TLT	ETF	85.09	85.26	85.09	85.18	54200.0
2002-11-05 15:00:00	TLT	ETF	85.25	85.44	85.25	85.27	4800.0

> showing 49 of 378 rows — these rows as CSV

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