PREVIEW / stock_30min / 2009-07-20

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-07-20.parquet
  size:    1.3 MB
  rows:    70,151
  symbols: 3,358

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
2009-07-20 05:00:00	AAPL	Stock	5.4536	5.4536	5.4536	5.4536	7700.0
2009-07-20 07:00:00	AAPL	Stock	5.4536	5.4768	5.4536	5.4575	104580.0
2009-07-20 07:30:00	AAPL	Stock	5.4589	5.5029	5.4571	5.5018	794136.0
2009-07-20 08:00:00	AAPL	Stock	5.4893	5.5007	5.4761	5.4804	2222640.0
2009-07-20 08:30:00	AAPL	Stock	5.48	5.4911	5.4643	5.4725	1822520.0
2009-07-20 09:00:00	AAPL	Stock	5.4725	5.49	5.4661	5.4736	2146424.0
2009-07-20 09:30:00	AAPL	Stock	5.4736	5.5257	5.4546	5.5243	89907776.0
2009-07-20 10:00:00	AAPL	Stock	5.525	5.5314	5.4846	5.4968	67530092.0
2009-07-20 10:30:00	AAPL	Stock	5.4971	5.5089	5.4796	5.5017	42177828.0
2009-07-20 11:00:00	AAPL	Stock	5.5018	5.5304	5.5018	5.5293	31516296.0
2009-07-20 11:30:00	AAPL	Stock	5.5296	5.537	5.5075	5.5212	38447164.0
2009-07-20 12:00:00	AAPL	Stock	5.5211	5.5318	5.5182	5.5204	23720620.0
2009-07-20 12:30:00	AAPL	Stock	5.521	5.5254	5.5043	5.5086	17641764.0
2009-07-20 13:00:00	AAPL	Stock	5.5085	5.5143	5.4893	5.4893	23212168.0
2009-07-20 13:30:00	AAPL	Stock	5.4893	5.5	5.4664	5.4832	54138308.0
2009-07-20 14:00:00	AAPL	Stock	5.4832	5.4857	5.4168	5.4229	65962372.0
2009-07-20 14:30:00	AAPL	Stock	5.4229	5.4396	5.3889	5.4021	98463456.0
2009-07-20 15:00:00	AAPL	Stock	5.4012	5.4436	5.4012	5.4071	59277764.0
2009-07-20 15:30:00	AAPL	Stock	5.4075	5.4632	5.4046	5.4625	92949612.0
2009-07-20 16:00:00	AAPL	Stock	5.4625	5.4729	5.4479	5.4643	14111300.0
2009-07-20 16:30:00	AAPL	Stock	5.465	5.4796	5.4575	5.4643	842352.0
2009-07-20 17:00:00	AAPL	Stock	5.4679	5.4818	5.4661	5.4804	528220.0
2009-07-20 17:30:00	AAPL	Stock	5.4786	5.4879	5.475	5.4761	670124.0
2009-07-20 18:00:00	AAPL	Stock	5.475	5.4764	5.4611	5.4718	1488872.0
2009-07-20 18:30:00	AAPL	Stock	5.4714	5.4782	5.4682	5.4775	319844.0
2009-07-20 19:00:00	AAPL	Stock	5.4775	5.4821	5.4754	5.4793	300776.0
2009-07-20 19:30:00	AAPL	Stock	5.4811	5.5021	5.4807	5.4932	1152088.0
2009-07-20 04:00:00	MSFT	Stock	24.34	24.34	24.34	24.34	100.0
2009-07-20 07:00:00	MSFT	Stock	24.47	24.47	24.47	24.47	116.0
2009-07-20 07:30:00	MSFT	Stock	24.41	24.49	24.41	24.41	2456.0
2009-07-20 08:00:00	MSFT	Stock	24.42	24.5	24.35	24.41	17996.0
2009-07-20 08:30:00	MSFT	Stock	24.44	24.45	24.35	24.35	7730.0
2009-07-20 09:00:00	MSFT	Stock	24.36	24.47	24.36	24.44	18783.0
2009-07-20 09:30:00	MSFT	Stock	24.44	24.48	24.32	24.39	5499028.0
2009-07-20 10:00:00	MSFT	Stock	24.38	24.42	24.26	24.27	4132385.0
2009-07-20 10:30:00	MSFT	Stock	24.27	24.27	24.16	24.19	3028328.0
2009-07-20 11:00:00	MSFT	Stock	24.18	24.25	24.15	24.232	1729208.0
2009-07-20 11:30:00	MSFT	Stock	24.24	24.3	24.23	24.26	1428155.0
2009-07-20 12:00:00	MSFT	Stock	24.269	24.35	24.26	24.3	1894430.0
2009-07-20 12:30:00	MSFT	Stock	24.31	24.31	24.28	24.282	1122067.0
2009-07-20 13:00:00	MSFT	Stock	24.29	24.31	24.25	24.26	1211695.0
2009-07-20 13:30:00	MSFT	Stock	24.25	24.28	24.23	24.28	1741985.0
2009-07-20 14:00:00	MSFT	Stock	24.275	24.35	24.19	24.22	4476510.0
2009-07-20 14:30:00	MSFT	Stock	24.22	24.37	24.21	24.335	4177616.0
2009-07-20 15:00:00	MSFT	Stock	24.34	24.48	24.33	24.45	4214379.0
2009-07-20 15:30:00	MSFT	Stock	24.46	24.53	24.39	24.53	7087372.0
2009-07-20 16:00:00	MSFT	Stock	24.52	24.56	24.357	24.53	5291537.0
2009-07-20 16:30:00	MSFT	Stock	24.5	24.53	24.47	24.53	11924.0
2009-07-20 17:00:00	MSFT	Stock	24.5	24.56	24.5	24.55	12581.0
2009-07-20 17:30:00	MSFT	Stock	24.55	24.55	24.5	24.55	6747.0

> showing 50 of 70,151 rows — these rows as CSV

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