PREVIEW / etf_30min / 2001-08-07

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-08-07.parquet
  size:    14 KB
  rows:    368

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-08-07 09:30:00	SPY	ETF	120.27	120.46	119.91	120.42	780400.0
2001-08-07 10:00:00	SPY	ETF	120.43	120.74	120.36	120.63	876900.0
2001-08-07 10:30:00	SPY	ETF	120.63	121.2	120.58	120.97	917800.0
2001-08-07 11:00:00	SPY	ETF	121.01	121.02	120.8	120.85	1106900.0
2001-08-07 11:30:00	SPY	ETF	120.83	120.96	120.82	120.9	253500.0
2001-08-07 12:00:00	SPY	ETF	120.91	120.96	120.67	120.73	171100.0
2001-08-07 12:30:00	SPY	ETF	120.75	120.75	120.35	120.38	269800.0
2001-08-07 13:00:00	SPY	ETF	120.38	120.67	120.38	120.65	408100.0
2001-08-07 13:30:00	SPY	ETF	120.68	120.71	120.47	120.58	572200.0
2001-08-07 14:00:00	SPY	ETF	120.57	120.66	120.36	120.66	436000.0
2001-08-07 14:30:00	SPY	ETF	120.63	120.77	120.5	120.5	508500.0
2001-08-07 15:00:00	SPY	ETF	120.53	120.65	120.27	120.61	1001500.0
2001-08-07 15:30:00	SPY	ETF	120.63	120.88	120.54	120.82	559300.0
2001-08-07 16:00:00	SPY	ETF	120.82	120.87	120.64	120.77	850300.0
2001-08-07 17:00:00	SPY	ETF	121.3	121.5	120.78	120.78	1300.0
2001-08-07 17:30:00	SPY	ETF	121.11	121.11	120.5	120.6	2200.0
2001-08-07 09:30:00	QQQ	ETF	42.1	42.35	41.95	42.33	5831100.0
2001-08-07 10:00:00	QQQ	ETF	42.35	42.41	42.17	42.3	4948200.0
2001-08-07 10:30:00	QQQ	ETF	42.31	42.82	42.27	42.72	4200400.0
2001-08-07 11:00:00	QQQ	ETF	42.73	42.76	42.62	42.62	3421700.0
2001-08-07 11:30:00	QQQ	ETF	42.62	42.71	42.56	42.62	744000.0
2001-08-07 12:00:00	QQQ	ETF	42.62	42.66	42.4	42.44	1237000.0
2001-08-07 12:30:00	QQQ	ETF	42.45	42.46	42.15	42.22	1698700.0
2001-08-07 13:00:00	QQQ	ETF	42.2	42.38	42.15	42.38	1249500.0
2001-08-07 13:30:00	QQQ	ETF	42.38	42.41	42.16	42.31	1214600.0
2001-08-07 14:00:00	QQQ	ETF	42.3	42.32	42.04	42.16	1832100.0
2001-08-07 14:30:00	QQQ	ETF	42.18	42.27	42.12	42.12	1621400.0
2001-08-07 15:00:00	QQQ	ETF	42.12	42.22	41.94	42.2	3669700.0
2001-08-07 15:30:00	QQQ	ETF	42.18	42.33	42.14	42.28	2870200.0
2001-08-07 16:00:00	QQQ	ETF	42.28	42.5	41.95	42.38	1604400.0
2001-08-07 16:30:00	QQQ	ETF	42.38	42.53	42.27	42.5	271600.0
2001-08-07 17:00:00	QQQ	ETF	42.53	42.65	42.29	42.3	262200.0
2001-08-07 17:30:00	QQQ	ETF	42.35	42.4	42.0	42.12	410500.0
2001-08-07 18:00:00	QQQ	ETF	42.15	42.24	42.1	42.16	56700.0
2001-08-07 09:30:00	IWM	ETF	47.9	47.9	47.65	47.745	16400.0
2001-08-07 10:00:00	IWM	ETF	47.805	47.875	47.75	47.875	8600.0
2001-08-07 10:30:00	IWM	ETF	48.0	48.0	47.985	47.995	1400.0
2001-08-07 11:00:00	IWM	ETF	47.98	48.05	47.855	47.975	57400.0
2001-08-07 11:30:00	IWM	ETF	47.925	47.995	47.83	47.995	21800.0
2001-08-07 12:00:00	IWM	ETF	47.95	47.95	47.875	47.875	38400.0
2001-08-07 12:30:00	IWM	ETF	47.8	47.9	47.7	47.7	6200.0
2001-08-07 13:00:00	IWM	ETF	47.75	47.85	47.725	47.85	25000.0
2001-08-07 13:30:00	IWM	ETF	47.845	47.845	47.795	47.795	13000.0
2001-08-07 14:00:00	IWM	ETF	47.795	47.795	47.775	47.795	29000.0
2001-08-07 14:30:00	IWM	ETF	47.8	47.825	47.8	47.8	4000.0
2001-08-07 15:00:00	IWM	ETF	47.705	47.8	47.7	47.8	14800.0
2001-08-07 15:30:00	IWM	ETF	47.8	47.975	47.75	47.975	156800.0
2001-08-07 16:00:00	IWM	ETF	48.0	48.0	47.95	47.95	28800.0
2001-08-07 09:30:00	DIA	ETF	104.1	104.2	103.73	104.1	532700.0
2001-08-07 10:00:00	DIA	ETF	104.16	104.35	104.07	104.34	289700.0

> showing 50 of 368 rows — these rows as CSV

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