PREVIEW / etf_30min / 2007-04-20

all etf 30-min files

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

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-20 05:30:00	SPY	ETF	147.66	147.66	147.66	147.66	19000.0
2007-04-20 06:00:00	SPY	ETF	147.69	147.75	147.69	147.75	25100.0
2007-04-20 06:30:00	SPY	ETF	147.77	147.77	147.77	147.77	10000.0
2007-04-20 07:00:00	SPY	ETF	147.72	147.95	147.7	147.8	553300.0
2007-04-20 07:30:00	SPY	ETF	147.8	147.99	147.8	147.92	789900.0
2007-04-20 08:00:00	SPY	ETF	147.77	147.95	147.77	147.9	2438300.0
2007-04-20 08:30:00	SPY	ETF	147.9	148.05	147.47	148.05	3300800.0
2007-04-20 09:00:00	SPY	ETF	148.05	148.3	148.0	148.23	4066777.0
2007-04-20 09:30:00	SPY	ETF	148.22	148.47	148.1	148.15	23142707.0
2007-04-20 10:00:00	SPY	ETF	148.16	148.5275	148.06	148.21	15145965.0
2007-04-20 10:30:00	SPY	ETF	148.2	148.25	148.02	148.065	10287146.0
2007-04-20 11:00:00	SPY	ETF	148.05	148.1	147.86	147.95	8216017.0
2007-04-20 11:30:00	SPY	ETF	147.95	148.1087	147.79	147.8699	6829079.0
2007-04-20 12:00:00	SPY	ETF	147.86	147.97	147.8	147.88	4599169.0
2007-04-20 12:30:00	SPY	ETF	147.88	147.91	147.69	147.85	5007789.0
2007-04-20 13:00:00	SPY	ETF	147.845	148.05	147.79	148.02	3945130.0
2007-04-20 13:30:00	SPY	ETF	148.03	148.08	147.95	147.95	2646384.0
2007-04-20 14:00:00	SPY	ETF	147.96	148.15	147.92	148.08	3203901.0
2007-04-20 14:30:00	SPY	ETF	148.08	148.2	148.06	148.18	4736805.0
2007-04-20 15:00:00	SPY	ETF	148.19	148.19	148.04	148.09	5419389.0
2007-04-20 15:30:00	SPY	ETF	148.09	148.48	148.06	148.47	11691977.0
2007-04-20 16:00:00	SPY	ETF	148.46	148.57	148.393	148.56	2884200.0
2007-04-20 16:30:00	SPY	ETF	148.56	148.58	148.51	148.58	129200.0
2007-04-20 17:00:00	SPY	ETF	148.56	148.62	148.5	148.52	51100.0
2007-04-20 17:30:00	SPY	ETF	148.57	148.6	148.57	148.58	3500.0
2007-04-20 18:00:00	SPY	ETF	148.58	148.58	148.57	148.57	10000.0
2007-04-20 18:30:00	SPY	ETF	148.55	148.58	148.55	148.57	900.0
2007-04-20 19:00:00	SPY	ETF	148.59	148.59	148.59	148.59	400.0
2007-04-20 19:30:00	SPY	ETF	148.58	148.58	148.57	148.57	500.0
2007-04-20 05:30:00	QQQ	ETF	45.24	45.34	45.24	45.34	57240.0
2007-04-20 06:00:00	QQQ	ETF	45.33	45.33	45.33	45.33	100.0
2007-04-20 07:00:00	QQQ	ETF	45.32	45.45	45.32	45.41	735441.0
2007-04-20 07:30:00	QQQ	ETF	45.38	45.47	45.38	45.44	517663.0
2007-04-20 08:00:00	QQQ	ETF	45.45	45.45	45.39	45.4	407141.0
2007-04-20 08:30:00	QQQ	ETF	45.41	45.45	45.4	45.44	1292121.0
2007-04-20 09:00:00	QQQ	ETF	45.44	45.55	45.43	45.53	2423723.0
2007-04-20 09:30:00	QQQ	ETF	45.53	45.67	45.42	45.45	27703200.0
2007-04-20 10:00:00	QQQ	ETF	45.45	45.48	45.35	45.46	12446500.0
2007-04-20 10:30:00	QQQ	ETF	45.46	45.48	45.36	45.38	7604900.0
2007-04-20 11:00:00	QQQ	ETF	45.37	45.4	45.29	45.34	9464100.0
2007-04-20 11:30:00	QQQ	ETF	45.34	45.35	45.25	45.27	3830600.0
2007-04-20 12:00:00	QQQ	ETF	45.27	45.5	45.24	45.26	6608900.0
2007-04-20 12:30:00	QQQ	ETF	45.25	45.29	45.2	45.26	6062700.0
2007-04-20 13:00:00	QQQ	ETF	45.25	45.38	45.23	45.37	7662200.0
2007-04-20 13:30:00	QQQ	ETF	45.37	45.4	45.29	45.3	7471300.0
2007-04-20 14:00:00	QQQ	ETF	45.3	45.38	45.05	45.34	6902400.0
2007-04-20 14:30:00	QQQ	ETF	45.34	45.42	45.34	45.42	3852000.0
2007-04-20 15:00:00	QQQ	ETF	45.42	45.43	45.32	45.33	4287000.0
2007-04-20 15:30:00	QQQ	ETF	45.33	45.4	45.32	45.4	9840200.0
2007-04-20 16:00:00	QQQ	ETF	45.4	45.48	45.34	45.43	3662131.0

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

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