PREVIEW / etf_30min / 2005-04-07

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-04-07.parquet
  size:    43 KB
  rows:    1,475

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
2005-04-07 08:00:00	SPY	ETF	118.55	118.55	118.44	118.47	154900.0
2005-04-07 08:30:00	SPY	ETF	118.5	118.55	118.46	118.54	39600.0
2005-04-07 09:00:00	SPY	ETF	118.53	118.58	118.33	118.43	144700.0
2005-04-07 09:30:00	SPY	ETF	118.41	118.59	118.32	118.47	4619900.0
2005-04-07 10:00:00	SPY	ETF	118.47	118.62	118.41	118.5	4864700.0
2005-04-07 10:30:00	SPY	ETF	118.51	118.84	118.5	118.75	4428000.0
2005-04-07 11:00:00	SPY	ETF	118.73	118.93	118.68	118.79	3161000.0
2005-04-07 11:30:00	SPY	ETF	118.8	118.84	118.72	118.79	1065500.0
2005-04-07 12:00:00	SPY	ETF	118.81	118.91	118.74	118.88	1373500.0
2005-04-07 12:30:00	SPY	ETF	118.88	119.17	118.85	119.01	3586800.0
2005-04-07 13:00:00	SPY	ETF	119.01	119.14	118.76	118.87	3205600.0
2005-04-07 13:30:00	SPY	ETF	118.87	118.93	118.57	118.69	2501100.0
2005-04-07 14:00:00	SPY	ETF	118.7	118.87	118.66	118.79	2682700.0
2005-04-07 14:30:00	SPY	ETF	118.79	119.14	118.74	119.09	4465800.0
2005-04-07 15:00:00	SPY	ETF	119.09	119.23	118.98	119.07	3042000.0
2005-04-07 15:30:00	SPY	ETF	119.07	119.17	118.95	119.15	5047800.0
2005-04-07 16:00:00	SPY	ETF	119.15	119.27	119.12	119.24	1223500.0
2005-04-07 16:30:00	SPY	ETF	119.23	119.25	118.845	119.19	455200.0
2005-04-07 17:00:00	SPY	ETF	119.19	119.19	119.18	119.18	14000.0
2005-04-07 17:30:00	SPY	ETF	119.2	119.23	119.19	119.23	1000.0
2005-04-07 18:00:00	SPY	ETF	119.16	119.22	119.16	119.2	3300.0
2005-04-07 18:30:00	SPY	ETF	119.2	119.2	119.18	119.18	1400.0
2005-04-07 19:00:00	SPY	ETF	119.25	119.25	119.25	119.25	100.0
2005-04-07 09:30:00	QQQ	ETF	36.53	36.61	36.51	36.6	9421900.0
2005-04-07 10:00:00	QQQ	ETF	36.59	36.7	36.57	36.62	6631200.0
2005-04-07 10:30:00	QQQ	ETF	36.63	36.76	36.62	36.72	5964600.0
2005-04-07 11:00:00	QQQ	ETF	36.72	36.79	36.7	36.72	4372800.0
2005-04-07 11:30:00	QQQ	ETF	36.72	36.73	36.68	36.71	2505700.0
2005-04-07 12:00:00	QQQ	ETF	36.71	36.76	36.67	36.73	3098700.0
2005-04-07 12:30:00	QQQ	ETF	36.73	36.86	36.7	36.8	8059200.0
2005-04-07 13:00:00	QQQ	ETF	36.8	36.85	36.74	36.83	8818100.0
2005-04-07 13:30:00	QQQ	ETF	36.82	36.84	36.72	36.74	5056000.0
2005-04-07 14:00:00	QQQ	ETF	36.74	36.84	36.72	36.79	4067300.0
2005-04-07 14:30:00	QQQ	ETF	36.79	36.91	36.78	36.91	6938800.0
2005-04-07 15:00:00	QQQ	ETF	36.91	36.95	36.86	36.89	6348700.0
2005-04-07 15:30:00	QQQ	ETF	36.89	36.93	36.84	36.93	9718400.0
2005-04-07 08:30:00	IWM	ETF	61.25	61.275	61.25	61.275	6000.0
2005-04-07 09:00:00	IWM	ETF	61.275	61.275	61.045	61.05	30400.0
2005-04-07 09:30:00	IWM	ETF	61.09	61.25	60.945	61.075	1734800.0
2005-04-07 10:00:00	IWM	ETF	61.08	61.235	61.01	61.16	694400.0
2005-04-07 10:30:00	IWM	ETF	61.165	61.475	61.16	61.395	2337400.0
2005-04-07 11:00:00	IWM	ETF	61.4	61.57	61.37	61.5	1663600.0
2005-04-07 11:30:00	IWM	ETF	61.5	61.525	61.433	61.49	498200.0
2005-04-07 12:00:00	IWM	ETF	61.485	61.54	61.46	61.54	684400.0
2005-04-07 12:30:00	IWM	ETF	61.535	61.755	61.535	61.665	1470000.0
2005-04-07 13:00:00	IWM	ETF	61.655	61.67	61.455	61.51	987800.0
2005-04-07 13:30:00	IWM	ETF	61.52	61.55	61.33	61.44	856200.0
2005-04-07 14:00:00	IWM	ETF	61.445	61.525	61.405	61.445	417800.0
2005-04-07 14:30:00	IWM	ETF	61.445	61.62	61.42	61.61	573000.0
2005-04-07 15:00:00	IWM	ETF	61.61	61.655	61.56	61.625	742000.0

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

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