PREVIEW / stock_30min / 2007-08-14

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-14.parquet
  size:    1.1 MB
  rows:    65,160
  symbols: 3,124

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-08-14 09:30:00	AAPL	Stock	4.5818	4.5821	4.5268	4.5354	86847740.0
2007-08-14 10:00:00	AAPL	Stock	4.5357	4.54	4.4718	4.4811	72090956.0
2007-08-14 10:30:00	AAPL	Stock	4.4807	4.4996	4.4604	4.4732	60436544.0
2007-08-14 11:00:00	AAPL	Stock	4.4732	4.4918	4.4454	4.4825	64344980.0
2007-08-14 11:30:00	AAPL	Stock	4.4825	4.5264	4.4775	4.5196	50917216.0
2007-08-14 12:00:00	AAPL	Stock	4.5196	4.52	4.4864	4.4929	37832116.0
2007-08-14 12:30:00	AAPL	Stock	4.4929	4.5125	4.4832	4.505	23071972.0
2007-08-14 13:00:00	AAPL	Stock	4.505	4.5086	4.4825	4.4857	20921824.0
2007-08-14 13:30:00	AAPL	Stock	4.4857	4.5107	4.4643	4.4793	33628140.0
2007-08-14 14:00:00	AAPL	Stock	4.48	4.4982	4.4664	4.48	36837780.0
2007-08-14 14:30:00	AAPL	Stock	4.4793	4.4804	4.4393	4.4571	68213292.0
2007-08-14 15:00:00	AAPL	Stock	4.4579	4.4818	4.4468	4.4696	60291084.0
2007-08-14 15:30:00	AAPL	Stock	4.47	4.4714	4.4182	4.4314	82414220.0
2007-08-14 16:00:00	AAPL	Stock	4.4329	4.4329	4.4296	4.4296	14388136.0
2007-08-14 09:30:00	MSFT	Stock	28.77	28.89	28.6	28.87	3329356.0
2007-08-14 10:00:00	MSFT	Stock	28.861	28.88	28.49	28.59	2947208.0
2007-08-14 10:30:00	MSFT	Stock	28.57	28.63	28.35	28.45	2994597.0
2007-08-14 11:00:00	MSFT	Stock	28.45	28.5	28.3	28.492	2340262.0
2007-08-14 11:30:00	MSFT	Stock	28.49	28.63	28.48	28.6	2068515.0
2007-08-14 12:00:00	MSFT	Stock	28.6	28.63	28.47	28.49	1500567.0
2007-08-14 12:30:00	MSFT	Stock	28.49	28.57	28.43	28.49	1714072.0
2007-08-14 13:00:00	MSFT	Stock	28.48	28.51	28.42	28.43	1320998.0
2007-08-14 13:30:00	MSFT	Stock	28.44	28.52	28.28	28.41	2170130.0
2007-08-14 14:00:00	MSFT	Stock	28.4	28.44	28.33	28.37	2831878.0
2007-08-14 14:30:00	MSFT	Stock	28.36	28.38	28.2	28.34	3896746.0
2007-08-14 15:00:00	MSFT	Stock	28.34	28.56	28.33	28.39	3825944.0
2007-08-14 15:30:00	MSFT	Stock	28.39	28.46	28.24	28.3	5623737.0
2007-08-14 16:00:00	MSFT	Stock	28.3	28.31	28.27	28.27	1986126.0
2007-08-14 08:00:00	NVDA	Stock	0.7208	0.7208	0.7183	0.72	160140.0
2007-08-14 08:30:00	NVDA	Stock	0.7217	0.7217	0.7217	0.7217	36000.0
2007-08-14 09:00:00	NVDA	Stock	0.7222	0.7307	0.722	0.7302	267000.0
2007-08-14 09:30:00	NVDA	Stock	0.7302	0.7417	0.728	0.74	117585480.0
2007-08-14 10:00:00	NVDA	Stock	0.7398	0.745	0.7388	0.743	89553120.0
2007-08-14 10:30:00	NVDA	Stock	0.7425	0.7482	0.7388	0.7408	91060500.0
2007-08-14 11:00:00	NVDA	Stock	0.7407	0.7417	0.7338	0.7402	66435540.0
2007-08-14 11:30:00	NVDA	Stock	0.7402	0.7475	0.74	0.7467	51697980.0
2007-08-14 12:00:00	NVDA	Stock	0.7468	0.7498	0.7457	0.7465	53218800.0
2007-08-14 12:30:00	NVDA	Stock	0.7468	0.7495	0.7462	0.748	39045180.0
2007-08-14 13:00:00	NVDA	Stock	0.748	0.7552	0.7475	0.7512	56917320.0
2007-08-14 13:30:00	NVDA	Stock	0.7515	0.7598	0.7508	0.759	76752540.0
2007-08-14 14:00:00	NVDA	Stock	0.7588	0.76	0.7507	0.7577	80303100.0
2007-08-14 14:30:00	NVDA	Stock	0.7577	0.7592	0.751	0.7585	109351500.0
2007-08-14 15:00:00	NVDA	Stock	0.7583	0.765	0.7577	0.7628	112678080.0
2007-08-14 15:30:00	NVDA	Stock	0.7628	0.7645	0.7528	0.7535	122257620.0
2007-08-14 16:00:00	NVDA	Stock	0.7533	0.7577	0.7522	0.7542	2086560.0
2007-08-14 16:30:00	NVDA	Stock	0.7542	0.755	0.7502	0.755	175320.0
2007-08-14 17:00:00	NVDA	Stock	0.7503	0.7503	0.75	0.75	157320.0
2007-08-14 17:30:00	NVDA	Stock	0.753	0.753	0.7508	0.7508	18000.0
2007-08-14 18:00:00	NVDA	Stock	0.7513	0.7513	0.7503	0.7513	51000.0
2007-08-14 18:30:00	NVDA	Stock	0.7508	0.7508	0.7485	0.7485	66600.0

> showing 50 of 65,160 rows — these rows as CSV

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