PREVIEW / stock_30min / 2007-09-18

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-09-18.parquet
  size:    1.1 MB
  rows:    64,641
  symbols: 3,121

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-18 09:30:00	AAPL	Stock	4.9664	4.975	4.9257	4.9404	80619980.0
2007-09-18 10:00:00	AAPL	Stock	4.94	4.9536	4.9225	4.9404	55890968.0
2007-09-18 10:30:00	AAPL	Stock	4.9404	4.9532	4.9304	4.9514	40917688.0
2007-09-18 11:00:00	AAPL	Stock	4.9525	4.9768	4.9454	4.9543	63437640.0
2007-09-18 11:30:00	AAPL	Stock	4.9539	4.9611	4.9514	4.9521	26639676.0
2007-09-18 12:00:00	AAPL	Stock	4.9521	4.9564	4.9443	4.9536	19758900.0
2007-09-18 12:30:00	AAPL	Stock	4.9529	4.9654	4.9521	4.9582	17023524.0
2007-09-18 13:00:00	AAPL	Stock	4.9586	4.9611	4.9425	4.9493	23070656.0
2007-09-18 13:30:00	AAPL	Stock	4.9489	4.9518	4.9293	4.9446	27440532.0
2007-09-18 14:00:00	AAPL	Stock	4.9439	5.0443	4.9311	5.0132	146416788.0
2007-09-18 14:30:00	AAPL	Stock	5.0129	5.1018	5.0104	5.0618	189537376.0
2007-09-18 15:00:00	AAPL	Stock	5.0618	5.0636	5.0282	5.0475	124385968.0
2007-09-18 15:30:00	AAPL	Stock	5.0471	5.0493	5.0125	5.0318	124378688.0
2007-09-18 16:00:00	AAPL	Stock	5.0325	5.0329	5.0319	5.0329	12319160.0
2007-09-18 09:30:00	MSFT	Stock	28.7	28.87	28.42	28.43	4977563.0
2007-09-18 10:00:00	MSFT	Stock	28.44	28.55	28.4	28.518	3571964.0
2007-09-18 10:30:00	MSFT	Stock	28.52	28.54	28.41	28.5	2601218.0
2007-09-18 11:00:00	MSFT	Stock	28.5	28.58	28.45	28.45	2891502.0
2007-09-18 11:30:00	MSFT	Stock	28.45	28.49	28.4	28.43	3283410.0
2007-09-18 12:00:00	MSFT	Stock	28.43	28.44	28.32	28.321	2747764.0
2007-09-18 12:30:00	MSFT	Stock	28.32	28.37	28.32	28.36	1438290.0
2007-09-18 13:00:00	MSFT	Stock	28.36	28.41	28.32	28.41	3191660.0
2007-09-18 13:30:00	MSFT	Stock	28.4	28.41	28.32	28.36	2839486.0
2007-09-18 14:00:00	MSFT	Stock	28.36	28.75	28.27	28.51	7311914.0
2007-09-18 14:30:00	MSFT	Stock	28.51	28.69	28.5	28.65	7131343.0
2007-09-18 15:00:00	MSFT	Stock	28.65	28.74	28.57	28.63	6906765.0
2007-09-18 15:30:00	MSFT	Stock	28.63	28.96	28.596	28.91	11658241.0
2007-09-18 16:00:00	MSFT	Stock	28.91	28.93	28.91	28.93	3147106.0
2007-09-18 08:00:00	NVDA	Stock	0.8095	0.8125	0.8095	0.8125	267000.0
2007-09-18 08:30:00	NVDA	Stock	0.813	0.815	0.813	0.815	42000.0
2007-09-18 09:00:00	NVDA	Stock	0.813	0.816	0.8125	0.8132	980000.0
2007-09-18 09:30:00	NVDA	Stock	0.8138	0.8332	0.8118	0.829	67576480.0
2007-09-18 10:00:00	NVDA	Stock	0.829	0.8325	0.8268	0.8325	28941760.0
2007-09-18 10:30:00	NVDA	Stock	0.8325	0.8355	0.8295	0.8348	32245000.0
2007-09-18 11:00:00	NVDA	Stock	0.8348	0.8432	0.8325	0.8382	38129840.0
2007-09-18 11:30:00	NVDA	Stock	0.8382	0.8405	0.829	0.8332	64421400.0
2007-09-18 12:00:00	NVDA	Stock	0.8335	0.834	0.8235	0.8322	38113320.0
2007-09-18 12:30:00	NVDA	Stock	0.832	0.835	0.831	0.8338	15222200.0
2007-09-18 13:00:00	NVDA	Stock	0.8338	0.8348	0.8298	0.8332	29559920.0
2007-09-18 13:30:00	NVDA	Stock	0.8335	0.8338	0.8308	0.8328	23452200.0
2007-09-18 14:00:00	NVDA	Stock	0.8325	0.8472	0.8312	0.8422	65457360.0
2007-09-18 14:30:00	NVDA	Stock	0.8422	0.8675	0.8422	0.8665	114302000.0
2007-09-18 15:00:00	NVDA	Stock	0.8662	0.8875	0.8658	0.8832	126902520.0
2007-09-18 15:30:00	NVDA	Stock	0.883	0.8832	0.8675	0.875	127844000.0
2007-09-18 16:00:00	NVDA	Stock	0.875	0.875	0.8688	0.8712	19492400.0
2007-09-18 16:30:00	NVDA	Stock	0.8718	0.875	0.8712	0.8738	1475360.0
2007-09-18 17:00:00	NVDA	Stock	0.8742	0.8742	0.8738	0.8738	40000.0
2007-09-18 17:30:00	NVDA	Stock	0.875	0.8782	0.875	0.8782	44800.0
2007-09-18 18:00:00	NVDA	Stock	0.875	0.8775	0.875	0.8752	72160.0
2007-09-18 18:30:00	NVDA	Stock	0.8762	0.8762	0.8752	0.8752	43000.0

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

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