PREVIEW / etf_30min / 2001-05-24

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-05-24.parquet
  size:    15 KB
  rows:    372

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-05-24 09:30:00	SPY	ETF	129.47	130.0	129.17	129.84	1364000.0
2001-05-24 10:00:00	SPY	ETF	129.84	129.93	128.98	129.0	899500.0
2001-05-24 10:30:00	SPY	ETF	128.96	129.16	128.68	128.75	691200.0
2001-05-24 11:00:00	SPY	ETF	128.75	129.03	128.62	128.85	463900.0
2001-05-24 11:30:00	SPY	ETF	128.85	129.08	128.69	129.0	327000.0
2001-05-24 12:00:00	SPY	ETF	129.06	129.09	128.78	128.96	317500.0
2001-05-24 12:30:00	SPY	ETF	128.96	129.04	128.67	128.67	146400.0
2001-05-24 13:00:00	SPY	ETF	128.65	129.02	128.63	128.65	294500.0
2001-05-24 13:30:00	SPY	ETF	128.73	128.95	128.55	128.84	370300.0
2001-05-24 14:00:00	SPY	ETF	128.86	129.25	128.67	129.11	432700.0
2001-05-24 14:30:00	SPY	ETF	129.1	129.57	129.06	129.35	527800.0
2001-05-24 15:00:00	SPY	ETF	129.39	129.89	129.37	129.6	508900.0
2001-05-24 15:30:00	SPY	ETF	129.64	129.89	129.52	129.7	612200.0
2001-05-24 16:00:00	SPY	ETF	129.7	129.81	129.6	129.64	697200.0
2001-05-24 17:00:00	SPY	ETF	129.75	131.0	129.68	129.85	6700.0
2001-05-24 17:30:00	SPY	ETF	129.85	129.96	129.58	129.9	4800.0
2001-05-24 09:30:00	QQQ	ETF	48.97	49.48	48.5	49.27	9714700.0
2001-05-24 10:00:00	QQQ	ETF	49.31	49.45	48.55	48.58	7530600.0
2001-05-24 10:30:00	QQQ	ETF	48.58	48.92	48.35	48.45	4343000.0
2001-05-24 11:00:00	QQQ	ETF	48.48	48.75	48.27	48.64	4884900.0
2001-05-24 11:30:00	QQQ	ETF	48.63	48.9	48.44	48.86	2596500.0
2001-05-24 12:00:00	QQQ	ETF	48.86	49.09	48.8	48.92	3205100.0
2001-05-24 12:30:00	QQQ	ETF	48.99	49.03	48.7	48.75	1510000.0
2001-05-24 13:00:00	QQQ	ETF	48.73	48.97	48.62	48.62	1864000.0
2001-05-24 13:30:00	QQQ	ETF	48.63	48.81	48.48	48.72	3099700.0
2001-05-24 14:00:00	QQQ	ETF	48.75	49.17	48.6	49.1	2599600.0
2001-05-24 14:30:00	QQQ	ETF	49.14	49.38	49.01	49.28	5390200.0
2001-05-24 15:00:00	QQQ	ETF	49.27	49.77	49.22	49.57	6019500.0
2001-05-24 15:30:00	QQQ	ETF	49.56	49.98	49.54	49.91	5096900.0
2001-05-24 16:00:00	QQQ	ETF	49.94	49.99	49.8	49.95	1285600.0
2001-05-24 16:30:00	QQQ	ETF	49.95	50.0	49.05	49.98	218500.0
2001-05-24 17:00:00	QQQ	ETF	49.95	50.13	49.92	50.1	64300.0
2001-05-24 17:30:00	QQQ	ETF	50.1	50.16	50.0	50.1	31700.0
2001-05-24 18:00:00	QQQ	ETF	50.15	50.15	50.05	50.05	63100.0
2001-05-24 09:30:00	IWM	ETF	50.8	50.85	50.525	50.85	108000.0
2001-05-24 10:00:00	IWM	ETF	50.7	50.7	50.475	50.555	48200.0
2001-05-24 10:30:00	IWM	ETF	50.475	50.5	50.315	50.41	42400.0
2001-05-24 11:00:00	IWM	ETF	50.255	50.295	50.16	50.295	39200.0
2001-05-24 11:30:00	IWM	ETF	50.245	50.35	50.245	50.35	27200.0
2001-05-24 12:00:00	IWM	ETF	50.37	50.485	50.255	50.405	15200.0
2001-05-24 12:30:00	IWM	ETF	50.495	50.545	50.475	50.545	12200.0
2001-05-24 13:00:00	IWM	ETF	50.45	50.495	50.45	50.49	11000.0
2001-05-24 13:30:00	IWM	ETF	50.47	50.47	50.44	50.44	2000.0
2001-05-24 14:00:00	IWM	ETF	50.45	50.495	50.45	50.495	7000.0
2001-05-24 14:30:00	IWM	ETF	50.52	50.745	50.52	50.74	15400.0
2001-05-24 15:00:00	IWM	ETF	50.735	50.95	50.735	50.85	44800.0
2001-05-24 15:30:00	IWM	ETF	50.85	51.1	50.755	51.1	100600.0
2001-05-24 16:00:00	IWM	ETF	51.1	51.175	51.025	51.025	56400.0
2001-05-24 09:30:00	DIA	ETF	111.45	111.85	111.1	111.65	327500.0
2001-05-24 10:00:00	DIA	ETF	111.61	111.75	111.0	111.0	257700.0

> showing 50 of 372 rows — these rows as CSV

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