PREVIEW / etf_1hour / 2001-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-03-01.parquet
  size:    11 KB
  rows:    215

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-01 09:00:00	SPY	ETF	124.05	124.1	122.66	123.12	1554100.0
2001-03-01 10:00:00	SPY	ETF	123.05	123.95	122.5	122.5	2014800.0
2001-03-01 11:00:00	SPY	ETF	122.49	123.46	122.45	123.06	954400.0
2001-03-01 12:00:00	SPY	ETF	123.02	123.1	122.3	122.41	922200.0
2001-03-01 13:00:00	SPY	ETF	122.45	122.82	122.03	122.41	1332200.0
2001-03-01 14:00:00	SPY	ETF	122.41	123.1	121.75	122.99	2431400.0
2001-03-01 15:00:00	SPY	ETF	122.99	124.5	122.67	124.4	3992900.0
2001-03-01 16:00:00	SPY	ETF	124.45	124.75	123.14	124.57	816900.0
2001-03-01 17:00:00	SPY	ETF	124.57	124.6	124.57	124.6	200.0
2001-03-01 09:00:00	QQQ	ETF	46.97	47.41	46.25	46.75	9224200.0
2001-03-01 10:00:00	QQQ	ETF	46.75	47.55	46.49	46.55	12514900.0
2001-03-01 11:00:00	QQQ	ETF	46.5	47.47	46.4	47.18	8499600.0
2001-03-01 12:00:00	QQQ	ETF	47.16	47.24	46.45	46.51	5553400.0
2001-03-01 13:00:00	QQQ	ETF	46.5	46.75	46.0	46.27	8443500.0
2001-03-01 14:00:00	QQQ	ETF	46.34	47.0	45.75	46.9	12591200.0
2001-03-01 15:00:00	QQQ	ETF	46.85	49.2	46.7	48.93	33874000.0
2001-03-01 16:00:00	QQQ	ETF	49.1	49.1	48.0	48.03	2446000.0
2001-03-01 17:00:00	QQQ	ETF	48.19	48.38	46.35	47.8	556400.0
2001-03-01 18:00:00	QQQ	ETF	47.85	47.9	47.6	47.84	75900.0
2001-03-01 09:00:00	IWM	ETF	47.025	47.07	46.655	46.7	38400.0
2001-03-01 10:00:00	IWM	ETF	46.775	46.95	46.425	46.425	22800.0
2001-03-01 11:00:00	IWM	ETF	46.5	46.825	46.415	46.825	24200.0
2001-03-01 12:00:00	IWM	ETF	46.7	46.7	46.4	46.625	227400.0
2001-03-01 13:00:00	IWM	ETF	46.515	46.7	46.355	46.595	23800.0
2001-03-01 14:00:00	IWM	ETF	46.52	46.69	46.35	46.65	19000.0
2001-03-01 15:00:00	IWM	ETF	46.65	47.4	46.65	47.4	177200.0
2001-03-01 09:00:00	DIA	ETF	104.45	104.68	103.83	104.2	230300.0
2001-03-01 10:00:00	DIA	ETF	104.2	104.74	103.57	103.7	560900.0
2001-03-01 11:00:00	DIA	ETF	103.7	104.25	103.4	103.9	167000.0
2001-03-01 12:00:00	DIA	ETF	103.85	103.85	103.32	103.59	202300.0
2001-03-01 13:00:00	DIA	ETF	103.52	103.78	103.3	103.7	48100.0
2001-03-01 14:00:00	DIA	ETF	103.5	104.05	103.11	104.0	237900.0
2001-03-01 15:00:00	DIA	ETF	104.05	105.1	103.85	104.71	976800.0
2001-03-01 16:00:00	DIA	ETF	104.81	104.81	104.58	104.68	21300.0

> showing 34 of 215 rows — these rows as CSV

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