PREVIEW / etf_30min / 2007-02-23

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-02-23.parquet
  size:    101 KB
  rows:    3,575

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-23 06:30:00	SPY	ETF	145.77	145.77	145.76	145.76	20000.0
2007-02-23 07:00:00	SPY	ETF	145.73	145.81	145.73	145.81	18600.0
2007-02-23 07:30:00	SPY	ETF	145.78	145.83	145.78	145.83	100400.0
2007-02-23 08:00:00	SPY	ETF	145.78	145.79	145.73	145.73	66900.0
2007-02-23 08:30:00	SPY	ETF	145.74	145.87	145.74	145.85	291900.0
2007-02-23 09:00:00	SPY	ETF	145.81	145.81	145.72	145.73	418700.0
2007-02-23 09:30:00	SPY	ETF	145.74	145.79	145.42	145.43	10045800.0
2007-02-23 10:00:00	SPY	ETF	145.43	145.58	145.2	145.24	8509700.0
2007-02-23 10:30:00	SPY	ETF	145.24	145.37	145.03	145.12	13264200.0
2007-02-23 11:00:00	SPY	ETF	145.11	145.3	145.03	145.16	4630400.0
2007-02-23 11:30:00	SPY	ETF	145.15	145.45	145.13	145.38	4550900.0
2007-02-23 12:00:00	SPY	ETF	145.38	145.645	145.09	145.26	3113200.0
2007-02-23 12:30:00	SPY	ETF	145.27	145.74	145.03	145.21	3834100.0
2007-02-23 13:00:00	SPY	ETF	145.21	145.29	145.1	145.29	2657900.0
2007-02-23 13:30:00	SPY	ETF	145.29	145.35	145.19	145.22	3512500.0
2007-02-23 14:00:00	SPY	ETF	145.22	145.45	144.75	145.39	3269500.0
2007-02-23 14:30:00	SPY	ETF	145.39	145.55	145.34	145.39	4591700.0
2007-02-23 15:00:00	SPY	ETF	145.4	145.51	145.31	145.45	3194500.0
2007-02-23 15:30:00	SPY	ETF	145.44	145.47	145.29	145.36	3753800.0
2007-02-23 16:00:00	SPY	ETF	145.34	145.38	145.24	145.29	707100.0
2007-02-23 16:30:00	SPY	ETF	145.28	145.31	145.27	145.31	21800.0
2007-02-23 17:00:00	SPY	ETF	145.31	145.32	145.3	145.3	13700.0
2007-02-23 17:30:00	SPY	ETF	145.33	145.38	145.32	145.38	7700.0
2007-02-23 18:00:00	SPY	ETF	145.4	145.43	145.4	145.43	700.0
2007-02-23 18:30:00	SPY	ETF	145.4	145.4	145.4	145.4	200.0
2007-02-23 19:00:00	SPY	ETF	145.41	145.41	145.35	145.35	2800.0
2007-02-23 19:30:00	SPY	ETF	145.36	145.36	145.33	145.35	14700.0
2007-02-23 07:00:00	QQQ	ETF	45.39	45.42	45.39	45.41	45900.0
2007-02-23 07:30:00	QQQ	ETF	45.41	45.46	45.4	45.46	108242.0
2007-02-23 08:00:00	QQQ	ETF	45.45	45.46	45.42	45.45	75829.0
2007-02-23 08:30:00	QQQ	ETF	45.44	45.47	45.43	45.47	376364.0
2007-02-23 09:00:00	QQQ	ETF	45.46	45.47	45.41	45.41	596442.0
2007-02-23 09:30:00	QQQ	ETF	45.41	45.46	45.25	45.26	12484900.0
2007-02-23 10:00:00	QQQ	ETF	45.26	45.39	45.19	45.2	10108300.0
2007-02-23 10:30:00	QQQ	ETF	45.2	45.22	45.06	45.15	17457500.0
2007-02-23 11:00:00	QQQ	ETF	45.15	45.29	45.12	45.23	9524800.0
2007-02-23 11:30:00	QQQ	ETF	45.23	45.37	45.22	45.31	10326700.0
2007-02-23 12:00:00	QQQ	ETF	45.3	45.32	45.21	45.28	4686200.0
2007-02-23 12:30:00	QQQ	ETF	45.28	45.29	45.16	45.26	4934300.0
2007-02-23 13:00:00	QQQ	ETF	45.26	45.27	45.19	45.24	3878700.0
2007-02-23 13:30:00	QQQ	ETF	45.24	45.32	45.23	45.25	4663300.0
2007-02-23 14:00:00	QQQ	ETF	45.25	45.33	45.22	45.3	6141800.0
2007-02-23 14:30:00	QQQ	ETF	45.29	45.37	45.29	45.32	3994800.0
2007-02-23 15:00:00	QQQ	ETF	45.33	45.37	45.29	45.33	4192200.0
2007-02-23 15:30:00	QQQ	ETF	45.34	45.35	45.26	45.26	5667000.0
2007-02-23 16:00:00	QQQ	ETF	45.25	45.29	45.24	45.28	1812280.0
2007-02-23 16:30:00	QQQ	ETF	45.28	45.31	45.27	45.31	118900.0
2007-02-23 17:00:00	QQQ	ETF	45.3	45.3	45.29	45.29	7200.0
2007-02-23 17:30:00	QQQ	ETF	45.29	45.3	45.26	45.29	36473.0
2007-02-23 18:00:00	QQQ	ETF	45.29	45.3	45.28	45.3	1500.0

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

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