PREVIEW / etf_30min / 2007-05-30

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-30.parquet
  size:    117 KB
  rows:    4,351

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
2007-05-30 04:00:00	SPY	ETF	151.78	151.78	151.78	151.78	100.0
2007-05-30 05:30:00	SPY	ETF	151.6	151.63	151.6	151.63	30000.0
2007-05-30 06:00:00	SPY	ETF	151.62	151.62	151.62	151.62	13200.0
2007-05-30 06:30:00	SPY	ETF	151.72	151.72	151.67	151.67	32000.0
2007-05-30 07:00:00	SPY	ETF	151.62	151.62	151.45	151.45	394900.0
2007-05-30 07:30:00	SPY	ETF	151.53	151.65	151.49	151.64	359800.0
2007-05-30 08:00:00	SPY	ETF	151.64	151.75	151.58	151.59	826900.0
2007-05-30 08:30:00	SPY	ETF	151.59	151.9	151.48	151.56	551000.0
2007-05-30 09:00:00	SPY	ETF	151.55	151.57	151.44	151.45	487700.0
2007-05-30 09:30:00	SPY	ETF	151.46	151.84	151.34	151.8	17613072.0
2007-05-30 10:00:00	SPY	ETF	151.8	152.06	151.69	151.94	9536900.0
2007-05-30 10:30:00	SPY	ETF	151.94	152.06	151.72	151.91	10244581.0
2007-05-30 11:00:00	SPY	ETF	151.91	152.24	151.81	152.14	9239695.0
2007-05-30 11:30:00	SPY	ETF	152.14	152.24	152.0	152.1	5179293.0
2007-05-30 12:00:00	SPY	ETF	152.1	152.52	152.08	152.5	5726269.0
2007-05-30 12:30:00	SPY	ETF	152.51	152.56	152.34	152.36	4306000.0
2007-05-30 13:00:00	SPY	ETF	152.36	152.46	152.3	152.45	3086700.0
2007-05-30 13:30:00	SPY	ETF	152.44	152.47	152.16	152.339	4251032.0
2007-05-30 14:00:00	SPY	ETF	152.33	152.68	151.92	152.6401	18517352.0
2007-05-30 14:30:00	SPY	ETF	152.64	153.13	152.5	152.9996	12525196.0
2007-05-30 15:00:00	SPY	ETF	152.99	153.09	152.87	152.98	6234236.0
2007-05-30 15:30:00	SPY	ETF	152.98	153.38	152.95	153.37	14542642.0
2007-05-30 16:00:00	SPY	ETF	153.38	153.53	153.31	153.48	2202800.0
2007-05-30 16:30:00	SPY	ETF	153.47	153.47	153.4	153.45	464600.0
2007-05-30 17:00:00	SPY	ETF	153.45	153.46	153.45	153.45	7200.0
2007-05-30 17:30:00	SPY	ETF	153.45	153.46	153.45	153.45	3100.0
2007-05-30 18:00:00	SPY	ETF	153.46	153.51	153.46	153.5	297800.0
2007-05-30 18:30:00	SPY	ETF	153.5	153.53	153.5	153.52	1977700.0
2007-05-30 19:00:00	SPY	ETF	153.51	153.51	153.49	153.49	400.0
2007-05-30 19:30:00	SPY	ETF	153.5	153.53	153.5	153.53	1000.0
2007-05-30 05:30:00	QQQ	ETF	46.56	46.56	46.55	46.55	60000.0
2007-05-30 06:00:00	QQQ	ETF	46.55	46.55	46.55	46.55	10691.0
2007-05-30 06:30:00	QQQ	ETF	46.55	46.55	46.55	46.55	5000.0
2007-05-30 07:00:00	QQQ	ETF	46.55	46.55	46.53	46.55	83250.0
2007-05-30 07:30:00	QQQ	ETF	46.51	46.56	46.5	46.56	170958.0
2007-05-30 08:00:00	QQQ	ETF	46.54	46.59	46.52	46.55	236000.0
2007-05-30 08:30:00	QQQ	ETF	46.54	46.55	46.51	46.53	419794.0
2007-05-30 09:00:00	QQQ	ETF	46.52	46.54	46.45	46.47	1062365.0
2007-05-30 09:30:00	QQQ	ETF	46.48	46.65	46.35	46.62	19024955.0
2007-05-30 10:00:00	QQQ	ETF	46.62	46.71	46.56	46.68	10578382.0
2007-05-30 10:30:00	QQQ	ETF	46.67	46.72	46.52	46.6	13905740.0
2007-05-30 11:00:00	QQQ	ETF	46.6	46.73	46.57	46.69	5975559.0
2007-05-30 11:30:00	QQQ	ETF	46.7	46.77	46.67	46.69	4747677.0
2007-05-30 12:00:00	QQQ	ETF	46.69	46.84	46.68	46.83	4505263.0
2007-05-30 12:30:00	QQQ	ETF	46.83	46.89	46.79	46.8105	6795774.0
2007-05-30 13:00:00	QQQ	ETF	46.82	46.85	46.77	46.84	2858037.0
2007-05-30 13:30:00	QQQ	ETF	46.84	46.85	46.72	46.77	4159279.0
2007-05-30 14:00:00	QQQ	ETF	46.77	46.86	46.61	46.84	15095051.0
2007-05-30 14:30:00	QQQ	ETF	46.83	47.0	46.79	46.99	9435913.0
2007-05-30 15:00:00	QQQ	ETF	46.99	47.03	46.94	47.0	8649483.0

> showing 50 of 4,351 rows — these rows as CSV

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