PREVIEW / etf_30min / 2007-04-09

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-09.parquet
  size:    104 KB
  rows:    3,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-04-09 05:00:00	SPY	ETF	144.45	144.5	144.45	144.5	200.0
2007-04-09 06:00:00	SPY	ETF	144.81	144.81	144.81	144.81	2500.0
2007-04-09 06:30:00	SPY	ETF	144.85	144.89	144.85	144.89	3500.0
2007-04-09 07:00:00	SPY	ETF	144.86	144.86	144.71	144.75	45700.0
2007-04-09 07:30:00	SPY	ETF	144.75	144.84	144.75	144.82	127100.0
2007-04-09 08:00:00	SPY	ETF	144.78	144.84	144.72	144.83	1340600.0
2007-04-09 08:30:00	SPY	ETF	144.82	144.84	144.24	144.77	236100.0
2007-04-09 09:00:00	SPY	ETF	144.78	144.78	144.58	144.58	409100.0
2007-04-09 09:30:00	SPY	ETF	144.59	144.68	144.15	144.58	7930000.0
2007-04-09 10:00:00	SPY	ETF	144.58	144.6	144.25	144.41	6954800.0
2007-04-09 10:30:00	SPY	ETF	144.41	144.5	144.36	144.45	3182600.0
2007-04-09 11:00:00	SPY	ETF	144.46	144.62	144.46	144.52	2963500.0
2007-04-09 11:30:00	SPY	ETF	144.53	144.59	144.43	144.47	1731906.0
2007-04-09 12:00:00	SPY	ETF	144.47	144.58	144.36	144.54	1536700.0
2007-04-09 12:30:00	SPY	ETF	144.53	144.78	144.53	144.67	2807900.0
2007-04-09 13:00:00	SPY	ETF	144.67	144.75	144.63	144.7	1480200.0
2007-04-09 13:30:00	SPY	ETF	144.7	144.8	144.48	144.48	2857412.0
2007-04-09 14:00:00	SPY	ETF	144.47	144.51	144.31	144.36	4228632.0
2007-04-09 14:30:00	SPY	ETF	144.36	144.52	144.31	144.48	2918252.0
2007-04-09 15:00:00	SPY	ETF	144.48	144.58	144.42	144.48	1972232.0
2007-04-09 15:30:00	SPY	ETF	144.48	144.57	144.35	144.43	4252706.0
2007-04-09 16:00:00	SPY	ETF	144.43	144.48	144.38	144.46	925700.0
2007-04-09 16:30:00	SPY	ETF	144.43	144.45	144.41	144.42	85800.0
2007-04-09 17:00:00	SPY	ETF	144.43	144.43	144.42	144.43	26900.0
2007-04-09 17:30:00	SPY	ETF	144.41	144.43	144.41	144.41	8000.0
2007-04-09 18:00:00	SPY	ETF	144.4	144.43	144.39	144.43	157700.0
2007-04-09 18:30:00	SPY	ETF	144.43	144.43	144.43	144.43	4700.0
2007-04-09 19:00:00	SPY	ETF	144.42	144.44	144.42	144.44	10200.0
2007-04-09 19:30:00	SPY	ETF	144.44	144.45	144.42	144.42	5200.0
2007-04-09 05:00:00	QQQ	ETF	44.78	44.78	44.78	44.78	200.0
2007-04-09 06:30:00	QQQ	ETF	44.77	44.77	44.77	44.77	15000.0
2007-04-09 07:00:00	QQQ	ETF	44.78	44.78	44.72	44.75	73400.0
2007-04-09 07:30:00	QQQ	ETF	44.75	44.79	44.73	44.79	143988.0
2007-04-09 08:00:00	QQQ	ETF	44.77	44.81	44.77	44.77	100008.0
2007-04-09 08:30:00	QQQ	ETF	44.78	44.79	44.58	44.78	263366.0
2007-04-09 09:00:00	QQQ	ETF	44.78	44.78	44.71	44.72	612150.0
2007-04-09 09:30:00	QQQ	ETF	44.71	44.75	44.52	44.58	9186300.0
2007-04-09 10:00:00	QQQ	ETF	44.58	44.6	44.38	44.48	10821200.0
2007-04-09 10:30:00	QQQ	ETF	44.49	46.47	44.44	44.51	3019900.0
2007-04-09 11:00:00	QQQ	ETF	44.52	44.6	44.51	44.57	3358400.0
2007-04-09 11:30:00	QQQ	ETF	44.56	44.6	44.56	44.57	2119300.0
2007-04-09 12:00:00	QQQ	ETF	44.57	44.6	44.56	44.58	965000.0
2007-04-09 12:30:00	QQQ	ETF	44.59	44.7	44.58	44.65	4073400.0
2007-04-09 13:00:00	QQQ	ETF	44.65	44.66	44.61	44.61	1811500.0
2007-04-09 13:30:00	QQQ	ETF	44.62	44.62	44.54	44.54	2822700.0
2007-04-09 14:00:00	QQQ	ETF	44.54	44.54	44.48	44.5	4819600.0
2007-04-09 14:30:00	QQQ	ETF	44.51	44.58	44.49	44.57	2395400.0
2007-04-09 15:00:00	QQQ	ETF	44.57	44.61	44.54	44.57	2455100.0
2007-04-09 15:30:00	QQQ	ETF	44.58	44.63	44.44	44.44	8173300.0
2007-04-09 16:00:00	QQQ	ETF	44.45	44.48	44.43	44.48	2549885.0

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

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