PREVIEW / etf_30min / 2007-09-25

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-25.parquet
  size:    126 KB
  rows:    4,781

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-09-25 04:00:00	SPY	ETF	151.27	151.27	151.17	151.17	2000.0
2007-09-25 04:30:00	SPY	ETF	151.07	151.07	151.07	151.07	100.0
2007-09-25 05:30:00	SPY	ETF	151.16	151.16	151.04	151.04	13200.0
2007-09-25 06:00:00	SPY	ETF	151.03	151.03	151.02	151.02	1400.0
2007-09-25 06:30:00	SPY	ETF	151.02	151.05	150.94	151.02	132900.0
2007-09-25 07:00:00	SPY	ETF	151.02	151.07	150.9	150.95	386400.0
2007-09-25 07:30:00	SPY	ETF	150.95	151.24	150.95	151.18	400200.0
2007-09-25 08:00:00	SPY	ETF	151.2	151.3	151.02	151.14	652700.0
2007-09-25 08:30:00	SPY	ETF	151.13	151.13	150.82	150.86	1509300.0
2007-09-25 09:00:00	SPY	ETF	150.85	151.69	150.73	150.83	2746836.0
2007-09-25 09:30:00	SPY	ETF	150.81	150.96	150.58	150.74	18960230.0
2007-09-25 10:00:00	SPY	ETF	150.74	151.35	150.47	151.08	22823300.0
2007-09-25 10:30:00	SPY	ETF	151.08	151.55	151.01	151.24	10516600.0
2007-09-25 11:00:00	SPY	ETF	151.245	151.62	151.18	151.24	8876200.0
2007-09-25 11:30:00	SPY	ETF	151.23	151.34	151.0	151.19	6313300.0
2007-09-25 12:00:00	SPY	ETF	151.19	151.2	150.94	151.11	5431800.0
2007-09-25 12:30:00	SPY	ETF	151.1	151.28	150.96	151.21	4632100.0
2007-09-25 13:00:00	SPY	ETF	151.2	151.45	151.13	151.42	5163600.0
2007-09-25 13:30:00	SPY	ETF	151.43	151.5463	151.17	151.34	6007100.0
2007-09-25 14:00:00	SPY	ETF	151.34	151.36	151.12	151.27	5350900.0
2007-09-25 14:30:00	SPY	ETF	151.28	151.48	151.15	151.44	6400600.0
2007-09-25 15:00:00	SPY	ETF	151.44	151.53	151.24	151.35	7783300.0
2007-09-25 15:30:00	SPY	ETF	151.34	151.65	151.18	151.63	18296200.0
2007-09-25 16:00:00	SPY	ETF	151.65	151.66	151.21	151.47	7443700.0
2007-09-25 16:30:00	SPY	ETF	151.46	151.57	151.4	151.52	896100.0
2007-09-25 17:00:00	SPY	ETF	151.51	151.57	151.5	151.52	21100.0
2007-09-25 17:30:00	SPY	ETF	151.55	151.6	151.49	151.58	48200.0
2007-09-25 18:00:00	SPY	ETF	151.58	151.62	151.39	151.39	46100.0
2007-09-25 18:30:00	SPY	ETF	151.61	151.61	151.58	151.59	700.0
2007-09-25 19:00:00	SPY	ETF	151.55	151.64	151.55	151.64	2500.0
2007-09-25 19:30:00	SPY	ETF	151.62	151.7	151.62	151.65	3900.0
2007-09-25 07:00:00	QQQ	ETF	50.4	50.42	50.4	50.4	28100.0
2007-09-25 07:30:00	QQQ	ETF	50.4	50.46	50.37	50.43	82708.0
2007-09-25 08:00:00	QQQ	ETF	50.42	50.45	50.39	50.44	158178.0
2007-09-25 08:30:00	QQQ	ETF	50.44	50.46	50.37	50.39	229808.0
2007-09-25 09:00:00	QQQ	ETF	50.39	50.48	50.39	50.42	2296659.0
2007-09-25 09:30:00	QQQ	ETF	50.42	50.58	50.36	50.5	14775245.0
2007-09-25 10:00:00	QQQ	ETF	50.5	50.71	50.4	50.6	12816267.0
2007-09-25 10:30:00	QQQ	ETF	50.6	50.76	50.59	50.72	7041569.0
2007-09-25 11:00:00	QQQ	ETF	50.72	50.84	50.69	50.72	8255091.0
2007-09-25 11:30:00	QQQ	ETF	50.72	50.76	50.64	50.7185	4408565.0
2007-09-25 12:00:00	QQQ	ETF	50.71	50.75	50.64	50.69	3628079.0
2007-09-25 12:30:00	QQQ	ETF	50.69	50.8	50.67	50.78	5417832.0
2007-09-25 13:00:00	QQQ	ETF	50.78	50.88	50.76	50.87	2790902.0
2007-09-25 13:30:00	QQQ	ETF	50.88	50.9	50.76	50.84	4632031.0
2007-09-25 14:00:00	QQQ	ETF	50.84	50.84	50.74	50.839	3944755.0
2007-09-25 14:30:00	QQQ	ETF	50.839	50.96	50.8	50.95	6661322.0
2007-09-25 15:00:00	QQQ	ETF	50.948	50.99	50.9	50.93	7359684.0
2007-09-25 15:30:00	QQQ	ETF	50.93	51.07	50.87	51.06	9047415.0
2007-09-25 16:00:00	QQQ	ETF	51.06	51.08	50.5771	51.04	6272282.0

> showing 50 of 4,781 rows — these rows as CSV

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