PREVIEW / stock_30min / 2007-06-21

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-21.parquet
  size:    1.1 MB
  rows:    64,362
  symbols: 3,051

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-21 09:30:00	AAPL	Stock	4.3464	4.3689	4.3114	4.3329	122769808.0
2007-06-21 10:00:00	AAPL	Stock	4.3324	4.3929	4.3324	4.3889	107528064.0
2007-06-21 10:30:00	AAPL	Stock	4.3889	4.4325	4.3807	4.4257	113921584.0
2007-06-21 11:00:00	AAPL	Stock	4.4247	4.4389	4.4107	4.4257	86012080.0
2007-06-21 11:30:00	AAPL	Stock	4.4261	4.4261	4.3886	4.4039	59707340.0
2007-06-21 12:00:00	AAPL	Stock	4.4039	4.4182	4.3961	4.4036	46021500.0
2007-06-21 12:30:00	AAPL	Stock	4.4036	4.4154	4.3961	4.4046	36053024.0
2007-06-21 13:00:00	AAPL	Stock	4.4054	4.4232	4.4036	4.4179	37586164.0
2007-06-21 13:30:00	AAPL	Stock	4.4179	4.4264	4.4157	4.4238	35689752.0
2007-06-21 14:00:00	AAPL	Stock	4.4232	4.4254	4.4157	4.4168	26958064.0
2007-06-21 14:30:00	AAPL	Stock	4.4168	4.4186	4.3968	4.4107	44782108.0
2007-06-21 15:00:00	AAPL	Stock	4.4111	4.4279	4.4107	4.4232	43964676.0
2007-06-21 15:30:00	AAPL	Stock	4.4229	4.4375	4.4218	4.425	81367300.0
2007-06-21 16:00:00	AAPL	Stock	4.425	4.4286	4.425	4.425	3860304.0
2007-06-21 09:30:00	MSFT	Stock	29.975	30.05	29.94	29.97	6541494.0
2007-06-21 10:00:00	MSFT	Stock	29.97	30.11	29.91	30.05	6338423.0
2007-06-21 10:30:00	MSFT	Stock	30.05	30.14	29.96	30.04	4318261.0
2007-06-21 11:00:00	MSFT	Stock	30.05	30.06	29.95	29.97	2562558.0
2007-06-21 11:30:00	MSFT	Stock	29.96	29.98	29.91	29.96	1852238.0
2007-06-21 12:00:00	MSFT	Stock	29.95	30.09	29.95	30.03	2709138.0
2007-06-21 12:30:00	MSFT	Stock	30.03	30.14	29.97	30.07	2950163.0
2007-06-21 13:00:00	MSFT	Stock	30.06	30.14	30.04	30.08	3739055.0
2007-06-21 13:30:00	MSFT	Stock	30.08	30.24	30.08	30.23	3784585.0
2007-06-21 14:00:00	MSFT	Stock	30.22	30.25	30.15	30.18	3112919.0
2007-06-21 14:30:00	MSFT	Stock	30.18	30.27	30.11	30.25	3741355.0
2007-06-21 15:00:00	MSFT	Stock	30.24	30.3	30.158	30.28	4123097.0
2007-06-21 15:30:00	MSFT	Stock	30.27	30.3	30.169	30.22	6334488.0
2007-06-21 16:00:00	MSFT	Stock	30.22	30.22	30.22	30.22	1269066.0
2007-06-21 07:00:00	NVDA	Stock	0.6692	0.6745	0.6692	0.6745	120000.0
2007-06-21 07:30:00	NVDA	Stock	0.6693	0.6783	0.6693	0.6777	1014000.0
2007-06-21 08:00:00	NVDA	Stock	0.6757	0.6775	0.6727	0.6733	963300.0
2007-06-21 08:30:00	NVDA	Stock	0.6742	0.6767	0.6732	0.6758	1209840.0
2007-06-21 09:00:00	NVDA	Stock	0.6643	0.6783	0.6643	0.6772	4967340.0
2007-06-21 09:30:00	NVDA	Stock	0.6772	0.6798	0.672	0.6743	152337540.0
2007-06-21 10:00:00	NVDA	Stock	0.6742	0.6878	0.6737	0.6867	121446000.0
2007-06-21 10:30:00	NVDA	Stock	0.6863	0.6968	0.6843	0.6955	100230480.0
2007-06-21 11:00:00	NVDA	Stock	0.6948	0.6977	0.693	0.6945	59495760.0
2007-06-21 11:30:00	NVDA	Stock	0.6945	0.7003	0.6938	0.6998	55482600.0
2007-06-21 12:00:00	NVDA	Stock	0.6998	0.7083	0.6995	0.7025	118393080.0
2007-06-21 12:30:00	NVDA	Stock	0.7025	0.7057	0.7015	0.7015	63054420.0
2007-06-21 13:00:00	NVDA	Stock	0.7015	0.7077	0.7012	0.7057	47798580.0
2007-06-21 13:30:00	NVDA	Stock	0.7057	0.7095	0.7057	0.7083	58669740.0
2007-06-21 14:00:00	NVDA	Stock	0.7083	0.7085	0.704	0.7052	46000500.0
2007-06-21 14:30:00	NVDA	Stock	0.705	0.7108	0.703	0.7102	79819320.0
2007-06-21 15:00:00	NVDA	Stock	0.7103	0.718	0.7102	0.7175	131523840.0
2007-06-21 15:30:00	NVDA	Stock	0.7175	0.7222	0.7147	0.7157	197439180.0
2007-06-21 16:00:00	NVDA	Stock	0.7163	0.7167	0.7162	0.7167	10321680.0
2007-06-21 16:30:00	NVDA	Stock	0.7157	0.7192	0.7157	0.7167	563700.0
2007-06-21 17:00:00	NVDA	Stock	0.7168	0.7168	0.7168	0.7168	57000.0
2007-06-21 17:30:00	NVDA	Stock	0.7168	0.7192	0.7168	0.7192	54600.0

> showing 50 of 64,362 rows — these rows as CSV

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