PREVIEW / etf_30min / 2001-09-25

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-09-25.parquet
  size:    17 KB
  rows:    429

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-09-25 09:30:00	SPY	ETF	100.75	101.34	100.42	101.3	3291600.0
2001-09-25 10:00:00	SPY	ETF	101.2	102.0	100.2	101.6	3874200.0
2001-09-25 10:30:00	SPY	ETF	101.55	101.87	101.32	101.37	1734800.0
2001-09-25 11:00:00	SPY	ETF	101.41	101.83	101.2	101.62	1750200.0
2001-09-25 11:30:00	SPY	ETF	101.68	101.98	101.54	101.54	1763800.0
2001-09-25 12:00:00	SPY	ETF	101.51	101.55	100.69	100.9	1434300.0
2001-09-25 12:30:00	SPY	ETF	100.82	100.95	100.5	100.79	1022700.0
2001-09-25 13:00:00	SPY	ETF	100.79	100.98	100.36	100.48	969500.0
2001-09-25 13:30:00	SPY	ETF	100.55	100.6	100.0	100.29	1393800.0
2001-09-25 14:00:00	SPY	ETF	100.3	100.5	99.9	100.42	1696400.0
2001-09-25 14:30:00	SPY	ETF	100.5	101.0	100.28	100.9	1525600.0
2001-09-25 15:00:00	SPY	ETF	100.9	101.35	100.69	100.9	1544500.0
2001-09-25 15:30:00	SPY	ETF	100.9	101.49	100.88	101.48	1787300.0
2001-09-25 16:00:00	SPY	ETF	101.4	101.8	101.4	101.5	665200.0
2001-09-25 16:30:00	SPY	ETF	101.77	101.82	101.0	101.7	2400.0
2001-09-25 17:00:00	SPY	ETF	101.72	101.72	101.62	101.62	1400.0
2001-09-25 09:30:00	QQQ	ETF	29.71	30.0	29.44	29.99	9936300.0
2001-09-25 10:00:00	QQQ	ETF	29.98	30.43	29.5	30.1	13528800.0
2001-09-25 10:30:00	QQQ	ETF	30.1	30.17	29.81	29.82	5760300.0
2001-09-25 11:00:00	QQQ	ETF	29.82	30.17	29.76	30.03	4214400.0
2001-09-25 11:30:00	QQQ	ETF	30.09	30.13	29.84	29.86	2720000.0
2001-09-25 12:00:00	QQQ	ETF	29.86	29.88	29.36	29.45	6982000.0
2001-09-25 12:30:00	QQQ	ETF	29.44	29.55	29.26	29.53	8072600.0
2001-09-25 13:00:00	QQQ	ETF	29.51	29.6	29.25	29.28	3957600.0
2001-09-25 13:30:00	QQQ	ETF	29.29	29.33	29.0	29.14	5711300.0
2001-09-25 14:00:00	QQQ	ETF	29.15	29.31	28.95	29.25	4072200.0
2001-09-25 14:30:00	QQQ	ETF	29.28	29.48	29.15	29.4	4798400.0
2001-09-25 15:00:00	QQQ	ETF	29.45	29.64	29.29	29.37	5065300.0
2001-09-25 15:30:00	QQQ	ETF	29.37	29.66	29.35	29.5	4474900.0
2001-09-25 16:00:00	QQQ	ETF	29.55	29.74	29.3	29.56	1970600.0
2001-09-25 16:30:00	QQQ	ETF	29.74	29.74	29.35	29.7	33400.0
2001-09-25 17:00:00	QQQ	ETF	29.7	29.73	29.65	29.72	41700.0
2001-09-25 17:30:00	QQQ	ETF	29.69	29.73	29.68	29.7	15300.0
2001-09-25 18:00:00	QQQ	ETF	29.7	29.7	29.6	29.6	13600.0
2001-09-25 09:30:00	IWM	ETF	39.12	39.425	39.12	39.225	66800.0
2001-09-25 10:00:00	IWM	ETF	39.2	39.55	38.875	39.275	152200.0
2001-09-25 10:30:00	IWM	ETF	39.25	39.5	39.25	39.49	62600.0
2001-09-25 11:00:00	IWM	ETF	39.37	39.6	39.255	39.59	244000.0
2001-09-25 11:30:00	IWM	ETF	39.6	39.75	39.545	39.565	76600.0
2001-09-25 12:00:00	IWM	ETF	39.55	39.56	39.35	39.44	5600.0
2001-09-25 12:30:00	IWM	ETF	39.275	39.375	39.255	39.26	7000.0
2001-09-25 13:00:00	IWM	ETF	39.375	39.445	39.3	39.3	5400.0
2001-09-25 13:30:00	IWM	ETF	39.305	39.425	39.25	39.325	25400.0
2001-09-25 14:00:00	IWM	ETF	39.325	39.395	39.16	39.305	7400.0
2001-09-25 14:30:00	IWM	ETF	39.33	39.425	39.33	39.335	9400.0
2001-09-25 15:00:00	IWM	ETF	39.43	39.65	39.355	39.355	75600.0
2001-09-25 15:30:00	IWM	ETF	39.45	39.545	39.45	39.5	125000.0
2001-09-25 16:00:00	IWM	ETF	39.475	39.475	39.475	39.475	200.0
2001-09-25 09:30:00	DIA	ETF	86.25	86.45	85.6	86.4	1626100.0
2001-09-25 10:00:00	DIA	ETF	86.4	87.2	85.7	86.71	1093700.0

> showing 50 of 429 rows — these rows as CSV

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