PREVIEW / etf_1hour / 2001-11-28

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-11-28.parquet
  size:    13 KB
  rows:    276

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-28 09:00:00	SPY	ETF	114.74	114.95	114.55	114.74	2169100.0
2001-11-28 10:00:00	SPY	ETF	114.75	115.17	114.25	114.32	3728300.0
2001-11-28 11:00:00	SPY	ETF	114.38	114.69	114.08	114.41	2735700.0
2001-11-28 12:00:00	SPY	ETF	114.37	114.68	114.16	114.16	1287900.0
2001-11-28 13:00:00	SPY	ETF	114.16	114.6	114.0	114.2	1632300.0
2001-11-28 14:00:00	SPY	ETF	114.23	114.23	113.65	113.85	2253400.0
2001-11-28 15:00:00	SPY	ETF	113.85	114.09	113.25	113.34	4718500.0
2001-11-28 16:00:00	SPY	ETF	113.35	113.37	113.0	113.34	1369800.0
2001-11-28 17:00:00	SPY	ETF	113.25	113.39	113.25	113.39	27500.0
2001-11-28 09:00:00	QQQ	ETF	39.73	39.93	39.58	39.75	12195500.0
2001-11-28 10:00:00	QQQ	ETF	39.73	40.37	39.44	39.55	20683200.0
2001-11-28 11:00:00	QQQ	ETF	39.56	40.0	39.56	39.75	9850000.0
2001-11-28 12:00:00	QQQ	ETF	39.77	40.0	39.5	39.55	7072800.0
2001-11-28 13:00:00	QQQ	ETF	39.55	39.68	39.24	39.31	13522200.0
2001-11-28 14:00:00	QQQ	ETF	39.3	39.35	38.89	38.98	18299800.0
2001-11-28 15:00:00	QQQ	ETF	38.92	39.22	38.74	38.75	14846200.0
2001-11-28 16:00:00	QQQ	ETF	38.76	39.07	38.61	38.65	2514000.0
2001-11-28 17:00:00	QQQ	ETF	38.66	38.75	38.6	38.72	798000.0
2001-11-28 18:00:00	QQQ	ETF	38.71	38.8	38.7	38.74	93400.0
2001-11-28 09:00:00	IWM	ETF	45.6	45.8	45.535	45.695	19800.0
2001-11-28 10:00:00	IWM	ETF	45.46	45.87	45.375	45.55	316400.0
2001-11-28 11:00:00	IWM	ETF	45.645	45.75	45.5	45.725	39600.0
2001-11-28 12:00:00	IWM	ETF	45.745	45.75	45.55	45.595	24800.0
2001-11-28 13:00:00	IWM	ETF	45.525	45.625	45.525	45.585	20800.0
2001-11-28 14:00:00	IWM	ETF	45.52	45.545	45.425	45.47	57200.0
2001-11-28 15:00:00	IWM	ETF	45.42	45.465	45.1	45.1	137200.0
2001-11-28 16:00:00	IWM	ETF	45.1	45.1	45.005	45.025	19800.0
2001-11-28 09:00:00	DIA	ETF	98.42	98.42	97.95	98.09	348000.0
2001-11-28 10:00:00	DIA	ETF	98.21	98.49	97.75	97.9	635900.0
2001-11-28 11:00:00	DIA	ETF	97.88	98.27	97.73	97.98	527200.0
2001-11-28 12:00:00	DIA	ETF	97.97	98.23	97.8	97.9	129400.0
2001-11-28 13:00:00	DIA	ETF	97.82	98.15	97.65	97.77	610400.0
2001-11-28 14:00:00	DIA	ETF	97.77	97.95	97.4	97.65	270700.0
2001-11-28 15:00:00	DIA	ETF	97.65	97.88	97.16	97.21	539800.0
2001-11-28 16:00:00	DIA	ETF	97.21	97.34	97.12	97.3	138500.0
2001-11-28 17:00:00	DIA	ETF	97.27	97.27	97.27	97.27	200.0
2001-11-28 18:00:00	DIA	ETF	97.33	97.33	97.33	97.33	200.0

> showing 37 of 276 rows — these rows as CSV

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