PREVIEW / etf_30min / 2002-04-19

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-04-19.parquet
  size:    17 KB
  rows:    479

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-04-19 09:30:00	SPY	ETF	113.2	113.24	112.89	112.9	2328300.0
2002-04-19 10:00:00	SPY	ETF	112.91	113.04	112.64	112.89	951200.0
2002-04-19 10:30:00	SPY	ETF	112.89	112.99	112.58	112.77	637500.0
2002-04-19 11:00:00	SPY	ETF	112.77	112.91	112.62	112.78	470600.0
2002-04-19 11:30:00	SPY	ETF	112.76	113.09	112.76	112.95	610200.0
2002-04-19 12:00:00	SPY	ETF	112.98	113.03	112.87	112.9	156100.0
2002-04-19 12:30:00	SPY	ETF	112.9	113.15	112.9	113.01	523600.0
2002-04-19 13:00:00	SPY	ETF	113.04	113.14	112.96	113.0	164300.0
2002-04-19 13:30:00	SPY	ETF	112.98	113.0	112.56	112.75	1523200.0
2002-04-19 14:00:00	SPY	ETF	112.76	112.98	112.67	112.93	804700.0
2002-04-19 14:30:00	SPY	ETF	112.92	112.98	112.81	112.83	327000.0
2002-04-19 15:00:00	SPY	ETF	112.84	112.92	112.7	112.86	289900.0
2002-04-19 15:30:00	SPY	ETF	112.88	112.97	112.67	112.85	546800.0
2002-04-19 16:00:00	SPY	ETF	112.83	112.93	112.72	112.86	593700.0
2002-04-19 16:30:00	SPY	ETF	112.84	112.84	112.72	112.84	12500.0
2002-04-19 09:30:00	QQQ	ETF	35.05	35.06	34.75	34.76	11574900.0
2002-04-19 10:00:00	QQQ	ETF	34.77	34.85	34.56	34.71	9046500.0
2002-04-19 10:30:00	QQQ	ETF	34.73	34.79	34.48	34.58	6139400.0
2002-04-19 11:00:00	QQQ	ETF	34.58	34.65	34.42	34.49	4531900.0
2002-04-19 11:30:00	QQQ	ETF	34.5	34.66	34.49	34.58	1725000.0
2002-04-19 12:00:00	QQQ	ETF	34.57	34.64	34.54	34.58	1207100.0
2002-04-19 12:30:00	QQQ	ETF	34.61	34.74	34.56	34.68	1588000.0
2002-04-19 13:00:00	QQQ	ETF	34.68	34.79	34.66	34.69	2097300.0
2002-04-19 13:30:00	QQQ	ETF	34.71	34.72	34.38	34.53	3304000.0
2002-04-19 14:00:00	QQQ	ETF	34.53	34.71	34.48	34.69	3162500.0
2002-04-19 14:30:00	QQQ	ETF	34.67	34.73	34.57	34.67	1857600.0
2002-04-19 15:00:00	QQQ	ETF	34.66	34.68	34.54	34.64	2967700.0
2002-04-19 15:30:00	QQQ	ETF	34.64	34.68	34.46	34.5	4234700.0
2002-04-19 16:00:00	QQQ	ETF	34.48	34.65	34.42	34.46	3494800.0
2002-04-19 16:30:00	QQQ	ETF	34.46	34.52	34.44	34.47	1084200.0
2002-04-19 17:00:00	QQQ	ETF	34.46	34.5	34.4	34.45	52600.0
2002-04-19 17:30:00	QQQ	ETF	34.44	34.49	34.42	34.48	15200.0
2002-04-19 18:00:00	QQQ	ETF	34.49	34.5	34.43	34.43	11200.0
2002-04-19 09:30:00	IWM	ETF	51.8	51.82	51.625	51.68	142000.0
2002-04-19 10:00:00	IWM	ETF	51.65	51.68	51.555	51.575	29600.0
2002-04-19 10:30:00	IWM	ETF	51.575	51.63	51.5	51.525	121800.0
2002-04-19 11:00:00	IWM	ETF	51.55	51.555	51.485	51.54	13600.0
2002-04-19 11:30:00	IWM	ETF	51.55	51.595	51.55	51.595	7800.0
2002-04-19 12:00:00	IWM	ETF	51.605	51.615	51.53	51.615	136800.0
2002-04-19 12:30:00	IWM	ETF	51.615	51.655	51.6	51.64	17000.0
2002-04-19 13:00:00	IWM	ETF	51.655	51.7	51.655	51.7	17600.0
2002-04-19 13:30:00	IWM	ETF	51.675	51.695	51.575	51.61	23600.0
2002-04-19 14:00:00	IWM	ETF	51.61	51.67	51.54	51.67	6200.0
2002-04-19 14:30:00	IWM	ETF	51.67	51.68	51.59	51.59	9400.0
2002-04-19 15:00:00	IWM	ETF	51.66	51.66	51.57	51.57	29200.0
2002-04-19 15:30:00	IWM	ETF	51.6	51.69	51.46	51.535	184400.0
2002-04-19 16:00:00	IWM	ETF	51.45	51.45	51.45	51.45	200.0
2002-04-19 09:30:00	DIA	ETF	102.85	102.91	102.48	102.49	822700.0
2002-04-19 10:00:00	DIA	ETF	102.5	102.62	102.23	102.42	262600.0
2002-04-19 10:30:00	DIA	ETF	102.47	102.59	102.2	102.31	122400.0

> showing 50 of 479 rows — these rows as CSV

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