PREVIEW / stock_1min / 2007-09-18

all stock 1-min files

  file:    by_date/stock_1min/2007/2007-09-18.parquet
  size:    11.5 MB
  rows:    928,593
  symbols: 2,550

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.9614	4.9679	7248780.0
2007-09-18 09:31:00	AAPL	Stock	4.9661	4.9747	4.95	4.9514	3913168.0
2007-09-18 09:32:00	AAPL	Stock	4.9728	4.9728	4.9439	4.9521	3692836.0
2007-09-18 09:33:00	AAPL	Stock	4.9525	4.9571	4.9446	4.9468	3533012.0
2007-09-18 09:34:00	AAPL	Stock	4.9471	4.9539	4.9411	4.945	3475556.0
2007-09-18 09:35:00	AAPL	Stock	4.9461	4.9461	4.9293	4.9304	5174792.0
2007-09-18 09:36:00	AAPL	Stock	4.9304	4.9339	4.93	4.9328	2768976.0
2007-09-18 09:37:00	AAPL	Stock	4.9325	4.9375	4.9293	4.9371	2969568.0
2007-09-18 09:38:00	AAPL	Stock	4.9361	4.9429	4.9354	4.9368	3624516.0
2007-09-18 09:39:00	AAPL	Stock	4.9368	4.9371	4.9321	4.9346	2252544.0
2007-09-18 09:40:00	AAPL	Stock	4.9357	4.9457	4.9346	4.9393	4010972.0
2007-09-18 09:41:00	AAPL	Stock	4.9393	4.9429	4.9375	4.9425	2110248.0
2007-09-18 09:42:00	AAPL	Stock	4.9414	4.9518	4.9414	4.9486	2511824.0
2007-09-18 09:43:00	AAPL	Stock	4.9493	4.9593	4.9339	4.9564	4205628.0
2007-09-18 09:44:00	AAPL	Stock	4.9557	4.9571	4.95	4.9571	1575616.0
2007-09-18 09:45:00	AAPL	Stock	4.9561	4.9571	4.95	4.9539	1862812.0
2007-09-18 09:46:00	AAPL	Stock	4.9543	4.9543	4.9475	4.9511	1163988.0
2007-09-18 09:47:00	AAPL	Stock	4.951	4.955	4.9489	4.9536	1026620.0
2007-09-18 09:48:00	AAPL	Stock	4.955	4.9554	4.9471	4.9525	1874432.0
2007-09-18 09:49:00	AAPL	Stock	4.9518	4.9518	4.9457	4.9465	1586144.0
2007-09-18 09:50:00	AAPL	Stock	4.9457	4.9459	4.9332	4.9396	3296804.0
2007-09-18 09:51:00	AAPL	Stock	4.94	4.9404	4.9257	4.9318	4741884.0
2007-09-18 09:52:00	AAPL	Stock	4.9311	4.9375	4.9286	4.9354	2038988.0
2007-09-18 09:53:00	AAPL	Stock	4.9356	4.9439	4.9325	4.9418	2026528.0
2007-09-18 09:54:00	AAPL	Stock	4.9422	4.9432	4.9375	4.9386	1176336.0
2007-09-18 09:55:00	AAPL	Stock	4.9386	4.9446	4.9379	4.9436	1788892.0
2007-09-18 09:56:00	AAPL	Stock	4.9439	4.9443	4.9396	4.9411	946988.0
2007-09-18 09:57:00	AAPL	Stock	4.9418	4.9425	4.9325	4.9375	1546832.0
2007-09-18 09:58:00	AAPL	Stock	4.9368	4.9404	4.9361	4.9375	1400000.0
2007-09-18 09:59:00	AAPL	Stock	4.9375	4.9404	4.935	4.9404	1074696.0
2007-09-18 10:00:00	AAPL	Stock	4.94	4.94	4.9311	4.9314	1786120.0
2007-09-18 10:01:00	AAPL	Stock	4.9315	4.9371	4.9304	4.9311	1910608.0
2007-09-18 10:02:00	AAPL	Stock	4.9307	4.9357	4.9307	4.9314	1117480.0
2007-09-18 10:03:00	AAPL	Stock	4.9321	4.9375	4.9321	4.9369	1239140.0
2007-09-18 10:04:00	AAPL	Stock	4.9371	4.9389	4.9354	4.9373	890820.0
2007-09-18 10:05:00	AAPL	Stock	4.9371	4.9386	4.935	4.935	828156.0
2007-09-18 10:06:00	AAPL	Stock	4.9357	4.9375	4.9311	4.9311	957768.0
2007-09-18 10:07:00	AAPL	Stock	4.9311	4.9346	4.9296	4.9318	1891932.0
2007-09-18 10:08:00	AAPL	Stock	4.9321	4.9371	4.9314	4.9368	1200976.0
2007-09-18 10:09:00	AAPL	Stock	4.9368	4.9429	4.9361	4.9429	2548700.0
2007-09-18 10:10:00	AAPL	Stock	4.9429	4.9536	4.9425	4.9507	2990456.0
2007-09-18 10:11:00	AAPL	Stock	4.9507	4.9532	4.9493	4.9496	2537360.0
2007-09-18 10:12:00	AAPL	Stock	4.95	4.9507	4.9464	4.9468	1799056.0
2007-09-18 10:13:00	AAPL	Stock	4.9464	4.9468	4.9443	4.9464	936320.0
2007-09-18 10:14:00	AAPL	Stock	4.9461	4.95	4.9454	4.9464	2091880.0
2007-09-18 10:15:00	AAPL	Stock	4.9461	4.9475	4.9421	4.9439	1286096.0
2007-09-18 10:16:00	AAPL	Stock	4.9439	4.9446	4.9382	4.9396	1231328.0
2007-09-18 10:17:00	AAPL	Stock	4.9396	4.9411	4.9368	4.9404	1499176.0
2007-09-18 10:18:00	AAPL	Stock	4.9404	4.9411	4.9382	4.9382	1050840.0
2007-09-18 10:19:00	AAPL	Stock	4.9382	4.9387	4.9311	4.9326	2271416.0

> showing 50 of 928,593 rows — these rows as CSV

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