PREVIEW / stock_30min / 2007-11-09

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-09.parquet
  size:    1.2 MB
  rows:    68,919
  symbols: 3,183

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-11-09 04:00:00	AAPL	Stock	6.4371	6.4482	6.4107	6.4107	114044.0
2007-11-09 04:30:00	AAPL	Stock	6.4032	6.4114	6.3996	6.4114	146356.0
2007-11-09 05:00:00	AAPL	Stock	6.4079	6.4079	6.3607	6.3607	81200.0
2007-11-09 05:30:00	AAPL	Stock	6.3696	6.3696	6.3293	6.3304	86800.0
2007-11-09 06:00:00	AAPL	Stock	6.3393	6.3486	6.3243	6.3486	109564.0
2007-11-09 06:30:00	AAPL	Stock	6.3532	6.3532	6.3039	6.3039	103600.0
2007-11-09 07:00:00	AAPL	Stock	6.3125	6.3161	6.2575	6.2821	402976.0
2007-11-09 07:30:00	AAPL	Stock	6.2857	6.2857	6.2393	6.2607	644280.0
2007-11-09 08:00:00	AAPL	Stock	6.2536	6.26	6.1607	6.1854	5914300.0
2007-11-09 08:30:00	AAPL	Stock	6.1832	6.1857	6.0893	6.1571	6058416.0
2007-11-09 09:00:00	AAPL	Stock	6.1571	6.1571	6.0896	6.1125	6721540.0
2007-11-09 09:30:00	AAPL	Stock	6.1121	6.2543	6.0357	6.1975	225856652.0
2007-11-09 10:00:00	AAPL	Stock	6.1968	6.2286	6.1625	6.1786	116846688.0
2007-11-09 10:30:00	AAPL	Stock	6.185	6.1964	6.0714	6.1006	114359224.0
2007-11-09 11:00:00	AAPL	Stock	6.1014	6.1096	6.0057	6.0832	133943152.0
2007-11-09 11:30:00	AAPL	Stock	6.0818	6.1521	6.0764	6.1365	95003384.0
2007-11-09 12:00:00	AAPL	Stock	6.1375	6.1379	6.0446	6.0856	73598056.0
2007-11-09 12:30:00	AAPL	Stock	6.0864	6.16	6.0804	6.09	79466604.0
2007-11-09 13:00:00	AAPL	Stock	6.09	6.1357	6.0554	6.1061	59238116.0
2007-11-09 13:30:00	AAPL	Stock	6.1057	6.1125	6.0471	6.0471	75761000.0
2007-11-09 14:00:00	AAPL	Stock	6.0468	6.1696	6.0318	6.1407	115499608.0
2007-11-09 14:30:00	AAPL	Stock	6.1407	6.1629	6.0961	6.1107	78959244.0
2007-11-09 15:00:00	AAPL	Stock	6.1104	6.1593	6.1046	6.1393	92964536.0
2007-11-09 15:30:00	AAPL	Stock	6.1393	6.1421	5.9004	5.9057	215530532.0
2007-11-09 16:00:00	AAPL	Stock	5.9046	6.1039	5.8554	5.9071	23943752.0
2007-11-09 16:30:00	AAPL	Stock	5.9096	6.1022	5.8929	5.9046	1856064.0
2007-11-09 17:00:00	AAPL	Stock	5.9054	6.1039	5.8929	5.9018	2054080.0
2007-11-09 17:30:00	AAPL	Stock	5.9029	5.9029	5.8929	5.8996	650328.0
2007-11-09 18:00:00	AAPL	Stock	5.8964	5.8996	5.8757	5.8921	684348.0
2007-11-09 18:30:00	AAPL	Stock	5.8911	6.0421	5.8679	5.875	275772.0
2007-11-09 19:00:00	AAPL	Stock	5.8786	5.8921	5.875	5.8921	171612.0
2007-11-09 19:30:00	AAPL	Stock	5.8857	5.8893	5.8786	5.8793	402528.0
2007-11-09 07:30:00	MSFT	Stock	34.5	34.5	34.5	34.5	500.0
2007-11-09 08:00:00	MSFT	Stock	34.5	34.74	34.05	34.15	168845.0
2007-11-09 08:30:00	MSFT	Stock	34.2	34.74	34.15	34.35	49216.0
2007-11-09 09:00:00	MSFT	Stock	34.38	34.45	34.12	34.19	150163.0
2007-11-09 09:30:00	MSFT	Stock	34.21	34.54	33.65	33.96	16946847.0
2007-11-09 10:00:00	MSFT	Stock	33.96	34.28	33.92	34.05	10470513.0
2007-11-09 10:30:00	MSFT	Stock	34.05	34.08	33.83	33.85	8671050.0
2007-11-09 11:00:00	MSFT	Stock	33.85	34.04	33.74	33.87	9026153.0
2007-11-09 11:30:00	MSFT	Stock	33.87	33.9	33.74	33.77	10268280.0
2007-11-09 12:00:00	MSFT	Stock	33.78	33.8	33.71	33.73	6043805.0
2007-11-09 12:30:00	MSFT	Stock	33.74	34.02	33.66	33.722	9941508.0
2007-11-09 13:00:00	MSFT	Stock	33.72	33.77	33.65	33.75	7003860.0
2007-11-09 13:30:00	MSFT	Stock	33.741	33.76	33.68	33.69	5738035.0
2007-11-09 14:00:00	MSFT	Stock	33.68	34.12	33.67	34.02	8264584.0
2007-11-09 14:30:00	MSFT	Stock	34.029	34.1	33.88	33.98	5027845.0
2007-11-09 15:00:00	MSFT	Stock	33.98	34.36	33.97	34.19	7481117.0
2007-11-09 15:30:00	MSFT	Stock	34.18	34.41	33.66	33.67	16477025.0
2007-11-09 16:00:00	MSFT	Stock	33.73	33.955	33.57	33.75	3251967.0

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

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