PREVIEW / etf_30min / 2007-02-26

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-02-26.parquet
  size:    104 KB
  rows:    3,530

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-02-26 06:00:00	SPY	ETF	145.86	145.86	145.86	145.86	10000.0
2007-02-26 06:30:00	SPY	ETF	145.78	145.81	145.78	145.81	7500.0
2007-02-26 07:00:00	SPY	ETF	145.75	145.81	145.74	145.79	209100.0
2007-02-26 07:30:00	SPY	ETF	145.78	145.86	145.74	145.84	119230.0
2007-02-26 08:00:00	SPY	ETF	145.81	145.86	145.4	145.83	408199.0
2007-02-26 08:30:00	SPY	ETF	145.83	145.83	145.75	145.78	739244.0
2007-02-26 09:00:00	SPY	ETF	145.78	145.87	145.78	145.83	444115.0
2007-02-26 09:30:00	SPY	ETF	145.83	145.95	145.64	145.64	8226167.0
2007-02-26 10:00:00	SPY	ETF	145.65	145.8774	145.5	145.52	6533926.0
2007-02-26 10:30:00	SPY	ETF	145.52	145.84	145.31	145.56	5287277.0
2007-02-26 11:00:00	SPY	ETF	145.56	145.75	145.52	145.61	3780191.0
2007-02-26 11:30:00	SPY	ETF	145.61	145.61	145.41	145.49	3110086.0
2007-02-26 12:00:00	SPY	ETF	145.49	145.5	145.16	145.2428	4671679.0
2007-02-26 12:30:00	SPY	ETF	145.24	145.25	144.75	144.82	7242938.0
2007-02-26 13:00:00	SPY	ETF	144.81	144.93	144.79	144.92	3957589.0
2007-02-26 13:30:00	SPY	ETF	144.92	144.97	144.83	144.95	4836470.0
2007-02-26 14:00:00	SPY	ETF	144.95	145.15	144.76	145.09	5167343.0
2007-02-26 14:30:00	SPY	ETF	145.09	145.945	145.03	145.13	3546538.0
2007-02-26 15:00:00	SPY	ETF	145.13	145.925	145.02	145.06	1922204.0
2007-02-26 15:30:00	SPY	ETF	145.06	145.23	145.0	145.21	5823231.0
2007-02-26 16:00:00	SPY	ETF	145.22	145.25	145.14	145.21	634308.0
2007-02-26 16:30:00	SPY	ETF	145.22	145.24	145.16	145.18	349548.0
2007-02-26 17:00:00	SPY	ETF	145.21	145.25	145.2	145.22	202861.0
2007-02-26 17:30:00	SPY	ETF	145.21	145.25	145.21	145.25	5000.0
2007-02-26 18:00:00	SPY	ETF	145.22	145.24	145.22	145.24	737290.0
2007-02-26 18:30:00	SPY	ETF	145.21	145.24	145.2	145.24	31300.0
2007-02-26 19:00:00	SPY	ETF	145.23	145.23	145.2	145.2	1000.0
2007-02-26 19:30:00	SPY	ETF	145.2	145.2	145.2	145.2	9000.0
2007-02-26 05:00:00	QQQ	ETF	45.44	45.44	45.44	45.44	1000.0
2007-02-26 07:00:00	QQQ	ETF	45.43	45.43	45.41	45.42	11800.0
2007-02-26 07:30:00	QQQ	ETF	45.41	45.49	45.41	45.47	520725.0
2007-02-26 08:00:00	QQQ	ETF	45.48	45.51	45.46	45.5	559316.0
2007-02-26 08:30:00	QQQ	ETF	45.5	45.53	45.49	45.51	626202.0
2007-02-26 09:00:00	QQQ	ETF	45.5	45.51	45.49	45.49	157225.0
2007-02-26 09:30:00	QQQ	ETF	45.49	45.5	45.16	45.16	17674500.0
2007-02-26 10:00:00	QQQ	ETF	45.16	45.25	45.12	45.12	9747500.0
2007-02-26 10:30:00	QQQ	ETF	45.13	45.13	44.98	45.1	7250900.0
2007-02-26 11:00:00	QQQ	ETF	45.1	45.17	45.06	45.11	3875500.0
2007-02-26 11:30:00	QQQ	ETF	45.12	45.17	45.05	45.16	4157100.0
2007-02-26 12:00:00	QQQ	ETF	45.15	45.16	44.99	45.04	6964400.0
2007-02-26 12:30:00	QQQ	ETF	45.03	45.04	44.77	44.78	11330100.0
2007-02-26 13:00:00	QQQ	ETF	44.78	44.86	44.76	44.85	6827200.0
2007-02-26 13:30:00	QQQ	ETF	44.85	44.92	44.83	44.89	5221800.0
2007-02-26 14:00:00	QQQ	ETF	44.9	44.97	44.87	44.93	4850100.0
2007-02-26 14:30:00	QQQ	ETF	44.93	44.99	44.91	44.94	2797100.0
2007-02-26 15:00:00	QQQ	ETF	44.95	44.98	44.9	44.92	2479300.0
2007-02-26 15:30:00	QQQ	ETF	44.93	45.07	44.91	45.07	7716500.0
2007-02-26 16:00:00	QQQ	ETF	45.07	45.42	45.04	45.09	1623776.0
2007-02-26 16:30:00	QQQ	ETF	45.08	45.1	45.07	45.1	220616.0
2007-02-26 17:00:00	QQQ	ETF	45.09	45.1	45.08	45.08	20466.0

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

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