PREVIEW / etf_30min / 2006-07-03

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-03.parquet
  size:    47 KB
  rows:    1,502

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
2006-07-03 07:00:00	SPY	ETF	127.35	127.4	127.33	127.36	1700.0
2006-07-03 07:30:00	SPY	ETF	127.32	127.32	127.32	127.32	1500.0
2006-07-03 08:00:00	SPY	ETF	127.32	127.37	127.27	127.36	12500.0
2006-07-03 08:30:00	SPY	ETF	127.37	127.37	127.28	127.28	143400.0
2006-07-03 09:00:00	SPY	ETF	127.37	127.42	127.28	127.41	173400.0
2006-07-03 09:30:00	SPY	ETF	127.43	127.55	127.31	127.38	4651500.0
2006-07-03 10:00:00	SPY	ETF	127.38	127.5	127.33	127.45	2073300.0
2006-07-03 10:30:00	SPY	ETF	127.46	127.57	127.45	127.51	1986200.0
2006-07-03 11:00:00	SPY	ETF	127.52	127.74	127.52	127.68	3726100.0
2006-07-03 11:30:00	SPY	ETF	127.68	127.91	127.66	127.84	3044100.0
2006-07-03 12:00:00	SPY	ETF	127.84	127.95	127.84	127.9	2493200.0
2006-07-03 12:30:00	SPY	ETF	127.9	128.01	127.87	127.97	3281700.0
2006-07-03 13:00:00	SPY	ETF	127.97	127.97	127.8	127.8	1966500.0
2006-07-03 09:30:00	QQQ	ETF	38.88	38.92	38.81	38.86	6002300.0
2006-07-03 10:00:00	QQQ	ETF	38.86	38.87	38.82	38.83	1866700.0
2006-07-03 10:30:00	QQQ	ETF	38.84	38.86	38.83	38.84	1385200.0
2006-07-03 11:00:00	QQQ	ETF	38.84	38.89	38.84	38.87	1496400.0
2006-07-03 11:30:00	QQQ	ETF	38.87	38.95	38.86	38.92	2686700.0
2006-07-03 12:00:00	QQQ	ETF	38.92	38.96	38.91	38.93	1540100.0
2006-07-03 12:30:00	QQQ	ETF	38.94	39.0	38.93	38.99	3845600.0
2006-07-03 08:00:00	IWM	ETF	71.85	71.9	71.73	71.79	23500.0
2006-07-03 08:30:00	IWM	ETF	71.79	71.9	71.79	71.9	11900.0
2006-07-03 09:00:00	IWM	ETF	71.83	71.99	71.82	71.99	370800.0
2006-07-03 09:30:00	IWM	ETF	72.0	72.14	71.76	71.96	8417100.0
2006-07-03 10:00:00	IWM	ETF	71.95	72.14	71.87	72.1	3657700.0
2006-07-03 10:30:00	IWM	ETF	72.1	72.27	72.09	72.23	1657500.0
2006-07-03 11:00:00	IWM	ETF	72.24	72.45	72.23	72.3	1830600.0
2006-07-03 11:30:00	IWM	ETF	72.3	72.47	72.28	72.32	1567800.0
2006-07-03 12:00:00	IWM	ETF	72.33	72.42	72.3	72.36	1364500.0
2006-07-03 12:30:00	IWM	ETF	72.36	72.59	72.35	72.57	3044600.0
2006-07-03 13:00:00	IWM	ETF	72.56	72.63	72.47	72.63	138200.0
2006-07-03 08:00:00	DIA	ETF	111.84	111.84	111.84	111.84	500.0
2006-07-03 08:30:00	DIA	ETF	111.84	111.87	111.79	111.79	2600.0
2006-07-03 09:00:00	DIA	ETF	111.9	111.94	111.9	111.94	200.0
2006-07-03 09:30:00	DIA	ETF	111.95	112.08	111.86	112.01	202700.0
2006-07-03 10:00:00	DIA	ETF	112.0	112.03	111.93	111.968	119600.0
2006-07-03 10:30:00	DIA	ETF	111.97	111.99	111.87	111.87	126200.0
2006-07-03 11:00:00	DIA	ETF	111.87	112.02	111.87	111.98	138300.0
2006-07-03 11:30:00	DIA	ETF	111.99	112.17	111.98	112.15	119700.0
2006-07-03 12:00:00	DIA	ETF	112.17	112.23	112.15	112.18	141700.0
2006-07-03 12:30:00	DIA	ETF	112.18	112.25	112.16	112.2	182400.0
2006-07-03 13:00:00	DIA	ETF	112.2	112.21	112.17	112.2	10200.0
2006-07-03 07:30:00	GLD	ETF	61.97	62.01	61.97	62.01	1100.0
2006-07-03 08:00:00	GLD	ETF	62.0	62.18	61.17	62.18	28100.0
2006-07-03 08:30:00	GLD	ETF	62.17	62.25	61.94	61.95	81700.0
2006-07-03 09:00:00	GLD	ETF	61.97	62.0	61.83	61.96	74000.0
2006-07-03 09:30:00	GLD	ETF	61.96	62.1	61.96	62.06	837200.0
2006-07-03 10:00:00	GLD	ETF	62.06	62.1	61.88	62.06	622300.0
2006-07-03 10:30:00	GLD	ETF	62.06	62.21	62.06	62.18	347800.0
2006-07-03 11:00:00	GLD	ETF	62.19	62.22	62.11	62.16	260500.0

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

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