PREVIEW / etf_30min / 2002-01-14

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-01-14.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-14 09:30:00	SPY	ETF	114.65	114.84	114.48	114.72	1427800.0
2002-01-14 10:00:00	SPY	ETF	114.7	114.82	114.42	114.55	1581700.0
2002-01-14 10:30:00	SPY	ETF	114.57	114.62	114.18	114.38	1071600.0
2002-01-14 11:00:00	SPY	ETF	114.36	114.43	114.18	114.37	602900.0
2002-01-14 11:30:00	SPY	ETF	114.4	114.46	114.25	114.37	465800.0
2002-01-14 12:00:00	SPY	ETF	114.39	114.39	114.15	114.25	537400.0
2002-01-14 12:30:00	SPY	ETF	114.25	114.36	114.1	114.34	408600.0
2002-01-14 13:00:00	SPY	ETF	114.33	114.43	114.28	114.28	404000.0
2002-01-14 13:30:00	SPY	ETF	114.35	114.6	114.33	114.57	1463800.0
2002-01-14 14:00:00	SPY	ETF	114.6	114.63	114.29	114.39	772400.0
2002-01-14 14:30:00	SPY	ETF	114.37	114.63	114.22	114.54	773500.0
2002-01-14 15:00:00	SPY	ETF	114.55	114.8	114.54	114.63	848600.0
2002-01-14 15:30:00	SPY	ETF	114.63	114.64	114.1	114.12	1002800.0
2002-01-14 16:00:00	SPY	ETF	114.13	114.22	113.96	114.13	755500.0
2002-01-14 16:30:00	SPY	ETF	114.13	114.22	114.13	114.2	6200.0
2002-01-14 18:00:00	SPY	ETF	114.16	114.25	114.16	114.25	3200.0
2002-01-14 09:30:00	QQQ	ETF	40.49	40.68	40.34	40.45	7860900.0
2002-01-14 10:00:00	QQQ	ETF	40.46	40.53	40.13	40.24	6143000.0
2002-01-14 10:30:00	QQQ	ETF	40.25	40.32	39.97	40.05	6250700.0
2002-01-14 11:00:00	QQQ	ETF	40.05	40.13	39.89	40.06	5472600.0
2002-01-14 11:30:00	QQQ	ETF	40.06	40.11	39.96	40.02	3499700.0
2002-01-14 12:00:00	QQQ	ETF	40.0	40.01	39.73	39.79	2850900.0
2002-01-14 12:30:00	QQQ	ETF	39.79	39.91	39.7	39.89	3204000.0
2002-01-14 13:00:00	QQQ	ETF	39.89	40.04	39.87	39.92	2687000.0
2002-01-14 13:30:00	QQQ	ETF	39.94	40.11	39.92	40.09	4469600.0
2002-01-14 14:00:00	QQQ	ETF	40.07	40.15	39.83	39.96	5448600.0
2002-01-14 14:30:00	QQQ	ETF	39.94	40.27	39.86	40.23	4568900.0
2002-01-14 15:00:00	QQQ	ETF	40.25	40.45	40.2	40.26	6082100.0
2002-01-14 15:30:00	QQQ	ETF	40.27	40.29	39.85	39.9	8221200.0
2002-01-14 16:00:00	QQQ	ETF	39.9	39.99	39.84	39.93	1054000.0
2002-01-14 16:30:00	QQQ	ETF	39.93	39.96	39.9	39.94	56700.0
2002-01-14 17:00:00	QQQ	ETF	39.93	39.95	39.85	39.9	39700.0
2002-01-14 17:30:00	QQQ	ETF	39.9	39.91	39.86	39.91	6800.0
2002-01-14 18:00:00	QQQ	ETF	39.89	39.91	39.84	39.85	13700.0
2002-01-14 09:30:00	IWM	ETF	48.63	48.63	48.4	48.615	108200.0
2002-01-14 10:00:00	IWM	ETF	48.545	48.545	48.25	48.325	74200.0
2002-01-14 10:30:00	IWM	ETF	48.325	48.325	48.11	48.12	83000.0
2002-01-14 11:00:00	IWM	ETF	48.145	48.175	48.04	48.12	29000.0
2002-01-14 11:30:00	IWM	ETF	48.15	48.15	48.06	48.12	64600.0
2002-01-14 12:00:00	IWM	ETF	48.14	48.14	48.025	48.1	9000.0
2002-01-14 12:30:00	IWM	ETF	48.0	48.11	47.985	48.075	30600.0
2002-01-14 13:00:00	IWM	ETF	48.085	48.195	48.085	48.18	108000.0
2002-01-14 13:30:00	IWM	ETF	48.165	48.215	48.1	48.175	15200.0
2002-01-14 14:00:00	IWM	ETF	48.21	48.215	48.125	48.15	16800.0
2002-01-14 14:30:00	IWM	ETF	48.14	48.175	48.04	48.175	42800.0
2002-01-14 15:00:00	IWM	ETF	48.125	48.235	48.125	48.175	60800.0
2002-01-14 15:30:00	IWM	ETF	48.2	48.205	47.85	47.85	132400.0
2002-01-14 16:00:00	IWM	ETF	47.925	47.975	47.925	47.975	3200.0
2002-01-14 09:30:00	DIA	ETF	99.74	99.86	99.52	99.68	233300.0
2002-01-14 10:00:00	DIA	ETF	99.64	99.7	99.41	99.6	128200.0

> showing 50 of 471 rows — these rows as CSV

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