PREVIEW / etf_30min / 2001-08-17

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-08-17.parquet
  size:    15 KB
  rows:    365

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-08-17 09:30:00	SPY	ETF	117.65	117.87	117.4	117.7	1433900.0
2001-08-17 10:00:00	SPY	ETF	117.7	117.81	117.08	117.3	909800.0
2001-08-17 10:30:00	SPY	ETF	117.31	117.32	116.5	116.88	1556300.0
2001-08-17 11:00:00	SPY	ETF	116.86	117.01	116.64	117.01	472800.0
2001-08-17 11:30:00	SPY	ETF	117.01	117.15	116.73	116.81	426600.0
2001-08-17 12:00:00	SPY	ETF	116.82	116.98	116.69	116.96	382400.0
2001-08-17 12:30:00	SPY	ETF	116.97	117.0	116.75	116.78	209400.0
2001-08-17 13:00:00	SPY	ETF	116.77	116.89	116.56	116.88	417400.0
2001-08-17 13:30:00	SPY	ETF	116.85	116.87	116.62	116.7	1090300.0
2001-08-17 14:00:00	SPY	ETF	116.71	116.77	116.42	116.62	400500.0
2001-08-17 14:30:00	SPY	ETF	116.62	116.8	116.54	116.57	416100.0
2001-08-17 15:00:00	SPY	ETF	116.56	116.57	116.04	116.04	1031700.0
2001-08-17 15:30:00	SPY	ETF	116.05	116.75	116.01	116.64	1897100.0
2001-08-17 16:00:00	SPY	ETF	116.65	116.75	116.61	116.71	769700.0
2001-08-17 16:30:00	SPY	ETF	116.71	117.65	116.71	117.65	6300.0
2001-08-17 09:30:00	QQQ	ETF	38.44	38.8	38.4	38.59	7031800.0
2001-08-17 10:00:00	QQQ	ETF	38.55	38.63	38.1	38.29	7185600.0
2001-08-17 10:30:00	QQQ	ETF	38.26	38.29	37.78	38.04	8205100.0
2001-08-17 11:00:00	QQQ	ETF	38.05	38.3	37.95	38.27	3294800.0
2001-08-17 11:30:00	QQQ	ETF	38.28	38.4	38.15	38.18	3046600.0
2001-08-17 12:00:00	QQQ	ETF	38.18	38.35	38.12	38.33	2334700.0
2001-08-17 12:30:00	QQQ	ETF	38.29	38.34	38.13	38.16	1222300.0
2001-08-17 13:00:00	QQQ	ETF	38.15	38.23	38.0	38.23	2596500.0
2001-08-17 13:30:00	QQQ	ETF	38.21	38.24	38.04	38.13	1851000.0
2001-08-17 14:00:00	QQQ	ETF	38.13	38.15	37.9	38.05	3012800.0
2001-08-17 14:30:00	QQQ	ETF	38.02	38.1	37.96	38.0	1734200.0
2001-08-17 15:00:00	QQQ	ETF	38.0	38.02	37.71	37.77	4408200.0
2001-08-17 15:30:00	QQQ	ETF	37.73	38.05	37.72	37.8	7646300.0
2001-08-17 16:00:00	QQQ	ETF	37.79	37.95	37.74	37.77	1028400.0
2001-08-17 16:30:00	QQQ	ETF	37.79	37.79	37.25	37.7	65700.0
2001-08-17 17:00:00	QQQ	ETF	37.74	37.74	37.7	37.74	9800.0
2001-08-17 17:30:00	QQQ	ETF	37.71	37.78	37.7	37.78	15300.0
2001-08-17 18:00:00	QQQ	ETF	37.78	37.94	37.75	37.94	7500.0
2001-08-17 09:30:00	IWM	ETF	47.7	47.815	47.66	47.66	1000.0
2001-08-17 10:00:00	IWM	ETF	47.875	47.875	47.505	47.505	5800.0
2001-08-17 10:30:00	IWM	ETF	47.65	47.65	47.355	47.355	2200.0
2001-08-17 11:00:00	IWM	ETF	47.54	47.54	47.405	47.54	800.0
2001-08-17 11:30:00	IWM	ETF	47.71	47.715	47.645	47.715	1600.0
2001-08-17 12:00:00	IWM	ETF	47.64	47.71	47.6	47.6	11600.0
2001-08-17 12:30:00	IWM	ETF	47.6	47.6	47.6	47.6	10600.0
2001-08-17 13:00:00	IWM	ETF	47.6	47.6	47.53	47.575	1800.0
2001-08-17 13:30:00	IWM	ETF	47.6	47.65	47.6	47.65	70200.0
2001-08-17 14:00:00	IWM	ETF	47.575	47.7	47.535	47.66	2200.0
2001-08-17 14:30:00	IWM	ETF	47.69	47.7	47.58	47.64	12600.0
2001-08-17 15:00:00	IWM	ETF	47.7	47.7	47.4	47.525	113800.0
2001-08-17 15:30:00	IWM	ETF	47.4	47.545	47.3	47.5	359000.0
2001-08-17 16:00:00	IWM	ETF	47.35	47.35	47.35	47.35	14400.0
2001-08-17 09:30:00	DIA	ETF	103.15	103.62	103.07	103.43	542800.0
2001-08-17 10:00:00	DIA	ETF	103.43	103.55	102.91	103.18	383600.0
2001-08-17 10:30:00	DIA	ETF	103.14	103.14	102.5	102.75	312700.0

> showing 50 of 365 rows — these rows as CSV

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