PREVIEW / etf_30min / 2007-04-30

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-30.parquet
  size:    111 KB
  rows:    3,878

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-04-30 04:30:00	SPY	ETF	149.4	149.4	149.4	149.4	100.0
2007-04-30 06:00:00	SPY	ETF	149.58	149.6	149.58	149.6	9000.0
2007-04-30 06:30:00	SPY	ETF	149.47	149.47	149.47	149.47	2500.0
2007-04-30 07:00:00	SPY	ETF	149.53	149.61	149.53	149.61	94400.0
2007-04-30 07:30:00	SPY	ETF	149.63	149.69	149.61	149.62	237900.0
2007-04-30 08:00:00	SPY	ETF	149.62	149.75	149.58	149.74	738100.0
2007-04-30 08:30:00	SPY	ETF	149.78	149.9	149.61	149.67	1426600.0
2007-04-30 09:00:00	SPY	ETF	149.68	149.68	149.56	149.62	497800.0
2007-04-30 09:30:00	SPY	ETF	149.64	149.67	149.14	149.34	11084411.0
2007-04-30 10:00:00	SPY	ETF	149.34	149.61	149.19	149.52	8468095.0
2007-04-30 10:30:00	SPY	ETF	149.52	149.74	149.44	149.68	6922340.0
2007-04-30 11:00:00	SPY	ETF	149.68	149.74	149.55	149.62	4426190.0
2007-04-30 11:30:00	SPY	ETF	149.62	149.63	149.34	149.38	5216839.0
2007-04-30 12:00:00	SPY	ETF	149.38	149.56	149.31	149.56	3704174.0
2007-04-30 12:30:00	SPY	ETF	149.55	149.67	149.51	149.52	3318130.0
2007-04-30 13:00:00	SPY	ETF	149.51	149.67	149.48	149.55	2165732.0
2007-04-30 13:30:00	SPY	ETF	149.55	149.6285	149.42	149.51	2428731.0
2007-04-30 14:00:00	SPY	ETF	149.51	149.58	149.27	149.29	4523848.0
2007-04-30 14:30:00	SPY	ETF	149.29	149.59	148.9	148.98	12099936.0
2007-04-30 15:00:00	SPY	ETF	148.98	149.08	148.74	148.78	10913297.0
2007-04-30 15:30:00	SPY	ETF	148.78	149.59	148.21	148.23	15853451.0
2007-04-30 16:00:00	SPY	ETF	148.24	149.03	148.19	148.32	4191800.0
2007-04-30 16:30:00	SPY	ETF	148.3	148.3	148.18	148.21	339000.0
2007-04-30 17:00:00	SPY	ETF	148.25	148.29	148.15	148.16	239300.0
2007-04-30 17:30:00	SPY	ETF	148.24	148.25	148.15	148.2	14800.0
2007-04-30 18:00:00	SPY	ETF	148.17	148.2	148.15	148.2	119600.0
2007-04-30 18:30:00	SPY	ETF	148.2	148.29	148.2	148.29	10400.0
2007-04-30 19:00:00	SPY	ETF	148.23	148.23	148.23	148.23	3900.0
2007-04-30 19:30:00	SPY	ETF	148.29	148.33	148.26	148.33	5700.0
2007-04-30 06:00:00	QQQ	ETF	46.53	46.53	46.53	46.53	2500.0
2007-04-30 07:00:00	QQQ	ETF	46.5	46.51	46.49	46.51	5400.0
2007-04-30 07:30:00	QQQ	ETF	46.54	46.56	46.54	46.54	50500.0
2007-04-30 08:00:00	QQQ	ETF	46.52	46.56	46.51	46.56	200812.0
2007-04-30 08:30:00	QQQ	ETF	46.56	46.62	46.51	46.53	360006.0
2007-04-30 09:00:00	QQQ	ETF	46.52	46.53	46.48	46.49	144622.0
2007-04-30 09:30:00	QQQ	ETF	46.5	46.51	46.28	46.35	12350627.0
2007-04-30 10:00:00	QQQ	ETF	46.34	46.46	46.28	46.41	7657102.0
2007-04-30 10:30:00	QQQ	ETF	46.41	46.53	46.39	46.5	6011484.0
2007-04-30 11:00:00	QQQ	ETF	46.5	46.51	46.44	46.46	2395587.0
2007-04-30 11:30:00	QQQ	ETF	46.46	46.47	46.32	46.35	8252973.0
2007-04-30 12:00:00	QQQ	ETF	46.35	46.41	46.34	46.4095	1909139.0
2007-04-30 12:30:00	QQQ	ETF	46.41	46.44	46.37	46.38	2773421.0
2007-04-30 13:00:00	QQQ	ETF	46.37	46.44	46.37	46.38	1399922.0
2007-04-30 13:30:00	QQQ	ETF	46.3819	46.42	46.34	46.3699	2265366.0
2007-04-30 14:00:00	QQQ	ETF	46.36	46.39	46.25	46.27	4429670.0
2007-04-30 14:30:00	QQQ	ETF	46.28	46.3	46.11	46.15	11249256.0
2007-04-30 15:00:00	QQQ	ETF	46.15	46.2	46.08	46.11	8018009.0
2007-04-30 15:30:00	QQQ	ETF	46.12	46.13	45.92	45.96	17129215.0
2007-04-30 16:00:00	QQQ	ETF	45.96	45.99	45.92	45.97	1904128.0
2007-04-30 16:30:00	QQQ	ETF	45.97	45.99	45.89	45.9	1629951.0

> showing 50 of 3,878 rows — these rows as CSV

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