PREVIEW / stock_5min / 2009-04-23

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-04-23.parquet
  size:    4.5 MB
  rows:    306,649
  symbols: 3,295

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
2009-04-23 04:30:00	AAPL	Stock	4.4696	4.4696	4.4696	4.4696	2800.0
2009-04-23 05:10:00	AAPL	Stock	4.4793	4.4793	4.4793	4.4793	2800.0
2009-04-23 05:15:00	AAPL	Stock	4.4954	4.4954	4.4954	4.4954	16800.0
2009-04-23 05:40:00	AAPL	Stock	4.4957	4.4964	4.4957	4.4964	19488.0
2009-04-23 06:05:00	AAPL	Stock	4.4993	4.5057	4.4993	4.5057	33040.0
2009-04-23 06:10:00	AAPL	Stock	4.5	4.5	4.5	4.5	14000.0
2009-04-23 06:15:00	AAPL	Stock	4.5089	4.5089	4.5089	4.5089	2800.0
2009-04-23 06:25:00	AAPL	Stock	4.5089	4.5139	4.5089	4.5139	30800.0
2009-04-23 06:30:00	AAPL	Stock	4.5125	4.5179	4.5125	4.5179	32200.0
2009-04-23 06:35:00	AAPL	Stock	4.525	4.525	4.525	4.525	2800.0
2009-04-23 06:40:00	AAPL	Stock	4.5268	4.5296	4.5268	4.5296	7000.0
2009-04-23 06:45:00	AAPL	Stock	4.5125	4.5125	4.5125	4.5125	2800.0
2009-04-23 06:50:00	AAPL	Stock	4.5125	4.5125	4.5125	4.5125	2800.0
2009-04-23 06:55:00	AAPL	Stock	4.5129	4.5129	4.505	4.505	5600.0
2009-04-23 07:00:00	AAPL	Stock	4.5043	4.5043	4.4839	4.4839	8400.0
2009-04-23 07:05:00	AAPL	Stock	4.4921	4.5107	4.4921	4.5036	244356.0
2009-04-23 07:10:00	AAPL	Stock	4.5021	4.5136	4.5021	4.5071	60340.0
2009-04-23 07:15:00	AAPL	Stock	4.51	4.5357	4.5071	4.5357	311080.0
2009-04-23 07:20:00	AAPL	Stock	4.5343	4.5346	4.5139	4.5161	113736.0
2009-04-23 07:25:00	AAPL	Stock	4.5179	4.5179	4.5129	4.5139	92988.0
2009-04-23 07:30:00	AAPL	Stock	4.5179	4.5179	4.5071	4.5071	150500.0
2009-04-23 07:35:00	AAPL	Stock	4.5029	4.5036	4.4886	4.4929	456428.0
2009-04-23 07:40:00	AAPL	Stock	4.4893	4.4964	4.4857	4.4964	177800.0
2009-04-23 07:45:00	AAPL	Stock	4.4893	4.4893	4.4743	4.4821	575708.0
2009-04-23 07:50:00	AAPL	Stock	4.485	4.4929	4.4825	4.4929	304360.0
2009-04-23 07:55:00	AAPL	Stock	4.4893	4.5282	4.4886	4.5082	646632.0
2009-04-23 08:00:00	AAPL	Stock	4.5075	4.5179	4.4832	4.4964	1315076.0
2009-04-23 08:05:00	AAPL	Stock	4.4979	4.5064	4.4911	4.4968	1186668.0
2009-04-23 08:10:00	AAPL	Stock	4.5004	4.5021	4.4821	4.4911	887712.0
2009-04-23 08:15:00	AAPL	Stock	4.4925	4.5243	4.4882	4.5236	1142540.0
2009-04-23 08:20:00	AAPL	Stock	4.5225	4.5268	4.5093	4.5139	1779624.0
2009-04-23 08:25:00	AAPL	Stock	4.5132	4.5286	4.5089	4.5286	910952.0
2009-04-23 08:30:00	AAPL	Stock	4.525	4.525	4.4971	4.5082	1774108.0
2009-04-23 08:35:00	AAPL	Stock	4.5093	4.5179	4.5071	4.5154	507108.0
2009-04-23 08:40:00	AAPL	Stock	4.5171	4.5293	4.5143	4.5275	1408848.0
2009-04-23 08:45:00	AAPL	Stock	4.5286	4.555	4.5264	4.5471	4377212.0
2009-04-23 08:50:00	AAPL	Stock	4.5486	4.5671	4.5464	4.55	2794960.0
2009-04-23 08:55:00	AAPL	Stock	4.5475	4.5786	4.5432	4.5746	2921604.0
2009-04-23 09:00:00	AAPL	Stock	4.5743	4.5786	4.5429	4.5496	2720144.0
2009-04-23 09:05:00	AAPL	Stock	4.55	4.5536	4.5368	4.5521	2150596.0
2009-04-23 09:10:00	AAPL	Stock	4.5518	4.5532	4.5357	4.5364	1374212.0
2009-04-23 09:15:00	AAPL	Stock	4.5364	4.5393	4.5268	4.5311	2134468.0
2009-04-23 09:20:00	AAPL	Stock	4.5311	4.5486	4.5225	4.5268	1435504.0
2009-04-23 09:25:00	AAPL	Stock	4.5268	4.5379	4.52	4.5204	2694776.0
2009-04-23 09:30:00	AAPL	Stock	4.5211	4.5429	4.4536	4.457	59938172.0
2009-04-23 09:35:00	AAPL	Stock	4.4568	4.495	4.4429	4.4939	45735228.0
2009-04-23 09:40:00	AAPL	Stock	4.4936	4.4964	4.4532	4.4614	27175596.0
2009-04-23 09:45:00	AAPL	Stock	4.46	4.4605	4.4179	4.4454	33595380.0
2009-04-23 09:50:00	AAPL	Stock	4.4454	4.4593	4.4218	4.4529	24161200.0
2009-04-23 09:55:00	AAPL	Stock	4.4543	4.4543	4.4314	4.4411	18055268.0

> showing 50 of 306,649 rows — these rows as CSV

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