PREVIEW / stock_30min / 2008-06-09

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-09.parquet
  size:    1.3 MB
  rows:    69,504
  symbols: 3,326

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-09 06:30:00	AAPL	Stock	6.6782	6.6786	6.6482	6.6482	110068.0
2008-06-09 07:00:00	AAPL	Stock	6.6432	6.6554	6.6339	6.6554	236320.0
2008-06-09 07:30:00	AAPL	Stock	6.6546	6.6546	6.6425	6.6425	448420.0
2008-06-09 08:00:00	AAPL	Stock	6.65	6.6904	6.6339	6.6425	6289192.0
2008-06-09 08:30:00	AAPL	Stock	6.6429	6.6511	6.5304	6.6011	9428020.0
2008-06-09 09:00:00	AAPL	Stock	6.6014	6.6071	6.5743	6.6018	4028808.0
2008-06-09 09:30:00	AAPL	Stock	6.6004	6.605	6.4289	6.4964	199610404.0
2008-06-09 10:00:00	AAPL	Stock	6.4954	6.5736	6.4782	6.5475	110799248.0
2008-06-09 10:30:00	AAPL	Stock	6.5461	6.5579	6.4868	6.4944	56285908.0
2008-06-09 11:00:00	AAPL	Stock	6.4932	6.5121	6.4664	6.5057	46971540.0
2008-06-09 11:30:00	AAPL	Stock	6.5052	6.5675	6.5018	6.5304	52535672.0
2008-06-09 12:00:00	AAPL	Stock	6.5293	6.5461	6.5011	6.5318	40594456.0
2008-06-09 12:30:00	AAPL	Stock	6.5304	6.5629	6.51	6.5568	37219532.0
2008-06-09 13:00:00	AAPL	Stock	6.5568	6.5643	6.4464	6.4625	110365948.0
2008-06-09 13:30:00	AAPL	Stock	6.4618	6.4907	6.2768	6.3704	207170544.0
2008-06-09 14:00:00	AAPL	Stock	6.3704	6.4618	6.3389	6.4475	182665000.0
2008-06-09 14:30:00	AAPL	Stock	6.4471	6.5821	6.3214	6.3711	374963848.0
2008-06-09 15:00:00	AAPL	Stock	6.3707	6.3959	6.3021	6.3725	189103992.0
2008-06-09 15:30:00	AAPL	Stock	6.3725	6.5018	6.3507	6.4886	197252188.0
2008-06-09 16:00:00	AAPL	Stock	6.4886	6.5054	6.4341	6.5	15149764.0
2008-06-09 16:30:00	AAPL	Stock	6.5	6.55	6.4861	6.5329	3519376.0
2008-06-09 17:00:00	AAPL	Stock	6.5304	6.5321	6.5068	6.5179	2896992.0
2008-06-09 17:30:00	AAPL	Stock	6.5179	6.5304	6.5096	6.5096	718732.0
2008-06-09 18:00:00	AAPL	Stock	6.5107	6.5179	6.5082	6.5096	154532.0
2008-06-09 18:30:00	AAPL	Stock	6.5096	6.5125	6.5	6.5089	375256.0
2008-06-09 19:00:00	AAPL	Stock	6.5104	6.5107	6.5004	6.5036	229068.0
2008-06-09 19:30:00	AAPL	Stock	6.5054	6.5093	6.5	6.5029	207480.0
2008-06-09 04:30:00	MSFT	Stock	27.73	27.73	27.63	27.63	300.0
2008-06-09 08:00:00	MSFT	Stock	27.54	27.7	27.54	27.68	11861.0
2008-06-09 08:30:00	MSFT	Stock	27.68	27.69	27.61	27.66	9375.0
2008-06-09 09:00:00	MSFT	Stock	27.68	27.71	27.58	27.62	28963.0
2008-06-09 09:30:00	MSFT	Stock	27.64	27.68	27.41	27.45	6835087.0
2008-06-09 10:00:00	MSFT	Stock	27.45	27.62	27.41	27.508	4903156.0
2008-06-09 10:30:00	MSFT	Stock	27.5	27.54	27.41	27.43	2746127.0
2008-06-09 11:00:00	MSFT	Stock	27.43	27.53	27.42	27.512	2107355.0
2008-06-09 11:30:00	MSFT	Stock	27.52	27.53	27.4	27.4	1874743.0
2008-06-09 12:00:00	MSFT	Stock	27.41	27.45	27.33	27.431	1618057.0
2008-06-09 12:30:00	MSFT	Stock	27.44	27.54	27.43	27.5	2145007.0
2008-06-09 13:00:00	MSFT	Stock	27.51	27.51	27.32	27.36	4078994.0
2008-06-09 13:30:00	MSFT	Stock	27.37	27.49	27.35	27.428	4774891.0
2008-06-09 14:00:00	MSFT	Stock	27.43	27.5	27.3	27.46	5506754.0
2008-06-09 14:30:00	MSFT	Stock	27.46	27.63	27.44	27.508	5595935.0
2008-06-09 15:00:00	MSFT	Stock	27.51	27.61	27.34	27.57	6711192.0
2008-06-09 15:30:00	MSFT	Stock	27.58	27.91	27.58	27.75	11560594.0
2008-06-09 16:00:00	MSFT	Stock	27.73	27.8	27.45	27.76	4559806.0
2008-06-09 16:30:00	MSFT	Stock	27.75	27.78	27.71	27.76	20754.0
2008-06-09 17:00:00	MSFT	Stock	27.76	27.76	27.74	27.74	2200.0
2008-06-09 17:30:00	MSFT	Stock	27.74	27.74	27.72	27.72	4894.0
2008-06-09 18:00:00	MSFT	Stock	27.72	27.74	27.71	27.71	855.0
2008-06-09 18:30:00	MSFT	Stock	27.71	27.73	27.71	27.73	532.0

> showing 50 of 69,504 rows — these rows as CSV

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