PREVIEW / etf_1hour / 2001-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-03-16.parquet
  size:    11 KB
  rows:    214

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-03-16 09:00:00	SPY	ETF	117.13	117.4	116.18	116.7	2151900.0
2001-03-16 10:00:00	SPY	ETF	116.82	117.2	115.06	115.56	2289100.0
2001-03-16 11:00:00	SPY	ETF	115.56	116.89	115.54	116.5	2633400.0
2001-03-16 12:00:00	SPY	ETF	116.55	117.0	116.25	116.38	1669200.0
2001-03-16 13:00:00	SPY	ETF	116.38	116.4	115.64	116.32	1100500.0
2001-03-16 14:00:00	SPY	ETF	116.36	116.44	115.2	115.34	1344900.0
2001-03-16 15:00:00	SPY	ETF	115.25	115.75	114.81	115.31	2718400.0
2001-03-16 16:00:00	SPY	ETF	115.31	115.9	115.0	115.24	926700.0
2001-03-16 17:00:00	SPY	ETF	115.24	115.24	115.24	115.24	21650000.0
2001-03-16 18:00:00	SPY	ETF	115.5	115.5	115.5	115.5	300.0
2001-03-16 09:00:00	QQQ	ETF	41.88	42.8	41.37	41.55	12887500.0
2001-03-16 10:00:00	QQQ	ETF	41.48	41.84	40.56	40.9	14622900.0
2001-03-16 11:00:00	QQQ	ETF	40.92	42.3	40.82	41.9	13041300.0
2001-03-16 12:00:00	QQQ	ETF	41.93	42.15	41.43	41.44	7051900.0
2001-03-16 13:00:00	QQQ	ETF	41.48	41.59	41.0	41.55	7812900.0
2001-03-16 14:00:00	QQQ	ETF	41.53	41.65	40.71	40.81	5643200.0
2001-03-16 15:00:00	QQQ	ETF	40.76	41.45	40.7	41.1	9540700.0
2001-03-16 16:00:00	QQQ	ETF	41.01	43.5	41.0	41.2	2202400.0
2001-03-16 17:00:00	QQQ	ETF	41.2	41.23	41.12	41.2	21900.0
2001-03-16 18:00:00	QQQ	ETF	41.2	41.39	41.19	41.23	24200.0
2001-03-16 09:00:00	IWM	ETF	44.925	45.175	44.8	44.9	50200.0
2001-03-16 10:00:00	IWM	ETF	45.0	45.0	44.2	44.2	25200.0
2001-03-16 11:00:00	IWM	ETF	44.3	44.6	44.125	44.3	29200.0
2001-03-16 12:00:00	IWM	ETF	44.975	45.0	44.25	44.55	21000.0
2001-03-16 13:00:00	IWM	ETF	44.545	44.545	44.13	44.135	4000.0
2001-03-16 14:00:00	IWM	ETF	44.25	44.425	44.125	44.125	49000.0
2001-03-16 15:00:00	IWM	ETF	44.15	44.15	43.825	44.0	48800.0
2001-03-16 09:00:00	DIA	ETF	99.65	100.61	99.26	99.69	517600.0
2001-03-16 10:00:00	DIA	ETF	99.63	100.06	98.35	98.89	774800.0
2001-03-16 11:00:00	DIA	ETF	98.95	99.89	98.83	99.63	455700.0
2001-03-16 12:00:00	DIA	ETF	99.62	100.15	99.4	99.76	400200.0
2001-03-16 13:00:00	DIA	ETF	99.63	99.64	99.01	99.49	395600.0
2001-03-16 14:00:00	DIA	ETF	99.5	99.58	98.51	98.52	302200.0
2001-03-16 15:00:00	DIA	ETF	98.55	98.9	98.15	98.39	992300.0
2001-03-16 16:00:00	DIA	ETF	98.25	98.4	98.2	98.27	121900.0
2001-03-16 18:00:00	DIA	ETF	98.2	98.2	98.2	98.2	200.0

> showing 36 of 214 rows — these rows as CSV

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