PREVIEW / etf_30min / 2002-03-20

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-03-20.parquet
  size:    18 KB
  rows:    496

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-20 09:30:00	SPY	ETF	116.47	116.58	116.28	116.43	2296300.0
2002-03-20 10:00:00	SPY	ETF	116.4	116.43	116.14	116.16	1297100.0
2002-03-20 10:30:00	SPY	ETF	116.16	116.27	115.94	116.17	1571200.0
2002-03-20 11:00:00	SPY	ETF	116.13	116.25	116.0	116.18	1486000.0
2002-03-20 11:30:00	SPY	ETF	116.18	116.27	116.03	116.18	630300.0
2002-03-20 12:00:00	SPY	ETF	116.2	116.22	116.05	116.19	513000.0
2002-03-20 12:30:00	SPY	ETF	116.21	116.41	116.15	116.34	1314100.0
2002-03-20 13:00:00	SPY	ETF	116.31	116.37	116.15	116.32	258800.0
2002-03-20 13:30:00	SPY	ETF	116.34	116.36	115.97	116.1	573400.0
2002-03-20 14:00:00	SPY	ETF	116.11	116.12	115.7	115.72	1810400.0
2002-03-20 14:30:00	SPY	ETF	115.75	115.95	115.71	115.77	1104600.0
2002-03-20 15:00:00	SPY	ETF	115.77	115.87	115.47	115.55	1285300.0
2002-03-20 15:30:00	SPY	ETF	115.54	115.62	115.39	115.43	818100.0
2002-03-20 16:00:00	SPY	ETF	115.43	115.44	115.19	115.24	1052700.0
2002-03-20 16:30:00	SPY	ETF	115.27	115.28	115.21	115.21	2700.0
2002-03-20 17:00:00	SPY	ETF	115.27	115.4	115.2	115.28	475800.0
2002-03-20 17:30:00	SPY	ETF	115.28	115.28	115.28	115.28	500.0
2002-03-20 18:00:00	SPY	ETF	115.26	115.26	114.4	115.26	11200.0
2002-03-20 09:30:00	QQQ	ETF	36.87	37.08	36.84	36.88	9776700.0
2002-03-20 10:00:00	QQQ	ETF	36.99	36.99	36.7	36.75	7798800.0
2002-03-20 10:30:00	QQQ	ETF	36.76	36.85	36.59	36.74	5010600.0
2002-03-20 11:00:00	QQQ	ETF	36.73	36.83	36.63	36.8	3173200.0
2002-03-20 11:30:00	QQQ	ETF	36.8	36.84	36.72	36.77	1853000.0
2002-03-20 12:00:00	QQQ	ETF	36.76	36.79	36.68	36.76	962500.0
2002-03-20 12:30:00	QQQ	ETF	36.76	36.87	36.72	36.79	2308300.0
2002-03-20 13:00:00	QQQ	ETF	36.79	36.82	36.71	36.79	1923100.0
2002-03-20 13:30:00	QQQ	ETF	36.8	36.82	36.61	36.69	2407700.0
2002-03-20 14:00:00	QQQ	ETF	36.69	36.72	36.32	36.4	7407600.0
2002-03-20 14:30:00	QQQ	ETF	36.36	36.51	36.32	36.41	3797700.0
2002-03-20 15:00:00	QQQ	ETF	36.4	36.47	36.22	36.26	4657200.0
2002-03-20 15:30:00	QQQ	ETF	36.29	36.37	36.14	36.15	6482800.0
2002-03-20 16:00:00	QQQ	ETF	36.15	36.3	36.03	36.04	1722400.0
2002-03-20 16:30:00	QQQ	ETF	36.04	36.08	36.0	36.08	58700.0
2002-03-20 17:00:00	QQQ	ETF	36.08	36.09	36.03	36.07	8300.0
2002-03-20 17:30:00	QQQ	ETF	36.07	36.07	36.02	36.02	15700.0
2002-03-20 18:00:00	QQQ	ETF	36.05	36.08	36.0	36.05	21300.0
2002-03-20 09:30:00	IWM	ETF	49.975	50.025	49.775	49.915	145000.0
2002-03-20 10:00:00	IWM	ETF	49.88	49.89	49.675	49.835	80400.0
2002-03-20 10:30:00	IWM	ETF	49.65	49.795	49.6	49.75	128200.0
2002-03-20 11:00:00	IWM	ETF	49.63	49.77	49.63	49.77	210400.0
2002-03-20 11:30:00	IWM	ETF	49.78	49.815	49.7	49.745	47600.0
2002-03-20 12:00:00	IWM	ETF	49.745	49.915	49.745	49.815	26800.0
2002-03-20 12:30:00	IWM	ETF	49.775	49.915	49.775	49.915	82200.0
2002-03-20 13:00:00	IWM	ETF	49.88	49.925	49.86	49.925	49200.0
2002-03-20 13:30:00	IWM	ETF	49.925	49.945	49.85	49.93	54800.0
2002-03-20 14:00:00	IWM	ETF	49.865	49.875	49.735	49.78	219200.0
2002-03-20 14:30:00	IWM	ETF	49.79	49.845	49.74	49.78	137600.0
2002-03-20 15:00:00	IWM	ETF	49.845	49.845	49.65	49.65	278600.0
2002-03-20 15:30:00	IWM	ETF	49.69	49.765	49.56	49.595	231800.0
2002-03-20 16:00:00	IWM	ETF	49.565	49.58	49.425	49.435	51000.0

> showing 50 of 496 rows — these rows as CSV

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