PREVIEW / stock_30min / 2008-08-29

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-08-29.parquet
  size:    1.2 MB
  rows:    67,803
  symbols: 3,316

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-08-29 07:30:00	AAPL	Stock	6.1786	6.1786	6.1786	6.1786	2800.0
2008-08-29 08:00:00	AAPL	Stock	6.1839	6.1954	6.1786	6.1946	277620.0
2008-08-29 08:30:00	AAPL	Stock	6.1882	6.205	6.1689	6.1707	1213352.0
2008-08-29 09:00:00	AAPL	Stock	6.1704	6.1829	6.17	6.1782	560700.0
2008-08-29 09:30:00	AAPL	Stock	6.1782	6.1964	6.1432	6.1711	73255728.0
2008-08-29 10:00:00	AAPL	Stock	6.17	6.1796	6.1393	6.1464	49790216.0
2008-08-29 10:30:00	AAPL	Stock	6.1471	6.1607	6.0786	6.0843	71145312.0
2008-08-29 11:00:00	AAPL	Stock	6.0843	6.1107	6.0804	6.0864	38364368.0
2008-08-29 11:30:00	AAPL	Stock	6.0871	6.0954	6.0746	6.0789	27716108.0
2008-08-29 12:00:00	AAPL	Stock	6.08	6.0814	6.0393	6.0404	45878896.0
2008-08-29 12:30:00	AAPL	Stock	6.0407	6.0811	6.0371	6.0804	28718564.0
2008-08-29 13:00:00	AAPL	Stock	6.0807	6.1061	6.0739	6.08	37637768.0
2008-08-29 13:30:00	AAPL	Stock	6.0796	6.0829	6.0536	6.0586	29856736.0
2008-08-29 14:00:00	AAPL	Stock	6.0586	6.0846	6.0575	6.0825	23270520.0
2008-08-29 14:30:00	AAPL	Stock	6.0825	6.0836	6.0614	6.0764	16571268.0
2008-08-29 15:00:00	AAPL	Stock	6.0764	6.0768	6.0425	6.0479	30139732.0
2008-08-29 15:30:00	AAPL	Stock	6.0486	6.0764	6.0471	6.058	51670108.0
2008-08-29 16:00:00	AAPL	Stock	6.0536	6.0962	6.0446	6.0518	22480444.0
2008-08-29 16:30:00	AAPL	Stock	6.0518	6.0966	6.0479	6.05	4044208.0
2008-08-29 17:00:00	AAPL	Stock	6.0518	6.0546	6.05	6.0518	1782004.0
2008-08-29 17:30:00	AAPL	Stock	6.0546	6.0546	6.0482	6.0482	129136.0
2008-08-29 18:00:00	AAPL	Stock	6.0518	6.0518	6.05	6.0518	29904.0
2008-08-29 18:30:00	AAPL	Stock	6.0518	6.0518	6.05	6.05	9660.0
2008-08-29 19:00:00	AAPL	Stock	6.0532	6.0532	6.0532	6.0532	2800.0
2008-08-29 19:30:00	AAPL	Stock	6.0532	6.0554	6.0518	6.0518	23044.0
2008-08-29 07:00:00	MSFT	Stock	27.5	27.5	27.5	27.5	1803.0
2008-08-29 07:30:00	MSFT	Stock	27.67	27.67	27.6	27.6	1000.0
2008-08-29 08:00:00	MSFT	Stock	27.69	27.7	27.6	27.7	4897.0
2008-08-29 08:30:00	MSFT	Stock	27.7	27.7	27.6	27.61	850.0
2008-08-29 09:00:00	MSFT	Stock	27.61	27.79	27.6	27.72	8198.0
2008-08-29 09:30:00	MSFT	Stock	27.74	27.78	27.6	27.67	4863642.0
2008-08-29 10:00:00	MSFT	Stock	27.67	27.7	27.51	27.61	3480771.0
2008-08-29 10:30:00	MSFT	Stock	27.62	27.66	27.45	27.47	4281460.0
2008-08-29 11:00:00	MSFT	Stock	27.48	27.54	27.41	27.47	3394335.0
2008-08-29 11:30:00	MSFT	Stock	27.47	27.502	27.41	27.428	2342166.0
2008-08-29 12:00:00	MSFT	Stock	27.43	27.442	27.32	27.38	2654990.0
2008-08-29 12:30:00	MSFT	Stock	27.38	27.45	27.31	27.43	1900624.0
2008-08-29 13:00:00	MSFT	Stock	27.42	27.56	27.42	27.5	1682876.0
2008-08-29 13:30:00	MSFT	Stock	27.5	27.55	27.45	27.53	1547010.0
2008-08-29 14:00:00	MSFT	Stock	27.535	27.6	27.48	27.56	2540781.0
2008-08-29 14:30:00	MSFT	Stock	27.56	27.62	27.49	27.56	2266715.0
2008-08-29 15:00:00	MSFT	Stock	27.56	27.57	27.47	27.5	2751118.0
2008-08-29 15:30:00	MSFT	Stock	27.49	27.58	27.32	27.32	6978866.0
2008-08-29 16:00:00	MSFT	Stock	27.33	27.516	27.284	27.296	6678275.0
2008-08-29 16:30:00	MSFT	Stock	27.33	27.39	27.287	27.31	1108114.0
2008-08-29 17:00:00	MSFT	Stock	27.29	27.29	27.29	27.29	566153.0
2008-08-29 17:30:00	MSFT	Stock	27.29	27.34	27.29	27.33	12132.0
2008-08-29 18:00:00	MSFT	Stock	27.32	27.33	27.3	27.33	5050.0
2008-08-29 18:30:00	MSFT	Stock	27.33	27.33	27.28	27.29	8240.0
2008-08-29 19:00:00	MSFT	Stock	27.29	27.29	27.27	27.27	4700.0

> showing 50 of 67,803 rows — these rows as CSV

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