PREVIEW / etf_1hour / 2002-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-01-09.parquet
  size:    13 KB
  rows:    292

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-01-09 09:00:00	SPY	ETF	116.68	117.08	116.65	116.91	2314300.0
2002-01-09 10:00:00	SPY	ETF	116.9	117.78	116.86	117.56	2726200.0
2002-01-09 11:00:00	SPY	ETF	117.54	117.75	117.2	117.27	1320600.0
2002-01-09 12:00:00	SPY	ETF	117.28	117.5	117.22	117.44	546100.0
2002-01-09 13:00:00	SPY	ETF	117.4	117.53	117.05	117.19	972900.0
2002-01-09 14:00:00	SPY	ETF	117.15	117.2	116.77	116.86	1839700.0
2002-01-09 15:00:00	SPY	ETF	116.9	116.97	115.34	115.7	4454400.0
2002-01-09 16:00:00	SPY	ETF	115.66	116.75	115.4	115.55	1612000.0
2002-01-09 17:00:00	SPY	ETF	115.55	115.58	115.43	115.55	8800.0
2002-01-09 18:00:00	SPY	ETF	115.48	115.48	115.25	115.25	6600.0
2002-01-09 09:00:00	QQQ	ETF	42.04	42.28	41.98	42.09	12468000.0
2002-01-09 10:00:00	QQQ	ETF	42.07	42.5	42.05	42.41	13454100.0
2002-01-09 11:00:00	QQQ	ETF	42.41	42.59	42.23	42.29	10671200.0
2002-01-09 12:00:00	QQQ	ETF	42.28	42.5	42.23	42.45	4685200.0
2002-01-09 13:00:00	QQQ	ETF	42.45	42.6	42.26	42.35	5029500.0
2002-01-09 14:00:00	QQQ	ETF	42.35	42.38	42.05	42.11	9772300.0
2002-01-09 15:00:00	QQQ	ETF	42.12	42.17	40.9	41.13	24924900.0
2002-01-09 16:00:00	QQQ	ETF	41.13	41.25	40.9	41.06	1878900.0
2002-01-09 17:00:00	QQQ	ETF	41.08	41.13	41.05	41.1	91700.0
2002-01-09 18:00:00	QQQ	ETF	41.1	41.13	41.06	41.11	26400.0
2002-01-09 09:00:00	IWM	ETF	49.875	49.94	49.78	49.835	39800.0
2002-01-09 10:00:00	IWM	ETF	49.79	50.065	49.765	49.985	134200.0
2002-01-09 11:00:00	IWM	ETF	49.985	49.99	49.825	49.825	40000.0
2002-01-09 12:00:00	IWM	ETF	49.85	49.995	49.825	49.935	30000.0
2002-01-09 13:00:00	IWM	ETF	49.925	49.985	49.83	49.84	113400.0
2002-01-09 14:00:00	IWM	ETF	49.885	49.895	49.75	49.845	165400.0
2002-01-09 15:00:00	IWM	ETF	49.835	49.845	49.055	49.055	233000.0
2002-01-09 16:00:00	IWM	ETF	49.05	49.15	49.0	49.0	105000.0
2002-01-09 09:00:00	DIA	ETF	101.95	102.2	101.85	102.02	658600.0
2002-01-09 10:00:00	DIA	ETF	102.01	102.83	102.01	102.65	335100.0
2002-01-09 11:00:00	DIA	ETF	102.6	102.84	102.36	102.36	401300.0
2002-01-09 12:00:00	DIA	ETF	102.41	102.64	102.33	102.52	311600.0
2002-01-09 13:00:00	DIA	ETF	102.46	102.64	102.24	102.33	312600.0
2002-01-09 14:00:00	DIA	ETF	102.33	102.33	102.01	102.15	496200.0
2002-01-09 15:00:00	DIA	ETF	102.15	102.2	100.72	101.08	930300.0
2002-01-09 16:00:00	DIA	ETF	101.08	101.1	100.8	101.06	100100.0
2002-01-09 17:00:00	DIA	ETF	100.9	100.9	100.9	100.9	100.0

> showing 37 of 292 rows — these rows as CSV

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