PREVIEW / etf_30min / 2001-07-17

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-07-17.parquet
  size:    15 KB
  rows:    363

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-17 09:30:00	SPY	ETF	120.2	120.63	119.83	120.1	748200.0
2001-07-17 10:00:00	SPY	ETF	120.1	120.6	119.87	120.55	581900.0
2001-07-17 10:30:00	SPY	ETF	120.56	121.04	120.56	120.75	630800.0
2001-07-17 11:00:00	SPY	ETF	120.7	120.73	120.35	120.68	401500.0
2001-07-17 11:30:00	SPY	ETF	120.67	120.89	120.35	120.4	430100.0
2001-07-17 12:00:00	SPY	ETF	120.4	120.64	120.33	120.43	187000.0
2001-07-17 12:30:00	SPY	ETF	120.42	120.65	120.16	120.65	273600.0
2001-07-17 13:00:00	SPY	ETF	120.6	120.94	120.42	120.94	260900.0
2001-07-17 13:30:00	SPY	ETF	120.9	121.14	120.79	121.14	360700.0
2001-07-17 14:00:00	SPY	ETF	121.05	121.54	121.05	121.49	567100.0
2001-07-17 14:30:00	SPY	ETF	121.5	121.94	121.36	121.68	1129600.0
2001-07-17 15:00:00	SPY	ETF	121.66	121.93	121.6	121.6	514200.0
2001-07-17 15:30:00	SPY	ETF	121.57	121.81	121.52	121.67	585900.0
2001-07-17 16:00:00	SPY	ETF	121.75	122.71	121.63	122.2	529700.0
2001-07-17 16:30:00	SPY	ETF	121.9	122.3	121.5	121.8	79800.0
2001-07-17 17:00:00	SPY	ETF	121.65	121.75	121.59	121.67	21400.0
2001-07-17 17:30:00	SPY	ETF	121.5	121.79	121.5	121.79	600.0
2001-07-17 18:00:00	SPY	ETF	121.79	121.79	121.79	121.79	500.0
2001-07-17 09:30:00	QQQ	ETF	41.82	42.15	41.54	41.76	10435300.0
2001-07-17 10:00:00	QQQ	ETF	41.79	42.25	41.56	42.24	6524700.0
2001-07-17 10:30:00	QQQ	ETF	42.2	42.6	42.17	42.27	5433900.0
2001-07-17 11:00:00	QQQ	ETF	42.27	42.39	42.06	42.38	2549000.0
2001-07-17 11:30:00	QQQ	ETF	42.37	42.5	42.14	42.15	2586900.0
2001-07-17 12:00:00	QQQ	ETF	42.15	42.25	42.0	42.02	1767300.0
2001-07-17 12:30:00	QQQ	ETF	42.02	42.25	41.88	42.2	1432500.0
2001-07-17 13:00:00	QQQ	ETF	42.18	42.5	41.99	42.45	3308300.0
2001-07-17 13:30:00	QQQ	ETF	42.45	42.67	42.3	42.64	4020200.0
2001-07-17 14:00:00	QQQ	ETF	42.6	42.94	42.55	42.9	3597300.0
2001-07-17 14:30:00	QQQ	ETF	42.9	43.05	42.7	42.85	3416100.0
2001-07-17 15:00:00	QQQ	ETF	42.87	43.12	42.7	42.88	4208300.0
2001-07-17 15:30:00	QQQ	ETF	42.89	43.11	42.82	43.08	4892800.0
2001-07-17 16:00:00	QQQ	ETF	43.06	43.75	42.93	43.55	2257100.0
2001-07-17 16:30:00	QQQ	ETF	43.55	44.0	42.75	42.9	979100.0
2001-07-17 17:00:00	QQQ	ETF	42.86	43.05	42.86	43.0	108100.0
2001-07-17 17:30:00	QQQ	ETF	42.97	43.05	42.9	43.05	127100.0
2001-07-17 18:00:00	QQQ	ETF	43.05	43.14	42.91	42.91	48700.0
2001-07-17 09:30:00	IWM	ETF	48.05	48.24	47.95	48.01	26000.0
2001-07-17 10:00:00	IWM	ETF	48.05	48.1	47.995	48.1	22600.0
2001-07-17 10:30:00	IWM	ETF	48.16	48.25	48.16	48.25	30600.0
2001-07-17 11:00:00	IWM	ETF	48.25	48.25	48.2	48.2	19600.0
2001-07-17 11:30:00	IWM	ETF	48.22	48.29	48.125	48.22	19600.0
2001-07-17 12:00:00	IWM	ETF	48.1	48.2	48.1	48.125	64200.0
2001-07-17 12:30:00	IWM	ETF	48.16	48.175	48.125	48.175	21400.0
2001-07-17 13:00:00	IWM	ETF	48.135	48.24	48.13	48.24	12800.0
2001-07-17 13:30:00	IWM	ETF	48.195	48.36	48.195	48.36	64400.0
2001-07-17 14:00:00	IWM	ETF	48.34	48.54	48.34	48.535	27600.0
2001-07-17 14:30:00	IWM	ETF	48.56	48.625	48.505	48.595	49200.0
2001-07-17 15:00:00	IWM	ETF	48.69	48.775	48.69	48.77	147600.0
2001-07-17 15:30:00	IWM	ETF	48.775	48.905	48.705	48.905	24200.0
2001-07-17 16:00:00	IWM	ETF	48.905	49.025	48.9	49.025	22000.0

> showing 50 of 363 rows — these rows as CSV

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