PREVIEW / etf_30min / 2001-07-09

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-07-09.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-09 09:30:00	SPY	ETF	119.49	119.84	119.2	119.58	1315200.0
2001-07-09 10:00:00	SPY	ETF	119.51	120.23	119.45	120.11	1045500.0
2001-07-09 10:30:00	SPY	ETF	120.06	120.2	119.7	119.9	709400.0
2001-07-09 11:00:00	SPY	ETF	119.84	120.05	119.76	119.87	571800.0
2001-07-09 11:30:00	SPY	ETF	119.92	119.92	119.6	119.71	699400.0
2001-07-09 12:00:00	SPY	ETF	119.7	119.73	119.41	119.6	518200.0
2001-07-09 12:30:00	SPY	ETF	119.56	119.93	119.56	119.82	142000.0
2001-07-09 13:00:00	SPY	ETF	119.81	120.15	119.74	120.09	422500.0
2001-07-09 13:30:00	SPY	ETF	120.02	120.5	120.0	120.42	412600.0
2001-07-09 14:00:00	SPY	ETF	120.41	120.42	120.14	120.31	268500.0
2001-07-09 14:30:00	SPY	ETF	120.26	120.54	119.95	119.95	279800.0
2001-07-09 15:00:00	SPY	ETF	120.0	120.19	119.83	120.06	236800.0
2001-07-09 15:30:00	SPY	ETF	120.1	120.35	120.0	120.1	696700.0
2001-07-09 16:00:00	SPY	ETF	120.03	120.1	119.61	119.7	493400.0
2001-07-09 16:30:00	SPY	ETF	119.77	119.82	119.75	119.82	700.0
2001-07-09 17:00:00	SPY	ETF	119.89	119.89	119.75	119.75	600.0
2001-07-09 18:00:00	SPY	ETF	119.95	120.0	119.95	119.99	1200.0
2001-07-09 09:30:00	QQQ	ETF	41.89	42.2	41.55	41.92	8651300.0
2001-07-09 10:00:00	QQQ	ETF	42.03	42.62	41.85	42.51	5157100.0
2001-07-09 10:30:00	QQQ	ETF	42.55	42.67	42.25	42.42	3541600.0
2001-07-09 11:00:00	QQQ	ETF	42.4	42.54	42.25	42.31	2175400.0
2001-07-09 11:30:00	QQQ	ETF	42.33	42.35	42.09	42.2	3954500.0
2001-07-09 12:00:00	QQQ	ETF	42.2	42.24	41.9	42.03	2998600.0
2001-07-09 12:30:00	QQQ	ETF	42.09	42.25	42.03	42.15	1355500.0
2001-07-09 13:00:00	QQQ	ETF	42.17	42.48	42.15	42.41	1543500.0
2001-07-09 13:30:00	QQQ	ETF	42.41	42.69	42.33	42.55	2607700.0
2001-07-09 14:00:00	QQQ	ETF	42.51	42.56	42.3	42.42	1729100.0
2001-07-09 14:30:00	QQQ	ETF	42.42	42.64	42.21	42.3	2177000.0
2001-07-09 15:00:00	QQQ	ETF	42.26	42.39	42.07	42.28	2464900.0
2001-07-09 15:30:00	QQQ	ETF	42.29	42.39	42.15	42.25	4214600.0
2001-07-09 16:00:00	QQQ	ETF	42.29	42.3	42.0	42.1	1535500.0
2001-07-09 16:30:00	QQQ	ETF	42.1	42.22	42.05	42.22	33700.0
2001-07-09 17:00:00	QQQ	ETF	42.2	42.27	42.12	42.25	85900.0
2001-07-09 17:30:00	QQQ	ETF	42.25	42.25	42.22	42.25	6000.0
2001-07-09 18:00:00	QQQ	ETF	42.25	42.3	42.23	42.23	9200.0
2001-07-09 09:30:00	IWM	ETF	48.125	48.15	47.625	48.125	72400.0
2001-07-09 10:00:00	IWM	ETF	48.03	48.475	48.0	48.475	44400.0
2001-07-09 10:30:00	IWM	ETF	48.325	48.475	48.325	48.375	2600.0
2001-07-09 11:00:00	IWM	ETF	48.35	48.35	48.27	48.325	34200.0
2001-07-09 11:30:00	IWM	ETF	48.325	48.325	48.015	48.015	34400.0
2001-07-09 12:00:00	IWM	ETF	48.0	48.125	47.95	48.0	188000.0
2001-07-09 12:30:00	IWM	ETF	48.05	48.195	47.95	48.195	6200.0
2001-07-09 13:00:00	IWM	ETF	48.125	48.25	48.075	48.25	30200.0
2001-07-09 13:30:00	IWM	ETF	48.245	48.35	48.21	48.215	129200.0
2001-07-09 14:00:00	IWM	ETF	48.325	48.35	48.175	48.18	11600.0
2001-07-09 14:30:00	IWM	ETF	48.25	48.25	48.055	48.18	46600.0
2001-07-09 15:00:00	IWM	ETF	48.18	48.18	48.0	48.125	44200.0
2001-07-09 15:30:00	IWM	ETF	48.125	48.345	48.1	48.225	200200.0
2001-07-09 16:00:00	IWM	ETF	48.34	48.4	48.34	48.4	1000.0
2001-07-09 09:30:00	DIA	ETF	102.95	102.97	102.55	102.85	356300.0

> showing 50 of 375 rows — these rows as CSV

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