PREVIEW / etf_30min / 2001-03-27

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-03-27.parquet
  size:    15 KB
  rows:    367

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-27 09:30:00	SPY	ETF	115.62	116.0	115.28	115.93	1529500.0
2001-03-27 10:00:00	SPY	ETF	115.88	116.49	115.52	116.4	1872600.0
2001-03-27 10:30:00	SPY	ETF	116.42	117.5	116.4	117.16	1540500.0
2001-03-27 11:00:00	SPY	ETF	117.16	117.35	116.85	117.07	767200.0
2001-03-27 11:30:00	SPY	ETF	117.05	117.38	116.85	117.12	497300.0
2001-03-27 12:00:00	SPY	ETF	117.05	117.57	117.05	117.55	586900.0
2001-03-27 12:30:00	SPY	ETF	117.55	117.93	117.44	117.71	822300.0
2001-03-27 13:00:00	SPY	ETF	117.72	117.83	117.51	117.79	325700.0
2001-03-27 13:30:00	SPY	ETF	117.76	117.84	117.32	117.4	469900.0
2001-03-27 14:00:00	SPY	ETF	117.48	117.84	117.3	117.43	477800.0
2001-03-27 14:30:00	SPY	ETF	117.4	117.99	117.29	117.48	749100.0
2001-03-27 15:00:00	SPY	ETF	117.4	118.25	117.37	118.07	717000.0
2001-03-27 15:30:00	SPY	ETF	118.07	118.65	117.92	118.37	1419200.0
2001-03-27 16:00:00	SPY	ETF	118.54	118.54	117.06	118.26	585300.0
2001-03-27 16:30:00	SPY	ETF	118.25	118.25	117.5	117.75	7200.0
2001-03-27 17:00:00	SPY	ETF	117.75	117.79	117.56	117.6	8500.0
2001-03-27 17:30:00	SPY	ETF	117.6	117.6	117.42	117.54	2200.0
2001-03-27 18:00:00	SPY	ETF	117.43	117.54	117.43	117.47	800.0
2001-03-27 09:30:00	QQQ	ETF	41.8	42.1	41.42	41.9	6911600.0
2001-03-27 10:00:00	QQQ	ETF	41.9	42.81	41.8	42.75	8974600.0
2001-03-27 10:30:00	QQQ	ETF	42.77	43.69	42.73	43.4	7870200.0
2001-03-27 11:00:00	QQQ	ETF	43.39	43.6	43.17	43.22	5227700.0
2001-03-27 11:30:00	QQQ	ETF	43.22	43.4	42.98	43.31	5666600.0
2001-03-27 12:00:00	QQQ	ETF	43.3	43.5	43.0	43.49	2540100.0
2001-03-27 12:30:00	QQQ	ETF	43.46	43.71	43.35	43.39	3200700.0
2001-03-27 13:00:00	QQQ	ETF	43.4	43.45	43.11	43.3	2547100.0
2001-03-27 13:30:00	QQQ	ETF	43.3	43.33	42.85	42.9	2817400.0
2001-03-27 14:00:00	QQQ	ETF	42.9	43.4	42.81	43.05	2574900.0
2001-03-27 14:30:00	QQQ	ETF	43.06	43.35	42.69	42.72	4291500.0
2001-03-27 15:00:00	QQQ	ETF	42.7	43.08	42.57	43.0	4636500.0
2001-03-27 15:30:00	QQQ	ETF	42.93	43.33	42.74	43.25	6736700.0
2001-03-27 16:00:00	QQQ	ETF	43.2	43.3	42.9	43.25	2724700.0
2001-03-27 16:30:00	QQQ	ETF	43.29	43.29	42.6	42.65	382700.0
2001-03-27 17:00:00	QQQ	ETF	42.65	43.25	42.6	42.7	223100.0
2001-03-27 17:30:00	QQQ	ETF	42.66	42.7	42.2	42.53	519300.0
2001-03-27 18:00:00	QQQ	ETF	42.5	42.59	42.44	42.59	36400.0
2001-03-27 09:30:00	IWM	ETF	44.8	44.8	44.25	44.375	62000.0
2001-03-27 10:00:00	IWM	ETF	44.35	44.5	44.05	44.325	5600.0
2001-03-27 10:30:00	IWM	ETF	44.44	44.95	44.385	44.925	301800.0
2001-03-27 11:00:00	IWM	ETF	44.8	44.85	44.7	44.85	11600.0
2001-03-27 11:30:00	IWM	ETF	44.825	44.825	44.675	44.7	21200.0
2001-03-27 12:00:00	IWM	ETF	44.65	44.85	44.65	44.85	4600.0
2001-03-27 12:30:00	IWM	ETF	44.925	44.925	44.75	44.8	81000.0
2001-03-27 13:00:00	IWM	ETF	44.625	44.845	44.625	44.7	19400.0
2001-03-27 13:30:00	IWM	ETF	44.665	44.7	44.625	44.625	5800.0
2001-03-27 14:30:00	IWM	ETF	44.92	44.92	44.725	44.75	57200.0
2001-03-27 15:00:00	IWM	ETF	44.925	45.0	44.705	45.0	16600.0
2001-03-27 15:30:00	IWM	ETF	44.97	45.3	44.97	45.085	45600.0
2001-03-27 09:30:00	DIA	ETF	96.7	97.15	96.4	96.98	738500.0
2001-03-27 10:00:00	DIA	ETF	97.0	97.5	96.6	97.37	717000.0

> showing 50 of 367 rows — these rows as CSV

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