PREVIEW / stock_30min / 2008-06-19

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-19.parquet
  size:    1.2 MB
  rows:    68,685
  symbols: 3,323

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-06-19 05:30:00	AAPL	Stock	6.3857	6.3857	6.3857	6.3857	33600.0
2008-06-19 06:30:00	AAPL	Stock	6.3868	6.3893	6.3868	6.3893	56224.0
2008-06-19 07:00:00	AAPL	Stock	6.3893	6.3893	6.3839	6.3839	22400.0
2008-06-19 07:30:00	AAPL	Stock	6.3889	6.4214	6.3889	6.4107	256200.0
2008-06-19 08:00:00	AAPL	Stock	6.4107	6.4125	6.3782	6.3921	1205764.0
2008-06-19 08:30:00	AAPL	Stock	6.3857	6.4068	6.3679	6.3679	1064252.0
2008-06-19 09:00:00	AAPL	Stock	6.3711	6.3929	6.3675	6.3768	853216.0
2008-06-19 09:30:00	AAPL	Stock	6.3768	6.4279	6.3482	6.403	93586304.0
2008-06-19 10:00:00	AAPL	Stock	6.4032	6.4107	6.3143	6.3657	83246940.0
2008-06-19 10:30:00	AAPL	Stock	6.3664	6.4325	6.36	6.4243	62248256.0
2008-06-19 11:00:00	AAPL	Stock	6.4243	6.4414	6.3529	6.3686	64153320.0
2008-06-19 11:30:00	AAPL	Stock	6.3679	6.4107	6.3679	6.4057	32967620.0
2008-06-19 12:00:00	AAPL	Stock	6.4054	6.4864	6.4025	6.4657	74355876.0
2008-06-19 12:30:00	AAPL	Stock	6.4654	6.4821	6.4439	6.452	39768260.0
2008-06-19 13:00:00	AAPL	Stock	6.4514	6.48	6.4375	6.4596	34616960.0
2008-06-19 13:30:00	AAPL	Stock	6.4593	6.4693	6.4157	6.4457	36534568.0
2008-06-19 14:00:00	AAPL	Stock	6.4457	6.4789	6.43	6.4743	41815676.0
2008-06-19 14:30:00	AAPL	Stock	6.4746	6.5086	6.4643	6.4979	71210804.0
2008-06-19 15:00:00	AAPL	Stock	6.4979	6.5121	6.4843	6.4936	51171456.0
2008-06-19 15:30:00	AAPL	Stock	6.4932	6.4975	6.4532	6.4636	65599576.0
2008-06-19 16:00:00	AAPL	Stock	6.4636	6.4845	6.4314	6.4589	7284984.0
2008-06-19 16:30:00	AAPL	Stock	6.4607	6.4657	6.434	6.4629	410984.0
2008-06-19 17:00:00	AAPL	Stock	6.4661	6.4689	6.465	6.465	225848.0
2008-06-19 17:30:00	AAPL	Stock	6.4693	6.4696	6.4682	6.4682	54068.0
2008-06-19 18:00:00	AAPL	Stock	6.47	6.4707	6.4668	6.4707	325304.0
2008-06-19 18:30:00	AAPL	Stock	6.4679	6.4696	6.4679	6.4696	57960.0
2008-06-19 19:00:00	AAPL	Stock	6.4696	6.4696	6.4657	6.4675	104664.0
2008-06-19 19:30:00	AAPL	Stock	6.4675	6.4675	6.4639	6.4639	277284.0
2008-06-19 08:00:00	MSFT	Stock	28.6	28.64	28.6	28.64	2500.0
2008-06-19 08:30:00	MSFT	Stock	28.46	28.58	28.46	28.55	27377.0
2008-06-19 09:00:00	MSFT	Stock	28.54	28.56	28.5	28.51	49834.0
2008-06-19 09:30:00	MSFT	Stock	28.52	28.76	28.5	28.57	3806909.0
2008-06-19 10:00:00	MSFT	Stock	28.56	28.59	28.33	28.5	6372730.0
2008-06-19 10:30:00	MSFT	Stock	28.51	28.62	28.46	28.51	4200997.0
2008-06-19 11:00:00	MSFT	Stock	28.51	28.69	28.47	28.61	3431791.0
2008-06-19 11:30:00	MSFT	Stock	28.61	28.755	28.565	28.74	3236617.0
2008-06-19 12:00:00	MSFT	Stock	28.74	28.97	28.72	28.93	5790524.0
2008-06-19 12:30:00	MSFT	Stock	28.93	28.97	28.84	28.912	3159824.0
2008-06-19 13:00:00	MSFT	Stock	28.91	28.99	28.85	28.95	3419516.0
2008-06-19 13:30:00	MSFT	Stock	28.94	29.0	28.83	28.92	2784662.0
2008-06-19 14:00:00	MSFT	Stock	28.91	29.05	28.86	28.987	3309996.0
2008-06-19 14:30:00	MSFT	Stock	28.98	29.19	28.98	29.115	5742232.0
2008-06-19 15:00:00	MSFT	Stock	29.11	29.18	28.96	28.98	5248234.0
2008-06-19 15:30:00	MSFT	Stock	28.99	29.05	28.85	28.95	7704510.0
2008-06-19 16:00:00	MSFT	Stock	28.95	29.085	28.532	28.93	2118845.0
2008-06-19 16:30:00	MSFT	Stock	28.95	28.95	28.7	28.95	39881.0
2008-06-19 17:00:00	MSFT	Stock	28.99	29.01	28.803	29.0	38861.0
2008-06-19 18:30:00	MSFT	Stock	28.94	28.94	28.94	28.94	153.0
2008-06-19 19:00:00	MSFT	Stock	28.97	28.97	28.97	28.97	200.0
2008-06-19 19:30:00	MSFT	Stock	28.96	28.96	28.95	28.95	9650.0

> showing 50 of 68,685 rows — these rows as CSV

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