PREVIEW / etf_30min / 2001-07-20

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-07-20.parquet
  size:    14 KB
  rows:    338

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-20 09:30:00	SPY	ETF	121.15	121.65	121.08	121.31	1532200.0
2001-07-20 10:00:00	SPY	ETF	121.3	121.81	120.92	121.7	645000.0
2001-07-20 10:30:00	SPY	ETF	121.78	121.94	121.56	121.71	482700.0
2001-07-20 11:00:00	SPY	ETF	121.65	121.71	121.23	121.59	301300.0
2001-07-20 11:30:00	SPY	ETF	121.55	121.79	121.41	121.46	147600.0
2001-07-20 12:00:00	SPY	ETF	121.49	121.64	121.26	121.26	466600.0
2001-07-20 12:30:00	SPY	ETF	121.28	121.46	121.21	121.39	137000.0
2001-07-20 13:00:00	SPY	ETF	121.43	121.49	121.04	121.04	188400.0
2001-07-20 13:30:00	SPY	ETF	121.14	121.39	121.07	121.33	206900.0
2001-07-20 14:00:00	SPY	ETF	121.29	121.54	121.18	121.5	217200.0
2001-07-20 14:30:00	SPY	ETF	121.54	121.64	121.42	121.5	805500.0
2001-07-20 15:00:00	SPY	ETF	121.56	121.58	121.33	121.44	233100.0
2001-07-20 15:30:00	SPY	ETF	121.46	121.55	121.27	121.44	804400.0
2001-07-20 16:00:00	SPY	ETF	121.41	121.47	121.16	121.34	433000.0
2001-07-20 16:30:00	SPY	ETF	121.27	121.27	121.27	121.27	100.0
2001-07-20 17:00:00	SPY	ETF	121.34	121.34	121.34	121.34	400.0
2001-07-20 09:30:00	QQQ	ETF	41.49	41.85	41.36	41.57	9167700.0
2001-07-20 10:00:00	QQQ	ETF	41.58	41.91	41.4	41.88	6354600.0
2001-07-20 10:30:00	QQQ	ETF	41.89	42.14	41.75	42.0	6188100.0
2001-07-20 11:00:00	QQQ	ETF	42.0	42.04	41.63	41.87	2721400.0
2001-07-20 11:30:00	QQQ	ETF	41.87	42.04	41.75	41.76	2337300.0
2001-07-20 12:00:00	QQQ	ETF	41.78	41.93	41.58	41.62	1354100.0
2001-07-20 12:30:00	QQQ	ETF	41.63	41.8	41.52	41.66	1870600.0
2001-07-20 13:00:00	QQQ	ETF	41.66	41.74	41.5	41.58	2388900.0
2001-07-20 13:30:00	QQQ	ETF	41.57	41.78	41.53	41.7	1090100.0
2001-07-20 14:00:00	QQQ	ETF	41.67	41.98	41.65	41.95	1937700.0
2001-07-20 14:30:00	QQQ	ETF	41.96	42.05	41.84	41.9	2571500.0
2001-07-20 15:00:00	QQQ	ETF	41.9	42.0	41.77	41.83	2443200.0
2001-07-20 15:30:00	QQQ	ETF	41.84	41.85	41.7	41.81	4033000.0
2001-07-20 16:00:00	QQQ	ETF	41.81	41.85	41.65	41.74	1915700.0
2001-07-20 16:30:00	QQQ	ETF	41.72	41.8	41.71	41.75	41600.0
2001-07-20 17:00:00	QQQ	ETF	41.75	41.8	41.74	41.79	7300.0
2001-07-20 17:30:00	QQQ	ETF	41.73	41.83	41.73	41.78	7000.0
2001-07-20 18:00:00	QQQ	ETF	41.8	41.84	41.75	41.75	7200.0
2001-07-20 09:30:00	IWM	ETF	48.25	48.575	48.25	48.28	98800.0
2001-07-20 10:00:00	IWM	ETF	48.325	48.595	48.305	48.595	38200.0
2001-07-20 10:30:00	IWM	ETF	48.595	48.8	48.59	48.8	30200.0
2001-07-20 11:00:00	IWM	ETF	48.75	48.77	48.61	48.65	37400.0
2001-07-20 11:30:00	IWM	ETF	48.675	48.77	48.58	48.77	130600.0
2001-07-20 12:00:00	IWM	ETF	48.715	48.75	48.575	48.67	48000.0
2001-07-20 12:30:00	IWM	ETF	48.575	48.625	48.555	48.6	36400.0
2001-07-20 13:00:00	IWM	ETF	48.525	48.62	48.505	48.525	31400.0
2001-07-20 13:30:00	IWM	ETF	48.55	48.62	48.455	48.455	32000.0
2001-07-20 14:00:00	IWM	ETF	48.62	48.645	48.6	48.645	43400.0
2001-07-20 14:30:00	IWM	ETF	48.65	48.73	48.56	48.73	11600.0
2001-07-20 15:00:00	IWM	ETF	48.71	48.745	48.65	48.72	48800.0
2001-07-20 15:30:00	IWM	ETF	48.71	48.72	48.585	48.585	26600.0
2001-07-20 16:00:00	IWM	ETF	48.65	48.65	48.5	48.5	13600.0
2001-07-20 09:30:00	DIA	ETF	105.55	105.89	105.41	105.65	399600.0
2001-07-20 10:00:00	DIA	ETF	105.61	106.03	105.36	105.9	110800.0

> showing 50 of 338 rows — these rows as CSV

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