PREVIEW / etf_30min / 2001-03-22

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-03-22.parquet
  size:    16 KB
  rows:    387

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-03-22 09:30:00	SPY	ETF	112.02	112.4	111.01	111.43	2920000.0
2001-03-22 10:00:00	SPY	ETF	111.45	111.62	110.2	110.3	2288100.0
2001-03-22 10:30:00	SPY	ETF	110.25	110.5	109.2	110.08	2958300.0
2001-03-22 11:00:00	SPY	ETF	110.02	110.35	109.21	109.25	2865200.0
2001-03-22 11:30:00	SPY	ETF	109.2	110.0	108.62	109.5	1785500.0
2001-03-22 12:00:00	SPY	ETF	109.35	110.5	109.27	110.45	986100.0
2001-03-22 12:30:00	SPY	ETF	110.48	110.73	109.6	110.02	852600.0
2001-03-22 13:00:00	SPY	ETF	110.15	110.23	109.43	109.8	486500.0
2001-03-22 13:30:00	SPY	ETF	109.81	110.37	109.71	109.95	620200.0
2001-03-22 14:00:00	SPY	ETF	109.78	109.95	109.0	109.01	868300.0
2001-03-22 14:30:00	SPY	ETF	109.19	109.28	108.04	109.09	2227300.0
2001-03-22 15:00:00	SPY	ETF	109.05	110.7	108.95	110.47	2068300.0
2001-03-22 15:30:00	SPY	ETF	110.44	112.6	110.05	111.9	3844300.0
2001-03-22 16:00:00	SPY	ETF	111.87	111.95	108.95	108.95	2570500.0
2001-03-22 16:30:00	SPY	ETF	111.36	111.87	109.35	111.0	821600.0
2001-03-22 17:00:00	SPY	ETF	111.38	111.38	111.21	111.21	200.0
2001-03-22 18:00:00	SPY	ETF	111.52	111.7	111.51	111.7	1000.0
2001-03-22 09:30:00	QQQ	ETF	40.6	41.0	40.39	40.56	10740400.0
2001-03-22 10:00:00	QQQ	ETF	40.46	40.65	39.9	39.98	8305400.0
2001-03-22 10:30:00	QQQ	ETF	40.07	40.33	39.49	40.2	12626300.0
2001-03-22 11:00:00	QQQ	ETF	40.14	40.66	39.97	40.0	8268800.0
2001-03-22 11:30:00	QQQ	ETF	39.99	40.55	39.68	40.35	7940700.0
2001-03-22 12:00:00	QQQ	ETF	40.35	41.15	40.19	41.13	10743400.0
2001-03-22 12:30:00	QQQ	ETF	41.13	41.26	40.52	40.7	6230600.0
2001-03-22 13:00:00	QQQ	ETF	40.76	40.91	40.43	40.48	5759500.0
2001-03-22 13:30:00	QQQ	ETF	40.56	41.03	40.43	40.55	3517100.0
2001-03-22 14:00:00	QQQ	ETF	40.55	40.6	39.91	40.35	6404100.0
2001-03-22 14:30:00	QQQ	ETF	40.4	40.85	40.0	40.79	7662200.0
2001-03-22 15:00:00	QQQ	ETF	40.85	41.69	40.72	41.49	12081600.0
2001-03-22 15:30:00	QQQ	ETF	41.4	42.66	41.23	42.5	22007200.0
2001-03-22 16:00:00	QQQ	ETF	42.5	42.8	42.1	42.6	3209700.0
2001-03-22 16:30:00	QQQ	ETF	42.55	42.8	42.05	42.25	284100.0
2001-03-22 17:00:00	QQQ	ETF	42.49	42.8	42.25	42.69	32100.0
2001-03-22 17:30:00	QQQ	ETF	42.64	42.7	42.5	42.65	19600.0
2001-03-22 18:00:00	QQQ	ETF	42.6	42.8	42.6	42.62	23400.0
2001-03-22 09:30:00	IWM	ETF	43.125	43.3	42.725	42.725	325000.0
2001-03-22 10:00:00	IWM	ETF	42.7	42.7	42.25	42.34	248600.0
2001-03-22 10:30:00	IWM	ETF	42.35	42.35	41.875	42.2	19200.0
2001-03-22 11:00:00	IWM	ETF	42.11	42.2	41.825	42.025	39800.0
2001-03-22 11:30:00	IWM	ETF	42.0	42.0	41.575	42.0	152000.0
2001-03-22 12:00:00	IWM	ETF	42.06	42.3	42.06	42.25	31600.0
2001-03-22 12:30:00	IWM	ETF	42.3	42.4	42.175	42.175	15800.0
2001-03-22 13:00:00	IWM	ETF	42.175	42.275	42.075	42.225	10800.0
2001-03-22 13:30:00	IWM	ETF	42.075	42.245	42.05	42.185	10200.0
2001-03-22 14:00:00	IWM	ETF	42.075	42.125	41.875	41.99	20600.0
2001-03-22 14:30:00	IWM	ETF	41.985	42.025	41.775	41.95	28400.0
2001-03-22 15:00:00	IWM	ETF	42.05	42.35	42.0	42.35	16400.0
2001-03-22 15:30:00	IWM	ETF	42.465	43.375	42.465	43.0	261000.0
2001-03-22 16:00:00	IWM	ETF	43.0	43.05	42.825	43.0	7600.0
2001-03-22 09:30:00	DIA	ETF	94.5	94.55	93.1	94.3	1642800.0

> showing 50 of 387 rows — these rows as CSV

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