PREVIEW / etf_1hour / 2002-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-05-07.parquet
  size:    14 KB
  rows:    317

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-05-07 09:00:00	SPY	ETF	106.1	106.25	105.75	105.78	3328800.0
2002-05-07 10:00:00	SPY	ETF	105.76	106.03	105.39	105.86	5186500.0
2002-05-07 11:00:00	SPY	ETF	105.89	105.96	105.45	105.67	2226400.0
2002-05-07 12:00:00	SPY	ETF	105.64	106.2	105.64	106.04	2750300.0
2002-05-07 13:00:00	SPY	ETF	106.08	106.27	105.83	105.97	1256200.0
2002-05-07 14:00:00	SPY	ETF	106.01	106.32	105.65	106.01	2815700.0
2002-05-07 15:00:00	SPY	ETF	106.0	106.08	105.2	105.23	2019800.0
2002-05-07 16:00:00	SPY	ETF	105.22	105.64	104.88	105.53	1941000.0
2002-05-07 17:00:00	SPY	ETF	105.55	105.94	105.5	105.87	262300.0
2002-05-07 18:00:00	SPY	ETF	105.83	105.95	105.71	105.85	255000.0
2002-05-07 09:00:00	QQQ	ETF	29.27	29.35	28.71	28.74	12684800.0
2002-05-07 10:00:00	QQQ	ETF	28.73	29.03	28.42	28.77	22407100.0
2002-05-07 11:00:00	QQQ	ETF	28.75	28.94	28.57	28.85	11649900.0
2002-05-07 12:00:00	QQQ	ETF	28.86	29.31	28.85	29.16	11956500.0
2002-05-07 13:00:00	QQQ	ETF	29.17	29.32	29.03	29.21	5725600.0
2002-05-07 14:00:00	QQQ	ETF	29.2	29.32	28.91	29.13	12444600.0
2002-05-07 15:00:00	QQQ	ETF	29.12	29.2	28.78	28.84	15192100.0
2002-05-07 16:00:00	QQQ	ETF	28.85	29.26	28.65	29.13	4474800.0
2002-05-07 17:00:00	QQQ	ETF	29.12	29.43	29.12	29.35	2881000.0
2002-05-07 18:00:00	QQQ	ETF	29.37	29.38	29.3	29.35	238900.0
2002-05-07 09:00:00	IWM	ETF	50.24	50.27	49.975	49.975	110000.0
2002-05-07 10:00:00	IWM	ETF	49.875	49.95	49.685	49.805	361400.0
2002-05-07 11:00:00	IWM	ETF	49.82	49.85	49.69	49.81	189800.0
2002-05-07 12:00:00	IWM	ETF	49.81	50.03	49.79	50.02	78400.0
2002-05-07 13:00:00	IWM	ETF	49.955	50.06	49.88	49.88	69800.0
2002-05-07 14:00:00	IWM	ETF	49.925	50.0	49.78	49.9	162600.0
2002-05-07 15:00:00	IWM	ETF	49.9	49.9	49.6	49.71	244800.0
2002-05-07 16:00:00	IWM	ETF	49.71	49.71	49.615	49.615	78600.0
2002-05-07 09:00:00	DIA	ETF	98.84	98.84	98.48	98.48	982300.0
2002-05-07 10:00:00	DIA	ETF	98.5	98.8	98.1	98.78	1595400.0
2002-05-07 11:00:00	DIA	ETF	98.78	98.93	98.5	98.73	479300.0
2002-05-07 12:00:00	DIA	ETF	98.77	99.28	98.72	99.06	945700.0
2002-05-07 13:00:00	DIA	ETF	99.05	99.25	98.15	99.06	108000.0
2002-05-07 14:00:00	DIA	ETF	99.15	99.39	98.68	99.14	501500.0
2002-05-07 15:00:00	DIA	ETF	99.1	99.17	98.25	98.38	559100.0
2002-05-07 16:00:00	DIA	ETF	98.38	98.65	98.08	98.45	185300.0

> showing 36 of 317 rows — these rows as CSV

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