PREVIEW / etf_30min / 2001-06-18

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-06-18.parquet
  size:    15 KB
  rows:    367

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-06-18 09:30:00	SPY	ETF	121.65	122.04	121.39	121.4	1313100.0
2001-06-18 10:00:00	SPY	ETF	121.49	122.11	121.38	122.02	539300.0
2001-06-18 10:30:00	SPY	ETF	122.01	122.33	121.8	122.33	978300.0
2001-06-18 11:00:00	SPY	ETF	122.35	122.44	121.74	121.78	1219000.0
2001-06-18 11:30:00	SPY	ETF	121.68	121.83	121.43	121.45	433700.0
2001-06-18 12:00:00	SPY	ETF	121.49	121.6	121.23	121.58	293300.0
2001-06-18 12:30:00	SPY	ETF	121.55	121.64	121.26	121.43	413200.0
2001-06-18 13:00:00	SPY	ETF	121.36	121.8	121.36	121.55	269300.0
2001-06-18 13:30:00	SPY	ETF	121.54	121.79	121.4	121.67	154100.0
2001-06-18 14:00:00	SPY	ETF	121.69	121.79	121.32	121.58	119700.0
2001-06-18 14:30:00	SPY	ETF	121.48	121.61	121.02	121.15	347200.0
2001-06-18 15:00:00	SPY	ETF	121.06	121.35	121.05	121.15	162300.0
2001-06-18 15:30:00	SPY	ETF	121.11	121.25	120.95	121.08	708600.0
2001-06-18 16:00:00	SPY	ETF	121.02	121.45	120.91	121.45	494900.0
2001-06-18 16:30:00	SPY	ETF	121.15	121.25	121.15	121.25	600.0
2001-06-18 17:00:00	SPY	ETF	121.04	121.04	121.04	121.04	3209400.0
2001-06-18 17:30:00	SPY	ETF	121.39	121.39	121.39	121.39	500.0
2001-06-18 18:00:00	SPY	ETF	121.55	121.73	121.5	121.73	7800.0
2001-06-18 09:30:00	QQQ	ETF	42.64	43.17	42.16	42.24	10698800.0
2001-06-18 10:00:00	QQQ	ETF	42.24	42.5	41.89	42.4	7345600.0
2001-06-18 10:30:00	QQQ	ETF	42.4	42.73	42.18	42.73	5156900.0
2001-06-18 11:00:00	QQQ	ETF	42.73	42.8	42.2	42.2	3364900.0
2001-06-18 11:30:00	QQQ	ETF	42.25	42.5	42.08	42.2	2294000.0
2001-06-18 12:00:00	QQQ	ETF	42.15	42.26	41.97	42.07	2776700.0
2001-06-18 12:30:00	QQQ	ETF	42.08	42.2	41.86	41.95	2317500.0
2001-06-18 13:00:00	QQQ	ETF	41.98	42.3	41.93	42.09	2444900.0
2001-06-18 13:30:00	QQQ	ETF	42.08	42.25	41.83	42.05	2556500.0
2001-06-18 14:00:00	QQQ	ETF	42.05	42.24	41.84	41.99	3254700.0
2001-06-18 14:30:00	QQQ	ETF	41.99	42.05	41.45	41.52	5529400.0
2001-06-18 15:00:00	QQQ	ETF	41.59	41.76	41.4	41.45	3655600.0
2001-06-18 15:30:00	QQQ	ETF	41.45	41.65	41.43	41.58	4967600.0
2001-06-18 16:00:00	QQQ	ETF	41.58	42.39	41.46	41.95	3287500.0
2001-06-18 16:30:00	QQQ	ETF	41.95	42.19	41.9	42.15	504300.0
2001-06-18 17:00:00	QQQ	ETF	42.13	42.25	42.09	42.1	131500.0
2001-06-18 17:30:00	QQQ	ETF	42.1	42.25	42.06	42.25	327200.0
2001-06-18 18:00:00	QQQ	ETF	42.25	42.47	42.2	42.42	206200.0
2001-06-18 18:30:00	QQQ	ETF	42.4	42.4	42.4	42.4	200.0
2001-06-18 09:30:00	IWM	ETF	49.25	49.45	49.185	49.185	42800.0
2001-06-18 10:00:00	IWM	ETF	49.255	49.395	49.255	49.35	158800.0
2001-06-18 10:30:00	IWM	ETF	49.345	49.435	49.345	49.435	38200.0
2001-06-18 11:00:00	IWM	ETF	49.415	49.5	49.375	49.375	35200.0
2001-06-18 11:30:00	IWM	ETF	49.35	49.375	49.28	49.28	30200.0
2001-06-18 12:00:00	IWM	ETF	49.27	49.285	49.2	49.2	52800.0
2001-06-18 12:30:00	IWM	ETF	49.205	49.205	49.12	49.135	24200.0
2001-06-18 13:00:00	IWM	ETF	49.15	49.175	49.135	49.175	12600.0
2001-06-18 13:30:00	IWM	ETF	49.175	49.175	49.13	49.135	23000.0
2001-06-18 14:00:00	IWM	ETF	49.16	49.16	49.06	49.075	46400.0
2001-06-18 14:30:00	IWM	ETF	49.06	49.085	48.9	48.915	27800.0
2001-06-18 15:00:00	IWM	ETF	48.9	49.0	48.875	48.875	27200.0
2001-06-18 15:30:00	IWM	ETF	48.87	48.9	48.75	48.9	109600.0

> showing 50 of 367 rows — these rows as CSV

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