PREVIEW / etf_30min / 2007-05-18

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-18.parquet
  size:    113 KB
  rows:    4,381

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-18 06:00:00	SPY	ETF	151.63	151.65	151.63	151.63	24500.0
2007-05-18 06:30:00	SPY	ETF	151.67	151.67	151.56	151.56	13100.0
2007-05-18 07:00:00	SPY	ETF	151.52	151.68	151.52	151.6	126400.0
2007-05-18 07:30:00	SPY	ETF	151.62	151.78	151.6	151.78	111800.0
2007-05-18 08:00:00	SPY	ETF	151.76	151.92	151.75	151.86	438700.0
2007-05-18 08:30:00	SPY	ETF	151.85	151.95	151.75	151.87	1326100.0
2007-05-18 09:00:00	SPY	ETF	151.9	152.07	151.9	151.93	3062800.0
2007-05-18 09:30:00	SPY	ETF	151.94	152.07	151.81	151.95	11101899.0
2007-05-18 10:00:00	SPY	ETF	151.95	152.33	151.85	152.211	16670947.0
2007-05-18 10:30:00	SPY	ETF	152.21	152.31	151.96	152.09	6275870.0
2007-05-18 11:00:00	SPY	ETF	152.09	152.13	151.98	152.0876	5888379.0
2007-05-18 11:30:00	SPY	ETF	152.08	152.18	151.92	152.03	4128271.0
2007-05-18 12:00:00	SPY	ETF	152.02	152.27	151.98	152.25	4076750.0
2007-05-18 12:30:00	SPY	ETF	152.24	152.44	152.2	152.35	6263700.0
2007-05-18 13:00:00	SPY	ETF	152.35	152.39	152.24	152.28	3133632.0
2007-05-18 13:30:00	SPY	ETF	152.28	152.41	152.21	152.31	2532332.0
2007-05-18 14:00:00	SPY	ETF	152.31	152.5	152.28	152.36	4907500.0
2007-05-18 14:30:00	SPY	ETF	152.36	152.38	152.1	152.2	8779075.0
2007-05-18 15:00:00	SPY	ETF	152.21	152.32	152.12	152.24	5891937.0
2007-05-18 15:30:00	SPY	ETF	152.24	152.5	152.22	152.5	8874949.0
2007-05-18 16:00:00	SPY	ETF	152.5	152.65	152.46	152.6	2650900.0
2007-05-18 16:30:00	SPY	ETF	152.6	152.6	152.49	152.56	110300.0
2007-05-18 17:00:00	SPY	ETF	152.54	152.6	152.52	152.53	598200.0
2007-05-18 17:30:00	SPY	ETF	152.6	152.6	152.51	152.51	3700.0
2007-05-18 18:30:00	SPY	ETF	152.53	152.54	152.53	152.54	900.0
2007-05-18 19:00:00	SPY	ETF	152.59	152.59	152.54	152.54	2500.0
2007-05-18 19:30:00	SPY	ETF	152.58	152.58	152.58	152.58	2500.0
2007-05-18 06:30:00	QQQ	ETF	46.46	46.46	46.46	46.46	200.0
2007-05-18 07:00:00	QQQ	ETF	46.46	46.48	46.46	46.46	304000.0
2007-05-18 07:30:00	QQQ	ETF	46.45	46.49	46.43	46.48	188801.0
2007-05-18 08:00:00	QQQ	ETF	46.46	46.52	46.45	46.51	1189187.0
2007-05-18 08:30:00	QQQ	ETF	46.53	46.55	46.47	46.51	1025571.0
2007-05-18 09:00:00	QQQ	ETF	46.51	46.57	46.45	46.48	1191700.0
2007-05-18 09:30:00	QQQ	ETF	46.48	46.54	46.38	46.44	17868867.0
2007-05-18 10:00:00	QQQ	ETF	46.45	46.65	46.44	46.6	16405073.0
2007-05-18 10:30:00	QQQ	ETF	46.6	46.63	46.48	46.5	6452061.0
2007-05-18 11:00:00	QQQ	ETF	46.5	46.52	46.45	46.4755	4804439.0
2007-05-18 11:30:00	QQQ	ETF	46.48	46.52	46.44	46.48	3869548.0
2007-05-18 12:00:00	QQQ	ETF	46.47	46.56	46.45	46.55	6084492.0
2007-05-18 12:30:00	QQQ	ETF	46.55	46.7	46.53	46.64	8464178.0
2007-05-18 13:00:00	QQQ	ETF	46.64	46.66	46.6	46.61	2805892.0
2007-05-18 13:30:00	QQQ	ETF	46.62	46.7	46.6	46.65	2921893.0
2007-05-18 14:00:00	QQQ	ETF	46.65	46.7	46.63	46.66	4249153.0
2007-05-18 14:30:00	QQQ	ETF	46.65	46.66	46.5	46.55	10016560.0
2007-05-18 15:00:00	QQQ	ETF	46.543	46.59	46.51	46.58	3707833.0
2007-05-18 15:30:00	QQQ	ETF	46.57	46.68	46.57	46.68	8455495.0
2007-05-18 16:00:00	QQQ	ETF	46.68	46.76	46.67	46.72	3722536.0
2007-05-18 16:30:00	QQQ	ETF	46.72	46.75	46.72	46.75	91798.0
2007-05-18 17:00:00	QQQ	ETF	46.76	46.76	46.73	46.73	9601.0
2007-05-18 17:30:00	QQQ	ETF	46.72	46.74	46.72	46.73	6600.0

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

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