PREVIEW / stock_30min / 2007-04-30

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-30.parquet
  size:    1.1 MB
  rows:    57,558
  symbols: 2,654

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-04-30 09:30:00	AAPL	Stock	3.5746	3.5807	3.5654	3.5725	115873688.0
2007-04-30 10:00:00	AAPL	Stock	3.5721	3.6064	3.5718	3.5971	83531840.0
2007-04-30 10:30:00	AAPL	Stock	3.5971	3.605	3.5893	3.6007	46164664.0
2007-04-30 11:00:00	AAPL	Stock	3.6004	3.6071	3.5964	3.6021	32985764.0
2007-04-30 11:30:00	AAPL	Stock	3.6021	3.6022	3.5879	3.5936	28037688.0
2007-04-30 12:00:00	AAPL	Stock	3.5936	3.6007	3.5932	3.6	16879716.0
2007-04-30 12:30:00	AAPL	Stock	3.5996	3.6021	3.5971	3.5972	13602120.0
2007-04-30 13:00:00	AAPL	Stock	3.5971	3.6021	3.5968	3.5989	15959104.0
2007-04-30 13:30:00	AAPL	Stock	3.5993	3.6	3.5971	3.6	14103404.0
2007-04-30 14:00:00	AAPL	Stock	3.6	3.6	3.5839	3.5921	28714896.0
2007-04-30 14:30:00	AAPL	Stock	3.5918	3.5932	3.5729	3.5732	50994468.0
2007-04-30 15:00:00	AAPL	Stock	3.5732	3.5854	3.5729	3.5793	43430520.0
2007-04-30 15:30:00	AAPL	Stock	3.5786	3.5807	3.5596	3.5646	90791652.0
2007-04-30 16:00:00	AAPL	Stock	3.565	3.5668	3.5643	3.5643	14180544.0
2007-04-30 09:30:00	MSFT	Stock	30.13	30.19	30.03	30.12	6196438.0
2007-04-30 10:00:00	MSFT	Stock	30.12	30.18	30.07	30.17	3182600.0
2007-04-30 10:30:00	MSFT	Stock	30.16	30.37	30.16	30.37	5073805.0
2007-04-30 11:00:00	MSFT	Stock	30.36	30.37	30.3	30.33	3279104.0
2007-04-30 11:30:00	MSFT	Stock	30.33	30.34	30.16	30.17	3660393.0
2007-04-30 12:00:00	MSFT	Stock	30.17	30.25	30.17	30.201	2671710.0
2007-04-30 12:30:00	MSFT	Stock	30.2	30.22	30.16	30.17	2302586.0
2007-04-30 13:00:00	MSFT	Stock	30.17	30.2	30.07	30.1	2908575.0
2007-04-30 13:30:00	MSFT	Stock	30.11	30.2	30.06	30.08	3332358.0
2007-04-30 14:00:00	MSFT	Stock	30.09	30.14	30.04	30.07	2560511.0
2007-04-30 14:30:00	MSFT	Stock	30.07	30.09	30.02	30.06	4254174.0
2007-04-30 15:00:00	MSFT	Stock	30.07	30.15	30.06	30.15	4334079.0
2007-04-30 15:30:00	MSFT	Stock	30.15	30.19	29.94	29.94	9072592.0
2007-04-30 16:00:00	MSFT	Stock	29.94	29.95	29.94	29.94	2001071.0
2007-04-30 08:00:00	NVDA	Stock	0.5517	0.5567	0.5517	0.5567	162000.0
2007-04-30 08:30:00	NVDA	Stock	0.555	0.5583	0.5547	0.5583	633000.0
2007-04-30 09:00:00	NVDA	Stock	0.5583	0.5583	0.5552	0.5583	1296000.0
2007-04-30 09:30:00	NVDA	Stock	0.5587	0.5628	0.5558	0.5618	76362060.0
2007-04-30 10:00:00	NVDA	Stock	0.5617	0.5655	0.5597	0.5637	56770620.0
2007-04-30 10:30:00	NVDA	Stock	0.5637	0.5657	0.5623	0.5643	42868380.0
2007-04-30 11:00:00	NVDA	Stock	0.5643	0.5648	0.5595	0.5598	32250060.0
2007-04-30 11:30:00	NVDA	Stock	0.56	0.561	0.5568	0.5587	26680740.0
2007-04-30 12:00:00	NVDA	Stock	0.5585	0.5598	0.5573	0.559	15770940.0
2007-04-30 12:30:00	NVDA	Stock	0.559	0.5645	0.559	0.5623	31146600.0
2007-04-30 13:00:00	NVDA	Stock	0.5625	0.564	0.5607	0.5623	19570680.0
2007-04-30 13:30:00	NVDA	Stock	0.5625	0.5635	0.5602	0.5612	18133260.0
2007-04-30 14:00:00	NVDA	Stock	0.561	0.5618	0.5563	0.5578	24604560.0
2007-04-30 14:30:00	NVDA	Stock	0.5578	0.5583	0.5515	0.5537	37462980.0
2007-04-30 15:00:00	NVDA	Stock	0.5537	0.5547	0.5512	0.5535	40539780.0
2007-04-30 15:30:00	NVDA	Stock	0.5535	0.5538	0.548	0.5487	85876800.0
2007-04-30 16:00:00	NVDA	Stock	0.5487	0.5497	0.548	0.5483	6651420.0
2007-04-30 16:30:00	NVDA	Stock	0.5493	0.5493	0.5493	0.5493	60000.0
2007-04-30 17:00:00	NVDA	Stock	0.5493	0.5493	0.5493	0.5493	458940.0
2007-04-30 17:30:00	NVDA	Stock	0.5483	0.5483	0.5482	0.5482	30000.0
2007-04-30 18:00:00	NVDA	Stock	0.5487	0.5487	0.5487	0.5487	30000.0
2007-04-30 19:00:00	NVDA	Stock	0.5483	0.5483	0.5483	0.5483	9000.0

> showing 50 of 57,558 rows — these rows as CSV

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