PREVIEW / etf_1hour / 2001-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-11-19.parquet
  size:    13 KB
  rows:    281

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-11-19 09:00:00	SPY	ETF	114.92	115.43	114.64	115.35	2023400.0
2001-11-19 10:00:00	SPY	ETF	115.34	115.57	115.04	115.29	2593000.0
2001-11-19 11:00:00	SPY	ETF	115.25	115.48	114.67	114.79	2126200.0
2001-11-19 12:00:00	SPY	ETF	114.76	114.97	114.6	114.87	890100.0
2001-11-19 13:00:00	SPY	ETF	114.81	114.84	114.45	114.72	1100600.0
2001-11-19 14:00:00	SPY	ETF	114.7	115.1	114.67	115.0	1818200.0
2001-11-19 15:00:00	SPY	ETF	115.01	115.57	114.95	115.53	1865100.0
2001-11-19 16:00:00	SPY	ETF	115.56	116.75	115.11	115.86	1193200.0
2001-11-19 17:00:00	SPY	ETF	115.78	115.95	115.75	115.9	53200.0
2001-11-19 18:00:00	SPY	ETF	115.9	116.0	115.6	116.0	5300.0
2001-11-19 09:00:00	QQQ	ETF	39.79	40.12	39.65	40.11	9532800.0
2001-11-19 10:00:00	QQQ	ETF	40.1	40.28	39.86	40.07	17400400.0
2001-11-19 11:00:00	QQQ	ETF	40.04	40.17	39.7	39.8	8747500.0
2001-11-19 12:00:00	QQQ	ETF	39.79	39.93	39.62	39.83	4943100.0
2001-11-19 13:00:00	QQQ	ETF	39.82	39.83	39.49	39.68	7085700.0
2001-11-19 14:00:00	QQQ	ETF	39.72	39.88	39.57	39.8	7157800.0
2001-11-19 15:00:00	QQQ	ETF	39.8	40.34	39.79	40.32	10337700.0
2001-11-19 16:00:00	QQQ	ETF	40.28	40.57	40.24	40.52	3371100.0
2001-11-19 17:00:00	QQQ	ETF	40.51	40.61	40.47	40.59	199000.0
2001-11-19 18:00:00	QQQ	ETF	40.61	40.65	40.52	40.61	32000.0
2001-11-19 09:00:00	IWM	ETF	45.075	45.275	45.005	45.275	35000.0
2001-11-19 10:00:00	IWM	ETF	45.29	45.375	45.2	45.2	53400.0
2001-11-19 11:00:00	IWM	ETF	45.25	45.32	45.175	45.225	24000.0
2001-11-19 12:00:00	IWM	ETF	45.25	45.275	45.12	45.13	23000.0
2001-11-19 13:00:00	IWM	ETF	45.25	45.275	45.06	45.185	32400.0
2001-11-19 14:00:00	IWM	ETF	45.205	45.275	45.05	45.18	88200.0
2001-11-19 15:00:00	IWM	ETF	45.275	45.55	45.16	45.55	43000.0
2001-11-19 16:00:00	IWM	ETF	45.625	45.69	45.5	45.5	4800.0
2001-11-19 09:00:00	DIA	ETF	99.45	99.62	99.05	99.62	639400.0
2001-11-19 10:00:00	DIA	ETF	99.58	99.82	99.46	99.62	573500.0
2001-11-19 11:00:00	DIA	ETF	99.71	99.88	99.21	99.35	186000.0
2001-11-19 12:00:00	DIA	ETF	99.35	99.43	99.13	99.3	183700.0
2001-11-19 13:00:00	DIA	ETF	99.32	99.32	98.9	99.17	363000.0
2001-11-19 14:00:00	DIA	ETF	99.19	99.5	99.09	99.38	348900.0
2001-11-19 15:00:00	DIA	ETF	99.39	99.85	99.39	99.85	366500.0
2001-11-19 16:00:00	DIA	ETF	99.8	100.14	99.8	99.99	129300.0
2001-11-19 17:00:00	DIA	ETF	100.1	100.99	100.05	100.19	2500.0

> showing 37 of 281 rows — these rows as CSV

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