PREVIEW / etf_30min / 2002-01-31

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-01-31.parquet
  size:    17 KB
  rows:    438

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
2002-01-31 08:00:00	SPY	ETF	111.7943	112.2389	111.7943	112.1322	21930.0
2002-01-31 08:30:00	SPY	ETF	112.1856	112.2389	112.1322	112.15	6570.0
2002-01-31 09:00:00	SPY	ETF	112.1322	112.399	112.0611	112.1322	44810.0
2002-01-31 09:30:00	SPY	ETF	112.15	113.0148	112.1092	112.7984	2078350.0
2002-01-31 10:00:00	SPY	ETF	112.811	113.3541	112.3347	112.6706	2048030.0
2002-01-31 10:30:00	SPY	ETF	112.7216	112.8191	111.738	111.9169	1433180.0
2002-01-31 11:00:00	SPY	ETF	111.9323	112.47	111.7616	111.8788	1370850.0
2002-01-31 11:30:00	SPY	ETF	111.9123	112.3977	111.62	112.3687	1475340.0
2002-01-31 12:00:00	SPY	ETF	112.3818	113.2317	112.1422	112.5816	1144090.0
2002-01-31 12:30:00	SPY	ETF	112.5767	112.8887	112.1452	112.7764	656850.0
2002-01-31 13:00:00	SPY	ETF	112.8432	113.3563	112.5699	113.1321	926090.0
2002-01-31 13:30:00	SPY	ETF	113.0915	113.2167	112.3006	112.666	675030.0
2002-01-31 14:00:00	SPY	ETF	112.6612	113.1054	112.0541	112.7185	708750.0
2002-01-31 14:30:00	SPY	ETF	112.7138	112.7625	111.8737	112.4508	919520.0
2002-01-31 15:00:00	SPY	ETF	112.4283	112.7629	112.1934	112.6823	1027670.0
2002-01-31 15:30:00	SPY	ETF	112.7131	113.3379	112.5708	113.18	2210800.0
2002-01-31 16:00:00	SPY	ETF	113.1622	113.5175	111.972	113.2155	1421690.0
2002-01-31 16:30:00	SPY	ETF	113.18	113.3399	112.0963	113.18	811760.0
2002-01-31 17:00:00	SPY	ETF	113.18	113.2511	113.18	113.2511	239690.0
2002-01-31 17:30:00	SPY	ETF	112.9846	112.9846	112.8958	112.9846	900.0
2002-01-31 18:00:00	SPY	ETF	112.9846	113.18	112.8958	113.1622	1290.0
2002-01-31 09:30:00	QQQ	ETF	38.57	38.71	38.34	38.61	10321300.0
2002-01-31 10:00:00	QQQ	ETF	38.61	38.72	38.17	38.28	6685500.0
2002-01-31 10:30:00	QQQ	ETF	38.27	38.45	38.02	38.12	5705100.0
2002-01-31 11:00:00	QQQ	ETF	38.06	38.31	38.06	38.14	2641300.0
2002-01-31 11:30:00	QQQ	ETF	38.16	38.33	38.05	38.31	2356100.0
2002-01-31 12:00:00	QQQ	ETF	38.31	38.51	38.26	38.35	2945900.0
2002-01-31 12:30:00	QQQ	ETF	38.34	38.51	38.21	38.48	2999300.0
2002-01-31 13:00:00	QQQ	ETF	38.46	38.69	38.38	38.62	3515400.0
2002-01-31 13:30:00	QQQ	ETF	38.62	38.63	38.39	38.49	3029400.0
2002-01-31 14:00:00	QQQ	ETF	38.49	38.58	38.32	38.45	3697000.0
2002-01-31 14:30:00	QQQ	ETF	38.45	38.5	38.21	38.41	4204700.0
2002-01-31 15:00:00	QQQ	ETF	38.41	38.66	38.38	38.6	6296000.0
2002-01-31 15:30:00	QQQ	ETF	38.57	38.75	38.46	38.55	12006300.0
2002-01-31 16:00:00	QQQ	ETF	38.56	38.58	38.43	38.51	2321700.0
2002-01-31 16:30:00	QQQ	ETF	38.55	38.68	38.51	38.55	105400.0
2002-01-31 17:00:00	QQQ	ETF	38.55	38.55	38.45	38.46	47000.0
2002-01-31 17:30:00	QQQ	ETF	38.52	38.52	38.45	38.48	14400.0
2002-01-31 18:00:00	QQQ	ETF	38.48	38.5	38.48	38.5	3000.0
2002-01-31 09:30:00	IWM	ETF	47.8	47.9	47.505	47.7	156000.0
2002-01-31 10:00:00	IWM	ETF	47.76	47.82	47.58	47.58	37800.0
2002-01-31 10:30:00	IWM	ETF	47.575	47.695	47.53	47.57	110400.0
2002-01-31 11:00:00	IWM	ETF	47.56	47.67	47.55	47.665	61200.0
2002-01-31 11:30:00	IWM	ETF	47.645	47.65	47.58	47.58	12200.0
2002-01-31 12:00:00	IWM	ETF	47.6	47.77	47.6	47.75	29600.0
2002-01-31 12:30:00	IWM	ETF	47.75	47.845	47.66	47.845	22200.0
2002-01-31 13:00:00	IWM	ETF	47.86	47.9	47.76	47.9	14800.0
2002-01-31 13:30:00	IWM	ETF	47.92	47.92	47.8	47.87	21000.0
2002-01-31 14:00:00	IWM	ETF	47.885	47.89	47.8	47.885	28600.0
2002-01-31 14:30:00	IWM	ETF	47.885	47.91	47.69	47.8	37000.0

> showing 50 of 438 rows — these rows as CSV

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