PREVIEW / etf_30min / 2007-04-23

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-23.parquet
  size:    106 KB
  rows:    3,775

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-04-23 06:00:00	SPY	ETF	148.39	148.48	148.39	148.48	16500.0
2007-04-23 06:30:00	SPY	ETF	148.46	148.6	148.43	148.6	85900.0
2007-04-23 07:00:00	SPY	ETF	148.56	148.6	148.56	148.57	44200.0
2007-04-23 07:30:00	SPY	ETF	148.57	148.57	148.5	148.54	51000.0
2007-04-23 08:00:00	SPY	ETF	148.57	148.59	148.43	148.48	384300.0
2007-04-23 08:30:00	SPY	ETF	148.48	148.5	148.29	148.45	790700.0
2007-04-23 09:00:00	SPY	ETF	148.45	148.47	148.3	148.37	823400.0
2007-04-23 09:30:00	SPY	ETF	148.37	148.73	148.21	148.5915	14901075.0
2007-04-23 10:00:00	SPY	ETF	148.59	148.68	148.42	148.51	7322222.0
2007-04-23 10:30:00	SPY	ETF	148.51	148.64	148.48	148.55	3949699.0
2007-04-23 11:00:00	SPY	ETF	148.54	148.61	148.36	148.54	6526676.0
2007-04-23 11:30:00	SPY	ETF	148.55	148.56	148.35	148.47	4464795.0
2007-04-23 12:00:00	SPY	ETF	148.47	148.49	148.28	148.38	2438231.0
2007-04-23 12:30:00	SPY	ETF	148.38	148.42	148.33	148.38	2009445.0
2007-04-23 13:00:00	SPY	ETF	148.38	148.47	148.33	148.39	2711610.0
2007-04-23 13:30:00	SPY	ETF	148.38	148.4042	148.09	148.1	8644026.0
2007-04-23 14:00:00	SPY	ETF	148.09	148.32	147.97	148.05	5648702.0
2007-04-23 14:30:00	SPY	ETF	148.04	148.25	148.0	148.2	3056621.0
2007-04-23 15:00:00	SPY	ETF	148.19	148.31	148.07	148.29	3887111.0
2007-04-23 15:30:00	SPY	ETF	148.298	148.3	148.06	148.12	5550824.0
2007-04-23 16:00:00	SPY	ETF	148.12	148.2	148.05	148.07	624700.0
2007-04-23 16:30:00	SPY	ETF	148.1	148.37	148.06	148.35	1587100.0
2007-04-23 17:00:00	SPY	ETF	148.35	148.38	148.17	148.17	933400.0
2007-04-23 17:30:00	SPY	ETF	148.18	148.3	148.18	148.2	15400.0
2007-04-23 18:00:00	SPY	ETF	148.2	148.2	148.14	148.14	298200.0
2007-04-23 18:30:00	SPY	ETF	148.14	148.15	148.14	148.14	5200.0
2007-04-23 19:00:00	SPY	ETF	148.2	148.2	148.2	148.2	10000.0
2007-04-23 19:30:00	SPY	ETF	148.19	148.19	148.19	148.19	2000.0
2007-04-23 04:00:00	QQQ	ETF	45.41	45.41	45.4	45.4	14400.0
2007-04-23 06:00:00	QQQ	ETF	45.42	45.45	45.42	45.44	72701.0
2007-04-23 07:00:00	QQQ	ETF	45.47	45.5	45.47	45.49	32637.0
2007-04-23 07:30:00	QQQ	ETF	45.48	45.49	45.48	45.48	10000.0
2007-04-23 08:00:00	QQQ	ETF	45.48	45.48	45.45	45.46	192579.0
2007-04-23 08:30:00	QQQ	ETF	45.47	45.48	45.44	45.44	758888.0
2007-04-23 09:00:00	QQQ	ETF	45.44	45.46	45.42	45.42	423438.0
2007-04-23 09:30:00	QQQ	ETF	45.42	45.56	45.4	45.51	12097400.0
2007-04-23 10:00:00	QQQ	ETF	45.51	45.54	45.42	45.46	10327900.0
2007-04-23 10:30:00	QQQ	ETF	45.46	45.55	45.45	45.53	4267900.0
2007-04-23 11:00:00	QQQ	ETF	45.52	45.6	45.48	45.59	5766300.0
2007-04-23 11:30:00	QQQ	ETF	45.58	45.59	45.48	45.54	4285400.0
2007-04-23 12:00:00	QQQ	ETF	45.53	45.54	45.43	45.46	4656800.0
2007-04-23 12:30:00	QQQ	ETF	45.47	45.51	45.44	45.5	3590300.0
2007-04-23 13:00:00	QQQ	ETF	45.51	45.55	45.49	45.5	3254500.0
2007-04-23 13:30:00	QQQ	ETF	45.5	45.5	45.39	45.39	6505500.0
2007-04-23 14:00:00	QQQ	ETF	45.4	45.43	45.34	45.4	4668700.0
2007-04-23 14:30:00	QQQ	ETF	45.4	45.5	45.4	45.47	4237900.0
2007-04-23 15:00:00	QQQ	ETF	45.47	45.54	45.44	45.54	5934000.0
2007-04-23 15:30:00	QQQ	ETF	45.53	45.54	45.46	45.47	6481500.0
2007-04-23 16:00:00	QQQ	ETF	45.47	45.49	45.44	45.48	2183224.0
2007-04-23 16:30:00	QQQ	ETF	45.49	45.69	45.48	45.68	4289112.0

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

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