PREVIEW / etf_30min / 2007-04-26

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-26.parquet
  size:    107 KB
  rows:    3,787

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-26 04:30:00	SPY	ETF	149.59	149.59	149.59	149.59	100.0
2007-04-26 05:00:00	SPY	ETF	149.53	149.53	149.53	149.53	7000.0
2007-04-26 06:00:00	SPY	ETF	149.49	149.49	149.49	149.49	3000.0
2007-04-26 06:30:00	SPY	ETF	149.61	149.61	149.6	149.6	4000.0
2007-04-26 07:00:00	SPY	ETF	149.6	149.76	149.6	149.7	134700.0
2007-04-26 07:30:00	SPY	ETF	149.7	149.83	149.7	149.76	87500.0
2007-04-26 08:00:00	SPY	ETF	149.81	149.81	149.67	149.79	656900.0
2007-04-26 08:30:00	SPY	ETF	149.79	149.82	149.5339	149.62	1351900.0
2007-04-26 09:00:00	SPY	ETF	149.63	149.64	149.5	149.5	504950.0
2007-04-26 09:30:00	SPY	ETF	149.49	149.67	149.18	149.18	15435660.0
2007-04-26 10:00:00	SPY	ETF	149.19	149.36	149.1	149.26	14635320.0
2007-04-26 10:30:00	SPY	ETF	149.26	149.59	149.25	149.5699	7959514.0
2007-04-26 11:00:00	SPY	ETF	149.56	149.67	149.4	149.43	6178133.0
2007-04-26 11:30:00	SPY	ETF	149.42	149.5	149.27	149.35	4069831.0
2007-04-26 12:00:00	SPY	ETF	149.35	149.49	149.34	149.43	2922219.0
2007-04-26 12:30:00	SPY	ETF	149.43	149.56	149.4	149.41	3931084.0
2007-04-26 13:00:00	SPY	ETF	149.41	149.5	149.27	149.3	3309244.0
2007-04-26 13:30:00	SPY	ETF	149.29	149.39	149.18	149.34	3822500.0
2007-04-26 14:00:00	SPY	ETF	149.34	149.63	149.28	149.56	4341409.0
2007-04-26 14:30:00	SPY	ETF	149.57	149.8	149.48	149.64	5220282.0
2007-04-26 15:00:00	SPY	ETF	149.64	149.78	149.63	149.69	3219028.0
2007-04-26 15:30:00	SPY	ETF	149.69	149.71	149.38	149.39	6940981.0
2007-04-26 16:00:00	SPY	ETF	149.38	149.66	149.32	149.45	1654500.0
2007-04-26 16:30:00	SPY	ETF	149.47	149.55	149.4	149.51	305800.0
2007-04-26 17:00:00	SPY	ETF	149.53	149.55	149.46	149.46	74900.0
2007-04-26 17:30:00	SPY	ETF	149.48	149.48	149.45	149.46	145800.0
2007-04-26 18:00:00	SPY	ETF	149.46	149.47	149.45	149.47	3800.0
2007-04-26 18:30:00	SPY	ETF	149.47	149.5	149.47	149.5	2400.0
2007-04-26 19:00:00	SPY	ETF	149.5	149.51	149.5	149.5	4900.0
2007-04-26 19:30:00	SPY	ETF	149.51	149.51	149.48	149.49	3700.0
2007-04-26 04:00:00	QQQ	ETF	46.45	46.45	46.45	46.45	400.0
2007-04-26 07:00:00	QQQ	ETF	46.48	46.55	46.48	46.53	266700.0
2007-04-26 07:30:00	QQQ	ETF	46.51	46.58	46.51	46.53	65005.0
2007-04-26 08:00:00	QQQ	ETF	46.53	46.53	46.49	46.52	336088.0
2007-04-26 08:30:00	QQQ	ETF	46.53	46.53	46.44	46.44	1956446.0
2007-04-26 09:00:00	QQQ	ETF	46.45	46.49	46.41	46.41	3088400.0
2007-04-26 09:30:00	QQQ	ETF	46.42	46.51	46.34	46.35	18116842.0
2007-04-26 10:00:00	QQQ	ETF	46.36	46.46	46.33	46.39	14741009.0
2007-04-26 10:30:00	QQQ	ETF	46.4	46.51	46.3914	46.49	6661518.0
2007-04-26 11:00:00	QQQ	ETF	46.49	46.54	46.46	46.47	6394974.0
2007-04-26 11:30:00	QQQ	ETF	46.47	46.49	46.39	46.42	4873960.0
2007-04-26 12:00:00	QQQ	ETF	46.427	46.48	46.42	46.45	3537242.0
2007-04-26 12:30:00	QQQ	ETF	46.4505	46.51	46.4505	46.49	2336285.0
2007-04-26 13:00:00	QQQ	ETF	46.49	46.5	46.41	46.46	3084645.0
2007-04-26 13:30:00	QQQ	ETF	46.46	46.48	46.39	46.457	5323579.0
2007-04-26 14:00:00	QQQ	ETF	46.45	46.54	46.44	46.52	3371998.0
2007-04-26 14:30:00	QQQ	ETF	46.52	46.65	46.49	46.5725	8044329.0
2007-04-26 15:00:00	QQQ	ETF	46.58	46.63	46.55	46.59	3039463.0
2007-04-26 15:30:00	QQQ	ETF	46.59	46.59	46.44	46.44	9285657.0
2007-04-26 16:00:00	QQQ	ETF	46.44	46.59	46.43	46.52	1668749.0

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

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