PREVIEW / etf_30min / 2001-09-18

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-09-18.parquet
  size:    17 KB
  rows:    448

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-09-18 09:30:00	SPY	ETF	104.33	104.7	103.7	104.33	3492400.0
2001-09-18 10:00:00	SPY	ETF	104.35	105.05	104.16	104.8	2032300.0
2001-09-18 10:30:00	SPY	ETF	104.82	105.19	104.65	105.12	1644700.0
2001-09-18 11:00:00	SPY	ETF	105.15	105.15	104.66	104.82	1148300.0
2001-09-18 11:30:00	SPY	ETF	104.82	104.82	104.0	104.5	812000.0
2001-09-18 12:00:00	SPY	ETF	104.5	104.75	104.45	104.59	855200.0
2001-09-18 12:30:00	SPY	ETF	104.58	104.9	104.44	104.71	1324300.0
2001-09-18 13:00:00	SPY	ETF	104.78	105.3	104.63	105.19	1082100.0
2001-09-18 13:30:00	SPY	ETF	105.17	105.2	104.76	104.9	786100.0
2001-09-18 14:00:00	SPY	ETF	104.83	104.94	104.51	104.59	1529700.0
2001-09-18 14:30:00	SPY	ETF	104.65	104.74	104.01	104.34	1762800.0
2001-09-18 15:00:00	SPY	ETF	104.32	104.32	103.36	103.57	2205000.0
2001-09-18 15:30:00	SPY	ETF	103.49	103.87	103.49	103.82	2051500.0
2001-09-18 16:00:00	SPY	ETF	103.9	104.15	103.6	104.05	619500.0
2001-09-18 16:30:00	SPY	ETF	103.95	105.5	103.95	104.2	12400.0
2001-09-18 17:00:00	SPY	ETF	104.04	104.04	104.04	104.04	500.0
2001-09-18 17:30:00	SPY	ETF	104.04	104.05	104.04	104.05	30100.0
2001-09-18 09:30:00	QQQ	ETF	31.53	31.62	31.1	31.57	10465700.0
2001-09-18 10:00:00	QQQ	ETF	31.56	32.0	31.45	31.83	8356200.0
2001-09-18 10:30:00	QQQ	ETF	31.8	31.92	31.67	31.79	3990200.0
2001-09-18 11:00:00	QQQ	ETF	31.85	31.85	31.43	31.5	3365100.0
2001-09-18 11:30:00	QQQ	ETF	31.54	31.55	31.25	31.31	3203300.0
2001-09-18 12:00:00	QQQ	ETF	31.32	31.47	31.21	31.28	3065900.0
2001-09-18 12:30:00	QQQ	ETF	31.31	31.5	31.23	31.42	2719600.0
2001-09-18 13:00:00	QQQ	ETF	31.42	31.67	31.31	31.61	3167300.0
2001-09-18 13:30:00	QQQ	ETF	31.64	31.65	31.35	31.38	2179500.0
2001-09-18 14:00:00	QQQ	ETF	31.42	31.42	31.12	31.14	2979700.0
2001-09-18 14:30:00	QQQ	ETF	31.14	31.25	30.77	30.88	6151700.0
2001-09-18 15:00:00	QQQ	ETF	30.9	30.91	30.37	30.47	6992500.0
2001-09-18 15:30:00	QQQ	ETF	30.48	30.65	30.41	30.49	5812500.0
2001-09-18 16:00:00	QQQ	ETF	30.49	30.98	30.43	30.55	959000.0
2001-09-18 16:30:00	QQQ	ETF	30.57	30.7	30.5	30.51	82400.0
2001-09-18 17:00:00	QQQ	ETF	30.54	30.6	30.51	30.53	12100.0
2001-09-18 17:30:00	QQQ	ETF	30.58	30.58	30.49	30.51	5600.0
2001-09-18 18:00:00	QQQ	ETF	30.54	30.6	30.49	30.57	11200.0
2001-09-18 09:30:00	IWM	ETF	41.87	41.875	41.55	41.75	1090400.0
2001-09-18 10:00:00	IWM	ETF	41.75	41.925	41.615	41.875	1457600.0
2001-09-18 10:30:00	IWM	ETF	41.85	41.87	41.72	41.87	30400.0
2001-09-18 11:00:00	IWM	ETF	41.87	41.895	41.7	41.725	204400.0
2001-09-18 11:30:00	IWM	ETF	41.62	41.72	41.5	41.5	28600.0
2001-09-18 12:00:00	IWM	ETF	41.565	41.565	41.45	41.475	60200.0
2001-09-18 12:30:00	IWM	ETF	41.5	41.535	41.45	41.525	12200.0
2001-09-18 13:00:00	IWM	ETF	41.525	41.7	41.525	41.625	706600.0
2001-09-18 13:30:00	IWM	ETF	41.56	41.605	41.56	41.605	2000.0
2001-09-18 14:00:00	IWM	ETF	41.575	41.575	41.325	41.325	27400.0
2001-09-18 14:30:00	IWM	ETF	41.305	41.325	41.15	41.25	171000.0
2001-09-18 15:00:00	IWM	ETF	41.255	41.255	40.935	40.995	186600.0
2001-09-18 15:30:00	IWM	ETF	40.995	41.055	40.8	41.055	244400.0
2001-09-18 16:00:00	IWM	ETF	41.055	41.075	41.055	41.075	9600.0
2001-09-18 09:30:00	DIA	ETF	89.75	89.9	88.85	89.3	1313200.0

> showing 50 of 448 rows — these rows as CSV

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