PREVIEW / stock_30min / 2008-03-12

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-12.parquet
  size:    1.2 MB
  rows:    68,367
  symbols: 3,268

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-03-12 05:30:00	AAPL	Stock	4.5593	4.5593	4.5593	4.5593	8400.0
2008-03-12 06:30:00	AAPL	Stock	4.5739	4.5775	4.5689	4.5689	22400.0
2008-03-12 07:00:00	AAPL	Stock	4.5593	4.5618	4.5593	4.5618	15680.0
2008-03-12 07:30:00	AAPL	Stock	4.5614	4.5625	4.54	4.5496	345828.0
2008-03-12 08:00:00	AAPL	Stock	4.5464	4.5482	4.5125	4.5286	2305744.0
2008-03-12 08:30:00	AAPL	Stock	4.5307	4.5318	4.5143	4.5218	780696.0
2008-03-12 09:00:00	AAPL	Stock	4.5214	4.5454	4.5214	4.5382	2446528.0
2008-03-12 09:30:00	AAPL	Stock	4.5379	4.5496	4.4879	4.4993	127161552.0
2008-03-12 10:00:00	AAPL	Stock	4.4982	4.5154	4.475	4.4993	85094100.0
2008-03-12 10:30:00	AAPL	Stock	4.4993	4.5782	4.4971	4.5625	135162076.0
2008-03-12 11:00:00	AAPL	Stock	4.5629	4.5957	4.5582	4.5611	101206028.0
2008-03-12 11:30:00	AAPL	Stock	4.5606	4.5682	4.5286	4.5482	66935176.0
2008-03-12 12:00:00	AAPL	Stock	4.5469	4.5654	4.535	4.5464	48044752.0
2008-03-12 12:30:00	AAPL	Stock	4.5471	4.5589	4.525	4.535	49520744.0
2008-03-12 13:00:00	AAPL	Stock	4.535	4.5407	4.5146	4.5332	54917352.0
2008-03-12 13:30:00	AAPL	Stock	4.5332	4.5371	4.5132	4.5254	43334760.0
2008-03-12 14:00:00	AAPL	Stock	4.5254	4.5461	4.5146	4.5364	61930400.0
2008-03-12 14:30:00	AAPL	Stock	4.5364	4.5696	4.5329	4.5571	59911544.0
2008-03-12 15:00:00	AAPL	Stock	4.5568	4.575	4.5421	4.5436	76729800.0
2008-03-12 15:30:00	AAPL	Stock	4.5436	4.5446	4.4704	4.5028	131527844.0
2008-03-12 16:00:00	AAPL	Stock	4.5011	4.5468	4.4936	4.4986	10765216.0
2008-03-12 16:30:00	AAPL	Stock	4.4975	4.5385	4.4929	4.5	999152.0
2008-03-12 17:00:00	AAPL	Stock	4.5	4.5	4.4957	4.4989	44464.0
2008-03-12 17:30:00	AAPL	Stock	4.4986	4.4989	4.4936	4.4936	43540.0
2008-03-12 18:00:00	AAPL	Stock	4.4961	4.4979	4.4929	4.4932	74032.0
2008-03-12 18:30:00	AAPL	Stock	4.4929	4.4929	4.4875	4.4893	34944.0
2008-03-12 19:00:00	AAPL	Stock	4.4829	4.4829	4.4768	4.4768	236796.0
2008-03-12 19:30:00	AAPL	Stock	4.4786	4.4889	4.4786	4.4889	163100.0
2008-03-12 07:30:00	MSFT	Stock	29.33	29.46	29.33	29.46	200.0
2008-03-12 08:00:00	MSFT	Stock	29.35	29.37	29.14	29.24	7980.0
2008-03-12 08:30:00	MSFT	Stock	29.24	29.25	29.19	29.23	21062.0
2008-03-12 09:00:00	MSFT	Stock	29.25	29.43	29.25	29.42	114529.0
2008-03-12 09:30:00	MSFT	Stock	29.43	29.49	29.13	29.17	7458928.0
2008-03-12 10:00:00	MSFT	Stock	29.16	29.19	28.93	29.1	6976437.0
2008-03-12 10:30:00	MSFT	Stock	29.1	29.45	29.09	29.27	5073291.0
2008-03-12 11:00:00	MSFT	Stock	29.26	29.45	29.24	29.24	7194690.0
2008-03-12 11:30:00	MSFT	Stock	29.23	29.26	29.06	29.15	4429071.0
2008-03-12 12:00:00	MSFT	Stock	29.15	29.25	29.1	29.212	3511320.0
2008-03-12 12:30:00	MSFT	Stock	29.21	29.33	29.18	29.202	3167568.0
2008-03-12 13:00:00	MSFT	Stock	29.2	29.28	29.19	29.25	2428465.0
2008-03-12 13:30:00	MSFT	Stock	29.25	29.26	29.1	29.11	2408248.0
2008-03-12 14:00:00	MSFT	Stock	29.11	29.13	28.93	28.97	5107194.0
2008-03-12 14:30:00	MSFT	Stock	28.96	29.12	28.94	29.041	3501402.0
2008-03-12 15:00:00	MSFT	Stock	29.04	29.04	28.7	28.7	7122941.0
2008-03-12 15:30:00	MSFT	Stock	28.7	28.76	28.54	28.6	12713040.0
2008-03-12 16:00:00	MSFT	Stock	28.6	29.3	28.6	28.64	2784560.0
2008-03-12 16:30:00	MSFT	Stock	28.64	29.104	28.63	28.63	1538734.0
2008-03-12 17:00:00	MSFT	Stock	29.063	29.063	28.62	28.75	320715.0
2008-03-12 17:30:00	MSFT	Stock	28.75	28.75	28.7	28.7	8020.0
2008-03-12 18:00:00	MSFT	Stock	28.7	29.05	28.68	28.73	104164.0

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

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