PREVIEW / stock_30min / 2009-12-16

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-12-16.parquet
  size:    1.4 MB
  rows:    76,866
  symbols: 3,438

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-12-16 07:00:00	AAPL	Stock	6.9714	6.9889	6.9654	6.9889	20860.0
2009-12-16 07:30:00	AAPL	Stock	6.9821	6.9889	6.9786	6.9882	139412.0
2009-12-16 08:00:00	AAPL	Stock	6.9889	6.9889	6.9518	6.9732	714924.0
2009-12-16 08:30:00	AAPL	Stock	6.9732	6.975	6.9375	6.9611	421092.0
2009-12-16 09:00:00	AAPL	Stock	6.9625	6.9743	6.9625	6.9671	659876.0
2009-12-16 09:30:00	AAPL	Stock	6.9679	7.0054	6.9554	6.9982	59520636.0
2009-12-16 10:00:00	AAPL	Stock	6.9982	7.0179	6.9879	6.9982	38958668.0
2009-12-16 10:30:00	AAPL	Stock	6.9982	7.0111	6.9857	6.9889	18922568.0
2009-12-16 11:00:00	AAPL	Stock	6.9884	7.0014	6.9807	7.0007	19276068.0
2009-12-16 11:30:00	AAPL	Stock	7.0014	7.0036	6.9911	6.9964	15924020.0
2009-12-16 12:00:00	AAPL	Stock	6.9957	7.0057	6.9886	6.9932	11970560.0
2009-12-16 12:30:00	AAPL	Stock	6.9932	6.9957	6.9768	6.9775	11838428.0
2009-12-16 13:00:00	AAPL	Stock	6.9775	6.9907	6.9775	6.9843	8170512.0
2009-12-16 13:30:00	AAPL	Stock	6.985	6.9889	6.9707	6.9718	9325288.0
2009-12-16 14:00:00	AAPL	Stock	6.9714	6.9964	6.9557	6.9736	26703908.0
2009-12-16 14:30:00	AAPL	Stock	6.9736	6.9918	6.9518	6.9604	33896968.0
2009-12-16 15:00:00	AAPL	Stock	6.9604	6.98	6.9482	6.9521	30590532.0
2009-12-16 15:30:00	AAPL	Stock	6.9525	6.9782	6.9486	6.9654	40888372.0
2009-12-16 16:00:00	AAPL	Stock	6.9654	6.9815	6.965	6.9725	4229148.0
2009-12-16 16:30:00	AAPL	Stock	6.9346	6.9743	6.9346	6.9664	17669036.0
2009-12-16 17:00:00	AAPL	Stock	6.9996	6.9996	6.9661	6.9729	82908.0
2009-12-16 17:30:00	AAPL	Stock	6.9711	6.9732	6.9711	6.9732	27300.0
2009-12-16 18:00:00	AAPL	Stock	6.9732	6.9746	6.9643	6.9661	158144.0
2009-12-16 18:30:00	AAPL	Stock	6.9712	6.9712	6.9661	6.9679	49000.0
2009-12-16 19:30:00	AAPL	Stock	6.9711	6.9714	6.9679	6.9696	63112.0
2009-12-16 08:00:00	MSFT	Stock	30.1	30.18	30.1	30.13	7886.0
2009-12-16 08:30:00	MSFT	Stock	30.16	30.16	30.13	30.14	2800.0
2009-12-16 09:00:00	MSFT	Stock	30.14	30.18	30.08	30.09	34015.0
2009-12-16 09:30:00	MSFT	Stock	30.09	30.35	30.04	30.285	5228140.0
2009-12-16 10:00:00	MSFT	Stock	30.31	30.37	30.29	30.34	3640297.0
2009-12-16 10:30:00	MSFT	Stock	30.34	30.35	30.3	30.33	3160478.0
2009-12-16 11:00:00	MSFT	Stock	30.33	30.41	30.3	30.395	3396856.0
2009-12-16 11:30:00	MSFT	Stock	30.41	30.41	30.36	30.37	2336089.0
2009-12-16 12:00:00	MSFT	Stock	30.37	30.4	30.31	30.33	2738519.0
2009-12-16 12:30:00	MSFT	Stock	30.33	30.37	30.32	30.36	1059011.0
2009-12-16 13:00:00	MSFT	Stock	30.37	30.38	30.34	30.355	2407704.0
2009-12-16 13:30:00	MSFT	Stock	30.35	30.37	30.31	30.322	3387670.0
2009-12-16 14:00:00	MSFT	Stock	30.33	30.35	30.28	30.331	3925763.0
2009-12-16 14:30:00	MSFT	Stock	30.335	30.34	30.175	30.18	4373377.0
2009-12-16 15:00:00	MSFT	Stock	30.18	30.29	30.18	30.2	3877178.0
2009-12-16 15:30:00	MSFT	Stock	30.2	30.22	30.09	30.09	6704933.0
2009-12-16 16:00:00	MSFT	Stock	30.1	30.287	30.09	30.1	2409206.0
2009-12-16 16:30:00	MSFT	Stock	30.02	30.17	30.02	30.1	4913647.0
2009-12-16 17:00:00	MSFT	Stock	30.38	30.38	30.38	30.38	500.0
2009-12-16 17:30:00	MSFT	Stock	30.11	30.15	30.1	30.13	2250.0
2009-12-16 18:00:00	MSFT	Stock	30.1	30.13	30.1	30.13	301.0
2009-12-16 18:30:00	MSFT	Stock	30.11	30.11	30.1	30.1	1101.0
2009-12-16 19:30:00	MSFT	Stock	30.1	30.1	30.1	30.1	2084.0
2009-12-16 08:00:00	NVDA	Stock	0.393	0.404	0.3928	0.395	100000.0
2009-12-16 09:00:00	NVDA	Stock	0.399	0.4118	0.399	0.4055	14022840.0

> showing 50 of 76,866 rows — these rows as CSV

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