PREVIEW / stock_30min / 2008-06-18

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-18.parquet
  size:    1.3 MB
  rows:    69,359
  symbols: 3,303

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-18 06:00:00	AAPL	Stock	6.4779	6.4779	6.4779	6.4779	8400.0
2008-06-18 06:30:00	AAPL	Stock	6.4839	6.4989	6.4839	6.4989	23800.0
2008-06-18 07:00:00	AAPL	Stock	6.4821	6.4821	6.4757	6.4768	22400.0
2008-06-18 07:30:00	AAPL	Stock	6.4804	6.4907	6.4764	6.4771	141680.0
2008-06-18 08:00:00	AAPL	Stock	6.4682	6.4804	6.44	6.4529	1078252.0
2008-06-18 08:30:00	AAPL	Stock	6.4529	6.465	6.45	6.4554	1238272.0
2008-06-18 09:00:00	AAPL	Stock	6.4536	6.4946	6.4536	6.4664	2602572.0
2008-06-18 09:30:00	AAPL	Stock	6.4686	6.5071	6.4361	6.4646	107563092.0
2008-06-18 10:00:00	AAPL	Stock	6.4646	6.4907	6.4514	6.4671	65897104.0
2008-06-18 10:30:00	AAPL	Stock	6.4664	6.4664	6.3339	6.3661	117307932.0
2008-06-18 11:00:00	AAPL	Stock	6.3657	6.4064	6.3525	6.38	71712424.0
2008-06-18 11:30:00	AAPL	Stock	6.3807	6.4482	6.3775	6.4418	57889048.0
2008-06-18 12:00:00	AAPL	Stock	6.4421	6.4429	6.4132	6.4132	33880672.0
2008-06-18 12:30:00	AAPL	Stock	6.4129	6.4293	6.3975	6.4092	25461240.0
2008-06-18 13:00:00	AAPL	Stock	6.4089	6.4107	6.3525	6.3812	33655860.0
2008-06-18 13:30:00	AAPL	Stock	6.3811	6.4089	6.3636	6.3986	47380340.0
2008-06-18 14:00:00	AAPL	Stock	6.3982	6.4107	6.3746	6.3868	41937784.0
2008-06-18 14:30:00	AAPL	Stock	6.3875	6.4129	6.3768	6.3996	31725176.0
2008-06-18 15:00:00	AAPL	Stock	6.3996	6.4293	6.3864	6.4138	47514992.0
2008-06-18 15:30:00	AAPL	Stock	6.4129	6.4164	6.3661	6.3825	76847176.0
2008-06-18 16:00:00	AAPL	Stock	6.3868	6.4135	6.3661	6.3793	24758944.0
2008-06-18 16:30:00	AAPL	Stock	6.3793	6.3861	6.3679	6.3679	514724.0
2008-06-18 17:00:00	AAPL	Stock	6.3664	6.4046	6.3643	6.3839	202300.0
2008-06-18 17:30:00	AAPL	Stock	6.3729	6.3729	6.3643	6.3646	48356.0
2008-06-18 18:00:00	AAPL	Stock	6.4814	6.4814	6.3657	6.3739	185920.0
2008-06-18 18:30:00	AAPL	Stock	6.3729	6.3736	6.3679	6.3736	44184.0
2008-06-18 19:00:00	AAPL	Stock	6.3707	6.3746	6.3696	6.3746	66920.0
2008-06-18 19:30:00	AAPL	Stock	6.3714	6.3743	6.3664	6.3739	141456.0
2008-06-18 08:00:00	MSFT	Stock	28.64	28.7	28.6	28.66	4801.0
2008-06-18 08:30:00	MSFT	Stock	28.65	28.69	28.64	28.69	7085.0
2008-06-18 09:00:00	MSFT	Stock	28.7	28.7	28.54	28.54	86666.0
2008-06-18 09:30:00	MSFT	Stock	28.56	28.86	28.52	28.67	4748864.0
2008-06-18 10:00:00	MSFT	Stock	28.66	28.752	28.6	28.62	2572051.0
2008-06-18 10:30:00	MSFT	Stock	28.61	28.7	28.58	28.61	4199278.0
2008-06-18 11:00:00	MSFT	Stock	28.62	28.71	28.558	28.64	3189741.0
2008-06-18 11:30:00	MSFT	Stock	28.64	28.78	28.62	28.73	2606407.0
2008-06-18 12:00:00	MSFT	Stock	28.73	28.77	28.65	28.653	2171664.0
2008-06-18 12:30:00	MSFT	Stock	28.65	28.729	28.62	28.66	1759390.0
2008-06-18 13:00:00	MSFT	Stock	28.66	28.71	28.56	28.59	2263653.0
2008-06-18 13:30:00	MSFT	Stock	28.595	28.66	28.55	28.59	2165433.0
2008-06-18 14:00:00	MSFT	Stock	28.595	28.66	28.5	28.54	3780706.0
2008-06-18 14:30:00	MSFT	Stock	28.55	28.65	28.53	28.61	3120509.0
2008-06-18 15:00:00	MSFT	Stock	28.62	28.67	28.58	28.6	3882567.0
2008-06-18 15:30:00	MSFT	Stock	28.61	28.66	28.46	28.46	6105078.0
2008-06-18 16:00:00	MSFT	Stock	28.46	28.647	28.45	28.53	3982926.0
2008-06-18 16:30:00	MSFT	Stock	28.56	28.56	28.46	28.49	56666.0
2008-06-18 17:00:00	MSFT	Stock	28.49	28.55	28.46	28.46	11892.0
2008-06-18 17:30:00	MSFT	Stock	28.52	28.52	28.49	28.49	1200.0
2008-06-18 18:00:00	MSFT	Stock	28.49	28.49	28.49	28.49	500.0
2008-06-18 18:30:00	MSFT	Stock	28.49	28.49	28.49	28.49	300.0

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

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