PREVIEW / etf_30min / 2002-06-19

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-06-19.parquet
  size:    19 KB
  rows:    507

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
2002-06-19 09:30:00	SPY	ETF	103.5	103.83	103.18	103.54	3008400.0
2002-06-19 10:00:00	SPY	ETF	103.54	103.64	103.24	103.53	1578300.0
2002-06-19 10:30:00	SPY	ETF	103.57	103.72	103.23	103.5	1400100.0
2002-06-19 11:00:00	SPY	ETF	103.5	104.33	103.4	104.3	1697500.0
2002-06-19 11:30:00	SPY	ETF	104.3	104.43	104.11	104.2	1127100.0
2002-06-19 12:00:00	SPY	ETF	104.18	104.24	103.71	103.71	1253600.0
2002-06-19 12:30:00	SPY	ETF	103.72	103.8	103.34	103.48	1349000.0
2002-06-19 13:00:00	SPY	ETF	103.5	103.67	103.36	103.48	634400.0
2002-06-19 13:30:00	SPY	ETF	103.54	103.68	103.4	103.55	454300.0
2002-06-19 14:00:00	SPY	ETF	103.56	103.62	103.0	103.02	1459500.0
2002-06-19 14:30:00	SPY	ETF	103.05	103.14	102.64	102.83	1376000.0
2002-06-19 15:00:00	SPY	ETF	102.78	102.99	102.47	102.52	1170900.0
2002-06-19 15:30:00	SPY	ETF	102.53	102.88	102.26	102.54	2510200.0
2002-06-19 16:00:00	SPY	ETF	102.5	103.29	102.24	102.57	2360400.0
2002-06-19 16:30:00	SPY	ETF	102.57	102.57	102.47	102.5	2100.0
2002-06-19 17:00:00	SPY	ETF	102.54	102.67	102.54	102.55	4700.0
2002-06-19 17:30:00	SPY	ETF	102.51	102.51	102.51	102.51	200.0
2002-06-19 18:00:00	SPY	ETF	102.5	102.57	102.47	102.57	9500.0
2002-06-19 09:30:00	QQQ	ETF	28.1	28.2	27.85	27.95	16241300.0
2002-06-19 10:00:00	QQQ	ETF	27.95	28.05	27.78	27.98	9034600.0
2002-06-19 10:30:00	QQQ	ETF	28.0	28.11	27.91	28.02	6419600.0
2002-06-19 11:00:00	QQQ	ETF	28.04	28.22	27.97	28.18	4791900.0
2002-06-19 11:30:00	QQQ	ETF	28.18	28.23	28.06	28.13	3763500.0
2002-06-19 12:00:00	QQQ	ETF	28.13	28.13	27.88	27.9	5014300.0
2002-06-19 12:30:00	QQQ	ETF	27.9	27.99	27.81	27.89	4369200.0
2002-06-19 13:00:00	QQQ	ETF	27.89	27.98	27.83	27.88	2938200.0
2002-06-19 13:30:00	QQQ	ETF	27.9	27.95	27.79	27.84	2089500.0
2002-06-19 14:00:00	QQQ	ETF	27.84	27.88	27.56	27.6	7420600.0
2002-06-19 14:30:00	QQQ	ETF	27.55	27.63	27.36	27.42	7860900.0
2002-06-19 15:00:00	QQQ	ETF	27.42	27.52	27.3	27.35	6006800.0
2002-06-19 15:30:00	QQQ	ETF	27.3	27.48	27.25	27.32	8296700.0
2002-06-19 16:00:00	QQQ	ETF	27.33	27.35	27.2	27.3	2521900.0
2002-06-19 16:30:00	QQQ	ETF	27.3	27.31	27.21	27.28	300100.0
2002-06-19 17:00:00	QQQ	ETF	27.28	27.33	27.27	27.3	403800.0
2002-06-19 17:30:00	QQQ	ETF	27.3	27.31	27.3	27.3	8500.0
2002-06-19 18:00:00	QQQ	ETF	27.31	27.32	27.29	27.3	18200.0
2002-06-19 09:30:00	IWM	ETF	46.35	46.625	46.35	46.53	345000.0
2002-06-19 10:00:00	IWM	ETF	46.53	47.095	46.49	47.095	194400.0
2002-06-19 10:30:00	IWM	ETF	47.01	47.115	46.925	46.965	121000.0
2002-06-19 11:00:00	IWM	ETF	47.03	47.175	47.0	47.165	135600.0
2002-06-19 11:30:00	IWM	ETF	47.185	47.185	47.095	47.125	111000.0
2002-06-19 12:00:00	IWM	ETF	47.1	47.125	46.755	46.755	105200.0
2002-06-19 12:30:00	IWM	ETF	46.75	46.775	46.5	46.585	71800.0
2002-06-19 13:00:00	IWM	ETF	46.55	46.6	46.51	46.57	73400.0
2002-06-19 13:30:00	IWM	ETF	46.55	46.575	46.485	46.485	124000.0
2002-06-19 14:00:00	IWM	ETF	46.555	46.555	46.195	46.3	95000.0
2002-06-19 14:30:00	IWM	ETF	46.25	46.275	46.125	46.125	136600.0
2002-06-19 15:00:00	IWM	ETF	46.2	46.25	46.05	46.15	439600.0
2002-06-19 15:30:00	IWM	ETF	46.09	46.15	46.0	46.055	361400.0
2002-06-19 16:00:00	IWM	ETF	45.505	46.0	45.505	46.0	1200.0

> showing 50 of 507 rows — these rows as CSV

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