PREVIEW / etf_30min / 2004-07-27

all etf 30-min files

  file:    by_date/etf_30min/2004/2004-07-27.parquet
  size:    36 KB
  rows:    1,152

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-07-27 08:00:00	SPY	ETF	109.09	109.14	109.06	109.14	27300.0
2004-07-27 08:30:00	SPY	ETF	109.14	109.18	109.09	109.11	74900.0
2004-07-27 09:00:00	SPY	ETF	109.05	109.09	109.05	109.06	48600.0
2004-07-27 09:30:00	SPY	ETF	109.05	109.28	109.0	109.26	2975100.0
2004-07-27 10:00:00	SPY	ETF	109.26	109.54	109.23	109.31	6713400.0
2004-07-27 10:30:00	SPY	ETF	109.33	109.35	109.03	109.11	4009500.0
2004-07-27 11:00:00	SPY	ETF	109.11	109.24	109.01	109.16	3708600.0
2004-07-27 11:30:00	SPY	ETF	109.17	109.26	108.97	109.18	2580400.0
2004-07-27 12:00:00	SPY	ETF	109.17	109.49	109.17	109.46	2626200.0
2004-07-27 12:30:00	SPY	ETF	109.45	109.57	109.24	109.49	3233400.0
2004-07-27 13:00:00	SPY	ETF	109.49	109.49	109.24	109.37	1934500.0
2004-07-27 13:30:00	SPY	ETF	109.38	109.39	109.1	109.32	1488500.0
2004-07-27 14:00:00	SPY	ETF	109.31	109.69	109.2	109.69	2105300.0
2004-07-27 14:30:00	SPY	ETF	109.66	109.95	109.56	109.84	5373800.0
2004-07-27 15:00:00	SPY	ETF	109.85	110.11	109.83	109.93	3365400.0
2004-07-27 15:30:00	SPY	ETF	109.93	110.07	109.82	109.88	4181700.0
2004-07-27 16:00:00	SPY	ETF	109.89	109.95	109.71	109.79	1908300.0
2004-07-27 16:30:00	SPY	ETF	109.79	109.79	109.72	109.79	29300.0
2004-07-27 17:00:00	SPY	ETF	109.76	109.8	109.76	109.8	6000.0
2004-07-27 17:30:00	SPY	ETF	109.85	109.86	109.8	109.83	11100.0
2004-07-27 19:00:00	SPY	ETF	109.86	109.86	109.86	109.86	200.0
2004-07-27 08:00:00	QQQ	ETF	34.19	34.24	34.19	34.2	322300.0
2004-07-27 08:30:00	QQQ	ETF	34.2	34.24	34.2	34.23	132800.0
2004-07-27 09:00:00	QQQ	ETF	34.23	34.23	34.19	34.2	139700.0
2004-07-27 09:30:00	QQQ	ETF	34.19	34.28	34.12	34.24	6779500.0
2004-07-27 10:00:00	QQQ	ETF	34.24	34.42	34.23	34.34	13336900.0
2004-07-27 10:30:00	QQQ	ETF	34.34	34.35	34.11	34.17	8341600.0
2004-07-27 11:00:00	QQQ	ETF	34.17	34.193	34.07	34.15	7203700.0
2004-07-27 11:30:00	QQQ	ETF	34.15	34.304	34.13	34.29	6217300.0
2004-07-27 12:00:00	QQQ	ETF	34.29	34.4	34.27	34.378	5157500.0
2004-07-27 12:30:00	QQQ	ETF	34.38	34.43	34.29	34.373	5389100.0
2004-07-27 13:00:00	QQQ	ETF	34.37	34.4	34.299	34.4	3148600.0
2004-07-27 13:30:00	QQQ	ETF	34.388	34.392	34.23	34.32	3202000.0
2004-07-27 14:00:00	QQQ	ETF	34.31	34.47	34.25	34.453	4963100.0
2004-07-27 14:30:00	QQQ	ETF	34.45	34.603	34.423	34.586	10488700.0
2004-07-27 15:00:00	QQQ	ETF	34.59	34.68	34.58	34.62	9363800.0
2004-07-27 15:30:00	QQQ	ETF	34.62	34.71	34.55	34.57	9363100.0
2004-07-27 16:00:00	QQQ	ETF	34.57	34.59	34.499	34.53	2979900.0
2004-07-27 16:30:00	QQQ	ETF	34.54	34.55	34.5	34.52	90300.0
2004-07-27 17:00:00	QQQ	ETF	34.52	34.56	34.511	34.53	154900.0
2004-07-27 17:30:00	QQQ	ETF	34.53	34.57	34.5	34.56	25300.0
2004-07-27 18:00:00	QQQ	ETF	34.56	34.57	34.54	34.57	17700.0
2004-07-27 18:30:00	QQQ	ETF	34.55	34.57	34.55	34.57	1200.0
2004-07-27 19:00:00	QQQ	ETF	34.56	34.58	34.56	34.58	3200.0
2004-07-27 19:30:00	QQQ	ETF	34.55	34.6	34.55	34.57	3800.0
2004-07-27 08:00:00	IWM	ETF	53.36	53.37	53.36	53.37	12000.0
2004-07-27 08:30:00	IWM	ETF	53.37	53.37	53.36	53.36	400.0
2004-07-27 09:00:00	IWM	ETF	53.345	53.36	53.315	53.36	32600.0
2004-07-27 09:30:00	IWM	ETF	53.39	53.625	53.34	53.535	2030400.0
2004-07-27 10:00:00	IWM	ETF	53.58	53.925	53.54	53.815	1907800.0

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

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