PREVIEW / etf_30min / 2005-01-31

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-01-31.parquet
  size:    42 KB
  rows:    1,458

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-01-31 08:00:00	SPY	ETF	117.9	118.0	117.88	117.97	140400.0
2005-01-31 08:30:00	SPY	ETF	117.97	117.97	117.91	117.95	148500.0
2005-01-31 09:00:00	SPY	ETF	117.96	118.0	117.89	117.94	238700.0
2005-01-31 09:30:00	SPY	ETF	117.97	118.08	117.81	118.02	8594900.0
2005-01-31 10:00:00	SPY	ETF	118.04	118.09	117.72	117.88	4538500.0
2005-01-31 10:30:00	SPY	ETF	117.88	118.05	117.83	117.87	2489000.0
2005-01-31 11:00:00	SPY	ETF	117.87	118.02	117.75	117.96	3608900.0
2005-01-31 11:30:00	SPY	ETF	117.94	118.02	117.86	117.97	1351000.0
2005-01-31 12:00:00	SPY	ETF	117.96	118.25	117.85	118.18	5985900.0
2005-01-31 12:30:00	SPY	ETF	118.17	118.2	118.04	118.18	1807100.0
2005-01-31 13:00:00	SPY	ETF	118.17	118.17	118.02	118.04	1241800.0
2005-01-31 13:30:00	SPY	ETF	118.04	118.06	117.86	117.93	1958600.0
2005-01-31 14:00:00	SPY	ETF	117.93	118.1	117.88	117.89	2729600.0
2005-01-31 14:30:00	SPY	ETF	117.9	118.15	117.86	118.05	2262800.0
2005-01-31 15:00:00	SPY	ETF	118.05	118.12	117.71	117.83	5171300.0
2005-01-31 15:30:00	SPY	ETF	117.83	118.18	117.72	118.07	5008300.0
2005-01-31 16:00:00	SPY	ETF	118.05	118.24	118.04	118.1	1766600.0
2005-01-31 16:30:00	SPY	ETF	118.17	118.22	118.13	118.13	1340000.0
2005-01-31 17:00:00	SPY	ETF	118.15	118.16	118.1	118.16	1004100.0
2005-01-31 17:30:00	SPY	ETF	118.11	118.11	118.11	118.11	200.0
2005-01-31 18:00:00	SPY	ETF	118.13	118.13	118.12	118.12	7200.0
2005-01-31 19:00:00	SPY	ETF	118.12	118.12	118.12	118.12	400.0
2005-01-31 09:30:00	QQQ	ETF	37.36	37.43	37.28	37.43	14515100.0
2005-01-31 10:00:00	QQQ	ETF	37.44	37.5	37.33	37.42	10082600.0
2005-01-31 10:30:00	QQQ	ETF	37.41	37.47	37.4	37.4	5398600.0
2005-01-31 11:00:00	QQQ	ETF	37.4	37.47	37.33	37.42	4683700.0
2005-01-31 11:30:00	QQQ	ETF	37.42	37.47	37.41	37.44	2350600.0
2005-01-31 12:00:00	QQQ	ETF	37.45	37.53	37.39	37.49	5738200.0
2005-01-31 12:30:00	QQQ	ETF	37.5	37.53	37.47	37.52	3240200.0
2005-01-31 13:00:00	QQQ	ETF	37.52	37.52	37.46	37.48	1960000.0
2005-01-31 13:30:00	QQQ	ETF	37.47	37.48	37.39	37.43	5002800.0
2005-01-31 14:00:00	QQQ	ETF	37.43	37.49	37.4	37.4	5192600.0
2005-01-31 14:30:00	QQQ	ETF	37.4	37.51	37.39	37.4	5125600.0
2005-01-31 15:00:00	QQQ	ETF	37.4	37.45	37.28	37.31	8435000.0
2005-01-31 15:30:00	QQQ	ETF	37.31	37.42	37.26	37.41	9461500.0
2005-01-31 08:30:00	IWM	ETF	61.735	61.745	61.7	61.7	4200.0
2005-01-31 09:00:00	IWM	ETF	61.69	61.695	61.635	61.635	7200.0
2005-01-31 09:30:00	IWM	ETF	61.76	61.89	61.635	61.83	2710800.0
2005-01-31 10:00:00	IWM	ETF	61.835	61.955	61.65	61.79	1835000.0
2005-01-31 10:30:00	IWM	ETF	61.775	61.825	61.68	61.7	512600.0
2005-01-31 11:00:00	IWM	ETF	61.7	61.73	61.57	61.695	780000.0
2005-01-31 11:30:00	IWM	ETF	61.695	61.855	61.65	61.705	564200.0
2005-01-31 12:00:00	IWM	ETF	61.71	61.91	61.65	61.885	744400.0
2005-01-31 12:30:00	IWM	ETF	61.88	61.9	61.83	61.9	833400.0
2005-01-31 13:00:00	IWM	ETF	61.9	61.9	61.805	61.845	309200.0
2005-01-31 13:30:00	IWM	ETF	61.84	61.86	61.725	61.84	284800.0
2005-01-31 14:00:00	IWM	ETF	61.84	62.115	61.81	61.93	1721400.0
2005-01-31 14:30:00	IWM	ETF	61.925	62.17	61.865	62.08	1869400.0
2005-01-31 15:00:00	IWM	ETF	62.08	62.135	61.88	61.965	2418400.0
2005-01-31 15:30:00	IWM	ETF	61.975	62.25	61.85	62.1	3587400.0

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

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