PREVIEW / etf_1hour / 2002-11-27

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-27.parquet
  size:    16 KB
  rows:    386

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-27 08:00:00	SPY	ETF	92.24	92.48	92.2	92.44	100600.0
2002-11-27 09:00:00	SPY	ETF	92.45	92.95	92.44	92.81	3711500.0
2002-11-27 10:00:00	SPY	ETF	92.84	94.03	92.82	93.88	10460000.0
2002-11-27 11:00:00	SPY	ETF	93.86	94.28	93.83	94.08	3649900.0
2002-11-27 12:00:00	SPY	ETF	94.12	94.44	94.07	94.25	3341700.0
2002-11-27 13:00:00	SPY	ETF	94.24	94.49	94.16	94.36	1658700.0
2002-11-27 14:00:00	SPY	ETF	94.35	94.57	94.15	94.4	3691600.0
2002-11-27 15:00:00	SPY	ETF	94.45	94.65	94.18	94.33	4801800.0
2002-11-27 16:00:00	SPY	ETF	94.35	94.53	94.03	94.33	3670100.0
2002-11-27 17:00:00	SPY	ETF	94.3	94.31	94.29	94.31	1000.0
2002-11-27 18:00:00	SPY	ETF	94.34	94.38	94.33	94.38	8800.0
2002-11-27 19:00:00	SPY	ETF	94.38	94.4	94.33	94.4	1500.0
2002-11-27 08:00:00	QQQ	ETF	27.25	27.48	27.24	27.47	229200.0
2002-11-27 09:00:00	QQQ	ETF	27.47	27.65	27.47	27.59	11677100.0
2002-11-27 10:00:00	QQQ	ETF	27.61	28.18	27.59	27.88	18956900.0
2002-11-27 11:00:00	QQQ	ETF	27.88	27.99	27.86	27.94	7440100.0
2002-11-27 12:00:00	QQQ	ETF	27.94	28.08	27.88	28.04	8277000.0
2002-11-27 13:00:00	QQQ	ETF	28.04	28.11	27.98	28.07	5123900.0
2002-11-27 14:00:00	QQQ	ETF	28.07	28.2	27.99	28.1	8021300.0
2002-11-27 15:00:00	QQQ	ETF	28.09	28.15	27.96	28.01	7836800.0
2002-11-27 16:00:00	QQQ	ETF	27.98	28.07	27.9	27.93	2848600.0
2002-11-27 17:00:00	QQQ	ETF	27.93	27.95	27.91	27.92	86500.0
2002-11-27 18:00:00	QQQ	ETF	27.92	27.96	27.9	27.94	38200.0
2002-11-27 19:00:00	QQQ	ETF	27.93	27.95	27.93	27.93	3300.0
2002-11-27 09:00:00	IWM	ETF	40.2	40.34	40.08	40.32	354600.0
2002-11-27 10:00:00	IWM	ETF	40.395	40.71	40.33	40.55	527600.0
2002-11-27 11:00:00	IWM	ETF	40.55	40.675	40.53	40.545	90200.0
2002-11-27 12:00:00	IWM	ETF	40.55	40.65	40.55	40.57	232400.0
2002-11-27 13:00:00	IWM	ETF	40.595	40.695	40.585	40.6	83400.0
2002-11-27 14:00:00	IWM	ETF	40.6	40.72	40.5	40.595	332400.0
2002-11-27 15:00:00	IWM	ETF	40.625	40.965	40.525	40.95	600800.0
2002-11-27 16:00:00	IWM	ETF	40.975	40.975	40.85	40.91	73600.0
2002-11-27 17:00:00	IWM	ETF	40.91	40.91	40.91	40.91	400.0
2002-11-27 08:00:00	DIA	ETF	87.34	87.64	87.34	87.64	2700.0
2002-11-27 09:00:00	DIA	ETF	87.62	87.92	87.56	87.76	756000.0
2002-11-27 10:00:00	DIA	ETF	87.8	89.1	87.71	88.95	2368700.0
2002-11-27 11:00:00	DIA	ETF	88.95	89.29	88.89	89.13	926400.0
2002-11-27 12:00:00	DIA	ETF	89.13	89.4	89.01	89.18	586000.0
2002-11-27 13:00:00	DIA	ETF	89.18	89.49	89.13	89.36	691600.0
2002-11-27 14:00:00	DIA	ETF	89.37	89.6	89.22	89.44	1093300.0
2002-11-27 15:00:00	DIA	ETF	89.46	89.65	89.26	89.56	1204000.0
2002-11-27 16:00:00	DIA	ETF	89.56	89.61	89.43	89.55	134400.0
2002-11-27 17:00:00	DIA	ETF	89.63	89.63	89.63	89.63	100.0
2002-11-27 18:00:00	DIA	ETF	89.63	89.63	89.57	89.57	1100.0
2002-11-27 19:00:00	DIA	ETF	89.68	89.68	89.6	89.6	500.0
2002-11-27 09:00:00	TLT	ETF	86.25	86.33	86.24	86.26	3400.0
2002-11-27 10:00:00	TLT	ETF	85.92	86.0	85.41	85.44	91100.0
2002-11-27 11:00:00	TLT	ETF	85.46	85.65	85.18	85.22	104700.0
2002-11-27 12:00:00	TLT	ETF	85.22	85.25	85.0	85.13	45300.0
2002-11-27 13:00:00	TLT	ETF	85.1	85.1	85.0	85.05	24100.0

> showing 50 of 386 rows — these rows as CSV

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