PREVIEW / etf_30min / 2003-07-29

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-07-29.parquet
  size:    23 KB
  rows:    666

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
2003-07-29 08:00:00	SPY	ETF	100.2	100.23	100.14	100.15	4700.0
2003-07-29 08:30:00	SPY	ETF	100.09	100.28	100.09	100.2	15200.0
2003-07-29 09:00:00	SPY	ETF	100.17	100.26	100.12	100.12	9200.0
2003-07-29 09:30:00	SPY	ETF	100.14	100.27	99.72	99.75	5059200.0
2003-07-29 10:00:00	SPY	ETF	99.76	99.76	98.86	99.03	11043100.0
2003-07-29 10:30:00	SPY	ETF	99.045	99.18	98.68	99.1	3315800.0
2003-07-29 11:00:00	SPY	ETF	99.07	99.25	98.97	99.11	1972100.0
2003-07-29 11:30:00	SPY	ETF	99.08	100.14	99.0	99.99	4987400.0
2003-07-29 12:00:00	SPY	ETF	99.975	100.0	99.65	99.69	5981000.0
2003-07-29 12:30:00	SPY	ETF	99.69	99.95	99.65	99.86	2027800.0
2003-07-29 13:00:00	SPY	ETF	99.85	100.1	99.73	100.1	1393700.0
2003-07-29 13:30:00	SPY	ETF	100.1	100.26	99.79	99.87	1687400.0
2003-07-29 14:00:00	SPY	ETF	99.86	100.09	99.52	99.57	3076700.0
2003-07-29 14:30:00	SPY	ETF	99.59	99.62	99.23	99.27	2173400.0
2003-07-29 15:00:00	SPY	ETF	99.27	99.47	99.09	99.35	2465800.0
2003-07-29 15:30:00	SPY	ETF	99.37	99.43	99.12	99.319	1821200.0
2003-07-29 16:00:00	SPY	ETF	99.329	99.46	99.26	99.45	1674500.0
2003-07-29 16:30:00	SPY	ETF	99.45	99.45	99.4	99.44	9000.0
2003-07-29 17:00:00	SPY	ETF	99.44	99.44	99.38	99.38	15700.0
2003-07-29 17:30:00	SPY	ETF	99.37	99.37	99.35	99.36	2700.0
2003-07-29 18:00:00	SPY	ETF	99.36	99.36	99.27	99.34	95900.0
2003-07-29 18:30:00	SPY	ETF	99.35	99.37	99.35	99.37	1100.0
2003-07-29 19:00:00	SPY	ETF	99.35	99.35	99.35	99.35	500.0
2003-07-29 19:30:00	SPY	ETF	99.35	99.4	99.35	99.4	200.0
2003-07-29 08:00:00	QQQ	ETF	31.96	31.96	31.93	31.95	38700.0
2003-07-29 08:30:00	QQQ	ETF	31.95	31.98	31.95	31.96	15300.0
2003-07-29 09:00:00	QQQ	ETF	31.97	31.98	31.94	31.94	24400.0
2003-07-29 09:30:00	QQQ	ETF	31.93	32.02	31.72	31.81	6121000.0
2003-07-29 10:00:00	QQQ	ETF	31.81	31.82	31.25	31.35	15578100.0
2003-07-29 10:30:00	QQQ	ETF	31.35	31.43	31.23	31.41	5367200.0
2003-07-29 11:00:00	QQQ	ETF	31.38	31.49	31.36	31.43	7243900.0
2003-07-29 11:30:00	QQQ	ETF	31.43	31.88	31.41	31.77	8127200.0
2003-07-29 12:00:00	QQQ	ETF	31.76	31.81	31.65	31.67	4201800.0
2003-07-29 12:30:00	QQQ	ETF	31.671	31.81	31.67	31.75	3167200.0
2003-07-29 13:00:00	QQQ	ETF	31.76	31.949	31.7	31.9	2468800.0
2003-07-29 13:30:00	QQQ	ETF	31.9	31.97	31.76	31.763	3767300.0
2003-07-29 14:00:00	QQQ	ETF	31.78	31.88	31.67	31.69	2739700.0
2003-07-29 14:30:00	QQQ	ETF	31.69	31.77	31.62	31.63	3570900.0
2003-07-29 15:00:00	QQQ	ETF	31.63	31.74	31.55	31.69	5131500.0
2003-07-29 15:30:00	QQQ	ETF	31.69	31.705	31.54	31.66	4793400.0
2003-07-29 16:00:00	QQQ	ETF	31.654	31.7	31.61	31.68	3368400.0
2003-07-29 16:30:00	QQQ	ETF	31.68	31.68	31.64	31.66	62300.0
2003-07-29 17:00:00	QQQ	ETF	31.65	31.65	31.63	31.64	45100.0
2003-07-29 17:30:00	QQQ	ETF	31.65	31.65	31.63	31.64	14200.0
2003-07-29 18:00:00	QQQ	ETF	31.628	31.649	31.621	31.649	26300.0
2003-07-29 18:30:00	QQQ	ETF	31.65	31.65	31.65	31.65	9700.0
2003-07-29 19:00:00	QQQ	ETF	31.65	31.66	31.64	31.66	9900.0
2003-07-29 19:30:00	QQQ	ETF	31.66	31.67	31.65	31.65	11500.0
2003-07-29 09:30:00	IWM	ETF	47.475	47.625	47.175	47.2	530000.0
2003-07-29 10:00:00	IWM	ETF	47.2	47.2	46.86	46.93	818000.0

> showing 50 of 666 rows — these rows as CSV

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