PREVIEW / etf_30min / 2001-04-23

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-04-23.parquet
  size:    14 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-04-23 09:30:00	SPY	ETF	123.65	123.89	123.1	123.46	1236900.0
2001-04-23 10:00:00	SPY	ETF	123.49	123.63	123.01	123.06	806700.0
2001-04-23 10:30:00	SPY	ETF	123.0	123.38	122.73	122.95	490500.0
2001-04-23 11:00:00	SPY	ETF	122.98	123.2	122.64	122.79	546600.0
2001-04-23 11:30:00	SPY	ETF	122.72	123.05	122.5	122.67	312500.0
2001-04-23 12:00:00	SPY	ETF	122.7	122.79	122.39	122.5	377200.0
2001-04-23 12:30:00	SPY	ETF	122.59	122.7	122.4	122.51	405100.0
2001-04-23 13:00:00	SPY	ETF	122.53	122.85	122.46	122.65	442500.0
2001-04-23 13:30:00	SPY	ETF	122.56	122.65	122.35	122.52	83500.0
2001-04-23 14:00:00	SPY	ETF	122.54	122.55	122.11	122.22	545900.0
2001-04-23 14:30:00	SPY	ETF	122.18	122.64	122.12	122.36	1117400.0
2001-04-23 15:00:00	SPY	ETF	122.35	122.55	121.91	122.22	418200.0
2001-04-23 15:30:00	SPY	ETF	122.2	122.8	122.15	122.7	723000.0
2001-04-23 16:00:00	SPY	ETF	122.7	122.85	121.31	121.76	556600.0
2001-04-23 16:30:00	SPY	ETF	122.28	122.3	122.28	122.3	1500.0
2001-04-23 17:00:00	SPY	ETF	122.08	122.08	122.08	122.08	500.0
2001-04-23 17:30:00	SPY	ETF	122.04	122.04	122.04	122.04	1000.0
2001-04-23 09:30:00	QQQ	ETF	46.99	47.7	46.2	46.47	14912600.0
2001-04-23 10:00:00	QQQ	ETF	46.48	46.6	45.92	45.94	8110300.0
2001-04-23 10:30:00	QQQ	ETF	46.05	46.33	45.81	46.13	7823100.0
2001-04-23 11:00:00	QQQ	ETF	46.05	46.25	45.8	45.94	3686300.0
2001-04-23 11:30:00	QQQ	ETF	45.94	46.1	45.57	45.67	3855400.0
2001-04-23 12:00:00	QQQ	ETF	45.73	45.76	45.48	45.58	3632500.0
2001-04-23 12:30:00	QQQ	ETF	45.61	45.67	45.45	45.58	3063700.0
2001-04-23 13:00:00	QQQ	ETF	45.59	45.94	45.5	45.72	3693400.0
2001-04-23 13:30:00	QQQ	ETF	45.76	45.78	45.34	45.45	2930500.0
2001-04-23 14:00:00	QQQ	ETF	45.39	45.47	45.0	45.1	5687300.0
2001-04-23 14:30:00	QQQ	ETF	45.15	45.45	45.05	45.21	4386700.0
2001-04-23 15:00:00	QQQ	ETF	45.2	45.26	44.89	45.14	4660400.0
2001-04-23 15:30:00	QQQ	ETF	45.15	45.33	45.0	45.13	5265600.0
2001-04-23 16:00:00	QQQ	ETF	45.13	45.22	44.8	44.94	957200.0
2001-04-23 16:30:00	QQQ	ETF	45.0	45.15	44.91	45.0	146800.0
2001-04-23 17:00:00	QQQ	ETF	44.95	45.0	44.77	44.89	201000.0
2001-04-23 17:30:00	QQQ	ETF	44.82	44.9	44.65	44.79	16800.0
2001-04-23 18:00:00	QQQ	ETF	44.8	44.84	44.72	44.83	4800.0
2001-04-23 09:30:00	IWM	ETF	46.0	46.2	46.0	46.0	51000.0
2001-04-23 10:00:00	IWM	ETF	46.1	46.175	46.0	46.0	28800.0
2001-04-23 10:30:00	IWM	ETF	46.19	46.19	46.0	46.0	7200.0
2001-04-23 11:00:00	IWM	ETF	46.1	46.1	46.1	46.1	200.0
2001-04-23 11:30:00	IWM	ETF	46.15	46.15	46.0	46.0	3600.0
2001-04-23 12:00:00	IWM	ETF	46.0	46.1	46.0	46.075	7200.0
2001-04-23 12:30:00	IWM	ETF	46.05	46.075	46.0	46.04	3200.0
2001-04-23 13:00:00	IWM	ETF	46.0	46.0	45.865	45.945	3000.0
2001-04-23 13:30:00	IWM	ETF	45.94	45.94	45.85	45.85	1000.0
2001-04-23 14:00:00	IWM	ETF	45.975	45.975	45.975	45.975	1000.0
2001-04-23 14:30:00	IWM	ETF	45.945	45.975	45.9	45.975	21000.0
2001-04-23 15:00:00	IWM	ETF	46.045	46.045	45.87	45.875	35200.0
2001-04-23 15:30:00	IWM	ETF	45.875	45.95	45.84	45.86	33400.0
2001-04-23 16:00:00	IWM	ETF	45.85	45.85	45.75	45.8	94600.0
2001-04-23 09:30:00	DIA	ETF	105.35	105.6	105.15	105.39	398900.0

> showing 50 of 363 rows — these rows as CSV

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