PREVIEW / etf_30min / 2001-06-05

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-06-05.parquet
  size:    15 KB
  rows:    384

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-06-05 09:30:00	SPY	ETF	127.49	127.96	127.27	127.8	1468500.0
2001-06-05 10:00:00	SPY	ETF	127.77	128.14	127.51	127.77	980600.0
2001-06-05 10:30:00	SPY	ETF	127.78	128.16	127.77	127.89	442500.0
2001-06-05 11:00:00	SPY	ETF	127.84	128.0	127.7	127.89	341800.0
2001-06-05 11:30:00	SPY	ETF	127.9	128.56	127.9	128.48	675800.0
2001-06-05 12:00:00	SPY	ETF	128.44	128.5	128.17	128.47	253900.0
2001-06-05 12:30:00	SPY	ETF	128.46	128.6	128.36	128.49	212600.0
2001-06-05 13:00:00	SPY	ETF	128.45	128.56	128.22	128.33	491000.0
2001-06-05 13:30:00	SPY	ETF	128.3	128.42	128.12	128.32	416000.0
2001-06-05 14:00:00	SPY	ETF	128.36	128.65	128.2	128.47	539900.0
2001-06-05 14:30:00	SPY	ETF	128.45	128.76	128.43	128.7	262200.0
2001-06-05 15:00:00	SPY	ETF	128.75	129.13	128.61	129.02	522000.0
2001-06-05 15:30:00	SPY	ETF	129.02	129.23	128.82	128.87	1014600.0
2001-06-05 16:00:00	SPY	ETF	128.85	129.0	128.6	128.92	645100.0
2001-06-05 16:30:00	SPY	ETF	128.87	128.87	128.8	128.8	498100.0
2001-06-05 17:00:00	SPY	ETF	128.87	128.88	128.87	128.88	700.0
2001-06-05 18:00:00	SPY	ETF	128.83	128.83	128.7	128.7	500.0
2001-06-05 09:30:00	QQQ	ETF	46.3	47.14	46.2	47.0	14419800.0
2001-06-05 10:00:00	QQQ	ETF	47.01	47.48	46.95	47.36	8529900.0
2001-06-05 10:30:00	QQQ	ETF	47.39	47.68	47.33	47.35	7231600.0
2001-06-05 11:00:00	QQQ	ETF	47.33	47.52	47.18	47.39	3309300.0
2001-06-05 11:30:00	QQQ	ETF	47.45	47.85	47.4	47.66	3597400.0
2001-06-05 12:00:00	QQQ	ETF	47.67	47.81	47.56	47.81	1831100.0
2001-06-05 12:30:00	QQQ	ETF	47.82	47.94	47.72	47.76	2063800.0
2001-06-05 13:00:00	QQQ	ETF	47.77	47.94	47.67	47.72	1531000.0
2001-06-05 13:30:00	QQQ	ETF	47.69	47.9	47.62	47.89	2033700.0
2001-06-05 14:00:00	QQQ	ETF	47.85	48.06	47.72	47.96	3992000.0
2001-06-05 14:30:00	QQQ	ETF	47.94	48.15	47.9	48.15	3805800.0
2001-06-05 15:00:00	QQQ	ETF	48.15	48.35	48.0	48.25	4138100.0
2001-06-05 15:30:00	QQQ	ETF	48.29	48.36	47.86	47.96	6446400.0
2001-06-05 16:00:00	QQQ	ETF	47.95	48.0	47.4	47.95	1408500.0
2001-06-05 16:30:00	QQQ	ETF	47.93	48.0	47.81	47.88	1574700.0
2001-06-05 17:00:00	QQQ	ETF	47.97	48.04	47.97	48.0	29200.0
2001-06-05 17:30:00	QQQ	ETF	48.04	48.05	47.9	47.95	11000.0
2001-06-05 18:00:00	QQQ	ETF	48.02	48.05	47.96	48.05	6800.0
2001-06-05 09:30:00	IWM	ETF	50.8	50.995	50.725	50.925	27200.0
2001-06-05 10:00:00	IWM	ETF	50.975	51.0	50.9	50.995	46400.0
2001-06-05 10:30:00	IWM	ETF	51.0	51.125	50.975	51.12	27800.0
2001-06-05 11:00:00	IWM	ETF	51.12	51.12	51.045	51.045	18800.0
2001-06-05 11:30:00	IWM	ETF	51.165	51.36	51.165	51.36	168800.0
2001-06-05 12:00:00	IWM	ETF	51.33	51.35	51.25	51.3	289200.0
2001-06-05 12:30:00	IWM	ETF	51.275	51.42	51.275	51.385	229200.0
2001-06-05 13:00:00	IWM	ETF	51.325	51.47	51.325	51.375	201400.0
2001-06-05 13:30:00	IWM	ETF	51.37	51.47	51.325	51.47	4600.0
2001-06-05 14:00:00	IWM	ETF	51.47	51.475	51.38	51.475	2400.0
2001-06-05 14:30:00	IWM	ETF	51.495	51.495	51.42	51.495	8200.0
2001-06-05 15:00:00	IWM	ETF	51.5	51.7	51.5	51.55	9400.0
2001-06-05 15:30:00	IWM	ETF	51.665	51.725	51.45	51.495	82200.0
2001-06-05 16:00:00	IWM	ETF	51.55	51.675	51.5	51.5	3400.0
2001-06-05 09:30:00	DIA	ETF	110.7	111.0	110.53	110.81	179600.0

> showing 50 of 384 rows — these rows as CSV

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