PREVIEW / etf_30min / 2005-04-20

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-04-20.parquet
  size:    46 KB
  rows:    1,507

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-20 07:00:00	SPY	ETF	115.7	115.8	115.7	115.78	43800.0
2005-04-20 07:30:00	SPY	ETF	115.76	115.78	115.7	115.7	155400.0
2005-04-20 08:00:00	SPY	ETF	115.74	115.77	115.67	115.73	109000.0
2005-04-20 08:30:00	SPY	ETF	115.6	115.67	115.08	115.59	1575400.0
2005-04-20 09:00:00	SPY	ETF	115.57	115.58	115.27	115.41	768800.0
2005-04-20 09:30:00	SPY	ETF	115.4	115.41	114.75	114.88	15121400.0
2005-04-20 10:00:00	SPY	ETF	114.82	115.32	114.76	115.29	8520500.0
2005-04-20 10:30:00	SPY	ETF	115.3	115.35	114.9	115.3	5188400.0
2005-04-20 11:00:00	SPY	ETF	115.3	115.63	115.07	115.19	8992500.0
2005-04-20 11:30:00	SPY	ETF	115.18	115.33	115.07	115.27	2535000.0
2005-04-20 12:00:00	SPY	ETF	115.27	115.27	115.03	115.08	1680400.0
2005-04-20 12:30:00	SPY	ETF	115.07	115.12	114.54	114.6	5884500.0
2005-04-20 13:00:00	SPY	ETF	114.6	114.71	114.52	114.52	3866200.0
2005-04-20 13:30:00	SPY	ETF	114.52	114.71	114.37	114.62	6312000.0
2005-04-20 14:00:00	SPY	ETF	114.61	114.65	114.15	114.16	8808400.0
2005-04-20 14:30:00	SPY	ETF	114.15	114.45	114.07	114.42	5691700.0
2005-04-20 15:00:00	SPY	ETF	114.45	114.45	113.75	113.96	13706000.0
2005-04-20 15:30:00	SPY	ETF	113.97	115.58	113.6	113.79	11007600.0
2005-04-20 16:00:00	SPY	ETF	113.77	115.22	113.53	113.79	997100.0
2005-04-20 16:30:00	SPY	ETF	113.79	113.92	113.64	113.88	1800600.0
2005-04-20 17:00:00	SPY	ETF	113.88	113.9	113.78	113.85	1208300.0
2005-04-20 17:30:00	SPY	ETF	113.87	113.92	113.8	113.82	8000.0
2005-04-20 18:00:00	SPY	ETF	113.87	113.89	113.82	113.85	58100.0
2005-04-20 18:30:00	SPY	ETF	113.84	113.86	113.8	113.8	37000.0
2005-04-20 19:30:00	SPY	ETF	113.89	113.89	113.88	113.88	1400.0
2005-04-20 09:30:00	QQQ	ETF	35.21	35.25	34.98	35.01	19323200.0
2005-04-20 10:00:00	QQQ	ETF	35.01	35.23	34.99	35.22	11249600.0
2005-04-20 10:30:00	QQQ	ETF	35.22	35.27	35.05	35.24	10671700.0
2005-04-20 11:00:00	QQQ	ETF	35.24	35.29	35.07	35.12	8348500.0
2005-04-20 11:30:00	QQQ	ETF	35.13	35.22	35.1	35.21	3864500.0
2005-04-20 12:00:00	QQQ	ETF	35.21	35.22	35.11	35.15	3193500.0
2005-04-20 12:30:00	QQQ	ETF	35.15	35.18	34.9	34.92	6769700.0
2005-04-20 13:00:00	QQQ	ETF	34.93	35.05	34.89	34.9	5013700.0
2005-04-20 13:30:00	QQQ	ETF	34.9	34.95	34.8	34.91	7104500.0
2005-04-20 14:00:00	QQQ	ETF	34.9	34.94	34.77	34.78	10343100.0
2005-04-20 14:30:00	QQQ	ETF	34.78	34.92	34.74	34.91	5812800.0
2005-04-20 15:00:00	QQQ	ETF	34.91	35.26	34.69	34.74	11448000.0
2005-04-20 15:30:00	QQQ	ETF	34.73	34.77	33.7	34.73	14092800.0
2005-04-20 08:00:00	IWM	ETF	59.305	59.305	59.305	59.305	400.0
2005-04-20 08:30:00	IWM	ETF	59.275	59.35	58.88	59.34	108800.0
2005-04-20 09:00:00	IWM	ETF	59.265	59.265	59.15	59.235	26200.0
2005-04-20 09:30:00	IWM	ETF	59.2	59.3	58.585	58.595	4056600.0
2005-04-20 10:00:00	IWM	ETF	58.605	59.04	58.57	59.035	3537000.0
2005-04-20 10:30:00	IWM	ETF	59.045	59.14	58.735	59.1	2785800.0
2005-04-20 11:00:00	IWM	ETF	59.075	59.225	58.88	58.975	2645800.0
2005-04-20 11:30:00	IWM	ETF	58.975	59.095	58.905	59.08	622600.0
2005-04-20 12:00:00	IWM	ETF	59.085	59.085	58.915	58.93	543600.0
2005-04-20 12:30:00	IWM	ETF	58.925	58.935	58.505	58.505	2785800.0
2005-04-20 13:00:00	IWM	ETF	58.535	58.64	58.43	58.465	1956200.0
2005-04-20 13:30:00	IWM	ETF	58.46	58.56	58.265	58.52	2062000.0

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

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