PREVIEW / etf_30min / 2001-03-15

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-03-15.parquet
  size:    14 KB
  rows:    341

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
2001-03-15 09:30:00	SPY	ETF	118.45	118.86	118.2	118.48	1592300.0
2001-03-15 10:00:00	SPY	ETF	118.42	118.62	118.01	118.55	1041500.0
2001-03-15 10:30:00	SPY	ETF	118.55	118.69	117.85	117.85	540200.0
2001-03-15 11:00:00	SPY	ETF	117.86	118.09	117.51	117.76	519600.0
2001-03-15 11:30:00	SPY	ETF	117.89	118.27	117.61	117.94	407200.0
2001-03-15 12:00:00	SPY	ETF	117.97	118.32	117.9	118.1	364600.0
2001-03-15 12:30:00	SPY	ETF	118.16	118.49	117.96	117.96	362400.0
2001-03-15 13:00:00	SPY	ETF	117.97	118.14	117.75	117.95	250900.0
2001-03-15 13:30:00	SPY	ETF	118.02	118.38	117.81	118.28	101700.0
2001-03-15 14:00:00	SPY	ETF	118.11	118.47	117.52	117.55	612600.0
2001-03-15 14:30:00	SPY	ETF	117.7	118.16	117.62	117.75	314900.0
2001-03-15 15:00:00	SPY	ETF	117.8	118.08	117.6	117.81	848300.0
2001-03-15 15:30:00	SPY	ETF	117.9	118.2	117.66	117.71	721300.0
2001-03-15 16:00:00	SPY	ETF	117.7	117.92	117.36	117.82	608000.0
2001-03-15 16:30:00	SPY	ETF	117.8	117.8	117.8	117.8	2000.0
2001-03-15 17:00:00	SPY	ETF	117.86	117.86	117.86	117.86	1460000.0
2001-03-15 17:30:00	SPY	ETF	118.42	118.42	117.99	117.99	200600.0
2001-03-15 09:30:00	QQQ	ETF	45.2	45.31	44.72	44.95	11883300.0
2001-03-15 10:00:00	QQQ	ETF	44.95	45.1	44.53	45.0	6501200.0
2001-03-15 10:30:00	QQQ	ETF	45.07	45.17	44.2	44.2	6703700.0
2001-03-15 11:00:00	QQQ	ETF	44.26	44.46	43.99	44.35	5406300.0
2001-03-15 11:30:00	QQQ	ETF	44.31	44.5	44.12	44.28	2510500.0
2001-03-15 12:00:00	QQQ	ETF	44.26	44.6	44.26	44.4	1985200.0
2001-03-15 12:30:00	QQQ	ETF	44.4	44.65	44.22	44.25	3820100.0
2001-03-15 13:00:00	QQQ	ETF	44.25	44.3	43.77	43.89	3129800.0
2001-03-15 13:30:00	QQQ	ETF	43.86	44.08	43.65	43.84	3452300.0
2001-03-15 14:00:00	QQQ	ETF	43.83	44.07	43.16	43.35	4028800.0
2001-03-15 14:30:00	QQQ	ETF	43.33	43.49	43.0	43.05	3359700.0
2001-03-15 15:00:00	QQQ	ETF	43.0	43.12	42.52	42.55	6030900.0
2001-03-15 15:30:00	QQQ	ETF	42.53	42.95	42.25	42.32	5610500.0
2001-03-15 16:00:00	QQQ	ETF	42.3	42.75	42.01	42.39	1717300.0
2001-03-15 16:30:00	QQQ	ETF	42.32	42.68	42.2	42.65	224300.0
2001-03-15 17:00:00	QQQ	ETF	42.65	43.0	42.57	42.75	886400.0
2001-03-15 17:30:00	QQQ	ETF	42.75	42.81	42.73	42.77	70800.0
2001-03-15 18:00:00	QQQ	ETF	42.75	42.9	42.6	42.85	54600.0
2001-03-15 09:30:00	IWM	ETF	45.525	45.675	45.475	45.615	13600.0
2001-03-15 10:00:00	IWM	ETF	45.7	45.7	45.3	45.3	17200.0
2001-03-15 10:30:00	IWM	ETF	45.4	45.57	45.4	45.55	1800.0
2001-03-15 11:00:00	IWM	ETF	45.2	45.265	45.05	45.1	25200.0
2001-03-15 11:30:00	IWM	ETF	45.18	45.18	45.18	45.18	200.0
2001-03-15 12:00:00	IWM	ETF	45.2	45.2	45.2	45.2	600.0
2001-03-15 12:30:00	IWM	ETF	45.3	45.425	45.3	45.325	92000.0
2001-03-15 13:00:00	IWM	ETF	45.255	45.255	45.125	45.125	4200.0
2001-03-15 13:30:00	IWM	ETF	45.05	45.1	45.05	45.1	12200.0
2001-03-15 14:00:00	IWM	ETF	45.325	45.325	45.1	45.1	1400.0
2001-03-15 14:30:00	IWM	ETF	45.25	45.35	45.2	45.24	258000.0
2001-03-15 15:00:00	IWM	ETF	45.0	45.2	44.9	45.05	71200.0
2001-03-15 15:30:00	IWM	ETF	44.9	44.965	44.75	44.825	61000.0
2001-03-15 16:00:00	IWM	ETF	44.85	44.85	44.85	44.85	15200.0
2001-03-15 09:30:00	DIA	ETF	101.24	101.32	100.5	100.82	593900.0

> showing 50 of 341 rows — these rows as CSV

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