PREVIEW / etf_30min / 2007-11-08

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-08.parquet
  size:    154 KB
  rows:    5,460

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-11-08 06:00:00	SPY	ETF	147.88	147.88	147.65	147.82	18000.0
2007-11-08 06:30:00	SPY	ETF	147.66	148.5	147.66	148.35	584700.0
2007-11-08 07:00:00	SPY	ETF	148.35	148.77	148.05	148.52	1707000.0
2007-11-08 07:30:00	SPY	ETF	148.52	148.62	148.23	148.35	462100.0
2007-11-08 08:00:00	SPY	ETF	148.35	148.7	147.58	148.14	3428300.0
2007-11-08 08:30:00	SPY	ETF	148.15	148.31	146.15	148.22	2167300.0
2007-11-08 09:00:00	SPY	ETF	148.27	148.32	147.98	147.99	1653900.0
2007-11-08 09:30:00	SPY	ETF	147.99	149.3	147.06	147.81	50366151.0
2007-11-08 10:00:00	SPY	ETF	147.8	148.36	146.9	147.91	41357001.0
2007-11-08 10:30:00	SPY	ETF	147.91	148.04	147.21	147.94	15865292.0
2007-11-08 11:00:00	SPY	ETF	147.93	148.17	147.4	147.56	14417213.0
2007-11-08 11:30:00	SPY	ETF	147.55	147.85	146.91	147.23	16384245.0
2007-11-08 12:00:00	SPY	ETF	147.23	147.41	146.4	146.85	25489802.0
2007-11-08 12:30:00	SPY	ETF	146.86	147.0	145.42	145.93	39951297.0
2007-11-08 13:00:00	SPY	ETF	145.93	146.19	145.07	145.96	27988070.0
2007-11-08 13:30:00	SPY	ETF	145.96	146.56	145.72	146.53	20952420.0
2007-11-08 14:00:00	SPY	ETF	146.53	146.62	145.6	145.75	16175203.0
2007-11-08 14:30:00	SPY	ETF	145.75	146.42	145.38	146.41	15021578.0
2007-11-08 15:00:00	SPY	ETF	146.41	147.73	146.12	147.49	39224784.0
2007-11-08 15:30:00	SPY	ETF	147.48	148.15	147.05	147.53	29362257.0
2007-11-08 16:00:00	SPY	ETF	147.43	147.99	147.1	147.31	3117400.0
2007-11-08 16:30:00	SPY	ETF	147.31	147.35	145.82	147.06	2943000.0
2007-11-08 17:00:00	SPY	ETF	147.09	147.21	146.78	147.21	438100.0
2007-11-08 17:30:00	SPY	ETF	147.18	147.21	147.13	147.18	32200.0
2007-11-08 18:00:00	SPY	ETF	147.2	147.25	147.09	147.09	88500.0
2007-11-08 18:30:00	SPY	ETF	147.05	147.29	147.02	147.26	33600.0
2007-11-08 19:00:00	SPY	ETF	147.28	147.46	147.22	147.46	63300.0
2007-11-08 19:30:00	SPY	ETF	147.44	147.5	147.39	147.5	16800.0
2007-11-08 04:30:00	QQQ	ETF	52.94	53.02	52.94	53.02	4800.0
2007-11-08 05:00:00	QQQ	ETF	53.0	53.0	53.0	53.0	200.0
2007-11-08 05:30:00	QQQ	ETF	53.12	53.12	53.12	53.12	100.0
2007-11-08 06:30:00	QQQ	ETF	53.03	53.22	53.03	53.22	191208.0
2007-11-08 07:00:00	QQQ	ETF	53.16	53.3	53.05	53.29	1089725.0
2007-11-08 07:30:00	QQQ	ETF	53.29	53.35	53.2	53.2	744821.0
2007-11-08 08:00:00	QQQ	ETF	53.2	53.3	52.6	53.22	3235207.0
2007-11-08 08:30:00	QQQ	ETF	53.23	53.3	52.5	53.2	912074.0
2007-11-08 09:00:00	QQQ	ETF	53.21	53.22	53.13	53.14	908273.0
2007-11-08 09:30:00	QQQ	ETF	53.15	53.33	52.59	52.81	36233358.0
2007-11-08 10:00:00	QQQ	ETF	52.81	52.95	52.52	52.73	28436827.0
2007-11-08 10:30:00	QQQ	ETF	52.74	52.75	52.45	52.72	16932252.0
2007-11-08 11:00:00	QQQ	ETF	52.71	52.83	52.6	52.68	12070633.0
2007-11-08 11:30:00	QQQ	ETF	52.68	52.73	52.22	52.33	18185489.0
2007-11-08 12:00:00	QQQ	ETF	52.32	52.42	51.78	51.97	32701877.0
2007-11-08 12:30:00	QQQ	ETF	51.97	52.25	51.2	51.46	39743793.0
2007-11-08 13:00:00	QQQ	ETF	51.46	51.47	50.8	51.35	38518782.0
2007-11-08 13:30:00	QQQ	ETF	51.35	51.68	51.32	51.6601	22498492.0
2007-11-08 14:00:00	QQQ	ETF	51.66	51.72	51.18	51.22	17714754.0
2007-11-08 14:30:00	QQQ	ETF	51.22	51.54	51.03	51.51	18211897.0
2007-11-08 15:00:00	QQQ	ETF	51.5195	52.2	51.3799	52.2	37053627.0
2007-11-08 15:30:00	QQQ	ETF	52.19	52.32	51.72	51.76	39435279.0

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

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