PREVIEW / stock_30min / 2007-04-18

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-18.parquet
  size:    1.0 MB
  rows:    55,373
  symbols: 2,579

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-18 07:00:00	AAPL	Stock	3.2143	3.2186	3.1971	3.1971	218400.0
2007-04-18 07:30:00	AAPL	Stock	3.2011	3.2018	3.2011	3.2018	21700.0
2007-04-18 08:00:00	AAPL	Stock	3.2018	3.2168	3.2018	3.2079	392868.0
2007-04-18 08:30:00	AAPL	Stock	3.2079	3.2125	3.2036	3.2064	714084.0
2007-04-18 09:00:00	AAPL	Stock	3.2071	3.2196	3.2061	3.2179	2509108.0
2007-04-18 09:30:00	AAPL	Stock	3.22	3.2214	3.2	3.2168	54511744.0
2007-04-18 10:00:00	AAPL	Stock	3.2168	3.2396	3.2146	3.23	70047712.0
2007-04-18 10:30:00	AAPL	Stock	3.2296	3.2346	3.2264	3.2311	38343340.0
2007-04-18 11:00:00	AAPL	Stock	3.2314	3.2446	3.2304	3.2418	35288316.0
2007-04-18 11:30:00	AAPL	Stock	3.2418	3.2432	3.2296	3.23	39993380.0
2007-04-18 12:00:00	AAPL	Stock	3.2296	3.2339	3.2254	3.2271	20811056.0
2007-04-18 12:30:00	AAPL	Stock	3.2279	3.2311	3.2225	3.2293	30910908.0
2007-04-18 13:00:00	AAPL	Stock	3.2293	3.2397	3.2286	3.2318	16885988.0
2007-04-18 13:30:00	AAPL	Stock	3.2321	3.2361	3.2286	3.2329	23410520.0
2007-04-18 14:00:00	AAPL	Stock	3.2329	3.2364	3.2293	3.2304	17122644.0
2007-04-18 14:30:00	AAPL	Stock	3.2307	3.2339	3.2268	3.2296	23480604.0
2007-04-18 15:00:00	AAPL	Stock	3.2304	3.2414	3.2221	3.2379	42063560.0
2007-04-18 15:30:00	AAPL	Stock	3.2382	3.2389	3.2257	3.2271	38826312.0
2007-04-18 16:00:00	AAPL	Stock	3.2264	3.2354	3.2257	3.2354	773864.0
2007-04-18 16:30:00	AAPL	Stock	3.2304	3.2354	3.2271	3.2271	902356.0
2007-04-18 17:00:00	AAPL	Stock	3.2293	3.2326	3.2293	3.2293	77840.0
2007-04-18 17:30:00	AAPL	Stock	3.2296	3.2336	3.2296	3.2321	57624.0
2007-04-18 18:00:00	AAPL	Stock	3.2321	3.2329	3.2286	3.2286	92344.0
2007-04-18 18:30:00	AAPL	Stock	3.2296	3.23	3.2296	3.23	19656.0
2007-04-18 19:00:00	AAPL	Stock	3.23	3.2357	3.23	3.2357	132160.0
2007-04-18 19:30:00	AAPL	Stock	3.2364	3.2386	3.2339	3.2339	161308.0
2007-04-18 07:00:00	MSFT	Stock	28.8	29.04	28.74	28.77	5000.0
2007-04-18 08:00:00	MSFT	Stock	28.88	28.88	28.7	28.7	1547.0
2007-04-18 08:30:00	MSFT	Stock	28.76	28.76	28.68	28.68	4850.0
2007-04-18 09:00:00	MSFT	Stock	28.74	28.74	28.61	28.61	49810.0
2007-04-18 09:30:00	MSFT	Stock	28.61	28.67	28.37	28.44	5607279.0
2007-04-18 10:00:00	MSFT	Stock	28.45	28.52	28.36	28.48	4266845.0
2007-04-18 10:30:00	MSFT	Stock	28.48	28.61	28.41	28.54	3687618.0
2007-04-18 11:00:00	MSFT	Stock	28.542	28.64	28.44	28.453	2701065.0
2007-04-18 11:30:00	MSFT	Stock	28.46	28.48	28.41	28.432	1813196.0
2007-04-18 12:00:00	MSFT	Stock	28.43	28.52	28.41	28.45	1573344.0
2007-04-18 12:30:00	MSFT	Stock	28.46	28.5	28.441	28.5	1420984.0
2007-04-18 13:00:00	MSFT	Stock	28.492	28.52	28.48	28.48	1342628.0
2007-04-18 13:30:00	MSFT	Stock	28.48	28.51	28.46	28.49	1854281.0
2007-04-18 14:00:00	MSFT	Stock	28.49	28.53	28.48	28.52	1559020.0
2007-04-18 14:30:00	MSFT	Stock	28.52	28.57	28.45	28.45	4220292.0
2007-04-18 15:00:00	MSFT	Stock	28.45	28.67	28.44	28.64	3874113.0
2007-04-18 15:30:00	MSFT	Stock	28.64	28.66	28.57	28.57	4935634.0
2007-04-18 16:00:00	MSFT	Stock	28.59	28.79	28.575	28.67	694817.0
2007-04-18 16:30:00	MSFT	Stock	28.63	28.79	28.6	28.63	390938.0
2007-04-18 17:00:00	MSFT	Stock	28.72	28.73	28.6	28.73	128500.0
2007-04-18 17:30:00	MSFT	Stock	28.72	28.81	28.6	28.81	12650.0
2007-04-18 18:00:00	MSFT	Stock	28.65	28.65	28.61	28.61	400.0
2007-04-18 18:30:00	MSFT	Stock	28.7	28.73	28.7	28.73	358.0
2007-04-18 08:30:00	NVDA	Stock	0.5122	0.5122	0.5122	0.5122	60000.0

> showing 50 of 55,373 rows — these rows as CSV

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