PREVIEW / etf_30min / 2001-03-13

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-03-13.parquet
  size:    15 KB
  rows:    365

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-13 09:30:00	SPY	ETF	119.4	119.4	118.0	118.35	3113400.0
2001-03-13 10:00:00	SPY	ETF	118.36	119.5	118.05	118.71	1502100.0
2001-03-13 10:30:00	SPY	ETF	118.85	119.08	118.26	118.78	492900.0
2001-03-13 11:00:00	SPY	ETF	118.71	118.75	117.9	118.1	676200.0
2001-03-13 11:30:00	SPY	ETF	118.09	118.21	117.53	117.9	1090700.0
2001-03-13 12:00:00	SPY	ETF	117.96	118.46	117.77	118.25	473100.0
2001-03-13 12:30:00	SPY	ETF	118.24	118.52	117.8	118.15	348100.0
2001-03-13 13:00:00	SPY	ETF	118.15	119.38	118.1	118.97	809000.0
2001-03-13 13:30:00	SPY	ETF	118.99	119.18	118.6	118.69	418900.0
2001-03-13 14:00:00	SPY	ETF	118.73	119.48	118.48	119.44	351900.0
2001-03-13 14:30:00	SPY	ETF	119.26	119.64	118.75	119.6	334600.0
2001-03-13 15:00:00	SPY	ETF	119.65	120.2	119.57	120.1	1290900.0
2001-03-13 15:30:00	SPY	ETF	120.16	120.44	119.84	120.2	871000.0
2001-03-13 16:00:00	SPY	ETF	120.18	120.38	119.75	119.75	465000.0
2001-03-13 17:00:00	SPY	ETF	120.16	120.21	120.16	120.21	4000.0
2001-03-13 18:00:00	SPY	ETF	120.16	120.25	120.16	120.25	800.0
2001-03-13 09:30:00	QQQ	ETF	42.78	43.25	42.13	42.6	12035100.0
2001-03-13 10:00:00	QQQ	ETF	42.55	43.67	42.48	43.19	8066800.0
2001-03-13 10:30:00	QQQ	ETF	43.21	43.56	42.95	43.2	3741900.0
2001-03-13 11:00:00	QQQ	ETF	43.21	43.22	42.55	42.72	3722000.0
2001-03-13 11:30:00	QQQ	ETF	42.72	42.85	42.37	42.74	3611200.0
2001-03-13 12:00:00	QQQ	ETF	42.68	43.25	42.64	43.06	6728700.0
2001-03-13 12:30:00	QQQ	ETF	43.02	43.25	42.74	43.0	1896400.0
2001-03-13 13:00:00	QQQ	ETF	43.07	43.92	42.96	43.68	7012300.0
2001-03-13 13:30:00	QQQ	ETF	43.7	43.84	43.38	43.54	3351800.0
2001-03-13 14:00:00	QQQ	ETF	43.53	43.84	43.1	43.65	3084200.0
2001-03-13 14:30:00	QQQ	ETF	43.59	43.97	43.24	43.9	4237900.0
2001-03-13 15:00:00	QQQ	ETF	43.93	44.53	43.85	44.34	8351400.0
2001-03-13 15:30:00	QQQ	ETF	44.37	44.71	44.18	44.68	8504400.0
2001-03-13 16:00:00	QQQ	ETF	44.54	44.68	43.63	44.58	1860600.0
2001-03-13 16:30:00	QQQ	ETF	44.6	44.8	44.5	44.77	288400.0
2001-03-13 17:00:00	QQQ	ETF	44.72	44.95	44.7	44.9	50800.0
2001-03-13 17:30:00	QQQ	ETF	44.88	45.0	44.81	44.95	18800.0
2001-03-13 18:00:00	QQQ	ETF	44.99	45.1	44.85	45.06	22400.0
2001-03-13 09:30:00	IWM	ETF	45.9	45.9	45.4	45.5	96800.0
2001-03-13 10:00:00	IWM	ETF	45.625	45.725	45.5	45.725	103200.0
2001-03-13 10:30:00	IWM	ETF	45.7	45.7	45.5	45.555	10600.0
2001-03-13 11:00:00	IWM	ETF	45.475	45.475	45.325	45.355	71400.0
2001-03-13 11:30:00	IWM	ETF	45.35	45.35	45.15	45.2	5400.0
2001-03-13 12:00:00	IWM	ETF	45.035	45.2	45.005	45.195	28600.0
2001-03-13 12:30:00	IWM	ETF	45.225	45.225	45.05	45.19	17200.0
2001-03-13 13:00:00	IWM	ETF	45.195	45.375	45.195	45.35	7000.0
2001-03-13 13:30:00	IWM	ETF	45.315	45.315	45.175	45.175	1600.0
2001-03-13 14:00:00	IWM	ETF	45.175	45.175	45.1	45.1	600.0
2001-03-13 14:30:00	IWM	ETF	45.28	45.585	45.28	45.585	9200.0
2001-03-13 15:00:00	IWM	ETF	45.4	45.85	45.4	45.85	32200.0
2001-03-13 15:30:00	IWM	ETF	46.05	46.1	45.9	46.1	137000.0
2001-03-13 09:30:00	DIA	ETF	102.55	102.76	101.56	101.75	1737600.0
2001-03-13 10:00:00	DIA	ETF	101.87	102.8	101.6	102.21	760700.0
2001-03-13 10:30:00	DIA	ETF	102.42	102.5	101.92	102.37	292000.0

> showing 50 of 365 rows — these rows as CSV

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