PREVIEW / stock_30min / 2008-05-29

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-05-29.parquet
  size:    1.3 MB
  rows:    69,160
  symbols: 3,293

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
2008-05-29 07:30:00	AAPL	Stock	6.6886	6.6886	6.6668	6.6668	30800.0
2008-05-29 08:00:00	AAPL	Stock	6.6782	6.6975	6.6696	6.6714	1681680.0
2008-05-29 08:30:00	AAPL	Stock	6.6714	6.6718	6.6429	6.6489	1948492.0
2008-05-29 09:00:00	AAPL	Stock	6.65	6.6793	6.65	6.6746	1408540.0
2008-05-29 09:30:00	AAPL	Stock	6.6714	6.6811	6.625	6.6511	79337804.0
2008-05-29 10:00:00	AAPL	Stock	6.6526	6.6925	6.6393	6.6829	79123772.0
2008-05-29 10:30:00	AAPL	Stock	6.6836	6.6925	6.6436	6.6686	66024616.0
2008-05-29 11:00:00	AAPL	Stock	6.6686	6.6782	6.6429	6.65	49695856.0
2008-05-29 11:30:00	AAPL	Stock	6.65	6.6911	6.64	6.6761	46000108.0
2008-05-29 12:00:00	AAPL	Stock	6.6761	6.6811	6.6636	6.6739	24395700.0
2008-05-29 12:30:00	AAPL	Stock	6.6746	6.7179	6.6721	6.7029	53488036.0
2008-05-29 13:00:00	AAPL	Stock	6.7036	6.7175	6.6786	6.6846	36186528.0
2008-05-29 13:30:00	AAPL	Stock	6.685	6.7021	6.6786	6.6939	25657184.0
2008-05-29 14:00:00	AAPL	Stock	6.6954	6.7161	6.6786	6.7011	42668892.0
2008-05-29 14:30:00	AAPL	Stock	6.7021	6.7214	6.6725	6.6854	42696640.0
2008-05-29 15:00:00	AAPL	Stock	6.6854	6.6946	6.6611	6.6696	36038156.0
2008-05-29 15:30:00	AAPL	Stock	6.6696	6.6889	6.6646	6.6664	45691436.0
2008-05-29 16:00:00	AAPL	Stock	6.6816	6.6857	6.6654	6.6836	10224452.0
2008-05-29 16:30:00	AAPL	Stock	6.6675	6.685	6.6675	6.6821	343812.0
2008-05-29 17:00:00	AAPL	Stock	6.6818	6.6882	6.6789	6.6868	501900.0
2008-05-29 17:30:00	AAPL	Stock	6.6868	6.6875	6.6796	6.6821	356020.0
2008-05-29 18:00:00	AAPL	Stock	6.685	6.6871	6.6811	6.6857	71260.0
2008-05-29 18:30:00	AAPL	Stock	6.6854	6.6857	6.6768	6.6786	218960.0
2008-05-29 19:00:00	AAPL	Stock	6.6786	6.6786	6.675	6.675	41384.0
2008-05-29 19:30:00	AAPL	Stock	6.675	6.6807	6.675	6.675	87052.0
2008-05-29 08:00:00	MSFT	Stock	28.23	28.29	28.23	28.26	2674.0
2008-05-29 08:30:00	MSFT	Stock	28.25	28.28	28.22	28.24	15164.0
2008-05-29 09:00:00	MSFT	Stock	28.24	28.25	28.14	28.14	15551.0
2008-05-29 09:30:00	MSFT	Stock	28.19	28.49	28.14	28.49	3956574.0
2008-05-29 10:00:00	MSFT	Stock	28.49	28.5	28.31	28.44	4012886.0
2008-05-29 10:30:00	MSFT	Stock	28.44	28.54	28.31	28.47	4215695.0
2008-05-29 11:00:00	MSFT	Stock	28.48	28.52	28.37	28.43	2337529.0
2008-05-29 11:30:00	MSFT	Stock	28.44	28.56	28.41	28.49	2937441.0
2008-05-29 12:00:00	MSFT	Stock	28.49	28.58	28.46	28.565	2037653.0
2008-05-29 12:30:00	MSFT	Stock	28.56	28.67	28.56	28.64	2470097.0
2008-05-29 13:00:00	MSFT	Stock	28.64	28.68	28.51	28.56	2441167.0
2008-05-29 13:30:00	MSFT	Stock	28.56	28.62	28.51	28.55	2372258.0
2008-05-29 14:00:00	MSFT	Stock	28.55	28.61	28.51	28.55	2916451.0
2008-05-29 14:30:00	MSFT	Stock	28.54	28.57	28.36	28.412	3769555.0
2008-05-29 15:00:00	MSFT	Stock	28.41	28.43	28.35	28.39	3876223.0
2008-05-29 15:30:00	MSFT	Stock	28.39	28.43	28.25	28.26	7804789.0
2008-05-29 16:00:00	MSFT	Stock	28.27	28.456	28.26	28.39	1557232.0
2008-05-29 16:30:00	MSFT	Stock	28.39	28.48	28.295	28.43	105919.0
2008-05-29 17:00:00	MSFT	Stock	28.45	28.5	28.4	28.41	56745.0
2008-05-29 17:30:00	MSFT	Stock	28.42	28.5	28.41	28.5	10590.0
2008-05-29 18:00:00	MSFT	Stock	28.49	28.5	28.47	28.5	7025.0
2008-05-29 18:30:00	MSFT	Stock	28.5	28.5	28.45	28.45	2194.0
2008-05-29 19:00:00	MSFT	Stock	28.45	28.48	28.43	28.45	2800.0
2008-05-29 19:30:00	MSFT	Stock	28.46	28.46	28.4	28.42	6565.0
2008-05-29 20:00:00	MSFT	Stock	28.31	28.31	28.31	28.31	3700.0

> showing 50 of 69,160 rows — these rows as CSV

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