PREVIEW / etf_30min / 2004-04-20

all etf 30-min files

  file:    by_date/etf_30min/2004/2004-04-20.parquet
  size:    37 KB
  rows:    1,234

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
2004-04-20 08:00:00	SPY	ETF	114.15	114.3	114.15	114.25	35000.0
2004-04-20 08:30:00	SPY	ETF	114.22	114.27	114.14	114.19	42500.0
2004-04-20 09:00:00	SPY	ETF	114.2	114.22	114.11	114.11	29800.0
2004-04-20 09:30:00	SPY	ETF	114.08	114.28	113.96	114.25	4695600.0
2004-04-20 10:00:00	SPY	ETF	114.27	114.32	114.05	114.15	2823800.0
2004-04-20 10:30:00	SPY	ETF	114.15	114.29	113.9	113.95	2868000.0
2004-04-20 11:00:00	SPY	ETF	113.94	113.99	113.76	113.87	2412200.0
2004-04-20 11:30:00	SPY	ETF	113.88	113.95	113.67	113.67	1415400.0
2004-04-20 12:00:00	SPY	ETF	113.68	113.82	113.65	113.78	1168700.0
2004-04-20 12:30:00	SPY	ETF	113.8	113.9	113.76	113.78	916000.0
2004-04-20 13:00:00	SPY	ETF	113.78	113.89	113.71	113.79	664800.0
2004-04-20 13:30:00	SPY	ETF	113.79	113.98	113.78	113.93	873500.0
2004-04-20 14:00:00	SPY	ETF	113.93	113.96	113.77	113.91	782400.0
2004-04-20 14:30:00	SPY	ETF	113.91	113.95	113.24	113.25	6720000.0
2004-04-20 15:00:00	SPY	ETF	113.25	113.45	113.05	113.14	4988900.0
2004-04-20 15:30:00	SPY	ETF	113.14	113.19	112.11	112.13	13516800.0
2004-04-20 16:00:00	SPY	ETF	112.14	112.2	111.78	112.0	3881800.0
2004-04-20 16:30:00	SPY	ETF	112.01	112.18	111.98	112.15	789300.0
2004-04-20 17:00:00	SPY	ETF	112.15	112.2	111.92	112.17	481100.0
2004-04-20 17:30:00	SPY	ETF	112.16	112.17	111.8662	112.11	672700.0
2004-04-20 18:00:00	SPY	ETF	112.12	112.14	112.09	112.11	15700.0
2004-04-20 18:30:00	SPY	ETF	112.15	112.15	112.09	112.09	10100.0
2004-04-20 19:00:00	SPY	ETF	112.14	112.16	112.09	112.09	11100.0
2004-04-20 08:00:00	QQQ	ETF	36.66	36.68	36.64	36.65	319600.0
2004-04-20 08:30:00	QQQ	ETF	36.65	36.68	36.64	36.64	138500.0
2004-04-20 09:00:00	QQQ	ETF	36.64	36.65	36.58	36.61	115200.0
2004-04-20 09:30:00	QQQ	ETF	36.61	36.76	36.56	36.74	13801900.0
2004-04-20 10:00:00	QQQ	ETF	36.736	36.79	36.65	36.694	9519800.0
2004-04-20 10:30:00	QQQ	ETF	36.69	36.76	36.63	36.643	5461600.0
2004-04-20 11:00:00	QQQ	ETF	36.644	36.67	36.54	36.56	6514500.0
2004-04-20 11:30:00	QQQ	ETF	36.568	36.62	36.47	36.474	5245200.0
2004-04-20 12:00:00	QQQ	ETF	36.475	36.53	36.41	36.451	6319000.0
2004-04-20 12:30:00	QQQ	ETF	36.45	36.53	36.438	36.45	4264200.0
2004-04-20 13:00:00	QQQ	ETF	36.449	36.5	36.393	36.45	2113100.0
2004-04-20 13:30:00	QQQ	ETF	36.44	36.58	36.44	36.57	3701200.0
2004-04-20 14:00:00	QQQ	ETF	36.57	36.58	36.45	36.51	3606200.0
2004-04-20 14:30:00	QQQ	ETF	36.52	36.54	36.177	36.22	13016200.0
2004-04-20 15:00:00	QQQ	ETF	36.217	36.271	36.1	36.14	11651200.0
2004-04-20 15:30:00	QQQ	ETF	36.14	36.161	35.73	35.75	20169400.0
2004-04-20 16:00:00	QQQ	ETF	35.75	35.85	35.63	35.83	6585400.0
2004-04-20 16:30:00	QQQ	ETF	35.81	35.88	35.76	35.88	1402600.0
2004-04-20 17:00:00	QQQ	ETF	35.85	35.9	35.84	35.84	233500.0
2004-04-20 17:30:00	QQQ	ETF	35.85	35.93	35.85	35.87	144700.0
2004-04-20 18:00:00	QQQ	ETF	35.87	35.871	35.83	35.85	142500.0
2004-04-20 18:30:00	QQQ	ETF	35.88	35.95	35.88	35.95	77800.0
2004-04-20 19:00:00	QQQ	ETF	35.95	35.96	35.89	35.93	129700.0
2004-04-20 19:30:00	QQQ	ETF	35.89	35.94	35.88	35.88	23000.0
2004-04-20 09:00:00	IWM	ETF	58.665	58.665	58.665	58.665	200.0
2004-04-20 09:30:00	IWM	ETF	58.725	59.045	58.705	59.02	3207200.0
2004-04-20 10:00:00	IWM	ETF	59.02	59.115	58.88	58.925	938600.0

> showing 50 of 1,234 rows — these rows as CSV

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