PREVIEW / etf_30min / 2001-11-27

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-11-27.parquet
  size:    18 KB
  rows:    467

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-11-27 09:30:00	SPY	ETF	115.62	115.85	115.46	115.8	1205900.0
2001-11-27 10:00:00	SPY	ETF	115.82	115.84	114.61	115.0	2721400.0
2001-11-27 10:30:00	SPY	ETF	115.05	115.06	114.51	114.59	905500.0
2001-11-27 11:00:00	SPY	ETF	114.61	115.04	114.52	114.9	630300.0
2001-11-27 11:30:00	SPY	ETF	114.95	115.14	114.81	115.01	622900.0
2001-11-27 12:00:00	SPY	ETF	115.0	115.34	114.94	115.2	833700.0
2001-11-27 12:30:00	SPY	ETF	115.2	115.25	115.01	115.18	613100.0
2001-11-27 13:00:00	SPY	ETF	115.16	115.98	115.16	115.95	2267300.0
2001-11-27 13:30:00	SPY	ETF	115.98	116.46	115.77	116.46	1292200.0
2001-11-27 14:00:00	SPY	ETF	116.39	116.9	116.36	116.42	1742000.0
2001-11-27 14:30:00	SPY	ETF	116.42	116.61	116.0	116.02	1052000.0
2001-11-27 15:00:00	SPY	ETF	116.03	116.17	115.4	115.6	2205000.0
2001-11-27 15:30:00	SPY	ETF	115.58	115.6	115.07	115.4	1859100.0
2001-11-27 16:00:00	SPY	ETF	115.37	116.08	115.35	115.5	842300.0
2001-11-27 16:30:00	SPY	ETF	115.4	115.47	115.4	115.47	27700.0
2001-11-27 09:30:00	QQQ	ETF	40.05	40.24	39.88	40.17	8881300.0
2001-11-27 10:00:00	QQQ	ETF	40.17	40.2	39.51	39.73	10521100.0
2001-11-27 10:30:00	QQQ	ETF	39.74	39.77	39.2	39.3	7206800.0
2001-11-27 11:00:00	QQQ	ETF	39.31	39.63	39.23	39.5	7375400.0
2001-11-27 11:30:00	QQQ	ETF	39.53	39.69	39.45	39.62	4482000.0
2001-11-27 12:00:00	QQQ	ETF	39.61	39.95	39.59	39.85	4738600.0
2001-11-27 12:30:00	QQQ	ETF	39.85	39.92	39.7	39.84	2734400.0
2001-11-27 13:00:00	QQQ	ETF	39.84	40.46	39.82	40.37	9430600.0
2001-11-27 13:30:00	QQQ	ETF	40.4	40.82	40.21	40.78	8278300.0
2001-11-27 14:00:00	QQQ	ETF	40.8	40.97	40.7	40.75	9670800.0
2001-11-27 14:30:00	QQQ	ETF	40.76	40.93	40.62	40.62	5873700.0
2001-11-27 15:00:00	QQQ	ETF	40.64	40.7	40.09	40.19	9926100.0
2001-11-27 15:30:00	QQQ	ETF	40.19	40.24	39.82	40.13	7344300.0
2001-11-27 16:00:00	QQQ	ETF	40.15	40.9	40.11	40.15	1474500.0
2001-11-27 16:30:00	QQQ	ETF	40.2	40.2	40.13	40.15	65000.0
2001-11-27 09:30:00	IWM	ETF	45.95	45.975	45.85	45.975	48200.0
2001-11-27 10:00:00	IWM	ETF	45.975	45.975	45.555	45.565	128400.0
2001-11-27 10:30:00	IWM	ETF	45.715	45.715	45.64	45.64	1800.0
2001-11-27 11:00:00	IWM	ETF	45.635	45.765	45.575	45.765	44800.0
2001-11-27 11:30:00	IWM	ETF	45.675	45.715	45.585	45.585	10000.0
2001-11-27 12:00:00	IWM	ETF	45.67	45.78	45.67	45.78	10800.0
2001-11-27 12:30:00	IWM	ETF	45.78	45.79	45.735	45.78	7600.0
2001-11-27 13:00:00	IWM	ETF	45.79	45.935	45.79	45.935	5600.0
2001-11-27 13:30:00	IWM	ETF	45.95	46.1	45.95	46.1	52400.0
2001-11-27 14:00:00	IWM	ETF	46.12	46.17	46.065	46.065	5600.0
2001-11-27 14:30:00	IWM	ETF	46.08	46.12	46.035	46.035	74000.0
2001-11-27 15:00:00	IWM	ETF	46.025	46.03	45.93	45.93	4400.0
2001-11-27 15:30:00	IWM	ETF	45.845	45.955	45.825	45.955	22800.0
2001-11-27 16:00:00	IWM	ETF	45.855	45.855	45.825	45.825	1200.0
2001-11-27 09:30:00	DIA	ETF	99.5	99.63	99.32	99.56	542900.0
2001-11-27 10:00:00	DIA	ETF	99.57	99.57	98.6	98.85	735900.0
2001-11-27 10:30:00	DIA	ETF	98.89	98.94	98.41	98.56	199600.0
2001-11-27 11:00:00	DIA	ETF	98.56	98.86	98.5	98.75	296800.0
2001-11-27 11:30:00	DIA	ETF	98.77	98.94	98.63	98.79	281200.0
2001-11-27 12:00:00	DIA	ETF	98.81	99.0	98.73	98.96	628800.0

> showing 50 of 467 rows — these rows as CSV

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