PREVIEW / etf_30min / 2001-02-20

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-02-20.parquet
  size:    14 KB
  rows:    343

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-02-20 09:30:00	SPY	ETF	131.04	131.14	130.48	130.55	692000.0
2001-02-20 10:00:00	SPY	ETF	130.51	130.96	130.11	130.24	346700.0
2001-02-20 10:30:00	SPY	ETF	130.14	130.46	129.93	130.05	240700.0
2001-02-20 11:00:00	SPY	ETF	130.01	130.1	129.06	129.36	586900.0
2001-02-20 11:30:00	SPY	ETF	129.24	129.5	129.06	129.5	263700.0
2001-02-20 12:00:00	SPY	ETF	129.5	129.58	129.05	129.43	315000.0
2001-02-20 12:30:00	SPY	ETF	129.41	129.75	129.3	129.31	167500.0
2001-02-20 13:00:00	SPY	ETF	129.31	129.53	129.07	129.12	433500.0
2001-02-20 13:30:00	SPY	ETF	129.07	129.38	129.0	129.38	333300.0
2001-02-20 14:00:00	SPY	ETF	129.4	129.53	128.88	128.95	237900.0
2001-02-20 14:30:00	SPY	ETF	128.86	129.26	128.81	128.91	100100.0
2001-02-20 15:00:00	SPY	ETF	128.81	129.0	128.31	128.48	639300.0
2001-02-20 15:30:00	SPY	ETF	128.4	128.54	128.16	128.32	718800.0
2001-02-20 16:00:00	SPY	ETF	128.17	129.37	128.15	128.39	394800.0
2001-02-20 09:30:00	QQQ	ETF	55.74	55.84	54.75	54.98	5497900.0
2001-02-20 10:00:00	QQQ	ETF	54.97	55.18	54.12	54.32	4607100.0
2001-02-20 10:30:00	QQQ	ETF	54.27	54.47	53.61	53.72	4919400.0
2001-02-20 11:00:00	QQQ	ETF	53.72	53.89	53.1	53.49	4491200.0
2001-02-20 11:30:00	QQQ	ETF	53.5	54.06	53.3	54.0	3520900.0
2001-02-20 12:00:00	QQQ	ETF	54.0	54.05	53.51	53.88	2735200.0
2001-02-20 12:30:00	QQQ	ETF	53.93	54.23	53.66	53.76	2338600.0
2001-02-20 13:00:00	QQQ	ETF	53.75	53.86	53.25	53.37	1934800.0
2001-02-20 13:30:00	QQQ	ETF	53.26	53.53	53.1	53.5	1877100.0
2001-02-20 14:00:00	QQQ	ETF	53.5	53.88	53.02	53.06	3784400.0
2001-02-20 14:30:00	QQQ	ETF	53.09	53.58	53.01	53.12	3211000.0
2001-02-20 15:00:00	QQQ	ETF	53.12	53.32	52.65	52.8	5606600.0
2001-02-20 15:30:00	QQQ	ETF	52.87	52.98	52.39	52.4	6106800.0
2001-02-20 16:00:00	QQQ	ETF	52.42	52.99	52.25	52.8	1390200.0
2001-02-20 16:30:00	QQQ	ETF	52.8	53.0	52.75	53.0	37300.0
2001-02-20 17:00:00	QQQ	ETF	53.0	53.1	52.8	53.1	52600.0
2001-02-20 17:30:00	QQQ	ETF	52.97	53.1	52.9	52.95	20900.0
2001-02-20 18:00:00	QQQ	ETF	53.0	53.03	52.95	52.97	7100.0
2001-02-20 09:30:00	IWM	ETF	49.85	50.0	49.685	49.845	9200.0
2001-02-20 10:00:00	IWM	ETF	49.85	49.85	49.505	49.505	16000.0
2001-02-20 10:30:00	IWM	ETF	49.56	49.62	49.45	49.62	10600.0
2001-02-20 11:00:00	IWM	ETF	49.525	49.525	49.135	49.17	12000.0
2001-02-20 11:30:00	IWM	ETF	49.365	49.475	49.25	49.475	5600.0
2001-02-20 12:00:00	IWM	ETF	49.45	49.45	49.42	49.45	1200.0
2001-02-20 12:30:00	IWM	ETF	49.29	49.475	49.29	49.42	3200.0
2001-02-20 13:00:00	IWM	ETF	49.285	49.385	49.25	49.305	2800.0
2001-02-20 13:30:00	IWM	ETF	49.245	49.3	49.15	49.27	8600.0
2001-02-20 14:00:00	IWM	ETF	49.125	49.25	49.05	49.05	36600.0
2001-02-20 14:30:00	IWM	ETF	49.005	49.005	49.005	49.005	50000.0
2001-02-20 15:00:00	IWM	ETF	49.0	49.0	48.76	48.76	20800.0
2001-02-20 15:30:00	IWM	ETF	48.94	49.065	48.765	49.03	25200.0
2001-02-20 16:30:00	IWM	ETF	49.125	49.125	49.125	49.125	426000.0
2001-02-20 09:30:00	DIA	ETF	108.4	108.9	108.2	108.76	174700.0
2001-02-20 10:00:00	DIA	ETF	108.75	109.1	108.56	108.56	102500.0
2001-02-20 10:30:00	DIA	ETF	108.56	108.83	108.5	108.6	92500.0
2001-02-20 11:00:00	DIA	ETF	108.6	108.6	107.85	107.99	291000.0

> showing 50 of 343 rows — these rows as CSV

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