PREVIEW / stock_30min / 2007-10-30

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-30.parquet
  size:    1.2 MB
  rows:    68,960
  symbols: 3,160

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-30 05:30:00	AAPL	Stock	6.6104	6.6104	6.595	6.595	22400.0
2007-10-30 07:00:00	AAPL	Stock	6.5775	6.5946	6.5725	6.575	117880.0
2007-10-30 07:30:00	AAPL	Stock	6.5754	6.5846	6.5579	6.5625	249200.0
2007-10-30 08:00:00	AAPL	Stock	6.5696	6.5879	6.5696	6.5857	875952.0
2007-10-30 08:30:00	AAPL	Stock	6.585	6.7036	6.5839	6.6486	20464416.0
2007-10-30 09:00:00	AAPL	Stock	6.6482	6.6696	6.6411	6.6496	5827836.0
2007-10-30 09:30:00	AAPL	Stock	6.6511	6.6607	6.6289	6.64	93543464.0
2007-10-30 10:00:00	AAPL	Stock	6.6396	6.6582	6.5975	6.6575	85623356.0
2007-10-30 10:30:00	AAPL	Stock	6.6575	6.7064	6.625	6.6982	106482236.0
2007-10-30 11:00:00	AAPL	Stock	6.6975	6.7107	6.6804	6.6804	67995564.0
2007-10-30 11:30:00	AAPL	Stock	6.6811	6.6893	6.6221	6.6721	63231812.0
2007-10-30 12:00:00	AAPL	Stock	6.6729	6.6861	6.6654	6.6714	32510688.0
2007-10-30 12:30:00	AAPL	Stock	6.6711	6.6886	6.6664	6.6839	36874348.0
2007-10-30 13:00:00	AAPL	Stock	6.685	6.7068	6.6843	6.705	41080228.0
2007-10-30 13:30:00	AAPL	Stock	6.7043	6.7543	6.7014	6.7354	99790768.0
2007-10-30 14:00:00	AAPL	Stock	6.7354	6.7632	6.725	6.7511	56748160.0
2007-10-30 14:30:00	AAPL	Stock	6.7511	6.7596	6.7046	6.7143	74824568.0
2007-10-30 15:00:00	AAPL	Stock	6.7146	6.7486	6.7089	6.7254	55761384.0
2007-10-30 15:30:00	AAPL	Stock	6.7257	6.7339	6.6786	6.6804	86813496.0
2007-10-30 16:00:00	AAPL	Stock	6.6804	6.709	6.6786	6.6889	7096712.0
2007-10-30 16:30:00	AAPL	Stock	6.6786	6.6868	6.675	6.675	1123640.0
2007-10-30 17:00:00	AAPL	Stock	6.675	6.6864	6.675	6.6857	396592.0
2007-10-30 17:30:00	AAPL	Stock	6.6804	6.6804	6.6611	6.6661	1027908.0
2007-10-30 18:00:00	AAPL	Stock	6.6739	6.6825	6.6721	6.675	291648.0
2007-10-30 18:30:00	AAPL	Stock	6.6786	6.7062	6.6786	6.6839	427924.0
2007-10-30 19:00:00	AAPL	Stock	6.6857	6.6868	6.6825	6.6857	72940.0
2007-10-30 19:30:00	AAPL	Stock	6.6825	6.6861	6.6821	6.6839	178220.0
2007-10-30 07:00:00	MSFT	Stock	34.51	34.53	34.51	34.53	2000.0
2007-10-30 08:00:00	MSFT	Stock	34.42	34.52	34.41	34.44	31779.0
2007-10-30 08:30:00	MSFT	Stock	34.57	34.57	34.42	34.42	15238.0
2007-10-30 09:00:00	MSFT	Stock	34.44	34.47	34.36	34.37	131907.0
2007-10-30 09:30:00	MSFT	Stock	34.36	34.75	34.35	34.69	9739469.0
2007-10-30 10:00:00	MSFT	Stock	34.68	34.78	34.5	34.7	9857038.0
2007-10-30 10:30:00	MSFT	Stock	34.695	34.89	34.68	34.87	5290371.0
2007-10-30 11:00:00	MSFT	Stock	34.86	34.96	34.75	34.931	6111727.0
2007-10-30 11:30:00	MSFT	Stock	34.93	34.99	34.9	34.92	5595401.0
2007-10-30 12:00:00	MSFT	Stock	34.92	35.05	34.92	35.03	5844814.0
2007-10-30 12:30:00	MSFT	Stock	35.03	35.1	34.99	35.09	4646775.0
2007-10-30 13:00:00	MSFT	Stock	35.09	35.37	35.09	35.37	7616576.0
2007-10-30 13:30:00	MSFT	Stock	35.35	35.38	35.25	35.28	5651341.0
2007-10-30 14:00:00	MSFT	Stock	35.28	35.42	35.27	35.378	5896298.0
2007-10-30 14:30:00	MSFT	Stock	35.38	35.46	35.37	35.39	9982322.0
2007-10-30 15:00:00	MSFT	Stock	35.39	35.51	35.38	35.48	8672257.0
2007-10-30 15:30:00	MSFT	Stock	35.47	35.59	35.39	35.58	17473517.0
2007-10-30 16:00:00	MSFT	Stock	35.58	35.6	34.215	35.57	4296516.0
2007-10-30 16:30:00	MSFT	Stock	35.57	35.57	35.45	35.57	412490.0
2007-10-30 17:00:00	MSFT	Stock	35.57	35.57	35.165	35.5	60211.0
2007-10-30 17:30:00	MSFT	Stock	34.39	35.54	34.39	35.53	3726.0
2007-10-30 18:00:00	MSFT	Stock	35.54	35.56	35.46	35.46	5975.0
2007-10-30 18:30:00	MSFT	Stock	35.5	35.55	35.266	35.51	2784.0

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

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