PREVIEW / stock_30min / 2007-02-05

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-02-05.parquet
  size:    968 KB
  rows:    52,370
  symbols: 2,494

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-02-05 07:00:00	AAPL	Stock	3.0154	3.0154	3.0154	3.0154	12600.0
2007-02-05 07:30:00	AAPL	Stock	3.0157	3.0157	3.0157	3.0157	2800.0
2007-02-05 08:00:00	AAPL	Stock	3.015	3.0179	3.0054	3.0107	452452.0
2007-02-05 08:30:00	AAPL	Stock	3.0107	3.0261	3.0107	3.025	1233148.0
2007-02-05 09:00:00	AAPL	Stock	3.0218	3.025	3.0029	3.0107	2639784.0
2007-02-05 09:30:00	AAPL	Stock	3.0107	3.0382	3.0089	3.0161	92057336.0
2007-02-05 10:00:00	AAPL	Stock	3.0157	3.0236	3.0029	3.0157	65115764.0
2007-02-05 10:30:00	AAPL	Stock	3.0154	3.0179	3.0089	3.0125	34867560.0
2007-02-05 11:00:00	AAPL	Stock	3.0118	3.0321	3.0104	3.0289	55041056.0
2007-02-05 11:30:00	AAPL	Stock	3.0293	3.0439	3.0243	3.0339	62698972.0
2007-02-05 12:00:00	AAPL	Stock	3.0343	3.0411	3.0293	3.0346	28157920.0
2007-02-05 12:30:00	AAPL	Stock	3.0346	3.0354	3.0257	3.0332	21180012.0
2007-02-05 13:00:00	AAPL	Stock	3.0332	3.0375	3.0275	3.0296	24271800.0
2007-02-05 13:30:00	AAPL	Stock	3.03	3.0311	3.0214	3.0239	20844320.0
2007-02-05 14:00:00	AAPL	Stock	3.0239	3.0304	3.0146	3.0171	26073124.0
2007-02-05 14:30:00	AAPL	Stock	3.0171	3.0214	3.0114	3.0207	29845424.0
2007-02-05 15:00:00	AAPL	Stock	3.0196	3.0207	3.0032	3.0064	43213408.0
2007-02-05 15:30:00	AAPL	Stock	3.0064	3.0089	2.9979	2.9979	63210588.0
2007-02-05 16:00:00	AAPL	Stock	2.9989	3.0014	2.9911	2.9979	2219280.0
2007-02-05 16:30:00	AAPL	Stock	2.9979	3.0	2.9975	2.9979	440216.0
2007-02-05 17:00:00	AAPL	Stock	2.9979	2.9993	2.9979	2.9993	78400.0
2007-02-05 17:30:00	AAPL	Stock	2.9993	2.9993	2.9982	2.9982	192780.0
2007-02-05 18:00:00	AAPL	Stock	2.9982	2.9982	2.9946	2.9946	245196.0
2007-02-05 18:30:00	AAPL	Stock	2.9936	2.9993	2.9936	2.9993	216300.0
2007-02-05 19:00:00	AAPL	Stock	2.9954	2.9975	2.9943	2.9946	189980.0
2007-02-05 19:30:00	AAPL	Stock	2.9946	2.9971	2.9943	2.9964	298200.0
2007-02-05 07:00:00	MSFT	Stock	30.04	30.07	30.04	30.07	200.0
2007-02-05 07:30:00	MSFT	Stock	30.06	30.08	30.03	30.03	8100.0
2007-02-05 08:00:00	MSFT	Stock	30.05	30.08	30.01	30.01	48026.0
2007-02-05 08:30:00	MSFT	Stock	30.02	30.1	30.02	30.07	24484.0
2007-02-05 09:00:00	MSFT	Stock	30.08	30.08	29.96	29.97	112238.0
2007-02-05 09:30:00	MSFT	Stock	29.97	29.98	29.61	29.85	12771979.0
2007-02-05 10:00:00	MSFT	Stock	29.85	29.99	29.8	29.9	5687862.0
2007-02-05 10:30:00	MSFT	Stock	29.91	30.0	29.86	29.88	4110992.0
2007-02-05 11:00:00	MSFT	Stock	29.89	29.9	29.72	29.728	5453861.0
2007-02-05 11:30:00	MSFT	Stock	29.73	29.74	29.67	29.71	5016903.0
2007-02-05 12:00:00	MSFT	Stock	29.7	29.71	29.63	29.64	2575681.0
2007-02-05 12:30:00	MSFT	Stock	29.64	30.02	29.58	29.59	4215606.0
2007-02-05 13:00:00	MSFT	Stock	29.59	29.6	29.48	29.49	6905716.0
2007-02-05 13:30:00	MSFT	Stock	29.49	29.55	29.41	29.52	6399508.0
2007-02-05 14:00:00	MSFT	Stock	29.52	29.53	29.41	29.46	4351839.0
2007-02-05 14:30:00	MSFT	Stock	29.46	29.56	29.43	29.52	3814587.0
2007-02-05 15:00:00	MSFT	Stock	29.52	29.54	29.42	29.45	4067977.0
2007-02-05 15:30:00	MSFT	Stock	29.45	29.7	29.45	29.59	12195007.0
2007-02-05 16:00:00	MSFT	Stock	29.6	29.66	29.58	29.61	196547.0
2007-02-05 16:30:00	MSFT	Stock	29.61	29.61	29.59	29.6	17675.0
2007-02-05 17:00:00	MSFT	Stock	29.6	29.6	29.57	29.58	8050.0
2007-02-05 17:30:00	MSFT	Stock	29.6	29.6	29.57	29.58	1600.0
2007-02-05 18:00:00	MSFT	Stock	29.58	29.58	29.58	29.58	3750.0
2007-02-05 18:30:00	MSFT	Stock	29.57	29.57	29.57	29.57	1000.0

> showing 50 of 52,370 rows — these rows as CSV

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