PREVIEW / etf_30min / 2001-08-27

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-08-27.parquet
  size:    15 KB
  rows:    378

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-08-27 09:30:00	SPY	ETF	118.97	119.04	118.72	118.85	1355400.0
2001-08-27 10:00:00	SPY	ETF	118.84	118.84	118.37	118.38	731200.0
2001-08-27 10:30:00	SPY	ETF	118.4	118.7	118.33	118.61	476700.0
2001-08-27 11:00:00	SPY	ETF	118.61	118.76	118.38	118.51	233800.0
2001-08-27 11:30:00	SPY	ETF	118.53	118.67	118.31	118.31	134500.0
2001-08-27 12:00:00	SPY	ETF	118.28	118.54	118.26	118.54	297500.0
2001-08-27 12:30:00	SPY	ETF	118.54	118.69	118.47	118.69	151000.0
2001-08-27 13:00:00	SPY	ETF	118.68	118.76	118.54	118.54	73500.0
2001-08-27 13:30:00	SPY	ETF	118.58	119.05	118.58	118.9	614700.0
2001-08-27 14:00:00	SPY	ETF	118.93	119.11	118.77	118.91	497800.0
2001-08-27 14:30:00	SPY	ETF	118.87	119.15	118.8	119.15	256500.0
2001-08-27 15:00:00	SPY	ETF	119.15	119.2	118.78	118.89	533500.0
2001-08-27 15:30:00	SPY	ETF	118.89	118.98	118.47	118.49	630500.0
2001-08-27 16:00:00	SPY	ETF	118.49	118.87	118.3	118.32	1424500.0
2001-08-27 09:30:00	QQQ	ETF	39.28	39.54	39.04	39.35	8521100.0
2001-08-27 10:00:00	QQQ	ETF	39.32	39.34	38.91	38.95	7708700.0
2001-08-27 10:30:00	QQQ	ETF	38.97	39.25	38.83	39.19	4288600.0
2001-08-27 11:00:00	QQQ	ETF	39.18	39.35	39.04	39.12	2473700.0
2001-08-27 11:30:00	QQQ	ETF	39.11	39.26	38.95	38.95	1766000.0
2001-08-27 12:00:00	QQQ	ETF	38.98	39.1	38.94	39.09	1005400.0
2001-08-27 12:30:00	QQQ	ETF	39.1	39.25	39.03	39.22	1570200.0
2001-08-27 13:00:00	QQQ	ETF	39.24	39.24	39.09	39.12	1162100.0
2001-08-27 13:30:00	QQQ	ETF	39.11	39.54	39.11	39.47	3445700.0
2001-08-27 14:00:00	QQQ	ETF	39.47	39.75	39.4	39.63	3755700.0
2001-08-27 14:30:00	QQQ	ETF	39.64	39.89	39.61	39.81	2916900.0
2001-08-27 15:00:00	QQQ	ETF	39.89	39.9	39.6	39.67	2733300.0
2001-08-27 15:30:00	QQQ	ETF	39.66	39.78	39.32	39.34	3562600.0
2001-08-27 16:00:00	QQQ	ETF	39.33	39.58	39.29	39.35	812600.0
2001-08-27 16:30:00	QQQ	ETF	39.35	39.39	39.2	39.2	97300.0
2001-08-27 17:00:00	QQQ	ETF	39.18	39.25	39.14	39.19	38900.0
2001-08-27 17:30:00	QQQ	ETF	39.2	39.35	39.18	39.23	16600.0
2001-08-27 18:00:00	QQQ	ETF	39.21	39.25	39.11	39.22	8700.0
2001-08-27 09:30:00	IWM	ETF	48.05	48.225	48.05	48.125	27400.0
2001-08-27 10:00:00	IWM	ETF	48.11	48.11	47.975	47.975	21400.0
2001-08-27 10:30:00	IWM	ETF	47.95	48.025	47.8	47.99	13400.0
2001-08-27 11:00:00	IWM	ETF	47.99	48.025	47.925	48.025	5400.0
2001-08-27 11:30:00	IWM	ETF	48.0	48.0	47.825	47.825	4800.0
2001-08-27 12:00:00	IWM	ETF	47.89	47.945	47.8	47.945	2600.0
2001-08-27 12:30:00	IWM	ETF	47.965	48.02	47.895	48.02	9000.0
2001-08-27 13:30:00	IWM	ETF	48.0	48.07	48.0	48.07	2800.0
2001-08-27 14:00:00	IWM	ETF	48.095	48.125	48.025	48.085	53200.0
2001-08-27 14:30:00	IWM	ETF	48.09	48.125	48.08	48.08	5000.0
2001-08-27 15:00:00	IWM	ETF	48.125	48.165	48.11	48.11	5800.0
2001-08-27 15:30:00	IWM	ETF	47.975	48.2	47.85	47.85	31200.0
2001-08-27 16:00:00	IWM	ETF	47.75	47.875	47.675	47.875	10200.0
2001-08-27 09:30:00	DIA	ETF	104.5	104.61	104.3	104.31	547400.0
2001-08-27 10:00:00	DIA	ETF	104.31	104.35	104.01	104.07	598800.0
2001-08-27 10:30:00	DIA	ETF	104.07	104.3	104.03	104.19	386400.0
2001-08-27 11:00:00	DIA	ETF	104.19	104.3	104.1	104.18	45700.0
2001-08-27 11:30:00	DIA	ETF	104.17	104.29	104.04	104.04	63100.0

> showing 50 of 378 rows — these rows as CSV

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