PREVIEW / etf_30min / 2001-07-06

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-07-06.parquet
  size:    15 KB
  rows:    375

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-06 09:30:00	SPY	ETF	121.31	121.49	120.75	120.83	982400.0
2001-07-06 10:00:00	SPY	ETF	120.81	120.89	119.86	120.02	828300.0
2001-07-06 10:30:00	SPY	ETF	120.0	120.2	119.75	119.91	596200.0
2001-07-06 11:00:00	SPY	ETF	119.88	120.14	119.75	119.99	235900.0
2001-07-06 11:30:00	SPY	ETF	120.04	120.07	119.26	119.48	548700.0
2001-07-06 12:00:00	SPY	ETF	119.5	119.78	119.43	119.77	194800.0
2001-07-06 12:30:00	SPY	ETF	119.71	119.84	119.57	119.6	622000.0
2001-07-06 13:00:00	SPY	ETF	119.65	119.8	119.42	119.68	756800.0
2001-07-06 13:30:00	SPY	ETF	119.7	119.73	119.39	119.57	368600.0
2001-07-06 14:00:00	SPY	ETF	119.56	119.7	119.25	119.35	625500.0
2001-07-06 14:30:00	SPY	ETF	119.33	119.44	119.05	119.32	915900.0
2001-07-06 15:00:00	SPY	ETF	119.32	119.71	119.27	119.62	1001300.0
2001-07-06 15:30:00	SPY	ETF	119.62	119.86	119.19	119.19	1366800.0
2001-07-06 16:00:00	SPY	ETF	119.19	119.37	119.0	119.02	2248400.0
2001-07-06 16:30:00	SPY	ETF	119.02	119.05	118.01	118.5	6300.0
2001-07-06 17:00:00	SPY	ETF	118.7	118.7	118.5	118.5	400.0
2001-07-06 17:30:00	SPY	ETF	118.56	118.56	118.56	118.56	300.0
2001-07-06 09:30:00	QQQ	ETF	43.01	43.11	42.45	42.53	7866200.0
2001-07-06 10:00:00	QQQ	ETF	42.52	42.55	41.96	42.2	8584200.0
2001-07-06 10:30:00	QQQ	ETF	42.2	42.43	41.9	42.1	4656200.0
2001-07-06 11:00:00	QQQ	ETF	42.06	42.25	41.94	42.14	3988000.0
2001-07-06 11:30:00	QQQ	ETF	42.1	42.17	41.59	41.79	4668000.0
2001-07-06 12:00:00	QQQ	ETF	41.76	42.03	41.71	42.03	2578000.0
2001-07-06 12:30:00	QQQ	ETF	42.01	42.16	41.9	41.98	1847800.0
2001-07-06 13:00:00	QQQ	ETF	41.96	42.09	41.8	41.91	1358100.0
2001-07-06 13:30:00	QQQ	ETF	41.91	41.95	41.75	41.88	1097300.0
2001-07-06 14:00:00	QQQ	ETF	41.88	42.0	41.7	41.77	2639400.0
2001-07-06 14:30:00	QQQ	ETF	41.76	41.84	41.49	41.68	2909000.0
2001-07-06 15:00:00	QQQ	ETF	41.66	42.03	41.65	41.88	3480600.0
2001-07-06 15:30:00	QQQ	ETF	41.86	42.04	41.55	41.65	4396800.0
2001-07-06 16:00:00	QQQ	ETF	41.61	41.68	41.5	41.67	1722300.0
2001-07-06 16:30:00	QQQ	ETF	41.7	41.85	41.6	41.69	42000.0
2001-07-06 17:00:00	QQQ	ETF	41.75	41.75	41.65	41.75	26200.0
2001-07-06 17:30:00	QQQ	ETF	41.7	41.75	41.7	41.75	8500.0
2001-07-06 18:00:00	QQQ	ETF	41.7	41.75	41.67	41.67	9500.0
2001-07-06 09:30:00	IWM	ETF	48.55	48.725	48.55	48.55	24200.0
2001-07-06 10:00:00	IWM	ETF	48.305	48.4	48.045	48.1	102200.0
2001-07-06 10:30:00	IWM	ETF	48.055	48.095	48.0	48.05	48200.0
2001-07-06 11:00:00	IWM	ETF	48.055	48.155	48.0	48.155	2600.0
2001-07-06 11:30:00	IWM	ETF	48.15	48.15	47.775	47.9	21000.0
2001-07-06 12:00:00	IWM	ETF	47.89	48.0	47.89	48.0	5600.0
2001-07-06 12:30:00	IWM	ETF	48.0	48.055	47.975	48.0	5000.0
2001-07-06 13:00:00	IWM	ETF	48.005	48.08	47.98	48.065	35600.0
2001-07-06 13:30:00	IWM	ETF	48.065	48.08	48.0	48.05	9200.0
2001-07-06 14:00:00	IWM	ETF	48.07	48.07	48.0	48.025	101600.0
2001-07-06 14:30:00	IWM	ETF	48.035	48.035	47.91	48.025	3600.0
2001-07-06 15:00:00	IWM	ETF	48.065	48.17	48.065	48.15	16200.0
2001-07-06 15:30:00	IWM	ETF	48.125	48.255	47.825	47.94	205200.0
2001-07-06 16:00:00	IWM	ETF	47.975	48.0	47.925	47.95	5000.0
2001-07-06 09:30:00	DIA	ETF	104.63	104.63	103.85	103.9	186400.0

> showing 50 of 375 rows — these rows as CSV

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