PREVIEW / stock_30min / 2007-12-06

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-06.parquet
  size:    1.2 MB
  rows:    69,314
  symbols: 3,230

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-12-06 04:00:00	AAPL	Stock	6.6696	6.6696	6.6696	6.6696	11200.0
2007-12-06 04:30:00	AAPL	Stock	6.65	6.6664	6.65	6.6661	63308.0
2007-12-06 06:00:00	AAPL	Stock	6.6696	6.6932	6.6696	6.6857	116704.0
2007-12-06 06:30:00	AAPL	Stock	6.6857	6.6875	6.6786	6.6875	61432.0
2007-12-06 07:00:00	AAPL	Stock	6.6939	6.7036	6.6786	6.7036	1168860.0
2007-12-06 07:30:00	AAPL	Stock	6.7125	6.7268	6.6714	6.6804	1520484.0
2007-12-06 08:00:00	AAPL	Stock	6.6957	6.7029	6.6786	6.6821	4207588.0
2007-12-06 08:30:00	AAPL	Stock	6.6821	6.685	6.625	6.6454	5027288.0
2007-12-06 09:00:00	AAPL	Stock	6.6464	6.6607	6.6329	6.65	2966432.0
2007-12-06 09:30:00	AAPL	Stock	6.6518	6.7464	6.6471	6.7229	143824940.0
2007-12-06 10:00:00	AAPL	Stock	6.7225	6.7607	6.72	6.7346	84182616.0
2007-12-06 10:30:00	AAPL	Stock	6.7339	6.7393	6.6964	6.7286	64165276.0
2007-12-06 11:00:00	AAPL	Stock	6.7289	6.7375	6.6964	6.725	43475936.0
2007-12-06 11:30:00	AAPL	Stock	6.725	6.7304	6.705	6.7207	43635172.0
2007-12-06 12:00:00	AAPL	Stock	6.7204	6.7232	6.6904	6.7071	39238136.0
2007-12-06 12:30:00	AAPL	Stock	6.7057	6.7671	6.6961	6.7632	85047256.0
2007-12-06 13:00:00	AAPL	Stock	6.7639	6.7679	6.7357	6.7471	39499012.0
2007-12-06 13:30:00	AAPL	Stock	6.7475	6.7768	6.7357	6.7429	57755096.0
2007-12-06 14:00:00	AAPL	Stock	6.7436	6.77	6.7418	6.7607	41790532.0
2007-12-06 14:30:00	AAPL	Stock	6.7607	6.7754	6.7536	6.7561	52714396.0
2007-12-06 15:00:00	AAPL	Stock	6.7561	6.7714	6.7471	6.7711	61238380.0
2007-12-06 15:30:00	AAPL	Stock	6.7711	6.7857	6.7475	6.7839	111811952.0
2007-12-06 16:00:00	AAPL	Stock	6.7843	6.7868	6.7402	6.7714	14798364.0
2007-12-06 16:30:00	AAPL	Stock	6.7711	6.784	6.7402	6.775	666316.0
2007-12-06 17:00:00	AAPL	Stock	6.7768	6.7821	6.7704	6.7804	691544.0
2007-12-06 17:30:00	AAPL	Stock	6.7786	6.7836	6.7216	6.7829	325360.0
2007-12-06 18:00:00	AAPL	Stock	6.7829	6.7839	6.7793	6.7793	140672.0
2007-12-06 18:30:00	AAPL	Stock	6.7804	6.7832	6.7786	6.7814	132188.0
2007-12-06 19:00:00	AAPL	Stock	6.7814	6.7839	6.7786	6.7789	194180.0
2007-12-06 19:30:00	AAPL	Stock	6.7786	6.7839	6.7786	6.7825	197680.0
2007-12-06 07:00:00	MSFT	Stock	34.35	34.5	34.35	34.5	2600.0
2007-12-06 07:30:00	MSFT	Stock	34.4	34.4	34.2	34.2	3710.0
2007-12-06 08:00:00	MSFT	Stock	34.38	34.41	34.15	34.29	150658.0
2007-12-06 08:30:00	MSFT	Stock	34.34	34.35	34.19	34.19	22908.0
2007-12-06 09:00:00	MSFT	Stock	34.16	34.27	34.05	34.26	44041.0
2007-12-06 09:30:00	MSFT	Stock	34.22	34.39	34.07	34.08	4701255.0
2007-12-06 10:00:00	MSFT	Stock	34.105	34.21	34.02	34.129	3109257.0
2007-12-06 10:30:00	MSFT	Stock	34.122	34.14	33.9	33.93	3701286.0
2007-12-06 11:00:00	MSFT	Stock	33.92	34.38	33.87	34.35	5711969.0
2007-12-06 11:30:00	MSFT	Stock	34.34	34.47	34.26	34.33	3953322.0
2007-12-06 12:00:00	MSFT	Stock	34.328	34.36	34.23	34.262	2095077.0
2007-12-06 12:30:00	MSFT	Stock	34.26	34.27	34.19	34.24	2008779.0
2007-12-06 13:00:00	MSFT	Stock	34.24	34.31	34.21	34.28	1848972.0
2007-12-06 13:30:00	MSFT	Stock	34.28	34.33	34.19	34.22	2463047.0
2007-12-06 14:00:00	MSFT	Stock	34.212	34.3	34.19	34.29	2611718.0
2007-12-06 14:30:00	MSFT	Stock	34.3	34.6	34.29	34.53	4397587.0
2007-12-06 15:00:00	MSFT	Stock	34.54	34.61	34.4	34.44	3846683.0
2007-12-06 15:30:00	MSFT	Stock	34.43	34.6	34.4	34.55	5739171.0
2007-12-06 16:00:00	MSFT	Stock	34.55	34.55	34.294	34.55	2779404.0
2007-12-06 16:30:00	MSFT	Stock	34.304	34.55	34.304	34.55	12174.0

> showing 50 of 69,314 rows — these rows as CSV

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