PREVIEW / stock_30min / 2008-01-03

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-03.parquet
  size:    1.2 MB
  rows:    71,168
  symbols: 3,237

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-01-03 06:00:00	AAPL	Stock	6.9796	6.9807	6.9796	6.9807	11200.0
2008-01-03 06:30:00	AAPL	Stock	6.9557	6.9557	6.9357	6.9389	14000.0
2008-01-03 07:00:00	AAPL	Stock	6.9389	6.9821	6.9389	6.9821	30800.0
2008-01-03 07:30:00	AAPL	Stock	6.9643	6.9696	6.9414	6.9429	173180.0
2008-01-03 08:00:00	AAPL	Stock	6.9482	6.9668	6.9068	6.95	2639532.0
2008-01-03 08:30:00	AAPL	Stock	6.9611	6.9961	6.95	6.9882	3255224.0
2008-01-03 09:00:00	AAPL	Stock	6.985	6.9929	6.9568	6.9796	1900836.0
2008-01-03 09:30:00	AAPL	Stock	6.9804	7.0075	6.9286	6.9482	121054136.0
2008-01-03 10:00:00	AAPL	Stock	6.9475	7.0393	6.9471	6.9846	113436708.0
2008-01-03 10:30:00	AAPL	Stock	6.9843	6.99	6.9414	6.9593	85363796.0
2008-01-03 11:00:00	AAPL	Stock	6.96	6.9957	6.9561	6.9761	47353740.0
2008-01-03 11:30:00	AAPL	Stock	6.9746	7.0036	6.955	6.9882	49479444.0
2008-01-03 12:00:00	AAPL	Stock	6.9886	7.0321	6.975	7.0318	53206160.0
2008-01-03 12:30:00	AAPL	Stock	7.0316	7.0496	7.0054	7.0124	58731764.0
2008-01-03 13:00:00	AAPL	Stock	7.0111	7.0261	7.0	7.0196	29552572.0
2008-01-03 13:30:00	AAPL	Stock	7.0196	7.0254	6.9786	6.9925	29948828.0
2008-01-03 14:00:00	AAPL	Stock	6.9943	6.9961	6.9593	6.9804	39556300.0
2008-01-03 14:30:00	AAPL	Stock	6.9811	6.9964	6.9711	6.9825	29519504.0
2008-01-03 15:00:00	AAPL	Stock	6.9829	6.9843	6.9129	6.9229	62152664.0
2008-01-03 15:30:00	AAPL	Stock	6.9225	6.9639	6.8818	6.9589	99314852.0
2008-01-03 16:00:00	AAPL	Stock	6.9604	7.0146	6.96	6.97	13506332.0
2008-01-03 16:30:00	AAPL	Stock	6.9618	6.9714	6.9618	6.9696	797860.0
2008-01-03 17:00:00	AAPL	Stock	6.97	6.9879	6.9632	6.9696	1657348.0
2008-01-03 17:30:00	AAPL	Stock	6.9682	6.9782	6.9618	6.9654	100940.0
2008-01-03 18:00:00	AAPL	Stock	6.9664	6.9714	6.9657	6.9714	35000.0
2008-01-03 18:30:00	AAPL	Stock	6.9714	6.9714	6.9661	6.9664	33600.0
2008-01-03 19:00:00	AAPL	Stock	6.9693	6.9714	6.9679	6.9714	196560.0
2008-01-03 19:30:00	AAPL	Stock	6.9732	6.9732	6.9643	6.9643	336560.0
2008-01-03 08:00:00	MSFT	Stock	35.17	35.22	35.16	35.22	18950.0
2008-01-03 08:30:00	MSFT	Stock	35.25	35.29	35.2	35.22	15046.0
2008-01-03 09:00:00	MSFT	Stock	35.2	35.27	35.2	35.25	234050.0
2008-01-03 09:30:00	MSFT	Stock	35.24	35.27	34.86	34.95	6019359.0
2008-01-03 10:00:00	MSFT	Stock	34.94	35.31	34.94	35.3	5726430.0
2008-01-03 10:30:00	MSFT	Stock	35.29	35.42	35.18	35.28	5203602.0
2008-01-03 11:00:00	MSFT	Stock	35.28	35.62	35.27	35.545	3658143.0
2008-01-03 11:30:00	MSFT	Stock	35.54	35.64	35.46	35.53	2621029.0
2008-01-03 12:00:00	MSFT	Stock	35.532	35.61	35.51	35.59	2393727.0
2008-01-03 12:30:00	MSFT	Stock	35.59	35.65	35.51	35.58	2323288.0
2008-01-03 13:00:00	MSFT	Stock	35.58	35.59	35.45	35.51	2807233.0
2008-01-03 13:30:00	MSFT	Stock	35.51	35.53	35.34	35.39	2083202.0
2008-01-03 14:00:00	MSFT	Stock	35.39	35.39	35.22	35.262	3304889.0
2008-01-03 14:30:00	MSFT	Stock	35.27	35.29	35.2	35.24	1983502.0
2008-01-03 15:00:00	MSFT	Stock	35.235	35.26	35.13	35.19	3518800.0
2008-01-03 15:30:00	MSFT	Stock	35.19	35.37	35.17	35.37	5548429.0
2008-01-03 16:00:00	MSFT	Stock	35.35	35.49	35.15	35.271	1615900.0
2008-01-03 16:30:00	MSFT	Stock	35.37	35.37	35.33	35.33	87154.0
2008-01-03 17:00:00	MSFT	Stock	35.496	35.496	35.33	35.37	435572.0
2008-01-03 17:30:00	MSFT	Stock	35.37	35.436	35.37	35.436	1258.0
2008-01-03 18:00:00	MSFT	Stock	35.37	35.37	35.37	35.37	100.0
2008-01-03 18:30:00	MSFT	Stock	35.4	35.4	35.4	35.4	300.0

> showing 50 of 71,168 rows — these rows as CSV

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