PREVIEW / etf_30min / 2001-03-14

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-03-14.parquet
  size:    15 KB
  rows:    380

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-03-14 09:30:00	SPY	ETF	117.05	117.96	115.99	117.66	2642900.0
2001-03-14 10:00:00	SPY	ETF	117.75	119.0	117.5	118.4	2028300.0
2001-03-14 10:30:00	SPY	ETF	118.34	119.29	118.1	118.68	1224500.0
2001-03-14 11:00:00	SPY	ETF	118.65	118.94	118.04	118.32	617800.0
2001-03-14 11:30:00	SPY	ETF	118.3	118.65	117.16	117.16	631800.0
2001-03-14 12:00:00	SPY	ETF	117.15	117.48	116.62	116.62	2641300.0
2001-03-14 12:30:00	SPY	ETF	116.75	117.32	116.44	116.9	493900.0
2001-03-14 13:00:00	SPY	ETF	116.85	116.93	115.75	116.39	1361200.0
2001-03-14 13:30:00	SPY	ETF	116.2	117.64	116.01	117.04	641300.0
2001-03-14 14:00:00	SPY	ETF	117.23	117.83	117.0	117.35	604900.0
2001-03-14 14:30:00	SPY	ETF	117.25	117.37	116.33	116.58	865200.0
2001-03-14 15:00:00	SPY	ETF	116.7	117.2	116.1	116.69	1292500.0
2001-03-14 15:30:00	SPY	ETF	116.79	117.8	116.62	117.2	1613500.0
2001-03-14 16:00:00	SPY	ETF	117.05	117.65	116.75	117.65	879500.0
2001-03-14 16:30:00	SPY	ETF	117.65	117.65	117.31	117.63	1903700.0
2001-03-14 17:00:00	SPY	ETF	117.25	117.25	117.25	117.25	1500.0
2001-03-14 09:30:00	QQQ	ETF	42.7	43.92	42.31	43.33	14779500.0
2001-03-14 10:00:00	QQQ	ETF	43.5	44.7	43.3	44.13	12184800.0
2001-03-14 10:30:00	QQQ	ETF	44.2	45.12	43.88	44.74	9360200.0
2001-03-14 11:00:00	QQQ	ETF	44.7	44.83	44.0	44.18	3955700.0
2001-03-14 11:30:00	QQQ	ETF	44.2	44.58	43.4	43.4	5034400.0
2001-03-14 12:00:00	QQQ	ETF	43.5	43.71	43.02	43.05	7122300.0
2001-03-14 12:30:00	QQQ	ETF	43.08	43.52	42.8	43.4	5083600.0
2001-03-14 13:00:00	QQQ	ETF	43.4	43.45	42.6	42.9	4400900.0
2001-03-14 13:30:00	QQQ	ETF	42.98	43.67	42.82	43.54	4806400.0
2001-03-14 14:00:00	QQQ	ETF	43.55	43.96	43.37	43.75	5380200.0
2001-03-14 14:30:00	QQQ	ETF	43.7	43.8	43.01	43.14	4896000.0
2001-03-14 15:00:00	QQQ	ETF	43.22	43.62	42.73	43.45	5072100.0
2001-03-14 15:30:00	QQQ	ETF	43.46	44.28	43.35	43.51	9230300.0
2001-03-14 16:00:00	QQQ	ETF	43.5	44.74	42.75	43.65	1658600.0
2001-03-14 16:30:00	QQQ	ETF	43.69	43.86	43.6	43.79	59300.0
2001-03-14 17:00:00	QQQ	ETF	43.79	44.15	43.6	43.77	52100.0
2001-03-14 17:30:00	QQQ	ETF	43.82	43.87	43.77	43.87	40400.0
2001-03-14 18:00:00	QQQ	ETF	43.81	43.91	43.7	43.75	7500.0
2001-03-14 09:30:00	IWM	ETF	44.875	45.275	44.85	45.275	66800.0
2001-03-14 10:00:00	IWM	ETF	45.25	45.7	45.05	45.625	366400.0
2001-03-14 10:30:00	IWM	ETF	45.75	46.15	45.695	46.15	4600.0
2001-03-14 11:00:00	IWM	ETF	46.12	46.125	45.725	45.725	52600.0
2001-03-14 11:30:00	IWM	ETF	45.73	45.73	45.55	45.55	10600.0
2001-03-14 12:00:00	IWM	ETF	45.525	45.525	45.38	45.38	800.0
2001-03-14 12:30:00	IWM	ETF	45.325	45.325	45.325	45.325	7600.0
2001-03-14 13:00:00	IWM	ETF	45.175	45.375	45.125	45.375	32000.0
2001-03-14 13:30:00	IWM	ETF	45.35	45.375	45.15	45.375	1800.0
2001-03-14 14:00:00	IWM	ETF	45.405	45.575	45.35	45.35	1400.0
2001-03-14 14:30:00	IWM	ETF	45.25	45.375	45.25	45.34	4400.0
2001-03-14 15:00:00	IWM	ETF	45.2	45.275	45.05	45.175	89600.0
2001-03-14 15:30:00	IWM	ETF	45.375	45.52	45.2	45.2	8400.0
2001-03-14 09:30:00	DIA	ETF	100.25	101.1	99.5	100.69	1793000.0
2001-03-14 10:00:00	DIA	ETF	100.5	101.7	100.4	101.39	864000.0
2001-03-14 10:30:00	DIA	ETF	101.39	101.9	100.84	101.3	730700.0

> showing 50 of 380 rows — these rows as CSV

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