PREVIEW / stock_30min / 2007-01-29

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-29.parquet
  size:    965 KB
  rows:    52,320
  symbols: 2,514

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-01-29 07:00:00	AAPL	Stock	3.0436	3.0436	3.0436	3.0436	26600.0
2007-01-29 07:30:00	AAPL	Stock	3.0464	3.0707	3.0439	3.0586	823200.0
2007-01-29 08:00:00	AAPL	Stock	3.0625	3.0789	3.0611	3.0704	4603844.0
2007-01-29 08:30:00	AAPL	Stock	3.0696	3.075	3.0696	3.075	3040296.0
2007-01-29 09:00:00	AAPL	Stock	3.0739	3.0889	3.0736	3.0821	6657028.0
2007-01-29 09:30:00	AAPL	Stock	3.0821	3.0943	3.0643	3.0739	152805128.0
2007-01-29 10:00:00	AAPL	Stock	3.0736	3.0907	3.0582	3.0629	127458128.0
2007-01-29 10:30:00	AAPL	Stock	3.0625	3.0821	3.0575	3.0729	78413356.0
2007-01-29 11:00:00	AAPL	Stock	3.0736	3.0811	3.0693	3.0764	51607192.0
2007-01-29 11:30:00	AAPL	Stock	3.0764	3.0796	3.0661	3.071	43793736.0
2007-01-29 12:00:00	AAPL	Stock	3.0707	3.0754	3.0629	3.0671	45260320.0
2007-01-29 12:30:00	AAPL	Stock	3.0671	3.0914	3.0654	3.0911	65670584.0
2007-01-29 13:00:00	AAPL	Stock	3.0911	3.0946	3.0804	3.0818	47971980.0
2007-01-29 13:30:00	AAPL	Stock	3.0814	3.0868	3.0618	3.0632	58444372.0
2007-01-29 14:00:00	AAPL	Stock	3.0629	3.0693	3.0546	3.0636	61752404.0
2007-01-29 14:30:00	AAPL	Stock	3.0632	3.07	3.0589	3.0607	32093936.0
2007-01-29 15:00:00	AAPL	Stock	3.0607	3.0743	3.06	3.07	42272356.0
2007-01-29 15:30:00	AAPL	Stock	3.0696	3.0718	3.0611	3.0682	54484332.0
2007-01-29 16:00:00	AAPL	Stock	3.0689	3.0764	3.0675	3.0736	3599204.0
2007-01-29 16:30:00	AAPL	Stock	3.0739	3.0786	3.0739	3.0739	556500.0
2007-01-29 17:00:00	AAPL	Stock	3.0739	3.0761	3.0693	3.0761	164976.0
2007-01-29 17:30:00	AAPL	Stock	3.0754	3.0768	3.0736	3.0768	208096.0
2007-01-29 18:00:00	AAPL	Stock	3.0768	3.0804	3.0768	3.0789	324324.0
2007-01-29 18:30:00	AAPL	Stock	3.0771	3.0796	3.0768	3.0796	139972.0
2007-01-29 19:00:00	AAPL	Stock	3.0771	3.0786	3.0771	3.0786	16800.0
2007-01-29 19:30:00	AAPL	Stock	3.0786	3.0796	3.0775	3.0779	317996.0
2007-01-29 07:00:00	MSFT	Stock	30.75	30.75	30.7	30.7	2077.0
2007-01-29 07:30:00	MSFT	Stock	30.7	30.7	30.65	30.7	4600.0
2007-01-29 08:00:00	MSFT	Stock	30.7	30.7	30.65	30.7	11223.0
2007-01-29 08:30:00	MSFT	Stock	30.7	30.72	30.61	30.61	22163.0
2007-01-29 09:00:00	MSFT	Stock	30.64	30.68	30.6	30.64	353679.0
2007-01-29 09:30:00	MSFT	Stock	30.65	30.78	30.45	30.53	9232538.0
2007-01-29 10:00:00	MSFT	Stock	30.53	30.65	30.42	30.43	5090565.0
2007-01-29 10:30:00	MSFT	Stock	30.43	30.52	30.38	30.46	4253456.0
2007-01-29 11:00:00	MSFT	Stock	30.46	30.47	30.34	30.41	3864898.0
2007-01-29 11:30:00	MSFT	Stock	30.4	30.42	30.35	30.36	2304852.0
2007-01-29 12:00:00	MSFT	Stock	30.37	30.5	30.36	30.48	3176707.0
2007-01-29 12:30:00	MSFT	Stock	30.48	30.66	30.45	30.59	3445638.0
2007-01-29 13:00:00	MSFT	Stock	30.59	30.62	30.4	30.54	2645876.0
2007-01-29 13:30:00	MSFT	Stock	30.53	30.59	30.37	30.4	3399488.0
2007-01-29 14:00:00	MSFT	Stock	30.4	30.43	30.34	30.4	4099187.0
2007-01-29 14:30:00	MSFT	Stock	30.4	30.49	30.39	30.46	2873307.0
2007-01-29 15:00:00	MSFT	Stock	30.46	30.5	30.4	30.42	3556169.0
2007-01-29 15:30:00	MSFT	Stock	30.42	30.56	30.41	30.53	6055279.0
2007-01-29 16:00:00	MSFT	Stock	30.53	30.7	30.5	30.59	168915.0
2007-01-29 16:30:00	MSFT	Stock	30.59	30.62	30.53	30.6	562130.0
2007-01-29 17:00:00	MSFT	Stock	30.6	30.6	30.56	30.56	1972.0
2007-01-29 17:30:00	MSFT	Stock	30.59	30.62	30.59	30.62	2328.0
2007-01-29 18:00:00	MSFT	Stock	30.62	30.64	30.62	30.64	4940.0
2007-01-29 18:30:00	MSFT	Stock	30.64	30.64	30.62	30.62	3240.0

> showing 50 of 52,320 rows — these rows as CSV

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