PREVIEW / etf_30min / 2003-07-01

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-07-01.parquet
  size:    24 KB
  rows:    692

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
2003-07-01 08:00:00	SPY	ETF	97.56	97.6	97.48	97.49	11100.0
2003-07-01 08:30:00	SPY	ETF	97.49	97.5	97.03	97.19	118200.0
2003-07-01 09:00:00	SPY	ETF	97.2	97.29	97.14	97.24	72800.0
2003-07-01 09:30:00	SPY	ETF	97.253	97.39	97.14	97.2	3569500.0
2003-07-01 10:00:00	SPY	ETF	97.2	97.26	96.43	96.96	9107300.0
2003-07-01 10:30:00	SPY	ETF	96.96	96.97	96.57	96.65	4500800.0
2003-07-01 11:00:00	SPY	ETF	96.675	97.03	96.66	97.01	1179200.0
2003-07-01 11:30:00	SPY	ETF	97.03	97.14	96.8	96.99	1922200.0
2003-07-01 12:00:00	SPY	ETF	96.99	97.03	96.7	96.76	1076200.0
2003-07-01 12:30:00	SPY	ETF	96.8	97.04	96.64	96.97	1458500.0
2003-07-01 13:00:00	SPY	ETF	96.99	97.67	96.97	97.55	4160300.0
2003-07-01 13:30:00	SPY	ETF	97.55	97.58	97.29	97.4	1604000.0
2003-07-01 14:00:00	SPY	ETF	97.4	98.05	97.25	97.956	3776800.0
2003-07-01 14:30:00	SPY	ETF	97.95	98.36	97.9	98.24	4242500.0
2003-07-01 15:00:00	SPY	ETF	98.24	98.55	98.16	98.511	2545900.0
2003-07-01 15:30:00	SPY	ETF	98.512	98.66	98.33	98.56	3592000.0
2003-07-01 16:00:00	SPY	ETF	98.562	98.75	97.481	98.63	3215600.0
2003-07-01 16:30:00	SPY	ETF	98.69	98.69	98.53	98.6	41000.0
2003-07-01 17:00:00	SPY	ETF	98.54	98.6	98.54	98.6	1800.0
2003-07-01 17:30:00	SPY	ETF	98.63	98.65	98.57	98.58	4400.0
2003-07-01 18:00:00	SPY	ETF	98.57	98.64	98.55	98.61	81300.0
2003-07-01 18:30:00	SPY	ETF	98.62	98.62	98.62	98.62	500.0
2003-07-01 19:00:00	SPY	ETF	98.65	98.65	98.62	98.62	900.0
2003-07-01 19:30:00	SPY	ETF	98.64	98.64	98.64	98.64	200.0
2003-07-01 08:00:00	QQQ	ETF	29.83	29.83	29.78	29.79	59200.0
2003-07-01 08:30:00	QQQ	ETF	29.79	29.79	29.68	29.7	216400.0
2003-07-01 09:00:00	QQQ	ETF	29.71	29.74	29.69	29.72	232600.0
2003-07-01 09:30:00	QQQ	ETF	29.7	29.75	29.61	29.67	8168900.0
2003-07-01 10:00:00	QQQ	ETF	29.67	29.7	29.26	29.54	14309100.0
2003-07-01 10:30:00	QQQ	ETF	29.54	29.56	29.38	29.39	4439800.0
2003-07-01 11:00:00	QQQ	ETF	29.4	29.513	29.38	29.5	4198700.0
2003-07-01 11:30:00	QQQ	ETF	29.5	29.58	29.47	29.57	3463800.0
2003-07-01 12:00:00	QQQ	ETF	29.56	29.59	29.46	29.505	1899000.0
2003-07-01 12:30:00	QQQ	ETF	29.501	29.58	29.42	29.55	2060800.0
2003-07-01 13:00:00	QQQ	ETF	29.55	29.77	29.54	29.72	6724500.0
2003-07-01 13:30:00	QQQ	ETF	29.73	29.75	29.62	29.64	3659100.0
2003-07-01 14:00:00	QQQ	ETF	29.66	30.11	29.57	30.07	8625900.0
2003-07-01 14:30:00	QQQ	ETF	30.06	30.242	30.0	30.15	10624800.0
2003-07-01 15:00:00	QQQ	ETF	30.154	30.32	30.08	30.26	7865800.0
2003-07-01 15:30:00	QQQ	ETF	30.25	30.33	30.07	30.299	7890600.0
2003-07-01 16:00:00	QQQ	ETF	30.29	30.38	29.704	30.33	5198300.0
2003-07-01 16:30:00	QQQ	ETF	30.32	30.37	30.26	30.37	98300.0
2003-07-01 17:00:00	QQQ	ETF	30.36	30.37	30.35	30.36	30800.0
2003-07-01 17:30:00	QQQ	ETF	30.36	30.36	30.33	30.34	23400.0
2003-07-01 18:00:00	QQQ	ETF	30.34	30.37	30.33	30.36	21500.0
2003-07-01 18:30:00	QQQ	ETF	30.37	30.39	30.37	30.37	11100.0
2003-07-01 19:00:00	QQQ	ETF	30.36	30.4	30.36	30.39	8700.0
2003-07-01 19:30:00	QQQ	ETF	30.39	30.41	30.38	30.4	37500.0
2003-07-01 09:30:00	IWM	ETF	44.405	44.49	44.2	44.285	662600.0
2003-07-01 10:00:00	IWM	ETF	44.25	44.25	43.91	43.955	530800.0

> showing 50 of 692 rows — these rows as CSV

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