PREVIEW / etf_1hour / 2001-12-10

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-12-10.parquet
  size:    13 KB
  rows:    279

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-12-10 09:00:00	SPY	ETF	115.85	116.11	115.72	115.9	1849900.0
2001-12-10 10:00:00	SPY	ETF	115.88	116.39	115.68	115.78	2770500.0
2001-12-10 11:00:00	SPY	ETF	115.79	115.91	115.37	115.48	1782700.0
2001-12-10 12:00:00	SPY	ETF	115.48	115.54	115.09	115.24	1516000.0
2001-12-10 13:00:00	SPY	ETF	115.24	115.27	114.88	115.0	1207500.0
2001-12-10 14:00:00	SPY	ETF	114.95	115.29	114.81	115.02	1305500.0
2001-12-10 15:00:00	SPY	ETF	115.0	115.09	114.46	114.46	2572200.0
2001-12-10 16:00:00	SPY	ETF	114.46	114.57	114.2	114.43	766400.0
2001-12-10 17:00:00	SPY	ETF	114.38	114.4	114.32	114.36	2000.0
2001-12-10 09:00:00	QQQ	ETF	41.32	41.75	41.26	41.6	7452100.0
2001-12-10 10:00:00	QQQ	ETF	41.59	42.23	41.56	41.85	15509100.0
2001-12-10 11:00:00	QQQ	ETF	41.85	41.93	41.43	41.48	9956900.0
2001-12-10 12:00:00	QQQ	ETF	41.49	41.64	41.31	41.5	5134800.0
2001-12-10 13:00:00	QQQ	ETF	41.51	41.52	41.16	41.32	7397100.0
2001-12-10 14:00:00	QQQ	ETF	41.32	41.53	41.16	41.3	7811500.0
2001-12-10 15:00:00	QQQ	ETF	41.3	41.39	40.88	40.97	13307300.0
2001-12-10 16:00:00	QQQ	ETF	40.99	41.05	40.93	40.98	1613900.0
2001-12-10 17:00:00	QQQ	ETF	40.98	41.0	40.9	40.98	38700.0
2001-12-10 18:00:00	QQQ	ETF	40.98	41.0	40.92	41.0	4200.0
2001-12-10 09:00:00	IWM	ETF	47.875	47.9	47.63	47.8	44400.0
2001-12-10 10:00:00	IWM	ETF	47.65	48.09	47.65	47.85	56000.0
2001-12-10 11:00:00	IWM	ETF	47.85	47.85	47.585	47.585	27000.0
2001-12-10 12:00:00	IWM	ETF	47.7	47.7	47.455	47.535	38400.0
2001-12-10 13:00:00	IWM	ETF	47.56	47.59	47.35	47.46	50600.0
2001-12-10 14:00:00	IWM	ETF	47.41	47.6	47.375	47.395	87800.0
2001-12-10 15:00:00	IWM	ETF	47.545	47.545	47.0	47.18	69400.0
2001-12-10 16:00:00	IWM	ETF	47.25	47.25	46.98	46.98	296200.0
2001-12-10 09:00:00	DIA	ETF	100.35	100.6	100.22	100.53	421100.0
2001-12-10 10:00:00	DIA	ETF	100.46	101.0	100.41	100.52	878300.0
2001-12-10 11:00:00	DIA	ETF	100.55	100.65	100.25	100.3	158300.0
2001-12-10 12:00:00	DIA	ETF	100.25	100.38	99.89	100.05	213600.0
2001-12-10 13:00:00	DIA	ETF	100.01	100.01	99.78	99.91	113100.0
2001-12-10 14:00:00	DIA	ETF	99.84	100.13	99.76	99.96	162600.0
2001-12-10 15:00:00	DIA	ETF	99.97	100.0	99.45	99.49	348100.0
2001-12-10 16:00:00	DIA	ETF	99.48	99.5	99.34	99.4	27100.0
2001-12-10 17:00:00	DIA	ETF	98.5	98.5	98.5	98.5	100.0
2001-12-10 18:00:00	DIA	ETF	99.1	99.1	99.1	99.1	100.0

> showing 37 of 279 rows — these rows as CSV

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