PREVIEW / stock_30min / 2007-10-22

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-22.parquet
  size:    1.2 MB
  rows:    68,810
  symbols: 3,157

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
2007-10-22 04:00:00	AAPL	Stock	6.0729	6.0729	6.0379	6.0379	5600.0
2007-10-22 04:30:00	AAPL	Stock	6.0536	6.0571	6.0446	6.0446	81200.0
2007-10-22 05:00:00	AAPL	Stock	6.0714	6.0714	6.0625	6.0625	57400.0
2007-10-22 05:30:00	AAPL	Stock	6.0589	6.0589	6.0589	6.0589	26600.0
2007-10-22 06:00:00	AAPL	Stock	6.0586	6.0586	6.0586	6.0586	13356.0
2007-10-22 06:30:00	AAPL	Stock	6.0589	6.0589	6.05	6.05	61600.0
2007-10-22 07:00:00	AAPL	Stock	6.0446	6.0446	6.0321	6.0336	227668.0
2007-10-22 07:30:00	AAPL	Stock	6.0336	6.0429	6.0214	6.0357	183680.0
2007-10-22 08:00:00	AAPL	Stock	6.0411	6.1375	6.0357	6.1321	7742420.0
2007-10-22 08:30:00	AAPL	Stock	6.1336	6.1411	6.0996	6.1082	5246528.0
2007-10-22 09:00:00	AAPL	Stock	6.1096	6.1136	6.0764	6.08	3696392.0
2007-10-22 09:30:00	AAPL	Stock	6.0804	6.1996	6.0704	6.1854	183187984.0
2007-10-22 10:00:00	AAPL	Stock	6.185	6.2464	6.1725	6.2275	131343548.0
2007-10-22 10:30:00	AAPL	Stock	6.2282	6.2304	6.1621	6.1771	101154620.0
2007-10-22 11:00:00	AAPL	Stock	6.1786	6.1921	6.1482	6.1882	94977092.0
2007-10-22 11:30:00	AAPL	Stock	6.1875	6.2143	6.1575	6.1875	60393732.0
2007-10-22 12:00:00	AAPL	Stock	6.1874	6.1968	6.1725	6.1954	46575620.0
2007-10-22 12:30:00	AAPL	Stock	6.1952	6.2143	6.1796	6.2007	56380604.0
2007-10-22 13:00:00	AAPL	Stock	6.2007	6.2129	6.1839	6.1904	60334680.0
2007-10-22 13:30:00	AAPL	Stock	6.19	6.1982	6.1757	6.1821	58965312.0
2007-10-22 14:00:00	AAPL	Stock	6.1821	6.2125	6.1818	6.1932	63535164.0
2007-10-22 14:30:00	AAPL	Stock	6.1943	6.2054	6.1875	6.195	61337080.0
2007-10-22 15:00:00	AAPL	Stock	6.1946	6.1982	6.1721	6.1761	94528532.0
2007-10-22 15:30:00	AAPL	Stock	6.1761	6.2411	6.1714	6.2289	182516824.0
2007-10-22 16:00:00	AAPL	Stock	6.2271	6.3464	6.1648	6.3464	22779232.0
2007-10-22 16:30:00	AAPL	Stock	6.3479	6.6064	6.2164	6.5821	255450860.0
2007-10-22 17:00:00	AAPL	Stock	6.5825	6.7089	6.1954	6.7068	84627424.0
2007-10-22 17:30:00	AAPL	Stock	6.7068	6.7143	6.1971	6.6804	45661980.0
2007-10-22 18:00:00	AAPL	Stock	6.6818	6.6968	6.1839	6.6725	14883400.0
2007-10-22 18:30:00	AAPL	Stock	6.6732	6.6746	6.635	6.6632	9157652.0
2007-10-22 19:00:00	AAPL	Stock	6.6643	6.6643	6.6364	6.6393	3489780.0
2007-10-22 19:30:00	AAPL	Stock	6.6375	6.6554	6.6375	6.6554	3193988.0
2007-10-22 04:00:00	MSFT	Stock	30.1	30.1	30.1	30.1	800.0
2007-10-22 07:00:00	MSFT	Stock	30.06	30.06	29.96	30.04	900.0
2007-10-22 07:30:00	MSFT	Stock	30.0	30.0	30.0	30.0	1000.0
2007-10-22 08:00:00	MSFT	Stock	29.91	30.14	29.91	30.13	23469.0
2007-10-22 08:30:00	MSFT	Stock	30.08	30.23	29.96	30.23	45038.0
2007-10-22 09:00:00	MSFT	Stock	30.23	30.23	30.05	30.17	508575.0
2007-10-22 09:30:00	MSFT	Stock	30.15	30.65	30.12	30.57	7648848.0
2007-10-22 10:00:00	MSFT	Stock	30.56	30.64	30.46	30.61	5601024.0
2007-10-22 10:30:00	MSFT	Stock	30.61	30.63	30.42	30.57	3095239.0
2007-10-22 11:00:00	MSFT	Stock	30.57	30.57	30.4	30.498	2876810.0
2007-10-22 11:30:00	MSFT	Stock	30.498	30.6	30.4	30.59	3336785.0
2007-10-22 12:00:00	MSFT	Stock	30.595	30.65	30.51	30.62	3091530.0
2007-10-22 12:30:00	MSFT	Stock	30.63	30.67	30.53	30.668	2615590.0
2007-10-22 13:00:00	MSFT	Stock	30.66	30.7	30.63	30.645	3120792.0
2007-10-22 13:30:00	MSFT	Stock	30.643	30.66	30.532	30.56	2232283.0
2007-10-22 14:00:00	MSFT	Stock	30.56	30.6	30.51	30.53	3360395.0
2007-10-22 14:30:00	MSFT	Stock	30.52	30.55	30.41	30.42	3022003.0
2007-10-22 15:00:00	MSFT	Stock	30.41	30.47	30.35	30.4	4614389.0

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

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