PREVIEW / etf_30min / 2005-06-24

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-06-24.parquet
  size:    45 KB
  rows:    1,606

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-06-24 06:30:00	SPY	ETF	119.91	119.91	119.91	119.91	500.0
2005-06-24 07:30:00	SPY	ETF	119.94	119.99	119.92	119.97	26400.0
2005-06-24 08:00:00	SPY	ETF	119.96	120.05	119.96	120.02	108800.0
2005-06-24 08:30:00	SPY	ETF	120.03	120.08	119.92	119.92	272300.0
2005-06-24 09:00:00	SPY	ETF	119.91	119.93	119.82	119.86	449900.0
2005-06-24 09:30:00	SPY	ETF	119.88	119.92	119.69	119.86	6025800.0
2005-06-24 10:00:00	SPY	ETF	119.862	119.96	119.58	119.6	6319500.0
2005-06-24 10:30:00	SPY	ETF	119.62	119.9	119.57	119.78	3990800.0
2005-06-24 11:00:00	SPY	ETF	119.79	119.99	119.75	119.85	3788700.0
2005-06-24 11:30:00	SPY	ETF	119.85	120.0078	119.55	119.65	3129200.0
2005-06-24 12:00:00	SPY	ETF	119.65	119.83	119.57	119.71	2717600.0
2005-06-24 12:30:00	SPY	ETF	119.71	119.79	119.64	119.67	1166100.0
2005-06-24 13:00:00	SPY	ETF	119.68	119.75	119.54	119.62	3073100.0
2005-06-24 13:30:00	SPY	ETF	119.62	119.66	119.32	119.39	5430200.0
2005-06-24 14:00:00	SPY	ETF	119.39	119.45	119.25	119.36	3779600.0
2005-06-24 14:30:00	SPY	ETF	119.37	119.51	119.16	119.27	3369000.0
2005-06-24 15:00:00	SPY	ETF	119.27	119.4	119.1	119.4	4224700.0
2005-06-24 15:30:00	SPY	ETF	119.4	119.51	119.05	119.09	6115000.0
2005-06-24 16:00:00	SPY	ETF	119.08	119.15	118.84	119.08	2545900.0
2005-06-24 16:30:00	SPY	ETF	119.08	119.19	119.0	119.06	560000.0
2005-06-24 17:00:00	SPY	ETF	119.06	119.06	119.01	119.06	9100.0
2005-06-24 17:30:00	SPY	ETF	119.09	119.09	119.05	119.05	4200.0
2005-06-24 18:00:00	SPY	ETF	119.03	119.03	119.03	119.03	700.0
2005-06-24 18:30:00	SPY	ETF	119.02	119.02	119.02	119.02	200.0
2005-06-24 19:00:00	SPY	ETF	119.09	119.13	119.09	119.1	3500.0
2005-06-24 19:30:00	SPY	ETF	119.1	119.1	119.1	119.1	600.0
2005-06-24 09:30:00	QQQ	ETF	37.38	37.41	37.26	37.37	9246900.0
2005-06-24 10:00:00	QQQ	ETF	37.37	37.41	37.19	37.19	7235600.0
2005-06-24 10:30:00	QQQ	ETF	37.2	37.28	37.1	37.16	9388500.0
2005-06-24 11:00:00	QQQ	ETF	37.16	37.28	37.15	37.22	4509200.0
2005-06-24 11:30:00	QQQ	ETF	37.22	37.23	37.11	37.15	4321600.0
2005-06-24 12:00:00	QQQ	ETF	37.16	37.21	37.11	37.17	3097400.0
2005-06-24 12:30:00	QQQ	ETF	37.17	37.2	37.16	37.17	1307800.0
2005-06-24 13:00:00	QQQ	ETF	37.18	37.18	37.09	37.15	3385700.0
2005-06-24 13:30:00	QQQ	ETF	37.15	37.16	37.02	37.08	6936600.0
2005-06-24 14:00:00	QQQ	ETF	37.08	37.1	37.03	37.07	3376900.0
2005-06-24 14:30:00	QQQ	ETF	37.08	37.15	37.0	37.03	5183900.0
2005-06-24 15:00:00	QQQ	ETF	37.03	37.08	36.96	37.07	68093400.0
2005-06-24 15:30:00	QQQ	ETF	37.07	37.11	36.96	36.96	10138100.0
2005-06-24 07:30:00	IWM	ETF	62.91	62.96	62.91	62.96	9100.0
2005-06-24 08:00:00	IWM	ETF	62.97	62.97	62.94	62.94	16000.0
2005-06-24 08:30:00	IWM	ETF	62.93	62.93	62.89	62.9	5000.0
2005-06-24 09:00:00	IWM	ETF	62.89	62.89	62.86	62.87	25000.0
2005-06-24 09:30:00	IWM	ETF	62.94	63.02	62.74	62.76	2405000.0
2005-06-24 10:00:00	IWM	ETF	62.76	62.83	62.48	62.494	1348700.0
2005-06-24 10:30:00	IWM	ETF	62.5	62.64	62.42	62.54	1716800.0
2005-06-24 11:00:00	IWM	ETF	62.55	62.67	62.54	62.58	1079800.0
2005-06-24 11:30:00	IWM	ETF	62.57	62.6	62.37	62.4	2135000.0
2005-06-24 12:00:00	IWM	ETF	62.39	62.51	62.37	62.44	1091700.0
2005-06-24 12:30:00	IWM	ETF	62.46	62.49	62.42	62.46	603200.0

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

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