PREVIEW / etf_30min / 2002-03-18

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-03-18.parquet
  size:    19 KB
  rows:    502

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-03-18 09:30:00	SPY	ETF	117.1	117.56	117.07	117.34	2594500.0
2002-03-18 10:00:00	SPY	ETF	117.31	117.49	117.21	117.33	901100.0
2002-03-18 10:30:00	SPY	ETF	117.31	117.36	116.91	116.95	1574900.0
2002-03-18 11:00:00	SPY	ETF	116.97	117.05	116.3	116.45	1634400.0
2002-03-18 11:30:00	SPY	ETF	116.41	116.54	116.1	116.21	2057600.0
2002-03-18 12:00:00	SPY	ETF	116.2	116.52	116.13	116.47	546400.0
2002-03-18 12:30:00	SPY	ETF	116.47	116.52	116.23	116.33	584500.0
2002-03-18 13:00:00	SPY	ETF	116.34	116.45	116.28	116.45	612800.0
2002-03-18 13:30:00	SPY	ETF	116.46	116.48	116.12	116.24	671900.0
2002-03-18 14:00:00	SPY	ETF	116.27	116.59	116.1	116.58	493800.0
2002-03-18 14:30:00	SPY	ETF	116.6	116.68	116.38	116.53	743600.0
2002-03-18 15:00:00	SPY	ETF	116.53	116.92	116.47	116.88	1052200.0
2002-03-18 15:30:00	SPY	ETF	116.86	117.04	116.65	116.76	1276300.0
2002-03-18 16:00:00	SPY	ETF	116.76	116.84	116.62	116.62	716400.0
2002-03-18 17:00:00	SPY	ETF	116.78	116.78	116.72	116.73	45100.0
2002-03-18 18:00:00	SPY	ETF	116.71	116.71	116.68	116.68	500.0
2002-03-18 09:30:00	QQQ	ETF	37.63	37.94	37.63	37.81	13508900.0
2002-03-18 10:00:00	QQQ	ETF	37.83	37.91	37.74	37.88	6910200.0
2002-03-18 10:30:00	QQQ	ETF	37.82	37.88	37.62	37.68	4798100.0
2002-03-18 11:00:00	QQQ	ETF	37.69	37.75	37.31	37.41	7723500.0
2002-03-18 11:30:00	QQQ	ETF	37.41	37.48	37.18	37.25	6589600.0
2002-03-18 12:00:00	QQQ	ETF	37.25	37.38	37.18	37.36	3441900.0
2002-03-18 12:30:00	QQQ	ETF	37.36	37.39	37.22	37.27	2127800.0
2002-03-18 13:00:00	QQQ	ETF	37.26	37.36	37.23	37.33	3521100.0
2002-03-18 13:30:00	QQQ	ETF	37.35	37.37	37.09	37.14	4109600.0
2002-03-18 14:00:00	QQQ	ETF	37.13	37.32	37.05	37.32	3175900.0
2002-03-18 14:30:00	QQQ	ETF	37.3	37.46	37.25	37.32	5370800.0
2002-03-18 15:00:00	QQQ	ETF	37.32	37.54	37.29	37.5	4945000.0
2002-03-18 15:30:00	QQQ	ETF	37.51	37.6	37.37	37.48	7328300.0
2002-03-18 16:00:00	QQQ	ETF	37.48	37.85	37.4	37.48	1765600.0
2002-03-18 16:30:00	QQQ	ETF	37.49	37.5	37.38	37.43	39900.0
2002-03-18 17:00:00	QQQ	ETF	37.42	37.42	37.36	37.39	14500.0
2002-03-18 17:30:00	QQQ	ETF	37.38	37.42	37.34	37.41	11500.0
2002-03-18 18:00:00	QQQ	ETF	37.4	37.42	37.32	37.32	17100.0
2002-03-18 09:30:00	IWM	ETF	49.745	50.095	49.745	50.095	176800.0
2002-03-18 10:00:00	IWM	ETF	50.025	50.045	49.855	49.995	245000.0
2002-03-18 10:30:00	IWM	ETF	49.995	49.995	49.8	49.8	67400.0
2002-03-18 11:00:00	IWM	ETF	49.8	49.835	49.56	49.565	75200.0
2002-03-18 11:30:00	IWM	ETF	49.62	49.7	49.55	49.62	42600.0
2002-03-18 12:00:00	IWM	ETF	49.615	49.715	49.6	49.715	29600.0
2002-03-18 12:30:00	IWM	ETF	49.74	49.82	49.74	49.81	43200.0
2002-03-18 13:00:00	IWM	ETF	49.81	49.88	49.775	49.88	69800.0
2002-03-18 13:30:00	IWM	ETF	49.89	49.89	49.78	49.82	5200.0
2002-03-18 14:00:00	IWM	ETF	49.75	49.925	49.75	49.9	116200.0
2002-03-18 14:30:00	IWM	ETF	49.905	50.02	49.855	49.985	29400.0
2002-03-18 15:00:00	IWM	ETF	49.895	50.13	49.895	50.13	59600.0
2002-03-18 15:30:00	IWM	ETF	50.14	50.18	49.9	50.035	340400.0
2002-03-18 16:00:00	IWM	ETF	50.04	50.04	49.905	49.95	6000.0
2002-03-18 09:30:00	DIA	ETF	106.35	106.78	106.35	106.5	823300.0
2002-03-18 10:00:00	DIA	ETF	106.48	106.66	106.4	106.57	230400.0

> showing 50 of 502 rows — these rows as CSV

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