PREVIEW / etf_30min / 2007-09-28

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-28.parquet
  size:    124 KB
  rows:    4,687

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-28 07:00:00	SPY	ETF	152.59	152.79	152.59	152.72	61900.0
2007-09-28 07:30:00	SPY	ETF	152.7	152.72	152.59	152.69	184100.0
2007-09-28 08:00:00	SPY	ETF	152.67	152.79	152.53	152.62	1432700.0
2007-09-28 08:30:00	SPY	ETF	152.62	152.89	152.61	152.78	1236100.0
2007-09-28 09:00:00	SPY	ETF	152.74	152.88	152.62	152.86	581000.0
2007-09-28 09:30:00	SPY	ETF	152.85	153.15	152.79	152.99	11291785.0
2007-09-28 10:00:00	SPY	ETF	152.99	153.19	152.52	152.52	14541300.0
2007-09-28 10:30:00	SPY	ETF	152.52	152.57	152.22	152.52	17083200.0
2007-09-28 11:00:00	SPY	ETF	152.52	152.72	152.395	152.56	6445100.0
2007-09-28 11:30:00	SPY	ETF	152.56	152.68	152.42	152.49	4148800.0
2007-09-28 12:00:00	SPY	ETF	152.49	152.57	152.35	152.48	5008600.0
2007-09-28 12:30:00	SPY	ETF	152.47	152.59	152.42	152.54	2609800.0
2007-09-28 13:00:00	SPY	ETF	152.54	152.78	152.52	152.66	4011600.0
2007-09-28 13:30:00	SPY	ETF	152.66	152.81	152.63	152.8	5539800.0
2007-09-28 14:00:00	SPY	ETF	152.8	152.93	152.46	152.47	8931000.0
2007-09-28 14:30:00	SPY	ETF	152.48	152.61	152.34	152.45	6374200.0
2007-09-28 15:00:00	SPY	ETF	152.45	152.51	151.98	152.25	13385100.0
2007-09-28 15:30:00	SPY	ETF	152.26	152.5	152.23	152.47	15612500.0
2007-09-28 16:00:00	SPY	ETF	152.55	152.7	152.33	152.7	12163100.0
2007-09-28 16:30:00	SPY	ETF	152.71	152.78	152.58	152.65	76500.0
2007-09-28 17:00:00	SPY	ETF	152.66	152.73	152.58	152.69	27700.0
2007-09-28 17:30:00	SPY	ETF	152.69	152.69	152.6	152.69	21600.0
2007-09-28 18:00:00	SPY	ETF	152.66	152.66	152.63	152.63	900.0
2007-09-28 18:30:00	SPY	ETF	152.84	152.84	152.62	152.65	1700.0
2007-09-28 19:00:00	SPY	ETF	152.64	152.64	152.61	152.61	500.0
2007-09-28 19:30:00	SPY	ETF	152.63	152.65	152.62	152.64	2900.0
2007-09-28 07:00:00	QQQ	ETF	51.41	51.45	51.39	51.44	251789.0
2007-09-28 07:30:00	QQQ	ETF	51.45	51.47	51.41	51.47	86788.0
2007-09-28 08:00:00	QQQ	ETF	51.43	51.51	51.43	51.5	968735.0
2007-09-28 08:30:00	QQQ	ETF	51.5	51.61	51.5	51.54	548320.0
2007-09-28 09:00:00	QQQ	ETF	51.54	51.57	51.38	51.55	291392.0
2007-09-28 09:30:00	QQQ	ETF	51.55	51.68	51.52	51.631	7875045.0
2007-09-28 10:00:00	QQQ	ETF	51.63	51.68	51.43	51.4319	10063698.0
2007-09-28 10:30:00	QQQ	ETF	51.43	51.44	51.32	51.42	7139740.0
2007-09-28 11:00:00	QQQ	ETF	51.42	51.46	51.36	51.43	4049094.0
2007-09-28 11:30:00	QQQ	ETF	51.42	51.46	51.36	51.41	2392744.0
2007-09-28 12:00:00	QQQ	ETF	51.41	51.43	51.34	51.38	1730982.0
2007-09-28 12:30:00	QQQ	ETF	51.39	51.44	51.38	51.41	4163349.0
2007-09-28 13:00:00	QQQ	ETF	51.41	51.5	51.39	51.45	5099434.0
2007-09-28 13:30:00	QQQ	ETF	51.45	51.51	51.44	51.5	3751687.0
2007-09-28 14:00:00	QQQ	ETF	51.5	51.54	51.36	51.36	3413718.0
2007-09-28 14:30:00	QQQ	ETF	51.36	51.42	51.27	51.32	5326065.0
2007-09-28 15:00:00	QQQ	ETF	51.32	51.35	51.18	51.27	7300287.0
2007-09-28 15:30:00	QQQ	ETF	51.27	51.42	51.26	51.4	7215955.0
2007-09-28 16:00:00	QQQ	ETF	51.41	51.49	51.3967	51.46	3717170.0
2007-09-28 16:30:00	QQQ	ETF	51.44	51.49	51.41	51.46	25222.0
2007-09-28 17:00:00	QQQ	ETF	51.46	51.49	51.43	51.47	52475.0
2007-09-28 17:30:00	QQQ	ETF	51.46	51.51	51.46	51.51	39482.0
2007-09-28 18:00:00	QQQ	ETF	51.52	51.53	51.48	51.52	7300.0
2007-09-28 18:30:00	QQQ	ETF	51.51	51.58	51.45	51.57	24560.0

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

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