PREVIEW / etf_30min / 2001-06-29

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-06-29.parquet
  size:    15 KB
  rows:    385

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-06-29 09:30:00	SPY	ETF	122.8	123.09	122.26	122.96	1151300.0
2001-06-29 10:00:00	SPY	ETF	122.86	123.69	122.84	123.57	1389300.0
2001-06-29 10:30:00	SPY	ETF	123.51	123.57	123.18	123.22	703800.0
2001-06-29 11:00:00	SPY	ETF	123.26	123.38	123.0	123.1	499900.0
2001-06-29 11:30:00	SPY	ETF	123.1	123.52	122.95	123.48	381300.0
2001-06-29 12:00:00	SPY	ETF	123.45	123.78	123.39	123.5	289200.0
2001-06-29 12:30:00	SPY	ETF	123.57	123.64	123.3	123.59	475500.0
2001-06-29 13:00:00	SPY	ETF	123.61	123.84	123.53	123.65	575600.0
2001-06-29 13:30:00	SPY	ETF	123.74	124.0	123.59	123.74	531200.0
2001-06-29 14:00:00	SPY	ETF	123.7	123.85	123.5	123.59	528200.0
2001-06-29 14:30:00	SPY	ETF	123.63	124.01	123.59	123.65	575500.0
2001-06-29 15:00:00	SPY	ETF	123.7	123.97	123.45	123.54	609400.0
2001-06-29 15:30:00	SPY	ETF	123.69	123.69	123.0	123.2	786000.0
2001-06-29 16:00:00	SPY	ETF	123.05	123.48	122.95	123.3	572300.0
2001-06-29 16:30:00	SPY	ETF	123.35	123.38	122.65	122.75	54600.0
2001-06-29 17:00:00	SPY	ETF	122.65	122.78	122.6	122.78	46500.0
2001-06-29 09:30:00	QQQ	ETF	45.09	45.64	44.7	45.47	9791900.0
2001-06-29 10:00:00	QQQ	ETF	45.46	46.05	45.44	45.81	8437000.0
2001-06-29 10:30:00	QQQ	ETF	45.8	45.93	45.56	45.63	3362700.0
2001-06-29 11:00:00	QQQ	ETF	45.64	45.78	45.49	45.55	2429700.0
2001-06-29 11:30:00	QQQ	ETF	45.58	45.88	45.42	45.82	2663800.0
2001-06-29 12:00:00	QQQ	ETF	45.84	45.96	45.7	45.79	2070300.0
2001-06-29 12:30:00	QQQ	ETF	45.79	45.96	45.65	45.93	1799700.0
2001-06-29 13:00:00	QQQ	ETF	45.92	46.28	45.9	46.21	4439200.0
2001-06-29 13:30:00	QQQ	ETF	46.2	46.52	46.16	46.29	5074700.0
2001-06-29 14:00:00	QQQ	ETF	46.27	46.35	45.97	46.0	4275200.0
2001-06-29 14:30:00	QQQ	ETF	46.07	46.3	45.82	46.0	3189800.0
2001-06-29 15:00:00	QQQ	ETF	46.0	46.33	45.9	46.12	2347900.0
2001-06-29 15:30:00	QQQ	ETF	46.18	46.21	45.75	46.0	4834600.0
2001-06-29 16:00:00	QQQ	ETF	45.99	46.39	45.91	45.94	1576700.0
2001-06-29 16:30:00	QQQ	ETF	45.92	45.95	45.54	45.65	556800.0
2001-06-29 17:00:00	QQQ	ETF	45.7	45.85	45.7	45.7	242100.0
2001-06-29 09:30:00	IWM	ETF	50.45	50.675	50.225	50.675	140400.0
2001-06-29 10:00:00	IWM	ETF	50.675	50.9	50.625	50.84	265200.0
2001-06-29 10:30:00	IWM	ETF	50.85	50.85	50.75	50.75	31000.0
2001-06-29 11:00:00	IWM	ETF	50.8	50.825	50.65	50.7	22600.0
2001-06-29 11:30:00	IWM	ETF	50.71	50.88	50.605	50.88	21400.0
2001-06-29 12:00:00	IWM	ETF	50.88	51.03	50.755	51.0	27000.0
2001-06-29 12:30:00	IWM	ETF	51.025	51.05	50.96	50.96	12000.0
2001-06-29 13:00:00	IWM	ETF	51.025	51.1	50.975	51.1	8600.0
2001-06-29 13:30:00	IWM	ETF	51.05	51.2	51.005	51.025	54000.0
2001-06-29 14:00:00	IWM	ETF	51.05	51.05	50.75	50.85	137800.0
2001-06-29 14:30:00	IWM	ETF	50.85	51.05	50.85	50.9	90400.0
2001-06-29 15:00:00	IWM	ETF	50.9	51.075	50.755	51.0	108200.0
2001-06-29 15:30:00	IWM	ETF	50.98	50.98	50.46	50.85	273200.0
2001-06-29 16:00:00	IWM	ETF	51.0	51.1	50.675	50.675	88600.0
2001-06-29 16:30:00	IWM	ETF	50.675	50.7	50.625	50.7	25600.0
2001-06-29 17:00:00	IWM	ETF	50.85	50.95	50.75	50.95	953200.0
2001-06-29 09:30:00	DIA	ETF	105.85	105.85	105.38	105.73	238500.0
2001-06-29 10:00:00	DIA	ETF	105.73	106.2	105.72	106.09	365900.0

> showing 50 of 385 rows — these rows as CSV

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