PREVIEW / etf_1hour / 2002-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-10.parquet
  size:    16 KB
  rows:    363

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-10-10 08:00:00	SPY	ETF	78.35	78.67	78.19	78.39	25100.0
2002-10-10 09:00:00	SPY	ETF	78.44	78.55	77.07	77.15	8619800.0
2002-10-10 10:00:00	SPY	ETF	77.15	80.1	77.1	79.96	14691600.0
2002-10-10 11:00:00	SPY	ETF	79.96	80.08	78.95	79.17	9749500.0
2002-10-10 12:00:00	SPY	ETF	79.2	79.76	79.2	79.52	5450200.0
2002-10-10 13:00:00	SPY	ETF	79.52	80.64	79.47	80.18	10385900.0
2002-10-10 14:00:00	SPY	ETF	80.2	80.56	79.75	80.4	9189400.0
2002-10-10 15:00:00	SPY	ETF	80.4	81.07	80.22	80.66	9410100.0
2002-10-10 16:00:00	SPY	ETF	80.69	80.77	77.82	77.82	5346400.0
2002-10-10 17:00:00	SPY	ETF	77.82	80.71	77.15	80.7	49200.0
2002-10-10 18:00:00	SPY	ETF	80.63	80.63	80.53	80.53	8600.0
2002-10-10 19:00:00	SPY	ETF	80.53	80.54	80.53	80.54	25200.0
2002-10-10 08:00:00	QQQ	ETF	20.18	20.25	20.15	20.15	15300.0
2002-10-10 09:00:00	QQQ	ETF	20.2	20.37	19.91	19.94	11159600.0
2002-10-10 10:00:00	QQQ	ETF	19.97	20.88	19.91	20.83	22464100.0
2002-10-10 11:00:00	QQQ	ETF	20.82	20.98	20.65	20.7	15813000.0
2002-10-10 12:00:00	QQQ	ETF	20.72	20.87	20.66	20.84	9080200.0
2002-10-10 13:00:00	QQQ	ETF	20.85	21.2	20.79	21.08	20859000.0
2002-10-10 14:00:00	QQQ	ETF	21.08	21.16	20.91	21.09	10869600.0
2002-10-10 15:00:00	QQQ	ETF	21.07	21.21	20.97	21.08	13056900.0
2002-10-10 16:00:00	QQQ	ETF	21.08	21.13	21.02	21.09	3396000.0
2002-10-10 17:00:00	QQQ	ETF	21.11	21.15	21.08	21.13	175700.0
2002-10-10 18:00:00	QQQ	ETF	21.13	21.18	21.11	21.18	29200.0
2002-10-10 19:00:00	QQQ	ETF	21.11	21.13	21.09	21.09	500.0
2002-10-10 09:00:00	IWM	ETF	32.535	32.77	32.3	32.3	351600.0
2002-10-10 10:00:00	IWM	ETF	32.4	32.97	32.305	32.935	586400.0
2002-10-10 11:00:00	IWM	ETF	32.97	33.0	32.8	32.85	1023400.0
2002-10-10 12:00:00	IWM	ETF	32.85	33.1	32.805	33.015	209800.0
2002-10-10 13:00:00	IWM	ETF	33.02	33.45	33.02	33.4	618000.0
2002-10-10 14:00:00	IWM	ETF	33.43	33.46	33.26	33.37	315600.0
2002-10-10 15:00:00	IWM	ETF	33.37	33.54	33.355	33.45	760000.0
2002-10-10 16:00:00	IWM	ETF	33.435	33.565	33.375	33.375	330400.0
2002-10-10 17:00:00	IWM	ETF	33.515	33.515	33.515	33.515	895000.0
2002-10-10 08:00:00	DIA	ETF	73.29	73.42	73.18	73.35	19100.0
2002-10-10 09:00:00	DIA	ETF	73.33	73.5	72.03	72.21	1838000.0
2002-10-10 10:00:00	DIA	ETF	72.3	74.94	72.2	74.79	5090800.0
2002-10-10 11:00:00	DIA	ETF	74.76	74.86	73.7	73.94	3975300.0
2002-10-10 12:00:00	DIA	ETF	74.0	74.55	74.0	74.35	1347300.0
2002-10-10 13:00:00	DIA	ETF	74.38	75.45	74.27	75.2	2640700.0
2002-10-10 14:00:00	DIA	ETF	75.12	75.33	74.55	75.18	2677300.0
2002-10-10 15:00:00	DIA	ETF	75.18	75.8	74.9	75.46	2323000.0
2002-10-10 16:00:00	DIA	ETF	75.5	75.55	75.3	75.42	399200.0
2002-10-10 17:00:00	DIA	ETF	75.3	75.42	75.3	75.42	1000.0
2002-10-10 18:00:00	DIA	ETF	75.3	75.42	75.3	75.3	1500.0
2002-10-10 09:00:00	TLT	ETF	90.17	90.17	89.95	90.04	12700.0
2002-10-10 10:00:00	TLT	ETF	90.03	90.03	89.33	89.33	30200.0
2002-10-10 11:00:00	TLT	ETF	89.38	89.68	89.34	89.55	26800.0
2002-10-10 12:00:00	TLT	ETF	89.53	89.58	89.35	89.58	6900.0
2002-10-10 13:00:00	TLT	ETF	89.56	89.56	89.3	89.32	10200.0
2002-10-10 14:00:00	TLT	ETF	89.28	89.55	89.28	89.51	1000.0

> showing 50 of 363 rows — these rows as CSV

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