PREVIEW / etf_30min / 2001-07-10

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-07-10.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-07-10 09:30:00	SPY	ETF	120.29	120.64	120.26	120.35	999500.0
2001-07-10 10:00:00	SPY	ETF	120.26	120.35	119.64	119.91	674000.0
2001-07-10 10:30:00	SPY	ETF	119.91	120.13	119.71	119.74	276800.0
2001-07-10 11:00:00	SPY	ETF	119.78	119.9	119.37	119.48	615900.0
2001-07-10 11:30:00	SPY	ETF	119.5	119.67	119.25	119.59	302400.0
2001-07-10 12:00:00	SPY	ETF	119.59	119.81	119.5	119.74	195200.0
2001-07-10 12:30:00	SPY	ETF	119.72	119.84	119.5	119.5	275000.0
2001-07-10 13:00:00	SPY	ETF	119.5	119.52	119.26	119.34	262700.0
2001-07-10 13:30:00	SPY	ETF	119.34	119.4	118.85	118.92	895200.0
2001-07-10 14:00:00	SPY	ETF	118.88	119.09	118.74	118.94	538900.0
2001-07-10 14:30:00	SPY	ETF	118.99	119.16	118.62	118.66	735300.0
2001-07-10 15:00:00	SPY	ETF	118.68	118.89	118.46	118.5	869700.0
2001-07-10 15:30:00	SPY	ETF	118.5	118.61	118.21	118.35	1364200.0
2001-07-10 16:00:00	SPY	ETF	118.35	118.55	118.23	118.26	424400.0
2001-07-10 16:30:00	SPY	ETF	118.2	118.47	118.18	118.47	5700.0
2001-07-10 17:00:00	SPY	ETF	118.18	118.35	118.18	118.18	800.0
2001-07-10 18:00:00	SPY	ETF	118.36	118.97	118.36	118.97	1200.0
2001-07-10 09:30:00	QQQ	ETF	42.76	42.88	42.38	42.38	7536600.0
2001-07-10 10:00:00	QQQ	ETF	42.39	42.5	41.95	42.31	5883900.0
2001-07-10 10:30:00	QQQ	ETF	42.31	42.49	42.05	42.07	3366000.0
2001-07-10 11:00:00	QQQ	ETF	42.07	42.2	41.83	41.95	2828800.0
2001-07-10 11:30:00	QQQ	ETF	41.97	42.01	41.71	41.95	2828700.0
2001-07-10 12:00:00	QQQ	ETF	41.92	42.1	41.82	42.02	1469800.0
2001-07-10 12:30:00	QQQ	ETF	42.0	42.03	41.67	41.67	1440800.0
2001-07-10 13:00:00	QQQ	ETF	41.68	41.75	41.44	41.45	3180000.0
2001-07-10 13:30:00	QQQ	ETF	41.48	41.57	41.04	41.09	4505200.0
2001-07-10 14:00:00	QQQ	ETF	41.05	41.16	40.85	41.04	6245200.0
2001-07-10 14:30:00	QQQ	ETF	41.05	41.21	40.83	40.85	2994800.0
2001-07-10 15:00:00	QQQ	ETF	40.86	41.08	40.59	40.68	4465200.0
2001-07-10 15:30:00	QQQ	ETF	40.69	40.75	40.44	40.5	7251800.0
2001-07-10 16:00:00	QQQ	ETF	40.54	42.55	40.32	40.4	1948700.0
2001-07-10 16:30:00	QQQ	ETF	40.36	40.75	40.2	40.53	298500.0
2001-07-10 17:00:00	QQQ	ETF	40.55	40.66	40.5	40.6	123600.0
2001-07-10 17:30:00	QQQ	ETF	40.6	40.65	40.55	40.6	66100.0
2001-07-10 18:00:00	QQQ	ETF	40.56	41.05	40.56	40.75	62100.0
2001-07-10 09:30:00	IWM	ETF	48.55	48.55	48.5	48.55	107200.0
2001-07-10 10:00:00	IWM	ETF	48.275	48.42	48.25	48.275	51600.0
2001-07-10 10:30:00	IWM	ETF	48.25	48.355	48.25	48.275	800.0
2001-07-10 11:00:00	IWM	ETF	48.345	48.35	48.105	48.225	154600.0
2001-07-10 11:30:00	IWM	ETF	48.15	48.2	48.15	48.195	5600.0
2001-07-10 12:00:00	IWM	ETF	48.21	48.26	48.15	48.26	73200.0
2001-07-10 12:30:00	IWM	ETF	48.375	48.375	48.21	48.21	74200.0
2001-07-10 13:00:00	IWM	ETF	48.21	48.235	48.13	48.13	19600.0
2001-07-10 13:30:00	IWM	ETF	48.1	48.17	47.91	47.91	97800.0
2001-07-10 14:00:00	IWM	ETF	47.75	47.875	47.73	47.825	34200.0
2001-07-10 14:30:00	IWM	ETF	47.825	47.885	47.755	47.835	31600.0
2001-07-10 15:00:00	IWM	ETF	47.78	47.835	47.5	47.5	33600.0
2001-07-10 15:30:00	IWM	ETF	47.5	47.5	47.29	47.29	57200.0
2001-07-10 16:00:00	IWM	ETF	47.425	47.5	47.425	47.5	24800.0
2001-07-10 09:30:00	DIA	ETF	103.4	103.5	103.12	103.16	203800.0

> showing 50 of 367 rows — these rows as CSV

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