PREVIEW / etf_1hour / 2001-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-04-16.parquet
  size:    11 KB
  rows:    213

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-04-16 09:00:00	SPY	ETF	118.29	118.82	118.19	118.62	1617700.0
2001-04-16 10:00:00	SPY	ETF	118.66	118.89	117.77	118.21	1079800.0
2001-04-16 11:00:00	SPY	ETF	118.28	118.47	117.77	118.22	517700.0
2001-04-16 12:00:00	SPY	ETF	118.24	118.41	117.82	117.96	446900.0
2001-04-16 13:00:00	SPY	ETF	117.92	118.69	117.92	118.69	473100.0
2001-04-16 14:00:00	SPY	ETF	118.55	118.77	117.56	117.64	700500.0
2001-04-16 15:00:00	SPY	ETF	117.64	118.25	116.91	118.23	1480200.0
2001-04-16 16:00:00	SPY	ETF	118.28	118.4	117.1	117.82	688500.0
2001-04-16 17:00:00	SPY	ETF	117.76	117.9	117.6	117.6	8300.0
2001-04-16 18:00:00	SPY	ETF	117.62	117.8	117.62	117.66	2400.0
2001-04-16 09:00:00	QQQ	ETF	41.94	42.15	41.3	41.69	8598200.0
2001-04-16 10:00:00	QQQ	ETF	41.67	41.75	41.05	41.59	9058400.0
2001-04-16 11:00:00	QQQ	ETF	41.65	41.97	41.32	41.9	6389900.0
2001-04-16 12:00:00	QQQ	ETF	41.88	42.25	41.6	41.72	6375500.0
2001-04-16 13:00:00	QQQ	ETF	41.78	42.4	41.66	42.38	5260100.0
2001-04-16 14:00:00	QQQ	ETF	42.4	42.43	41.2	41.25	7796900.0
2001-04-16 15:00:00	QQQ	ETF	41.25	41.3	40.63	41.12	13562500.0
2001-04-16 16:00:00	QQQ	ETF	41.1	42.35	39.5	40.1	5086400.0
2001-04-16 17:00:00	QQQ	ETF	40.1	40.4	40.09	40.3	285700.0
2001-04-16 18:00:00	QQQ	ETF	40.3	40.3	40.18	40.2	32800.0
2001-04-16 09:00:00	IWM	ETF	45.25	45.25	44.95	44.95	24800.0
2001-04-16 10:00:00	IWM	ETF	44.945	45.05	44.825	45.05	25400.0
2001-04-16 11:00:00	IWM	ETF	45.05	45.2	45.05	45.075	4600.0
2001-04-16 12:00:00	IWM	ETF	45.325	45.325	45.15	45.15	3200.0
2001-04-16 13:00:00	IWM	ETF	45.02	45.25	45.02	45.25	16600.0
2001-04-16 14:00:00	IWM	ETF	45.25	45.4	45.0	45.0	22200.0
2001-04-16 15:00:00	IWM	ETF	44.93	45.05	44.75	45.025	150600.0
2001-04-16 16:00:00	IWM	ETF	45.0	45.0	44.63	44.63	6400.0
2001-04-16 09:00:00	DIA	ETF	101.0	101.9	101.0	101.9	307400.0
2001-04-16 10:00:00	DIA	ETF	101.95	101.97	101.15	101.5	662900.0
2001-04-16 11:00:00	DIA	ETF	101.54	101.74	101.2	101.25	168200.0
2001-04-16 12:00:00	DIA	ETF	101.25	101.58	101.0	101.0	169200.0
2001-04-16 13:00:00	DIA	ETF	101.13	101.73	101.1	101.71	169500.0
2001-04-16 14:00:00	DIA	ETF	101.69	101.73	101.0	101.01	104900.0
2001-04-16 15:00:00	DIA	ETF	100.96	101.5	100.5	101.45	349200.0
2001-04-16 16:00:00	DIA	ETF	101.47	101.6	100.25	100.25	201300.0

> showing 36 of 213 rows — these rows as CSV

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