PREVIEW / etf_30min / 2001-07-23

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-07-23.parquet
  size:    15 KB
  rows:    355

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-23 09:30:00	SPY	ETF	121.8	121.88	121.36	121.51	835500.0
2001-07-23 10:00:00	SPY	ETF	121.48	121.74	121.0	121.02	335700.0
2001-07-23 10:30:00	SPY	ETF	121.02	121.04	119.75	119.76	1011300.0
2001-07-23 11:00:00	SPY	ETF	119.81	120.1	119.7	120.0	793900.0
2001-07-23 11:30:00	SPY	ETF	120.03	120.23	119.93	120.17	299200.0
2001-07-23 12:00:00	SPY	ETF	120.15	120.2	120.02	120.2	427400.0
2001-07-23 12:30:00	SPY	ETF	120.23	120.3	120.13	120.15	154000.0
2001-07-23 13:00:00	SPY	ETF	120.08	120.1	119.84	120.07	306200.0
2001-07-23 13:30:00	SPY	ETF	120.0	120.29	120.0	120.19	291700.0
2001-07-23 14:00:00	SPY	ETF	120.16	120.26	119.96	120.03	156100.0
2001-07-23 14:30:00	SPY	ETF	120.11	120.39	120.0	120.16	181600.0
2001-07-23 15:00:00	SPY	ETF	120.13	120.15	119.62	119.66	731400.0
2001-07-23 15:30:00	SPY	ETF	119.69	119.75	119.22	119.36	1425100.0
2001-07-23 16:00:00	SPY	ETF	119.39	119.4	118.95	118.95	761200.0
2001-07-23 16:30:00	SPY	ETF	119.0	119.35	119.0	119.35	1500.0
2001-07-23 17:00:00	SPY	ETF	119.01	119.24	119.01	119.24	400.0
2001-07-23 18:00:00	SPY	ETF	119.2	119.2	119.15	119.15	2000.0
2001-07-23 09:30:00	QQQ	ETF	42.24	42.4	41.91	42.02	6470900.0
2001-07-23 10:00:00	QQQ	ETF	42.0	42.23	41.7	41.75	4176100.0
2001-07-23 10:30:00	QQQ	ETF	41.74	41.8	41.01	41.05	8541000.0
2001-07-23 11:00:00	QQQ	ETF	41.05	41.28	40.89	41.15	5486100.0
2001-07-23 11:30:00	QQQ	ETF	41.14	41.36	41.06	41.3	2919700.0
2001-07-23 12:00:00	QQQ	ETF	41.3	41.33	41.08	41.19	1917300.0
2001-07-23 12:30:00	QQQ	ETF	41.19	41.38	41.15	41.29	3052600.0
2001-07-23 13:00:00	QQQ	ETF	41.31	41.31	41.12	41.23	1309700.0
2001-07-23 13:30:00	QQQ	ETF	41.25	41.5	41.21	41.4	2278200.0
2001-07-23 14:00:00	QQQ	ETF	41.39	41.47	41.11	41.2	1271400.0
2001-07-23 14:30:00	QQQ	ETF	41.15	41.4	41.06	41.2	2343200.0
2001-07-23 15:00:00	QQQ	ETF	41.17	41.2	40.75	40.8	3539800.0
2001-07-23 15:30:00	QQQ	ETF	40.8	40.85	40.55	40.64	5972000.0
2001-07-23 16:00:00	QQQ	ETF	40.62	40.74	40.57	40.6	2388600.0
2001-07-23 16:30:00	QQQ	ETF	40.63	40.75	40.6	40.69	158600.0
2001-07-23 17:00:00	QQQ	ETF	40.71	40.71	40.58	40.64	95700.0
2001-07-23 17:30:00	QQQ	ETF	40.61	40.67	40.59	40.66	16200.0
2001-07-23 18:00:00	QQQ	ETF	40.66	40.7	40.55	40.65	13900.0
2001-07-23 09:30:00	IWM	ETF	48.825	48.825	48.525	48.64	84000.0
2001-07-23 10:00:00	IWM	ETF	48.75	48.75	48.6	48.6	28400.0
2001-07-23 10:30:00	IWM	ETF	48.65	48.65	48.05	48.06	129200.0
2001-07-23 11:00:00	IWM	ETF	48.15	48.275	48.065	48.275	109600.0
2001-07-23 11:30:00	IWM	ETF	48.325	48.325	48.2	48.2	18000.0
2001-07-23 12:00:00	IWM	ETF	48.325	48.335	48.305	48.305	12800.0
2001-07-23 12:30:00	IWM	ETF	48.355	48.395	48.18	48.395	71400.0
2001-07-23 13:00:00	IWM	ETF	48.255	48.395	48.255	48.395	11400.0
2001-07-23 13:30:00	IWM	ETF	48.375	48.41	48.305	48.41	23000.0
2001-07-23 14:00:00	IWM	ETF	48.41	48.41	48.395	48.41	17200.0
2001-07-23 14:30:00	IWM	ETF	48.41	48.45	48.255	48.45	292200.0
2001-07-23 15:00:00	IWM	ETF	48.45	48.45	48.21	48.21	20000.0
2001-07-23 15:30:00	IWM	ETF	48.365	48.365	48.01	48.01	145400.0
2001-07-23 16:00:00	IWM	ETF	48.2	48.385	48.0	48.385	433200.0
2001-07-23 09:30:00	DIA	ETF	106.22	106.33	105.46	105.64	133600.0

> showing 50 of 355 rows — these rows as CSV

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