PREVIEW / etf_30min / 2001-07-26

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-07-26.parquet
  size:    14 KB
  rows:    344

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-26 09:30:00	SPY	ETF	119.06	119.32	118.81	119.18	1560700.0
2001-07-26 10:00:00	SPY	ETF	119.2	119.57	119.0	119.25	776300.0
2001-07-26 10:30:00	SPY	ETF	119.2	119.25	118.86	119.1	538000.0
2001-07-26 11:00:00	SPY	ETF	119.1	119.16	118.6	118.66	1363600.0
2001-07-26 11:30:00	SPY	ETF	118.7	118.94	118.56	118.92	1471500.0
2001-07-26 12:00:00	SPY	ETF	118.92	119.13	118.84	119.12	221400.0
2001-07-26 12:30:00	SPY	ETF	119.12	119.17	118.71	119.11	313000.0
2001-07-26 13:00:00	SPY	ETF	119.18	119.3	118.99	119.29	225700.0
2001-07-26 13:30:00	SPY	ETF	119.29	119.44	119.14	119.37	304100.0
2001-07-26 14:00:00	SPY	ETF	119.4	119.78	119.23	119.7	506500.0
2001-07-26 14:30:00	SPY	ETF	119.65	120.2	119.6	120.12	1409100.0
2001-07-26 15:00:00	SPY	ETF	120.01	120.69	120.01	120.53	1426300.0
2001-07-26 15:30:00	SPY	ETF	120.58	120.85	120.49	120.74	1305300.0
2001-07-26 16:00:00	SPY	ETF	120.73	120.75	120.05	120.45	807200.0
2001-07-26 16:30:00	SPY	ETF	120.3	120.43	120.3	120.43	4100.0
2001-07-26 17:00:00	SPY	ETF	120.65	120.7	120.6	120.6	3500.0
2001-07-26 18:00:00	SPY	ETF	120.6	120.6	120.6	120.6	100.0
2001-07-26 09:30:00	QQQ	ETF	40.45	40.85	40.3	40.68	8797000.0
2001-07-26 10:00:00	QQQ	ETF	40.68	41.05	40.65	40.75	4614800.0
2001-07-26 10:30:00	QQQ	ETF	40.8	40.85	40.39	40.51	4762300.0
2001-07-26 11:00:00	QQQ	ETF	40.51	40.61	40.06	40.18	5423400.0
2001-07-26 11:30:00	QQQ	ETF	40.15	40.28	39.98	40.27	3974500.0
2001-07-26 12:00:00	QQQ	ETF	40.28	40.38	40.15	40.32	2039500.0
2001-07-26 12:30:00	QQQ	ETF	40.32	40.43	40.06	40.4	1854400.0
2001-07-26 13:00:00	QQQ	ETF	40.39	40.61	40.25	40.6	1865700.0
2001-07-26 13:30:00	QQQ	ETF	40.6	40.87	40.52	40.78	2314300.0
2001-07-26 14:00:00	QQQ	ETF	40.79	41.15	40.68	41.13	4818900.0
2001-07-26 14:30:00	QQQ	ETF	41.1	41.42	41.05	41.36	6864300.0
2001-07-26 15:00:00	QQQ	ETF	41.37	41.82	41.31	41.75	9110500.0
2001-07-26 15:30:00	QQQ	ETF	41.77	41.89	41.5	41.67	7027800.0
2001-07-26 16:00:00	QQQ	ETF	41.67	41.8	41.05	41.32	2399100.0
2001-07-26 16:30:00	QQQ	ETF	41.32	41.6	41.23	41.54	592400.0
2001-07-26 17:00:00	QQQ	ETF	41.54	41.6	41.2	41.44	124000.0
2001-07-26 17:30:00	QQQ	ETF	41.44	41.54	41.4	41.49	78100.0
2001-07-26 18:00:00	QQQ	ETF	41.45	41.65	40.5	41.55	68800.0
2001-07-26 09:30:00	IWM	ETF	47.505	47.75	47.4	47.75	13000.0
2001-07-26 10:00:00	IWM	ETF	47.6	47.75	47.525	47.75	7400.0
2001-07-26 10:30:00	IWM	ETF	47.625	47.625	47.625	47.625	1800.0
2001-07-26 11:00:00	IWM	ETF	47.665	47.665	47.355	47.355	1400.0
2001-07-26 11:30:00	IWM	ETF	47.375	47.5	47.23	47.5	2200.0
2001-07-26 12:00:00	IWM	ETF	47.6	47.6	47.5	47.5	4400.0
2001-07-26 12:30:00	IWM	ETF	47.45	47.5	47.45	47.5	800.0
2001-07-26 13:00:00	IWM	ETF	47.5	47.57	47.5	47.57	1800.0
2001-07-26 13:30:00	IWM	ETF	47.57	47.645	47.505	47.525	18600.0
2001-07-26 14:00:00	IWM	ETF	47.575	48.07	47.575	48.07	228800.0
2001-07-26 14:30:00	IWM	ETF	48.065	48.175	48.0	48.01	34000.0
2001-07-26 15:00:00	IWM	ETF	48.1	48.55	48.05	48.45	141400.0
2001-07-26 15:30:00	IWM	ETF	48.475	48.52	48.275	48.4	124000.0
2001-07-26 16:00:00	IWM	ETF	48.375	48.375	48.325	48.325	40400.0
2001-07-26 09:30:00	DIA	ETF	103.7	103.7	103.31	103.46	257000.0

> showing 50 of 344 rows — these rows as CSV

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