PREVIEW / etf_30min / 2001-04-06

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-04-06.parquet
  size:    14 KB
  rows:    353

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-04-06 09:30:00	SPY	ETF	113.99	114.25	113.2	113.8	2586800.0
2001-04-06 10:00:00	SPY	ETF	113.79	113.9	112.84	113.28	1063200.0
2001-04-06 10:30:00	SPY	ETF	113.25	113.48	112.75	113.4	1260100.0
2001-04-06 11:00:00	SPY	ETF	113.49	113.75	113.19	113.72	571800.0
2001-04-06 11:30:00	SPY	ETF	113.64	114.09	113.29	114.0	1394100.0
2001-04-06 12:00:00	SPY	ETF	113.99	114.4	112.65	112.95	1542600.0
2001-04-06 12:30:00	SPY	ETF	112.88	113.04	112.15	112.9	1301000.0
2001-04-06 13:00:00	SPY	ETF	112.98	113.19	112.56	112.58	553000.0
2001-04-06 13:30:00	SPY	ETF	112.61	113.92	112.5	113.52	807200.0
2001-04-06 14:00:00	SPY	ETF	113.53	113.79	112.6	112.71	562600.0
2001-04-06 14:30:00	SPY	ETF	112.75	112.98	112.06	112.8	667700.0
2001-04-06 15:00:00	SPY	ETF	112.69	113.19	112.31	112.8	699400.0
2001-04-06 15:30:00	SPY	ETF	112.7	113.15	112.15	113.05	1056500.0
2001-04-06 16:00:00	SPY	ETF	113.15	113.43	112.95	113.3	713500.0
2001-04-06 09:30:00	QQQ	ETF	36.9	36.95	36.22	36.42	11061600.0
2001-04-06 10:00:00	QQQ	ETF	36.42	36.6	35.9	36.25	8121000.0
2001-04-06 10:30:00	QQQ	ETF	36.24	36.36	35.8	36.35	7157300.0
2001-04-06 11:00:00	QQQ	ETF	36.35	36.45	36.07	36.42	3927000.0
2001-04-06 11:30:00	QQQ	ETF	36.42	36.65	36.31	36.65	5444300.0
2001-04-06 12:00:00	QQQ	ETF	36.6	36.91	36.0	36.15	10576400.0
2001-04-06 12:30:00	QQQ	ETF	36.15	36.57	35.83	36.57	5004400.0
2001-04-06 13:00:00	QQQ	ETF	36.57	36.75	36.35	36.5	3343400.0
2001-04-06 13:30:00	QQQ	ETF	36.5	37.1	36.35	36.78	6016500.0
2001-04-06 14:00:00	QQQ	ETF	36.77	36.91	36.35	36.39	4021600.0
2001-04-06 14:30:00	QQQ	ETF	36.38	36.43	35.68	35.9	6039000.0
2001-04-06 15:00:00	QQQ	ETF	35.88	36.15	35.7	35.86	4444400.0
2001-04-06 15:30:00	QQQ	ETF	35.87	36.18	35.5	36.11	7238900.0
2001-04-06 16:00:00	QQQ	ETF	36.15	36.3	35.68	36.3	1195500.0
2001-04-06 16:30:00	QQQ	ETF	36.28	36.31	36.25	36.27	49200.0
2001-04-06 17:00:00	QQQ	ETF	36.25	36.31	36.1	36.29	13300.0
2001-04-06 17:30:00	QQQ	ETF	36.28	36.33	36.25	36.3	17700.0
2001-04-06 18:00:00	QQQ	ETF	36.35	36.4	36.25	36.37	8000.0
2001-04-06 09:30:00	IWM	ETF	43.75	43.75	43.4	43.45	70600.0
2001-04-06 10:00:00	IWM	ETF	43.475	43.475	43.25	43.425	72200.0
2001-04-06 10:30:00	IWM	ETF	43.49	43.6	43.49	43.6	19000.0
2001-04-06 11:00:00	IWM	ETF	43.7	43.7	43.7	43.7	200.0
2001-04-06 11:30:00	IWM	ETF	43.8	43.89	43.63	43.63	86200.0
2001-04-06 12:00:00	IWM	ETF	43.695	43.75	43.5	43.5	29800.0
2001-04-06 12:30:00	IWM	ETF	43.5	43.7	43.375	43.7	7400.0
2001-04-06 13:00:00	IWM	ETF	43.675	43.75	43.675	43.7	5200.0
2001-04-06 13:30:00	IWM	ETF	43.675	43.675	43.675	43.675	1000.0
2001-04-06 14:00:00	IWM	ETF	43.75	43.775	43.6	43.65	25400.0
2001-04-06 14:30:00	IWM	ETF	43.41	43.6	43.3	43.375	9800.0
2001-04-06 15:00:00	IWM	ETF	43.5	43.525	43.275	43.29	15000.0
2001-04-06 15:30:00	IWM	ETF	43.275	43.39	43.125	43.25	50600.0
2001-04-06 16:00:00	IWM	ETF	43.325	43.325	43.125	43.125	13000.0
2001-04-06 09:30:00	DIA	ETF	98.5	98.65	97.7	98.4	1247700.0
2001-04-06 10:00:00	DIA	ETF	98.39	98.4	97.45	97.75	709200.0
2001-04-06 10:30:00	DIA	ETF	97.75	97.9	97.29	97.8	269700.0
2001-04-06 11:00:00	DIA	ETF	97.82	98.08	97.7	98.0	232500.0

> showing 50 of 353 rows — these rows as CSV

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