PREVIEW / stock_30min / 2007-09-10

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-09-10.parquet
  size:    1.1 MB
  rows:    63,958
  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-09-10 09:30:00	AAPL	Stock	4.8927	4.8932	4.8111	4.8118	224180880.0
2007-09-10 10:00:00	AAPL	Stock	4.8118	4.8339	4.7839	4.8121	150232152.0
2007-09-10 10:30:00	AAPL	Stock	4.8118	4.8329	4.7989	4.82	96003656.0
2007-09-10 11:00:00	AAPL	Stock	4.8207	4.8314	4.795	4.8039	87993584.0
2007-09-10 11:30:00	AAPL	Stock	4.805	4.8264	4.7911	4.8261	71647576.0
2007-09-10 12:00:00	AAPL	Stock	4.8257	4.8536	4.7957	4.8454	66082044.0
2007-09-10 12:30:00	AAPL	Stock	4.8461	4.8496	4.8125	4.8175	54375272.0
2007-09-10 13:00:00	AAPL	Stock	4.8168	4.8364	4.806	4.8357	55889400.0
2007-09-10 13:30:00	AAPL	Stock	4.8357	4.8457	4.8221	4.8289	47224828.0
2007-09-10 14:00:00	AAPL	Stock	4.8286	4.875	4.8254	4.8654	65083312.0
2007-09-10 14:30:00	AAPL	Stock	4.8654	4.8996	4.8593	4.8986	110192572.0
2007-09-10 15:00:00	AAPL	Stock	4.8989	4.93	4.8825	4.9039	138066264.0
2007-09-10 15:30:00	AAPL	Stock	4.9039	4.9232	4.8793	4.8832	115248756.0
2007-09-10 16:00:00	AAPL	Stock	4.8832	4.8832	4.8825	4.8825	7933380.0
2007-09-10 09:30:00	MSFT	Stock	28.66	28.745	28.58	28.669	2401661.0
2007-09-10 10:00:00	MSFT	Stock	28.66	28.68	28.55	28.57	2951802.0
2007-09-10 10:30:00	MSFT	Stock	28.57	28.64	28.5	28.6	2639894.0
2007-09-10 11:00:00	MSFT	Stock	28.6	28.64	28.45	28.45	1733024.0
2007-09-10 11:30:00	MSFT	Stock	28.46	28.52	28.41	28.49	1980498.0
2007-09-10 12:00:00	MSFT	Stock	28.492	28.56	28.44	28.49	1346493.0
2007-09-10 12:30:00	MSFT	Stock	28.491	28.53	28.44	28.47	1107396.0
2007-09-10 13:00:00	MSFT	Stock	28.48	28.62	28.46	28.59	1025819.0
2007-09-10 13:30:00	MSFT	Stock	28.59	28.64	28.52	28.54	1053744.0
2007-09-10 14:00:00	MSFT	Stock	28.54	28.65	28.5	28.64	2140231.0
2007-09-10 14:30:00	MSFT	Stock	28.65	28.66	28.59	28.63	2006772.0
2007-09-10 15:00:00	MSFT	Stock	28.63	28.75	28.55	28.67	2869574.0
2007-09-10 15:30:00	MSFT	Stock	28.67	28.69	28.47	28.49	4511433.0
2007-09-10 16:00:00	MSFT	Stock	28.48	28.48	28.48	28.48	2333185.0
2007-09-10 08:30:00	NVDA	Stock	0.8613	0.8613	0.8613	0.8613	24000.0
2007-09-10 09:00:00	NVDA	Stock	0.8548	0.871	0.8548	0.8657	3798000.0
2007-09-10 09:30:00	NVDA	Stock	0.8625	0.8775	0.8585	0.8587	86805360.0
2007-09-10 10:00:00	NVDA	Stock	0.8587	0.8612	0.8453	0.8458	61931640.0
2007-09-10 10:30:00	NVDA	Stock	0.8458	0.8487	0.8395	0.8445	38407140.0
2007-09-10 11:00:00	NVDA	Stock	0.8445	0.8488	0.8425	0.843	34176120.0
2007-09-10 11:30:00	NVDA	Stock	0.8428	0.851	0.8413	0.8465	34228920.0
2007-09-10 12:00:00	NVDA	Stock	0.8463	0.8485	0.8425	0.8463	21807660.0
2007-09-10 12:30:00	NVDA	Stock	0.8467	0.8477	0.8413	0.8447	18507180.0
2007-09-10 13:00:00	NVDA	Stock	0.8447	0.851	0.8433	0.8498	30307800.0
2007-09-10 13:30:00	NVDA	Stock	0.8495	0.8533	0.8425	0.845	35150340.0
2007-09-10 14:00:00	NVDA	Stock	0.8447	0.8485	0.8425	0.8475	24420480.0
2007-09-10 14:30:00	NVDA	Stock	0.8475	0.8485	0.844	0.8455	39221160.0
2007-09-10 15:00:00	NVDA	Stock	0.8452	0.8528	0.8432	0.8485	43700280.0
2007-09-10 15:30:00	NVDA	Stock	0.8487	0.8507	0.8442	0.8465	54110940.0
2007-09-10 16:00:00	NVDA	Stock	0.846	0.8467	0.8435	0.8435	369600.0
2007-09-10 16:30:00	NVDA	Stock	0.8492	0.8492	0.8483	0.8483	90000.0
2007-09-10 17:00:00	NVDA	Stock	0.8482	0.8483	0.8482	0.8483	60000.0
2007-09-10 18:30:00	NVDA	Stock	0.8483	0.8493	0.8483	0.8493	15000.0
2007-09-10 08:00:00	AMZN	Stock	4.2225	4.2225	4.215	4.2225	64400.0
2007-09-10 08:30:00	AMZN	Stock	4.222	4.2485	4.222	4.2425	164400.0
2007-09-10 09:00:00	AMZN	Stock	4.245	4.2625	4.2395	4.2435	298600.0

> showing 50 of 63,958 rows — these rows as CSV

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