PREVIEW / etf_1hour / 2001-03-19

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-03-19.parquet
  size:    11 KB
  rows:    220

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-19 09:00:00	SPY	ETF	115.76	116.06	115.4	115.62	1773500.0
2001-03-19 10:00:00	SPY	ETF	115.5	116.13	115.36	115.58	1217600.0
2001-03-19 11:00:00	SPY	ETF	115.6	115.76	115.01	115.01	301100.0
2001-03-19 12:00:00	SPY	ETF	115.01	115.54	114.82	115.35	795300.0
2001-03-19 13:00:00	SPY	ETF	115.37	115.87	115.34	115.79	723300.0
2001-03-19 14:00:00	SPY	ETF	115.77	117.21	115.6	117.16	1998900.0
2001-03-19 15:00:00	SPY	ETF	117.21	117.69	116.95	117.3	2400900.0
2001-03-19 16:00:00	SPY	ETF	117.3	117.67	115.55	117.55	525600.0
2001-03-19 17:00:00	SPY	ETF	117.35	117.35	117.35	117.35	2100.0
2001-03-19 09:00:00	QQQ	ETF	41.44	41.76	40.94	41.29	7087000.0
2001-03-19 10:00:00	QQQ	ETF	41.3	41.79	41.02	41.32	6469000.0
2001-03-19 11:00:00	QQQ	ETF	41.35	41.49	40.76	40.81	4876300.0
2001-03-19 12:00:00	QQQ	ETF	40.81	41.25	40.75	41.14	3480200.0
2001-03-19 13:00:00	QQQ	ETF	41.12	41.49	41.01	41.36	3636100.0
2001-03-19 14:00:00	QQQ	ETF	41.4	42.86	41.28	42.8	10618400.0
2001-03-19 15:00:00	QQQ	ETF	42.77	43.25	42.5	43.19	12611300.0
2001-03-19 16:00:00	QQQ	ETF	43.2	43.3	43.04	43.15	1668000.0
2001-03-19 17:00:00	QQQ	ETF	43.15	43.31	43.15	43.29	177000.0
2001-03-19 18:00:00	QQQ	ETF	43.26	43.33	43.22	43.3	16000.0
2001-03-19 09:00:00	IWM	ETF	44.5	44.5	44.025	44.05	11000.0
2001-03-19 10:00:00	IWM	ETF	44.1	44.15	43.925	43.925	16600.0
2001-03-19 11:00:00	IWM	ETF	44.12	44.12	43.975	43.975	12000.0
2001-03-19 12:00:00	IWM	ETF	43.875	44.15	43.755	44.15	64800.0
2001-03-19 13:00:00	IWM	ETF	44.0	44.1	44.0	44.1	20800.0
2001-03-19 14:00:00	IWM	ETF	44.0	44.475	43.975	44.46	55200.0
2001-03-19 15:00:00	IWM	ETF	44.5	45.05	44.45	45.05	551200.0
2001-03-19 16:00:00	IWM	ETF	44.95	45.2	44.89	45.15	52000.0
2001-03-19 09:00:00	DIA	ETF	98.91	99.06	98.45	98.64	640800.0
2001-03-19 10:00:00	DIA	ETF	98.75	99.1	98.55	98.75	925300.0
2001-03-19 11:00:00	DIA	ETF	98.82	98.97	98.1	98.12	327000.0
2001-03-19 12:00:00	DIA	ETF	98.12	98.48	97.91	98.35	235700.0
2001-03-19 13:00:00	DIA	ETF	98.36	98.92	98.27	98.89	258000.0
2001-03-19 14:00:00	DIA	ETF	98.83	99.94	98.73	99.89	1024200.0
2001-03-19 15:00:00	DIA	ETF	99.91	100.0	99.6	99.71	506800.0
2001-03-19 16:00:00	DIA	ETF	99.67	99.83	99.55	99.77	84300.0

> showing 35 of 220 rows — these rows as CSV

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