PREVIEW / etf_1hour / 2002-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-05-24.parquet
  size:    14 KB
  rows:    309

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-24 09:00:00	SPY	ETF	109.98	110.1	109.66	109.98	1069500.0
2002-05-24 10:00:00	SPY	ETF	109.99	110.2	109.24	109.3	2213100.0
2002-05-24 11:00:00	SPY	ETF	109.31	109.5	109.12	109.38	1322700.0
2002-05-24 12:00:00	SPY	ETF	109.35	109.5	109.2	109.22	933700.0
2002-05-24 13:00:00	SPY	ETF	109.22	109.49	108.97	109.0	1010000.0
2002-05-24 14:00:00	SPY	ETF	108.97	109.09	108.66	108.79	1456800.0
2002-05-24 15:00:00	SPY	ETF	108.76	109.27	108.69	108.78	2369800.0
2002-05-24 16:00:00	SPY	ETF	108.85	108.97	108.61	108.85	1472900.0
2002-05-24 17:00:00	SPY	ETF	108.67	108.67	108.67	108.67	200.0
2002-05-24 18:00:00	SPY	ETF	108.69	108.7	108.66	108.66	700.0
2002-05-24 09:00:00	QQQ	ETF	31.59	31.69	31.28	31.47	9590800.0
2002-05-24 10:00:00	QQQ	ETF	31.5	31.58	31.13	31.24	12512400.0
2002-05-24 11:00:00	QQQ	ETF	31.24	31.39	31.15	31.23	5829700.0
2002-05-24 12:00:00	QQQ	ETF	31.23	31.31	31.14	31.28	3181300.0
2002-05-24 13:00:00	QQQ	ETF	31.25	31.4	31.1	31.1	4687600.0
2002-05-24 14:00:00	QQQ	ETF	31.11	31.19	31.01	31.06	4792900.0
2002-05-24 15:00:00	QQQ	ETF	31.06	31.47	31.03	31.23	13174500.0
2002-05-24 16:00:00	QQQ	ETF	31.23	31.52	31.17	31.2	1899800.0
2002-05-24 17:00:00	QQQ	ETF	31.2	32.13	31.18	31.18	12700.0
2002-05-24 18:00:00	QQQ	ETF	31.2	31.33	31.2	31.33	23000.0
2002-05-24 09:00:00	IWM	ETF	49.75	49.82	49.55	49.725	109200.0
2002-05-24 10:00:00	IWM	ETF	49.8	49.8	49.575	49.575	165800.0
2002-05-24 11:00:00	IWM	ETF	49.58	49.695	49.55	49.67	310000.0
2002-05-24 12:00:00	IWM	ETF	49.665	49.725	49.605	49.65	252600.0
2002-05-24 13:00:00	IWM	ETF	49.725	49.825	49.65	49.695	206000.0
2002-05-24 14:00:00	IWM	ETF	49.725	49.725	49.555	49.555	217000.0
2002-05-24 15:00:00	IWM	ETF	49.56	49.69	49.215	49.215	319000.0
2002-05-24 16:00:00	IWM	ETF	49.275	49.3	49.185	49.185	24800.0
2002-05-24 09:00:00	DIA	ETF	102.0	102.3	101.84	102.3	217200.0
2002-05-24 10:00:00	DIA	ETF	102.24	102.4	101.61	101.67	481100.0
2002-05-24 11:00:00	DIA	ETF	101.7	101.72	101.44	101.5	82300.0
2002-05-24 12:00:00	DIA	ETF	101.51	101.65	101.36	101.46	110200.0
2002-05-24 13:00:00	DIA	ETF	101.4	101.6	101.21	101.21	273000.0
2002-05-24 14:00:00	DIA	ETF	101.21	101.29	100.92	100.96	294100.0
2002-05-24 15:00:00	DIA	ETF	101.0	101.54	100.98	101.13	404300.0
2002-05-24 16:00:00	DIA	ETF	101.09	101.15	101.0	101.0	53800.0

> showing 36 of 309 rows — these rows as CSV

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