PREVIEW / etf_30min / 2004-07-19

all etf 30-min files

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

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-19 08:00:00	SPY	ETF	110.91	110.95	110.88	110.9	8900.0
2004-07-19 08:30:00	SPY	ETF	110.9	110.9	110.77	110.77	110500.0
2004-07-19 09:00:00	SPY	ETF	110.79	110.79	110.74	110.75	12300.0
2004-07-19 09:30:00	SPY	ETF	110.75	110.83	110.53	110.76	7157200.0
2004-07-19 10:00:00	SPY	ETF	110.76	110.9	110.55	110.6	2299700.0
2004-07-19 10:30:00	SPY	ETF	110.6	110.87	110.5	110.72	2082500.0
2004-07-19 11:00:00	SPY	ETF	110.73	110.77	110.52	110.56	2000600.0
2004-07-19 11:30:00	SPY	ETF	110.57	110.59	110.13	110.17	3426500.0
2004-07-19 12:00:00	SPY	ETF	110.17	110.29	110.1	110.21	1877900.0
2004-07-19 12:30:00	SPY	ETF	110.2	110.31	110.01	110.27	1734400.0
2004-07-19 13:00:00	SPY	ETF	110.28	110.37	110.14	110.19	1588000.0
2004-07-19 13:30:00	SPY	ETF	110.2	110.26	109.99	110.15	1192600.0
2004-07-19 14:00:00	SPY	ETF	110.14	110.77	110.1	110.73	3675400.0
2004-07-19 14:30:00	SPY	ETF	110.73	110.96	110.58	110.71	3954000.0
2004-07-19 15:00:00	SPY	ETF	110.71	110.82	110.57	110.62	2208200.0
2004-07-19 15:30:00	SPY	ETF	110.62	110.67	110.34	110.45	3436700.0
2004-07-19 16:00:00	SPY	ETF	110.47	110.49	110.24	110.29	634600.0
2004-07-19 16:30:00	SPY	ETF	110.32	110.32	110.19	110.2	32000.0
2004-07-19 17:00:00	SPY	ETF	110.19	110.27	110.19	110.22	36100.0
2004-07-19 17:30:00	SPY	ETF	110.23	110.25	110.23	110.25	3300.0
2004-07-19 18:00:00	SPY	ETF	110.24	110.24	110.23	110.24	700.0
2004-07-19 19:00:00	SPY	ETF	110.27	110.27	110.27	110.27	600.0
2004-07-19 08:00:00	QQQ	ETF	34.8	34.84	34.8	34.82	91500.0
2004-07-19 08:30:00	QQQ	ETF	34.83	34.84	34.79	34.79	283000.0
2004-07-19 09:00:00	QQQ	ETF	34.79	34.79	34.72	34.79	113000.0
2004-07-19 09:30:00	QQQ	ETF	34.78	34.93	34.71	34.87	12510100.0
2004-07-19 10:00:00	QQQ	ETF	34.87	34.902	34.73	34.75	6189300.0
2004-07-19 10:30:00	QQQ	ETF	34.74	34.83	34.67	34.77	7209700.0
2004-07-19 11:00:00	QQQ	ETF	34.78	34.81	34.69	34.7	4579400.0
2004-07-19 11:30:00	QQQ	ETF	34.706	34.74	34.52	34.55	7589300.0
2004-07-19 12:00:00	QQQ	ETF	34.55	34.59	34.5	34.56	5769400.0
2004-07-19 12:30:00	QQQ	ETF	34.55	34.611	34.47	34.61	6060300.0
2004-07-19 13:00:00	QQQ	ETF	34.6	34.67	34.55	34.57	5798300.0
2004-07-19 13:30:00	QQQ	ETF	34.57	34.6	34.49	34.55	2981500.0
2004-07-19 14:00:00	QQQ	ETF	34.549	34.86	34.53	34.85	11379000.0
2004-07-19 14:30:00	QQQ	ETF	34.849	34.97	34.78	34.88	13857300.0
2004-07-19 15:00:00	QQQ	ETF	34.88	34.9	34.8	34.82	7033400.0
2004-07-19 15:30:00	QQQ	ETF	34.82	34.85	34.72	34.731	9554000.0
2004-07-19 16:00:00	QQQ	ETF	34.731	34.76	34.59	34.63	3640900.0
2004-07-19 16:30:00	QQQ	ETF	34.633	34.654	34.58	34.6	190400.0
2004-07-19 17:00:00	QQQ	ETF	34.609	34.63	34.6	34.6	69400.0
2004-07-19 17:30:00	QQQ	ETF	34.601	34.64	34.601	34.62	32000.0
2004-07-19 18:00:00	QQQ	ETF	34.63	34.641	34.61	34.641	11200.0
2004-07-19 18:30:00	QQQ	ETF	34.64	34.64	34.62	34.63	3300.0
2004-07-19 19:00:00	QQQ	ETF	34.63	34.63	34.63	34.63	100.0
2004-07-19 19:30:00	QQQ	ETF	34.63	34.64	34.6	34.64	4300.0
2004-07-19 08:30:00	IWM	ETF	55.485	55.485	55.485	55.485	400.0
2004-07-19 09:30:00	IWM	ETF	55.42	55.475	55.25	55.335	1951000.0
2004-07-19 10:00:00	IWM	ETF	55.33	55.475	55.105	55.12	2315200.0
2004-07-19 10:30:00	IWM	ETF	55.14	55.275	55.055	55.25	1726400.0

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

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