PREVIEW / stock_30min / 2007-06-08

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-08.parquet
  size:    1.1 MB
  rows:    62,645
  symbols: 3,026

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-06-08 09:30:00	AAPL	Stock	4.4937	4.4939	4.4007	4.4418	231923300.0
2007-06-08 10:00:00	AAPL	Stock	4.4418	4.46	4.4218	4.4396	139072640.0
2007-06-08 10:30:00	AAPL	Stock	4.4396	4.4421	4.4132	4.4182	90348664.0
2007-06-08 11:00:00	AAPL	Stock	4.4182	4.4193	4.3675	4.39	166841696.0
2007-06-08 11:30:00	AAPL	Stock	4.3904	4.4129	4.3829	4.4096	68750724.0
2007-06-08 12:00:00	AAPL	Stock	4.4093	4.41	4.395	4.4018	30742712.0
2007-06-08 12:30:00	AAPL	Stock	4.4018	4.4032	4.3846	4.3925	41797336.0
2007-06-08 13:00:00	AAPL	Stock	4.3921	4.41	4.3839	4.4059	39050564.0
2007-06-08 13:30:00	AAPL	Stock	4.4061	4.4429	4.3986	4.4289	87950772.0
2007-06-08 14:00:00	AAPL	Stock	4.4291	4.4529	4.4264	4.4364	63500976.0
2007-06-08 14:30:00	AAPL	Stock	4.4368	4.4386	4.4168	4.4243	57954876.0
2007-06-08 15:00:00	AAPL	Stock	4.4246	4.4446	4.4214	4.4311	56382480.0
2007-06-08 15:30:00	AAPL	Stock	4.4311	4.45	4.4279	4.445	106591044.0
2007-06-08 16:00:00	AAPL	Stock	4.4454	4.4461	4.445	4.4461	12630884.0
2007-06-08 09:30:00	MSFT	Stock	29.58	29.671	29.45	29.56	7914568.0
2007-06-08 10:00:00	MSFT	Stock	29.56	29.86	29.52	29.82	6500596.0
2007-06-08 10:30:00	MSFT	Stock	29.82	29.9	29.75	29.82	4067361.0
2007-06-08 11:00:00	MSFT	Stock	29.82	29.85	29.73	29.75	3342225.0
2007-06-08 11:30:00	MSFT	Stock	29.76	29.77	29.69	29.74	2082473.0
2007-06-08 12:00:00	MSFT	Stock	29.74	29.75	29.65	29.71	2013882.0
2007-06-08 12:30:00	MSFT	Stock	29.71	29.82	29.65	29.8	1861767.0
2007-06-08 13:00:00	MSFT	Stock	29.8	29.85	29.75	29.83	1655134.0
2007-06-08 13:30:00	MSFT	Stock	29.83	29.93	29.79	29.9	2980546.0
2007-06-08 14:00:00	MSFT	Stock	29.91	30.02	29.9	29.97	2901202.0
2007-06-08 14:30:00	MSFT	Stock	29.97	30.01	29.91	30.0	2660159.0
2007-06-08 15:00:00	MSFT	Stock	30.01	30.04	29.91	29.92	4127927.0
2007-06-08 15:30:00	MSFT	Stock	29.91	30.06	29.41	30.04	11730772.0
2007-06-08 16:00:00	MSFT	Stock	30.05	30.05	30.03	30.05	2905662.0
2007-06-08 08:30:00	NVDA	Stock	0.5975	0.5975	0.5973	0.5973	18000.0
2007-06-08 09:00:00	NVDA	Stock	0.5985	0.5995	0.5942	0.5952	354000.0
2007-06-08 09:30:00	NVDA	Stock	0.5948	0.5998	0.5875	0.5985	56727000.0
2007-06-08 10:00:00	NVDA	Stock	0.5987	0.6003	0.5958	0.5992	40904940.0
2007-06-08 10:30:00	NVDA	Stock	0.5993	0.5997	0.5967	0.5968	26812500.0
2007-06-08 11:00:00	NVDA	Stock	0.597	0.5972	0.5908	0.5942	41686140.0
2007-06-08 11:30:00	NVDA	Stock	0.5943	0.5945	0.5913	0.5932	32785860.0
2007-06-08 12:00:00	NVDA	Stock	0.5932	0.5967	0.5918	0.5957	20308920.0
2007-06-08 12:30:00	NVDA	Stock	0.5957	0.5963	0.5927	0.5962	19918980.0
2007-06-08 13:00:00	NVDA	Stock	0.5963	0.6027	0.5938	0.6027	52307280.0
2007-06-08 13:30:00	NVDA	Stock	0.6025	0.606	0.6008	0.6033	33528660.0
2007-06-08 14:00:00	NVDA	Stock	0.6032	0.605	0.6028	0.6043	27385560.0
2007-06-08 14:30:00	NVDA	Stock	0.6043	0.607	0.6033	0.6055	41051280.0
2007-06-08 15:00:00	NVDA	Stock	0.6053	0.6092	0.605	0.6063	60558360.0
2007-06-08 15:30:00	NVDA	Stock	0.6065	0.61	0.6058	0.6092	63892200.0
2007-06-08 16:00:00	NVDA	Stock	0.6092	0.6093	0.6092	0.6092	363720.0
2007-06-08 16:30:00	NVDA	Stock	0.609	0.609	0.6088	0.6088	126000.0
2007-06-08 17:30:00	NVDA	Stock	0.6092	0.6092	0.6092	0.6092	72000.0
2007-06-08 18:00:00	NVDA	Stock	0.609	0.609	0.609	0.609	60000.0
2007-06-08 05:30:00	AMZN	Stock	3.5955	3.5955	3.5955	3.5955	3000.0
2007-06-08 07:30:00	AMZN	Stock	3.6095	3.61	3.605	3.61	31280.0
2007-06-08 08:00:00	AMZN	Stock	3.61	3.629	3.605	3.629	279800.0

> showing 50 of 62,645 rows — these rows as CSV

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