PREVIEW / etf_30min / 2007-06-26

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-26.parquet
  size:    125 KB
  rows:    4,644

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-06-26 05:00:00	SPY	ETF	149.83	149.83	149.83	149.83	5000.0
2007-06-26 06:00:00	SPY	ETF	150.06	150.11	150.06	150.09	19000.0
2007-06-26 06:30:00	SPY	ETF	150.03	150.03	150.03	150.03	5000.0
2007-06-26 07:00:00	SPY	ETF	150.13	150.27	150.13	150.26	207100.0
2007-06-26 07:30:00	SPY	ETF	150.27	150.37	150.21	150.27	315800.0
2007-06-26 08:00:00	SPY	ETF	150.23	150.3	150.09	150.3	2284100.0
2007-06-26 08:30:00	SPY	ETF	150.25	150.25	150.08	150.11	842500.0
2007-06-26 09:00:00	SPY	ETF	150.16	150.3	150.14	150.21	1253100.0
2007-06-26 09:30:00	SPY	ETF	150.21	150.3	149.95	150.14	14734427.0
2007-06-26 10:00:00	SPY	ETF	150.14	150.4	149.41	149.54	21579241.0
2007-06-26 10:30:00	SPY	ETF	149.52	150.2474	149.23	149.3	18441068.0
2007-06-26 11:00:00	SPY	ETF	149.3	149.92	149.21	149.73	11516459.0
2007-06-26 11:30:00	SPY	ETF	149.73	150.33	149.6	150.29	12942942.0
2007-06-26 12:00:00	SPY	ETF	150.3	150.46	150.06	150.23	8417567.0
2007-06-26 12:30:00	SPY	ETF	150.24	150.27	149.86	149.94	5564250.0
2007-06-26 13:00:00	SPY	ETF	149.94	150.3	149.89	150.03	6754535.0
2007-06-26 13:30:00	SPY	ETF	150.03	150.1	149.55	149.73	9295404.0
2007-06-26 14:00:00	SPY	ETF	149.73	149.91	149.27	149.46	14006405.0
2007-06-26 14:30:00	SPY	ETF	149.445	149.58	148.93	149.07	22573486.0
2007-06-26 15:00:00	SPY	ETF	149.07	149.45	148.82	149.25	18765752.0
2007-06-26 15:30:00	SPY	ETF	149.25	150.1715	149.06	149.06	12364298.0
2007-06-26 16:00:00	SPY	ETF	149.07	149.12	148.29	148.42	6127000.0
2007-06-26 16:30:00	SPY	ETF	148.44	148.6	148.29	148.42	3563900.0
2007-06-26 17:00:00	SPY	ETF	148.42	148.58	148.41	148.55	247300.0
2007-06-26 17:30:00	SPY	ETF	148.56	148.68	148.46	148.46	97400.0
2007-06-26 18:00:00	SPY	ETF	148.47	148.47	148.37	148.44	754300.0
2007-06-26 18:30:00	SPY	ETF	148.42	148.42	148.32	148.35	56100.0
2007-06-26 19:00:00	SPY	ETF	148.35	148.36	148.3	148.33	59400.0
2007-06-26 19:30:00	SPY	ETF	148.31	148.36	148.31	148.35	38100.0
2007-06-26 06:30:00	QQQ	ETF	47.26	47.26	47.23	47.23	11000.0
2007-06-26 07:00:00	QQQ	ETF	47.27	47.35	47.27	47.31	121969.0
2007-06-26 07:30:00	QQQ	ETF	47.3	47.33	47.29	47.29	94497.0
2007-06-26 08:00:00	QQQ	ETF	47.3	47.3	47.21	47.27	1725073.0
2007-06-26 08:30:00	QQQ	ETF	47.26	47.26	47.21	47.24	251121.0
2007-06-26 09:00:00	QQQ	ETF	47.23	47.33	47.21	47.31	1277939.0
2007-06-26 09:30:00	QQQ	ETF	47.32	47.32	47.16	47.19	9209004.0
2007-06-26 10:00:00	QQQ	ETF	47.19	47.29	46.95	47.0	16465734.0
2007-06-26 10:30:00	QQQ	ETF	47.0	47.21	46.93	46.95	15020836.0
2007-06-26 11:00:00	QQQ	ETF	46.94	47.09	46.88	46.99	11071471.0
2007-06-26 11:30:00	QQQ	ETF	46.99	47.18	46.95	47.14	7561442.0
2007-06-26 12:00:00	QQQ	ETF	47.15	47.2	47.06	47.1285	7562085.0
2007-06-26 12:30:00	QQQ	ETF	47.13	47.15	47.03	47.07	4199103.0
2007-06-26 13:00:00	QQQ	ETF	47.09	47.2	47.07	47.1	3078567.0
2007-06-26 13:30:00	QQQ	ETF	47.1	47.1301	46.99	47.0225	5448242.0
2007-06-26 14:00:00	QQQ	ETF	47.03	47.09	46.92	46.96	7630596.0
2007-06-26 14:30:00	QQQ	ETF	46.95	46.99	46.82	46.82	8371140.0
2007-06-26 15:00:00	QQQ	ETF	46.82	46.94	46.74	46.89	11991620.0
2007-06-26 15:30:00	QQQ	ETF	46.895	46.96	46.84	46.91	7302642.0
2007-06-26 16:00:00	QQQ	ETF	46.94	46.95	46.76	46.79	3099468.0
2007-06-26 16:30:00	QQQ	ETF	46.81	46.84	46.79	46.79	911996.0

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

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