PREVIEW / etf_1hour / 2002-12-05

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-12-05.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-12-05 08:00:00	SPY	ETF	92.92	93.19	92.8	92.87	73400.0
2002-12-05 09:00:00	SPY	ETF	92.81	93.03	91.74	91.81	3991600.0
2002-12-05 10:00:00	SPY	ETF	91.8	92.1	91.4	91.63	7899400.0
2002-12-05 11:00:00	SPY	ETF	91.63	91.68	91.1	91.33	4876700.0
2002-12-05 12:00:00	SPY	ETF	91.34	91.46	91.15	91.26	2765300.0
2002-12-05 13:00:00	SPY	ETF	91.27	91.66	91.11	91.64	3639300.0
2002-12-05 14:00:00	SPY	ETF	91.63	91.99	91.47	91.59	3395200.0
2002-12-05 15:00:00	SPY	ETF	91.59	91.61	91.16	91.16	4528800.0
2002-12-05 16:00:00	SPY	ETF	91.18	91.63	91.17	91.48	1931000.0
2002-12-05 17:00:00	SPY	ETF	91.5	91.5	91.27	91.3	61800.0
2002-12-05 18:00:00	SPY	ETF	91.33	91.53	91.3	91.53	30300.0
2002-12-05 19:00:00	SPY	ETF	91.54	91.62	91.45	91.47	17700.0
2002-12-05 08:00:00	QQQ	ETF	26.9	27.03	26.83	26.89	253500.0
2002-12-05 09:00:00	QQQ	ETF	26.88	27.03	26.52	26.56	13266400.0
2002-12-05 10:00:00	QQQ	ETF	26.55	26.75	26.4	26.46	11549500.0
2002-12-05 11:00:00	QQQ	ETF	26.47	26.48	26.13	26.27	11801100.0
2002-12-05 12:00:00	QQQ	ETF	26.27	26.43	26.18	26.27	6572900.0
2002-12-05 13:00:00	QQQ	ETF	26.28	26.47	26.19	26.45	7361100.0
2002-12-05 14:00:00	QQQ	ETF	26.45	26.62	26.31	26.35	10976400.0
2002-12-05 15:00:00	QQQ	ETF	26.35	26.37	26.16	26.19	11344000.0
2002-12-05 16:00:00	QQQ	ETF	26.19	26.44	26.17	26.34	3695400.0
2002-12-05 17:00:00	QQQ	ETF	26.34	26.36	26.21	26.23	217000.0
2002-12-05 18:00:00	QQQ	ETF	26.22	26.47	26.21	26.47	212600.0
2002-12-05 19:00:00	QQQ	ETF	26.47	26.47	26.36	26.4	80900.0
2002-12-05 09:00:00	IWM	ETF	40.04	40.04	39.47	39.485	230600.0
2002-12-05 10:00:00	IWM	ETF	39.49	39.63	39.4	39.47	430200.0
2002-12-05 11:00:00	IWM	ETF	39.435	39.47	39.255	39.34	276800.0
2002-12-05 12:00:00	IWM	ETF	39.34	39.45	39.31	39.42	365400.0
2002-12-05 13:00:00	IWM	ETF	39.385	39.565	39.335	39.565	376400.0
2002-12-05 14:00:00	IWM	ETF	39.56	39.67	39.48	39.515	310800.0
2002-12-05 15:00:00	IWM	ETF	39.48	39.54	39.25	39.25	288000.0
2002-12-05 16:00:00	IWM	ETF	39.26	39.42	39.225	39.42	50600.0
2002-12-05 18:00:00	IWM	ETF	39.38	39.38	39.38	39.38	1904400.0
2002-12-05 08:00:00	DIA	ETF	88.2	88.41	88.14	88.2	18400.0
2002-12-05 09:00:00	DIA	ETF	88.19	88.25	86.97	87.14	1057400.0
2002-12-05 10:00:00	DIA	ETF	87.16	87.34	86.56	86.79	1471100.0
2002-12-05 11:00:00	DIA	ETF	86.79	86.88	86.35	86.53	1126800.0
2002-12-05 12:00:00	DIA	ETF	86.55	86.7	86.4	86.46	630800.0
2002-12-05 13:00:00	DIA	ETF	86.46	86.88	86.29	86.8	629800.0
2002-12-05 14:00:00	DIA	ETF	86.8	87.08	86.65	86.73	768600.0
2002-12-05 15:00:00	DIA	ETF	86.74	86.79	86.4	86.49	696000.0
2002-12-05 16:00:00	DIA	ETF	86.5	86.95	86.46	86.84	86900.0
2002-12-05 17:00:00	DIA	ETF	86.88	86.91	86.7	86.7	2100.0
2002-12-05 18:00:00	DIA	ETF	86.73	86.84	86.6	86.6	4100.0
2002-12-05 19:00:00	DIA	ETF	86.68	86.68	86.68	86.68	200.0
2002-12-05 09:00:00	TLT	ETF	85.28	85.62	85.26	85.62	17500.0
2002-12-05 10:00:00	TLT	ETF	85.63	85.9	85.63	85.73	22600.0
2002-12-05 11:00:00	TLT	ETF	85.85	86.18	85.85	86.18	13600.0
2002-12-05 12:00:00	TLT	ETF	86.23	86.23	86.02	86.14	110600.0
2002-12-05 13:00:00	TLT	ETF	86.24	86.28	86.1	86.18	3400.0

> showing 50 of 377 rows — these rows as CSV

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