PREVIEW / stock_30min / 2010-02-02

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-02.parquet
  size:    1.4 MB
  rows:    72,881
  symbols: 3,439

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
2010-02-02 05:00:00	AAPL	Stock	6.9629	6.9682	6.9629	6.9682	11200.0
2010-02-02 06:00:00	AAPL	Stock	6.9907	6.9911	6.9907	6.9911	5824.0
2010-02-02 06:30:00	AAPL	Stock	6.9914	6.9914	6.9911	6.9911	5600.0
2010-02-02 07:00:00	AAPL	Stock	6.9911	6.9996	6.9904	6.9904	120680.0
2010-02-02 07:30:00	AAPL	Stock	6.9839	6.9839	6.9771	6.9818	65856.0
2010-02-02 08:00:00	AAPL	Stock	6.9786	6.9993	6.9668	6.9793	1624756.0
2010-02-02 08:30:00	AAPL	Stock	6.9804	6.9832	6.9589	6.9761	1764812.0
2010-02-02 09:00:00	AAPL	Stock	6.9739	6.9957	6.9721	6.9957	1554196.0
2010-02-02 09:30:00	AAPL	Stock	6.9914	7.0054	6.9404	6.9546	94302432.0
2010-02-02 10:00:00	AAPL	Stock	6.9568	6.9786	6.9064	6.9661	79224152.0
2010-02-02 10:30:00	AAPL	Stock	6.9679	6.9768	6.9207	6.9254	58178148.0
2010-02-02 11:00:00	AAPL	Stock	6.9254	6.95	6.9146	6.9479	40617584.0
2010-02-02 11:30:00	AAPL	Stock	6.9486	6.9736	6.935	6.9618	36403136.0
2010-02-02 12:00:00	AAPL	Stock	6.9611	6.9718	6.9543	6.969	26043808.0
2010-02-02 12:30:00	AAPL	Stock	6.969	6.9779	6.9521	6.9779	21685944.0
2010-02-02 13:00:00	AAPL	Stock	6.9771	6.9821	6.9557	6.9718	26515412.0
2010-02-02 13:30:00	AAPL	Stock	6.9715	7.0	6.9664	6.9803	36221500.0
2010-02-02 14:00:00	AAPL	Stock	6.9811	6.9921	6.9664	6.9754	29070664.0
2010-02-02 14:30:00	AAPL	Stock	6.9761	6.9811	6.9614	6.9767	24467184.0
2010-02-02 15:00:00	AAPL	Stock	6.9768	7.0114	6.9661	6.9932	46990272.0
2010-02-02 15:30:00	AAPL	Stock	6.9932	7.0036	6.975	6.9936	50089844.0
2010-02-02 16:00:00	AAPL	Stock	6.9939	6.9964	6.9643	6.9911	28061404.0
2010-02-02 16:30:00	AAPL	Stock	6.9916	6.995	6.9875	6.9911	260792.0
2010-02-02 17:00:00	AAPL	Stock	6.9546	6.9911	6.9546	6.9868	65240.0
2010-02-02 17:30:00	AAPL	Stock	6.9861	6.9945	6.9861	6.9889	120232.0
2010-02-02 18:00:00	AAPL	Stock	6.9879	6.995	6.9879	6.9918	154308.0
2010-02-02 18:30:00	AAPL	Stock	6.9929	6.995	6.9896	6.9939	56000.0
2010-02-02 19:00:00	AAPL	Stock	6.9929	6.9929	6.9882	6.9929	92820.0
2010-02-02 19:30:00	AAPL	Stock	6.9886	6.99	6.9875	6.9875	86184.0
2010-02-02 04:00:00	MSFT	Stock	28.3	28.3	28.3	28.3	100.0
2010-02-02 05:00:00	MSFT	Stock	28.36	28.36	28.36	28.36	100.0
2010-02-02 07:00:00	MSFT	Stock	28.4	28.45	28.37	28.45	3000.0
2010-02-02 07:30:00	MSFT	Stock	28.45	28.45	28.45	28.45	600.0
2010-02-02 08:00:00	MSFT	Stock	28.43	28.46	28.38	28.38	17005.0
2010-02-02 08:30:00	MSFT	Stock	28.4	28.4	28.36	28.37	16178.0
2010-02-02 09:00:00	MSFT	Stock	28.36	28.42	28.33	28.37	19300.0
2010-02-02 09:30:00	MSFT	Stock	28.37	28.39	28.16	28.2	6627225.0
2010-02-02 10:00:00	MSFT	Stock	28.21	28.47	28.14	28.441	5923404.0
2010-02-02 10:30:00	MSFT	Stock	28.44	28.5	28.33	28.4	5652015.0
2010-02-02 11:00:00	MSFT	Stock	28.4	28.415	28.32	28.39	2697092.0
2010-02-02 11:30:00	MSFT	Stock	28.39	28.46	28.35	28.415	2958842.0
2010-02-02 12:00:00	MSFT	Stock	28.42	28.49	28.38	28.451	3048985.0
2010-02-02 12:30:00	MSFT	Stock	28.45	28.46	28.37	28.405	2496832.0
2010-02-02 13:00:00	MSFT	Stock	28.41	28.42	28.27	28.38	2861948.0
2010-02-02 13:30:00	MSFT	Stock	28.37	28.44	28.36	28.42	2517398.0
2010-02-02 14:00:00	MSFT	Stock	28.42	28.44	28.35	28.38	2534934.0
2010-02-02 14:30:00	MSFT	Stock	28.388	28.42	28.35	28.4	2073279.0
2010-02-02 15:00:00	MSFT	Stock	28.41	28.5	28.38	28.404	3940381.0
2010-02-02 15:30:00	MSFT	Stock	28.4	28.48	28.4	28.48	6274392.0
2010-02-02 16:00:00	MSFT	Stock	28.48	28.49	28.37	28.48	2994207.0

> showing 50 of 72,881 rows — these rows as CSV

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