PREVIEW / stock_30min / 2008-08-28

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-08-28.parquet
  size:    1.2 MB
  rows:    67,882
  symbols: 3,308

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-28 07:30:00	AAPL	Stock	6.2479	6.2479	6.2479	6.2479	2800.0
2008-08-28 08:00:00	AAPL	Stock	6.2007	6.2314	6.2007	6.2261	203504.0
2008-08-28 08:30:00	AAPL	Stock	6.23	6.2639	6.23	6.2618	2275756.0
2008-08-28 09:00:00	AAPL	Stock	6.2618	6.2618	6.2557	6.26	588672.0
2008-08-28 09:30:00	AAPL	Stock	6.26	6.2946	6.2436	6.2746	62466712.0
2008-08-28 10:00:00	AAPL	Stock	6.2746	6.2929	6.27	6.2857	35543088.0
2008-08-28 10:30:00	AAPL	Stock	6.285	6.2929	6.2721	6.2825	26980912.0
2008-08-28 11:00:00	AAPL	Stock	6.2825	6.2875	6.2614	6.2696	20916616.0
2008-08-28 11:30:00	AAPL	Stock	6.2696	6.285	6.2625	6.2743	20477128.0
2008-08-28 12:00:00	AAPL	Stock	6.2732	6.2757	6.2464	6.2629	26839036.0
2008-08-28 12:30:00	AAPL	Stock	6.2625	6.2625	6.2236	6.2486	27370616.0
2008-08-28 13:00:00	AAPL	Stock	6.2475	6.2589	6.235	6.2579	17690624.0
2008-08-28 13:30:00	AAPL	Stock	6.2571	6.2643	6.2268	6.2318	24715852.0
2008-08-28 14:00:00	AAPL	Stock	6.2309	6.2332	6.1761	6.2035	42277788.0
2008-08-28 14:30:00	AAPL	Stock	6.2046	6.2211	6.2	6.2046	20543068.0
2008-08-28 15:00:00	AAPL	Stock	6.2046	6.2121	6.1696	6.1961	35827596.0
2008-08-28 15:30:00	AAPL	Stock	6.1954	6.2207	6.1818	6.1996	45990840.0
2008-08-28 16:00:00	AAPL	Stock	6.2054	6.2516	6.1825	6.1825	9106384.0
2008-08-28 16:30:00	AAPL	Stock	6.205	6.2382	6.1782	6.1879	3029992.0
2008-08-28 17:00:00	AAPL	Stock	6.1889	6.1911	6.1857	6.1886	128296.0
2008-08-28 17:30:00	AAPL	Stock	6.1886	6.1893	6.1857	6.1889	100380.0
2008-08-28 18:00:00	AAPL	Stock	6.1875	6.1896	6.1857	6.1893	231420.0
2008-08-28 18:30:00	AAPL	Stock	6.1929	6.1929	6.1857	6.1861	70700.0
2008-08-28 19:00:00	AAPL	Stock	6.1946	6.1946	6.1889	6.1921	34160.0
2008-08-28 19:30:00	AAPL	Stock	6.1943	6.1943	6.1875	6.1929	120568.0
2008-08-28 08:00:00	MSFT	Stock	27.6	27.6	27.6	27.6	159.0
2008-08-28 08:30:00	MSFT	Stock	27.63	27.68	27.63	27.67	6249.0
2008-08-28 09:00:00	MSFT	Stock	27.68	27.71	27.6	27.6	11616.0
2008-08-28 09:30:00	MSFT	Stock	27.61	27.96	27.6	27.75	8199845.0
2008-08-28 10:00:00	MSFT	Stock	27.75	27.782	27.65	27.72	5185775.0
2008-08-28 10:30:00	MSFT	Stock	27.73	27.87	27.69	27.82	3708492.0
2008-08-28 11:00:00	MSFT	Stock	27.82	27.9	27.73	27.79	2680907.0
2008-08-28 11:30:00	MSFT	Stock	27.8	27.9	27.75	27.87	4259797.0
2008-08-28 12:00:00	MSFT	Stock	27.87	27.88	27.8	27.83	2882669.0
2008-08-28 12:30:00	MSFT	Stock	27.83	27.88	27.77	27.83	2097080.0
2008-08-28 13:00:00	MSFT	Stock	27.84	27.91	27.81	27.9	1936761.0
2008-08-28 13:30:00	MSFT	Stock	27.9	27.96	27.89	27.95	1878204.0
2008-08-28 14:00:00	MSFT	Stock	27.95	27.955	27.87	27.95	2493667.0
2008-08-28 14:30:00	MSFT	Stock	27.94	28.01	27.91	27.96	3791940.0
2008-08-28 15:00:00	MSFT	Stock	27.96	27.98	27.88	27.922	2133359.0
2008-08-28 15:30:00	MSFT	Stock	27.93	27.97	27.85	27.92	4017522.0
2008-08-28 16:00:00	MSFT	Stock	27.91	27.95	27.76	27.79	2222165.0
2008-08-28 16:30:00	MSFT	Stock	27.94	27.94	27.56	27.76	278525.0
2008-08-28 17:00:00	MSFT	Stock	27.8	27.8	27.76	27.76	9468.0
2008-08-28 17:30:00	MSFT	Stock	27.76	27.76	27.76	27.76	700.0
2008-08-28 18:00:00	MSFT	Stock	27.77	27.77	27.77	27.77	1550.0
2008-08-28 18:30:00	MSFT	Stock	27.77	27.77	27.77	27.77	500.0
2008-08-28 19:00:00	MSFT	Stock	27.77	27.77	27.76	27.76	4150.0
2008-08-28 19:30:00	MSFT	Stock	27.76	27.76	27.76	27.76	465.0
2008-08-28 20:00:00	MSFT	Stock	27.75	27.75	27.75	27.75	1530.0

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

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