PREVIEW / etf_30min / 2002-01-09

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-01-09.parquet
  size:    18 KB
  rows:    471

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-09 09:30:00	SPY	ETF	116.68	117.08	116.65	116.91	2314300.0
2002-01-09 10:00:00	SPY	ETF	116.9	117.62	116.86	117.46	1655400.0
2002-01-09 10:30:00	SPY	ETF	117.49	117.78	117.41	117.56	1070800.0
2002-01-09 11:00:00	SPY	ETF	117.54	117.75	117.39	117.4	836800.0
2002-01-09 11:30:00	SPY	ETF	117.43	117.52	117.2	117.27	483800.0
2002-01-09 12:00:00	SPY	ETF	117.28	117.45	117.22	117.33	262600.0
2002-01-09 12:30:00	SPY	ETF	117.31	117.5	117.28	117.44	283500.0
2002-01-09 13:00:00	SPY	ETF	117.4	117.46	117.28	117.45	399700.0
2002-01-09 13:30:00	SPY	ETF	117.42	117.53	117.05	117.19	573200.0
2002-01-09 14:00:00	SPY	ETF	117.15	117.2	116.86	116.91	1078400.0
2002-01-09 14:30:00	SPY	ETF	116.9	117.15	116.77	116.86	761300.0
2002-01-09 15:00:00	SPY	ETF	116.9	116.97	116.16	116.16	1974200.0
2002-01-09 15:30:00	SPY	ETF	116.17	116.22	115.34	115.7	2480200.0
2002-01-09 16:00:00	SPY	ETF	115.66	116.75	115.4	115.5	965500.0
2002-01-09 16:30:00	SPY	ETF	115.57	115.64	115.55	115.55	646500.0
2002-01-09 17:00:00	SPY	ETF	115.55	115.58	115.43	115.58	7700.0
2002-01-09 17:30:00	SPY	ETF	115.56	115.56	115.55	115.55	1100.0
2002-01-09 18:00:00	SPY	ETF	115.48	115.48	115.25	115.25	6600.0
2002-01-09 09:30:00	QQQ	ETF	42.04	42.28	41.98	42.09	12468000.0
2002-01-09 10:00:00	QQQ	ETF	42.07	42.45	42.05	42.3	7983400.0
2002-01-09 10:30:00	QQQ	ETF	42.3	42.5	42.25	42.41	5470700.0
2002-01-09 11:00:00	QQQ	ETF	42.41	42.59	42.27	42.33	6592000.0
2002-01-09 11:30:00	QQQ	ETF	42.31	42.45	42.23	42.29	4079200.0
2002-01-09 12:00:00	QQQ	ETF	42.28	42.4	42.23	42.31	1954100.0
2002-01-09 12:30:00	QQQ	ETF	42.3	42.5	42.26	42.45	2731100.0
2002-01-09 13:00:00	QQQ	ETF	42.45	42.52	42.36	42.52	1455400.0
2002-01-09 13:30:00	QQQ	ETF	42.52	42.6	42.26	42.35	3574100.0
2002-01-09 14:00:00	QQQ	ETF	42.35	42.38	42.1	42.14	4668800.0
2002-01-09 14:30:00	QQQ	ETF	42.16	42.34	42.05	42.11	5103500.0
2002-01-09 15:00:00	QQQ	ETF	42.12	42.17	41.35	41.44	11135800.0
2002-01-09 15:30:00	QQQ	ETF	41.44	41.49	40.9	41.13	13789100.0
2002-01-09 16:00:00	QQQ	ETF	41.13	41.19	40.9	41.14	1542200.0
2002-01-09 16:30:00	QQQ	ETF	41.15	41.25	41.02	41.06	336700.0
2002-01-09 17:00:00	QQQ	ETF	41.08	41.11	41.05	41.1	53700.0
2002-01-09 17:30:00	QQQ	ETF	41.1	41.13	41.05	41.1	38000.0
2002-01-09 18:00:00	QQQ	ETF	41.1	41.13	41.06	41.11	26400.0
2002-01-09 09:30:00	IWM	ETF	49.875	49.94	49.78	49.835	39800.0
2002-01-09 10:00:00	IWM	ETF	49.79	50.065	49.765	50.035	109600.0
2002-01-09 10:30:00	IWM	ETF	50.0	50.02	49.87	49.985	24600.0
2002-01-09 11:00:00	IWM	ETF	49.985	49.99	49.875	49.89	23200.0
2002-01-09 11:30:00	IWM	ETF	49.91	49.915	49.825	49.825	16800.0
2002-01-09 12:00:00	IWM	ETF	49.85	49.865	49.825	49.865	17800.0
2002-01-09 12:30:00	IWM	ETF	49.875	49.995	49.875	49.935	12200.0
2002-01-09 13:00:00	IWM	ETF	49.925	49.975	49.84	49.84	43200.0
2002-01-09 13:30:00	IWM	ETF	49.935	49.985	49.83	49.84	70200.0
2002-01-09 14:00:00	IWM	ETF	49.885	49.895	49.75	49.875	149200.0
2002-01-09 14:30:00	IWM	ETF	49.835	49.885	49.81	49.845	16200.0
2002-01-09 15:00:00	IWM	ETF	49.835	49.845	49.53	49.53	136400.0
2002-01-09 15:30:00	IWM	ETF	49.51	49.57	49.055	49.055	96600.0
2002-01-09 16:00:00	IWM	ETF	49.05	49.15	49.0	49.0	105000.0

> showing 50 of 471 rows — these rows as CSV

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