PREVIEW / etf_30min / 2001-09-20

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-09-20.parquet
  size:    17 KB
  rows:    448

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-20 09:30:00	SPY	ETF	100.4	100.95	99.95	100.85	4488700.0
2001-09-20 10:00:00	SPY	ETF	100.68	101.17	99.75	99.76	4934300.0
2001-09-20 10:30:00	SPY	ETF	99.86	100.15	99.3	100.12	3566000.0
2001-09-20 11:00:00	SPY	ETF	100.1	100.5	99.83	100.05	3375800.0
2001-09-20 11:30:00	SPY	ETF	100.12	100.24	99.5	99.7	1544600.0
2001-09-20 12:00:00	SPY	ETF	99.75	100.06	98.8	99.45	2901100.0
2001-09-20 12:30:00	SPY	ETF	99.37	99.95	99.09	99.18	1143900.0
2001-09-20 13:00:00	SPY	ETF	99.06	99.65	99.06	99.54	737600.0
2001-09-20 13:30:00	SPY	ETF	99.55	100.4	99.35	100.35	1653300.0
2001-09-20 14:00:00	SPY	ETF	100.4	100.46	99.6	99.86	2293000.0
2001-09-20 14:30:00	SPY	ETF	99.83	100.1	99.45	99.76	992500.0
2001-09-20 15:00:00	SPY	ETF	99.75	100.04	99.5	99.63	1454800.0
2001-09-20 15:30:00	SPY	ETF	99.56	99.65	98.81	98.96	2669800.0
2001-09-20 16:00:00	SPY	ETF	98.95	99.7	98.6	98.71	2597700.0
2001-09-20 16:30:00	SPY	ETF	98.7	98.71	98.25	98.64	52700.0
2001-09-20 17:00:00	SPY	ETF	98.59	98.85	98.55	98.85	66100.0
2001-09-20 17:30:00	SPY	ETF	98.81	98.81	98.81	98.81	1600.0
2001-09-20 18:00:00	SPY	ETF	98.95	98.95	98.7	98.75	300.0
2001-09-20 09:30:00	QQQ	ETF	29.3	29.94	29.2	29.9	13433700.0
2001-09-20 10:00:00	QQQ	ETF	29.89	30.09	29.2	29.25	11554800.0
2001-09-20 10:30:00	QQQ	ETF	29.3	29.85	29.08	29.7	7773100.0
2001-09-20 11:00:00	QQQ	ETF	29.75	29.82	29.46	29.6	6266800.0
2001-09-20 11:30:00	QQQ	ETF	29.53	29.62	29.3	29.37	2124900.0
2001-09-20 12:00:00	QQQ	ETF	29.37	29.61	28.95	29.22	6926200.0
2001-09-20 12:30:00	QQQ	ETF	29.22	29.53	29.03	29.06	3580100.0
2001-09-20 13:00:00	QQQ	ETF	29.08	29.41	29.05	29.4	3799700.0
2001-09-20 13:30:00	QQQ	ETF	29.4	29.8	29.28	29.75	5353800.0
2001-09-20 14:00:00	QQQ	ETF	29.75	29.81	29.35	29.52	4560200.0
2001-09-20 14:30:00	QQQ	ETF	29.5	29.64	29.23	29.31	3608700.0
2001-09-20 15:00:00	QQQ	ETF	29.3	29.54	29.12	29.2	5628300.0
2001-09-20 15:30:00	QQQ	ETF	29.2	29.26	28.85	28.98	10886000.0
2001-09-20 16:00:00	QQQ	ETF	28.99	29.94	28.8	28.97	1598000.0
2001-09-20 16:30:00	QQQ	ETF	28.91	29.0	28.88	28.94	61300.0
2001-09-20 17:00:00	QQQ	ETF	28.95	28.98	28.9	28.98	26400.0
2001-09-20 17:30:00	QQQ	ETF	28.98	29.02	28.98	29.0	31800.0
2001-09-20 18:00:00	QQQ	ETF	29.04	29.15	28.96	28.96	10200.0
2001-09-20 09:30:00	IWM	ETF	39.55	39.62	39.255	39.565	18000.0
2001-09-20 10:00:00	IWM	ETF	39.625	39.625	39.45	39.45	11600.0
2001-09-20 10:30:00	IWM	ETF	39.1	39.25	38.95	39.15	93600.0
2001-09-20 11:00:00	IWM	ETF	39.15	39.375	39.1	39.25	9600.0
2001-09-20 11:30:00	IWM	ETF	39.25	39.25	38.975	38.975	2600.0
2001-09-20 12:00:00	IWM	ETF	39.175	39.175	38.7	38.95	1800.0
2001-09-20 12:30:00	IWM	ETF	38.7	38.7	38.7	38.7	1000.0
2001-09-20 13:00:00	IWM	ETF	38.7	38.75	38.605	38.75	102000.0
2001-09-20 13:30:00	IWM	ETF	38.75	38.75	38.68	38.75	26400.0
2001-09-20 14:00:00	IWM	ETF	39.0	39.0	38.75	38.755	125400.0
2001-09-20 14:30:00	IWM	ETF	38.9	38.9	38.8	38.8	9200.0
2001-09-20 15:00:00	IWM	ETF	38.8	38.875	38.61	38.61	201800.0
2001-09-20 15:30:00	IWM	ETF	38.7	38.7	38.3	38.555	106400.0
2001-09-20 09:30:00	DIA	ETF	86.5	86.9	85.85	86.35	1278600.0

> showing 50 of 448 rows — these rows as CSV

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