PREVIEW / etf_30min / 2001-08-23

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-08-23.parquet
  size:    14 KB
  rows:    346

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-08-23 09:30:00	SPY	ETF	116.96	117.32	116.72	117.19	1210900.0
2001-08-23 10:00:00	SPY	ETF	117.2	117.52	117.11	117.27	1053100.0
2001-08-23 10:30:00	SPY	ETF	117.27	117.38	116.98	117.17	452900.0
2001-08-23 11:00:00	SPY	ETF	117.18	117.26	116.98	117.24	647600.0
2001-08-23 11:30:00	SPY	ETF	117.22	117.22	116.85	117.03	465100.0
2001-08-23 12:00:00	SPY	ETF	117.04	117.14	116.94	117.07	383500.0
2001-08-23 12:30:00	SPY	ETF	117.07	117.48	117.06	117.3	352800.0
2001-08-23 13:00:00	SPY	ETF	117.27	117.44	117.02	117.1	207100.0
2001-08-23 13:30:00	SPY	ETF	117.14	117.29	117.01	117.12	269900.0
2001-08-23 14:00:00	SPY	ETF	117.11	117.26	116.52	116.63	642200.0
2001-08-23 14:30:00	SPY	ETF	116.6	116.85	116.58	116.82	637200.0
2001-08-23 15:00:00	SPY	ETF	116.84	117.11	116.71	117.08	449000.0
2001-08-23 15:30:00	SPY	ETF	117.1	117.1	116.7	116.7	762800.0
2001-08-23 16:00:00	SPY	ETF	116.7	116.7	116.44	116.7	722000.0
2001-08-23 16:30:00	SPY	ETF	116.46	117.24	116.46	116.9	9200.0
2001-08-23 17:00:00	SPY	ETF	116.85	117.0	116.85	116.85	27100.0
2001-08-23 17:30:00	SPY	ETF	116.93	116.93	116.93	116.93	700.0
2001-08-23 18:00:00	SPY	ETF	117.0	117.1	117.0	117.1	5500.0
2001-08-23 09:30:00	QQQ	ETF	37.67	38.3	37.55	38.22	8589500.0
2001-08-23 10:00:00	QQQ	ETF	38.2	38.46	38.1	38.32	7639000.0
2001-08-23 10:30:00	QQQ	ETF	38.3	38.38	38.04	38.08	3125900.0
2001-08-23 11:00:00	QQQ	ETF	38.07	38.23	37.96	38.17	2797000.0
2001-08-23 11:30:00	QQQ	ETF	38.15	38.2	37.83	37.96	2710000.0
2001-08-23 12:00:00	QQQ	ETF	37.97	38.07	37.88	37.99	1594800.0
2001-08-23 12:30:00	QQQ	ETF	37.98	38.22	37.93	38.06	2287500.0
2001-08-23 13:00:00	QQQ	ETF	38.05	38.12	37.85	37.89	2069100.0
2001-08-23 13:30:00	QQQ	ETF	37.9	38.0	37.73	37.85	2048000.0
2001-08-23 14:00:00	QQQ	ETF	37.8	37.95	37.35	37.41	4567000.0
2001-08-23 14:30:00	QQQ	ETF	37.45	37.66	37.35	37.66	3682600.0
2001-08-23 15:00:00	QQQ	ETF	37.66	37.85	37.5	37.85	3360400.0
2001-08-23 15:30:00	QQQ	ETF	37.84	37.85	37.31	37.32	4061400.0
2001-08-23 16:00:00	QQQ	ETF	37.32	37.4	37.29	37.34	1019500.0
2001-08-23 16:30:00	QQQ	ETF	37.31	38.32	37.3	37.74	1183000.0
2001-08-23 17:00:00	QQQ	ETF	37.75	37.84	37.34	37.79	206900.0
2001-08-23 17:30:00	QQQ	ETF	37.78	38.0	37.75	37.95	116800.0
2001-08-23 18:00:00	QQQ	ETF	37.95	38.15	37.95	38.04	239100.0
2001-08-23 09:30:00	IWM	ETF	47.6	47.845	47.6	47.845	25800.0
2001-08-23 10:00:00	IWM	ETF	47.935	47.995	47.825	47.95	51800.0
2001-08-23 10:30:00	IWM	ETF	47.935	47.935	47.805	47.9	166600.0
2001-08-23 11:00:00	IWM	ETF	47.725	47.77	47.625	47.77	31200.0
2001-08-23 11:30:00	IWM	ETF	47.75	47.77	47.6	47.6	43800.0
2001-08-23 12:00:00	IWM	ETF	47.7	47.7	47.695	47.695	2400.0
2001-08-23 12:30:00	IWM	ETF	47.675	47.75	47.675	47.75	13400.0
2001-08-23 13:00:00	IWM	ETF	47.8	47.8	47.6	47.6	44400.0
2001-08-23 13:30:00	IWM	ETF	47.6	47.64	47.6	47.64	2400.0
2001-08-23 14:00:00	IWM	ETF	47.645	47.645	47.44	47.45	11200.0
2001-08-23 14:30:00	IWM	ETF	47.44	47.525	47.4	47.4	17600.0
2001-08-23 15:00:00	IWM	ETF	47.525	47.55	47.475	47.55	2200.0
2001-08-23 15:30:00	IWM	ETF	47.45	47.45	47.205	47.205	362400.0
2001-08-23 16:00:00	IWM	ETF	47.155	47.155	47.05	47.05	64800.0

> showing 50 of 346 rows — these rows as CSV

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