PREVIEW / etf_1hour / 2001-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-09-27.parquet
  size:    12 KB
  rows:    245

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-09-27 09:00:00	SPY	ETF	101.25	101.45	100.43	100.7	2294200.0
2001-09-27 10:00:00	SPY	ETF	100.66	100.9	100.02	100.55	3702600.0
2001-09-27 11:00:00	SPY	ETF	100.52	100.8	100.25	100.36	2542100.0
2001-09-27 12:00:00	SPY	ETF	100.33	100.47	100.0	100.37	1107100.0
2001-09-27 13:00:00	SPY	ETF	100.36	100.58	100.18	100.46	1002400.0
2001-09-27 14:00:00	SPY	ETF	100.48	101.69	100.44	101.5	3287900.0
2001-09-27 15:00:00	SPY	ETF	101.46	102.25	101.3	102.05	4057800.0
2001-09-27 16:00:00	SPY	ETF	102.05	102.3	101.25	102.3	1079300.0
2001-09-27 17:00:00	SPY	ETF	102.06	102.3	102.0	102.3	14900.0
2001-09-27 09:00:00	QQQ	ETF	28.4	28.59	27.9	28.01	7163000.0
2001-09-27 10:00:00	QQQ	ETF	28.01	28.15	27.42	27.7	12288700.0
2001-09-27 11:00:00	QQQ	ETF	27.72	27.85	27.54	27.67	5969600.0
2001-09-27 12:00:00	QQQ	ETF	27.69	27.7	27.42	27.56	4919400.0
2001-09-27 13:00:00	QQQ	ETF	27.57	27.68	27.47	27.62	2443400.0
2001-09-27 14:00:00	QQQ	ETF	27.63	28.44	27.6	28.38	14038200.0
2001-09-27 15:00:00	QQQ	ETF	28.36	28.79	28.25	28.51	16284800.0
2001-09-27 16:00:00	QQQ	ETF	28.55	28.6	27.84	28.5	3728300.0
2001-09-27 17:00:00	QQQ	ETF	28.45	28.65	28.45	28.58	41000.0
2001-09-27 18:00:00	QQQ	ETF	28.58	28.7	28.56	28.65	15200.0
2001-09-27 09:00:00	IWM	ETF	38.89	39.0	38.575	38.6	58400.0
2001-09-27 10:00:00	IWM	ETF	38.6	38.6	38.33	38.47	137800.0
2001-09-27 11:00:00	IWM	ETF	38.52	38.55	38.375	38.41	24800.0
2001-09-27 12:00:00	IWM	ETF	38.415	38.54	38.345	38.4	209000.0
2001-09-27 13:00:00	IWM	ETF	38.47	38.47	38.315	38.315	384800.0
2001-09-27 14:00:00	IWM	ETF	38.495	38.82	38.495	38.775	187000.0
2001-09-27 15:00:00	IWM	ETF	38.7	39.35	38.7	39.21	453200.0
2001-09-27 16:00:00	IWM	ETF	39.15	39.525	39.15	39.515	388000.0
2001-09-27 09:00:00	DIA	ETF	86.0	86.23	85.41	85.6	597400.0
2001-09-27 10:00:00	DIA	ETF	85.6	85.78	84.85	85.27	607000.0
2001-09-27 11:00:00	DIA	ETF	85.29	85.5	85.08	85.11	278400.0
2001-09-27 12:00:00	DIA	ETF	85.1	85.22	84.8	85.14	307400.0
2001-09-27 13:00:00	DIA	ETF	85.18	85.33	85.01	85.27	213000.0
2001-09-27 14:00:00	DIA	ETF	85.25	86.45	85.25	86.35	1332700.0
2001-09-27 15:00:00	DIA	ETF	86.35	86.99	86.06	86.75	970800.0
2001-09-27 16:00:00	DIA	ETF	86.82	87.0	86.74	86.9	92600.0
2001-09-27 17:00:00	DIA	ETF	86.95	86.96	86.95	86.96	500.0

> showing 36 of 245 rows — these rows as CSV

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