PREVIEW / etf_30min / 2007-10-11

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-11.parquet
  size:    136 KB
  rows:    5,071

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-10-11 04:00:00	SPY	ETF	156.84	156.84	156.84	156.84	100.0
2007-10-11 04:30:00	SPY	ETF	156.94	156.94	156.94	156.94	5000.0
2007-10-11 05:00:00	SPY	ETF	156.96	157.0	156.96	157.0	400.0
2007-10-11 05:30:00	SPY	ETF	156.89	156.89	156.89	156.89	12500.0
2007-10-11 06:00:00	SPY	ETF	156.82	156.9	156.82	156.89	15500.0
2007-10-11 06:30:00	SPY	ETF	156.89	156.97	156.89	156.95	110500.0
2007-10-11 07:00:00	SPY	ETF	156.97	157.3	156.9	157.26	1421600.0
2007-10-11 07:30:00	SPY	ETF	157.23	157.28	157.05	157.13	274700.0
2007-10-11 08:00:00	SPY	ETF	157.13	157.31	157.05	157.11	2596600.0
2007-10-11 08:30:00	SPY	ETF	157.16	157.2	156.96	157.18	1592400.0
2007-10-11 09:00:00	SPY	ETF	157.18	157.19	156.9	156.9	648642.0
2007-10-11 09:30:00	SPY	ETF	156.93	157.128	156.76	156.96	12932988.0
2007-10-11 10:00:00	SPY	ETF	156.95	157.11	156.88	157.04	8334500.0
2007-10-11 10:30:00	SPY	ETF	157.05	157.25	156.93	157.13	9364900.0
2007-10-11 11:00:00	SPY	ETF	157.13	157.15	156.85	157.0	4072000.0
2007-10-11 11:30:00	SPY	ETF	157.0	157.16	156.96	157.06	4430100.0
2007-10-11 12:00:00	SPY	ETF	157.06	157.26	156.99	157.25	4958700.0
2007-10-11 12:30:00	SPY	ETF	157.26	157.4385	157.26	157.34	3887900.0
2007-10-11 13:00:00	SPY	ETF	157.35	157.52	157.27	157.36	4709963.0
2007-10-11 13:30:00	SPY	ETF	157.36	157.37	156.93	156.99	5832937.0
2007-10-11 14:00:00	SPY	ETF	156.99	156.99	155.6	155.74	51299248.0
2007-10-11 14:30:00	SPY	ETF	155.74	156.48	155.43	155.91	32920467.0
2007-10-11 15:00:00	SPY	ETF	155.9	156.0	154.61	154.73	45704120.0
2007-10-11 15:30:00	SPY	ETF	154.72	155.53	154.54	155.34	27322700.0
2007-10-11 16:00:00	SPY	ETF	155.36	157.09	155.23	157.09	4621800.0
2007-10-11 16:30:00	SPY	ETF	155.38	155.42	154.67	155.36	3055100.0
2007-10-11 17:00:00	SPY	ETF	155.41	155.45	155.16	155.22	105800.0
2007-10-11 17:30:00	SPY	ETF	155.2	155.27	155.17	155.21	5200.0
2007-10-11 18:00:00	SPY	ETF	155.2	155.27	155.15	155.27	35100.0
2007-10-11 18:30:00	SPY	ETF	155.27	155.31	155.27	155.29	3900.0
2007-10-11 19:00:00	SPY	ETF	155.21	155.22	155.16	155.22	5900.0
2007-10-11 19:30:00	SPY	ETF	155.23	155.34	155.22	155.34	7400.0
2007-10-11 04:00:00	QQQ	ETF	53.72	53.72	53.72	53.72	600.0
2007-10-11 06:30:00	QQQ	ETF	53.76	53.76	53.76	53.76	10000.0
2007-10-11 07:00:00	QQQ	ETF	53.75	53.83	53.73	53.83	195900.0
2007-10-11 07:30:00	QQQ	ETF	53.84	53.85	53.79	53.81	157896.0
2007-10-11 08:00:00	QQQ	ETF	53.82	53.85	53.79	53.81	325161.0
2007-10-11 08:30:00	QQQ	ETF	53.83	53.84	53.78	53.83	382164.0
2007-10-11 09:00:00	QQQ	ETF	53.83	53.85	53.72	53.78	558667.0
2007-10-11 09:30:00	QQQ	ETF	53.79	53.83	53.69	53.82	15279443.0
2007-10-11 10:00:00	QQQ	ETF	53.82	53.89	53.77	53.86	10849617.0
2007-10-11 10:30:00	QQQ	ETF	53.86	53.93	53.81	53.838	9743738.0
2007-10-11 11:00:00	QQQ	ETF	53.83	53.832	53.74	53.7815	3965658.0
2007-10-11 11:30:00	QQQ	ETF	53.78	53.89	53.76	53.8505	4312634.0
2007-10-11 12:00:00	QQQ	ETF	53.85	53.92	53.79	53.9	5589536.0
2007-10-11 12:30:00	QQQ	ETF	53.91	53.94	53.86	53.89	2762451.0
2007-10-11 13:00:00	QQQ	ETF	53.892	53.93	53.82	53.83	4918490.0
2007-10-11 13:30:00	QQQ	ETF	53.84	53.84	53.55	53.57	12297988.0
2007-10-11 14:00:00	QQQ	ETF	53.57	53.57	52.65	52.84	52014140.0
2007-10-11 14:30:00	QQQ	ETF	52.85	53.24	52.76	52.94	35965027.0

> showing 50 of 5,071 rows — these rows as CSV

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