PREVIEW / etf_1hour / 2001-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-09-28.parquet
  size:    12 KB
  rows:    258

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
2001-09-28 09:00:00	SPY	ETF	102.98	103.18	102.5	103.15	2285100.0
2001-09-28 10:00:00	SPY	ETF	103.12	104.11	102.93	103.4	6034900.0
2001-09-28 11:00:00	SPY	ETF	103.45	104.06	103.36	103.72	1700300.0
2001-09-28 12:00:00	SPY	ETF	103.71	104.03	103.54	103.63	1788900.0
2001-09-28 13:00:00	SPY	ETF	103.63	104.18	103.46	104.1	2180700.0
2001-09-28 14:00:00	SPY	ETF	104.13	104.14	103.56	103.85	2421000.0
2001-09-28 15:00:00	SPY	ETF	103.86	104.31	103.82	104.25	3246700.0
2001-09-28 16:00:00	SPY	ETF	104.31	104.45	103.8	104.11	777300.0
2001-09-28 17:00:00	SPY	ETF	104.11	104.36	104.11	104.11	4600.0
2001-09-28 09:00:00	QQQ	ETF	28.84	28.97	28.53	28.77	12422900.0
2001-09-28 10:00:00	QQQ	ETF	28.78	29.32	28.61	28.83	23442400.0
2001-09-28 11:00:00	QQQ	ETF	28.83	29.35	28.8	29.15	9459800.0
2001-09-28 12:00:00	QQQ	ETF	29.14	29.3	28.92	28.98	6273400.0
2001-09-28 13:00:00	QQQ	ETF	28.96	29.25	28.9	29.15	5920200.0
2001-09-28 14:00:00	QQQ	ETF	29.17	29.2	28.83	29.0	5937700.0
2001-09-28 15:00:00	QQQ	ETF	28.99	29.3	28.87	29.06	15902800.0
2001-09-28 16:00:00	QQQ	ETF	29.05	29.1	28.94	29.07	2467800.0
2001-09-28 17:00:00	QQQ	ETF	29.09	29.09	28.95	29.05	79200.0
2001-09-28 18:00:00	QQQ	ETF	29.07	29.09	29.01	29.02	5600.0
2001-09-28 09:00:00	IWM	ETF	39.8	39.8	39.64	39.8	1048400.0
2001-09-28 10:00:00	IWM	ETF	40.175	40.3	39.97	40.025	357800.0
2001-09-28 11:00:00	IWM	ETF	40.1	40.18	40.05	40.15	153000.0
2001-09-28 12:00:00	IWM	ETF	40.07	40.225	40.07	40.125	53800.0
2001-09-28 13:00:00	IWM	ETF	40.075	40.225	40.075	40.22	11000.0
2001-09-28 14:00:00	IWM	ETF	40.225	40.245	40.125	40.19	89400.0
2001-09-28 15:00:00	IWM	ETF	40.175	40.39	40.175	40.225	134200.0
2001-09-28 16:00:00	IWM	ETF	40.125	40.275	40.05	40.1	408400.0
2001-09-28 09:00:00	DIA	ETF	87.25	87.75	87.05	87.3	907200.0
2001-09-28 10:00:00	DIA	ETF	87.37	88.13	87.27	87.8	2113000.0
2001-09-28 11:00:00	DIA	ETF	87.84	88.5	87.82	88.3	1004000.0
2001-09-28 12:00:00	DIA	ETF	88.26	88.48	88.01	88.1	387600.0
2001-09-28 13:00:00	DIA	ETF	88.1	88.74	87.84	88.61	618000.0
2001-09-28 14:00:00	DIA	ETF	88.61	88.65	88.1	88.32	773100.0
2001-09-28 15:00:00	DIA	ETF	88.38	88.6	88.16	88.4	1093700.0
2001-09-28 16:00:00	DIA	ETF	88.4	88.55	87.4	87.4	195100.0
2001-09-28 17:00:00	DIA	ETF	88.46	88.46	88.46	88.46	100.0
2001-09-28 18:00:00	DIA	ETF	88.28	88.28	88.26	88.26	500.0

> showing 37 of 258 rows — these rows as CSV

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