PREVIEW / etf_30min / 2001-10-05

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-10-05.parquet
  size:    16 KB
  rows:    413

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-10-05 09:30:00	SPY	ETF	107.25	107.38	106.43	106.45	3105700.0
2001-10-05 10:00:00	SPY	ETF	106.47	106.62	105.65	105.81	4620300.0
2001-10-05 10:30:00	SPY	ETF	105.76	106.1	105.52	105.78	4351500.0
2001-10-05 11:00:00	SPY	ETF	105.72	106.45	105.7	106.25	3072000.0
2001-10-05 11:30:00	SPY	ETF	106.3	106.78	106.3	106.41	1522600.0
2001-10-05 12:00:00	SPY	ETF	106.36	106.55	105.86	105.95	755000.0
2001-10-05 12:30:00	SPY	ETF	105.96	106.39	105.82	106.25	759800.0
2001-10-05 13:00:00	SPY	ETF	106.25	106.55	106.06	106.12	874800.0
2001-10-05 13:30:00	SPY	ETF	106.12	106.28	105.91	106.25	788000.0
2001-10-05 14:00:00	SPY	ETF	106.2	106.68	106.17	106.42	648800.0
2001-10-05 14:30:00	SPY	ETF	106.41	107.44	106.4	107.33	3023900.0
2001-10-05 15:00:00	SPY	ETF	107.3	107.4	106.82	106.84	1687500.0
2001-10-05 15:30:00	SPY	ETF	106.83	107.62	106.83	107.26	1905600.0
2001-10-05 16:00:00	SPY	ETF	107.26	108.3	106.89	106.97	2117500.0
2001-10-05 17:00:00	SPY	ETF	107.33	107.33	107.33	107.33	100.0
2001-10-05 09:30:00	QQQ	ETF	31.0	31.26	30.53	30.56	14625200.0
2001-10-05 10:00:00	QQQ	ETF	30.55	30.85	30.28	30.31	11055200.0
2001-10-05 10:30:00	QQQ	ETF	30.35	30.65	30.26	30.5	7371600.0
2001-10-05 11:00:00	QQQ	ETF	30.5	30.9	30.39	30.72	7273400.0
2001-10-05 11:30:00	QQQ	ETF	30.7	31.12	30.7	30.84	6433100.0
2001-10-05 12:00:00	QQQ	ETF	30.82	31.0	30.67	30.78	2355300.0
2001-10-05 12:30:00	QQQ	ETF	30.78	31.16	30.7	31.15	4906100.0
2001-10-05 13:00:00	QQQ	ETF	31.15	31.39	31.06	31.1	5513900.0
2001-10-05 13:30:00	QQQ	ETF	31.14	31.22	30.92	31.12	3160600.0
2001-10-05 14:00:00	QQQ	ETF	31.14	31.5	31.13	31.34	4764400.0
2001-10-05 14:30:00	QQQ	ETF	31.36	31.9	31.2	31.85	9476300.0
2001-10-05 15:00:00	QQQ	ETF	31.86	31.89	31.3	31.31	6308000.0
2001-10-05 15:30:00	QQQ	ETF	31.32	31.8	31.31	31.65	7184800.0
2001-10-05 16:00:00	QQQ	ETF	31.63	31.8	31.2	31.65	2962700.0
2001-10-05 16:30:00	QQQ	ETF	31.75	31.79	31.71	31.79	25900.0
2001-10-05 17:00:00	QQQ	ETF	31.71	31.74	31.68	31.7	17900.0
2001-10-05 17:30:00	QQQ	ETF	31.7	31.72	31.68	31.7	13100.0
2001-10-05 18:00:00	QQQ	ETF	31.68	31.74	31.68	31.7	4400.0
2001-10-05 09:30:00	IWM	ETF	41.45	41.45	40.965	40.99	19000.0
2001-10-05 10:00:00	IWM	ETF	40.84	40.875	40.74	40.795	32400.0
2001-10-05 10:30:00	IWM	ETF	40.52	40.605	40.505	40.55	44000.0
2001-10-05 11:00:00	IWM	ETF	40.67	40.825	40.67	40.8	11600.0
2001-10-05 11:30:00	IWM	ETF	40.795	40.9	40.785	40.86	18000.0
2001-10-05 12:00:00	IWM	ETF	40.745	40.79	40.555	40.63	26400.0
2001-10-05 12:30:00	IWM	ETF	40.64	40.77	40.61	40.745	176800.0
2001-10-05 13:00:00	IWM	ETF	40.83	40.875	40.715	40.86	8800.0
2001-10-05 13:30:00	IWM	ETF	40.86	40.925	40.77	40.895	36200.0
2001-10-05 14:00:00	IWM	ETF	40.9	41.045	40.9	41.025	15000.0
2001-10-05 14:30:00	IWM	ETF	41.025	41.4	41.025	41.32	30400.0
2001-10-05 15:00:00	IWM	ETF	41.425	41.425	41.175	41.265	45000.0
2001-10-05 15:30:00	IWM	ETF	41.36	41.43	41.27	41.37	19400.0
2001-10-05 16:00:00	IWM	ETF	41.275	41.3	41.275	41.3	14800.0
2001-10-05 09:30:00	DIA	ETF	90.5	91.0	90.3	90.33	1187000.0
2001-10-05 10:00:00	DIA	ETF	90.28	90.61	89.73	89.81	852700.0
2001-10-05 10:30:00	DIA	ETF	89.77	89.95	89.57	89.72	948600.0

> showing 50 of 413 rows — these rows as CSV

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