PREVIEW / stock_1min / 2010-07-19

all stock 1-min files

  file:    by_date/stock_1min/2010/2010-07-19.parquet
  size:    12.1 MB
  rows:    930,836
  symbols: 2,799

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
2010-07-19 04:01:00	AAPL	Stock	8.9461	8.9461	8.9461	8.9461	5600.0
2010-07-19 04:02:00	AAPL	Stock	8.9721	8.9721	8.9721	8.9721	2800.0
2010-07-19 05:31:00	AAPL	Stock	8.9986	8.9996	8.9986	8.9996	8400.0
2010-07-19 05:56:00	AAPL	Stock	8.9961	8.9961	8.9961	8.9961	5320.0
2010-07-19 06:32:00	AAPL	Stock	8.9725	8.9725	8.9725	8.9725	5600.0
2010-07-19 06:34:00	AAPL	Stock	8.9725	8.9725	8.9725	8.9725	5600.0
2010-07-19 06:38:00	AAPL	Stock	8.9725	8.9725	8.9725	8.9725	7560.0
2010-07-19 06:44:00	AAPL	Stock	8.9814	8.9821	8.9814	8.9821	19320.0
2010-07-19 06:49:00	AAPL	Stock	8.9946	8.9961	8.9946	8.9961	45052.0
2010-07-19 06:50:00	AAPL	Stock	8.9961	8.9961	8.9961	8.9961	2800.0
2010-07-19 06:52:00	AAPL	Stock	8.9961	8.9961	8.9961	8.9961	2800.0
2010-07-19 06:55:00	AAPL	Stock	9.0054	9.0054	9.0054	9.0054	2800.0
2010-07-19 06:56:00	AAPL	Stock	9.0054	9.0079	9.0054	9.0079	14000.0
2010-07-19 06:59:00	AAPL	Stock	9.0175	9.0175	9.0175	9.0175	4200.0
2010-07-19 07:02:00	AAPL	Stock	8.9771	8.9771	8.9375	8.9375	52500.0
2010-07-19 07:03:00	AAPL	Stock	8.9557	8.9714	8.9557	8.9714	16800.0
2010-07-19 07:04:00	AAPL	Stock	8.9718	8.9718	8.9643	8.9643	11200.0
2010-07-19 07:06:00	AAPL	Stock	8.9643	8.9643	8.9643	8.9643	2800.0
2010-07-19 07:07:00	AAPL	Stock	8.9643	8.9643	8.9643	8.9643	19600.0
2010-07-19 07:08:00	AAPL	Stock	8.9643	8.9661	8.9639	8.9661	16800.0
2010-07-19 07:09:00	AAPL	Stock	8.97	8.9704	8.9643	8.9643	78400.0
2010-07-19 07:10:00	AAPL	Stock	8.9554	8.9554	8.9554	8.9554	2800.0
2010-07-19 07:11:00	AAPL	Stock	8.95	8.9536	8.9489	8.9536	43428.0
2010-07-19 07:12:00	AAPL	Stock	8.9536	8.9536	8.9536	8.9536	4200.0
2010-07-19 07:14:00	AAPL	Stock	8.9529	8.9529	8.9464	8.9507	25200.0
2010-07-19 07:15:00	AAPL	Stock	8.9529	8.9529	8.9507	8.9529	14000.0
2010-07-19 07:17:00	AAPL	Stock	8.9525	8.9536	8.9375	8.9468	33600.0
2010-07-19 07:18:00	AAPL	Stock	8.9536	8.9536	8.9464	8.9464	191800.0
2010-07-19 07:19:00	AAPL	Stock	8.9454	8.9454	8.9446	8.9446	5600.0
2010-07-19 07:20:00	AAPL	Stock	8.9357	8.9357	8.925	8.925	44800.0
2010-07-19 07:23:00	AAPL	Stock	8.9125	8.9286	8.9018	8.9036	134400.0
2010-07-19 07:24:00	AAPL	Stock	8.9054	8.9054	8.8893	8.8936	145264.0
2010-07-19 07:25:00	AAPL	Stock	8.8936	8.8936	8.8893	8.8893	11200.0
2010-07-19 07:27:00	AAPL	Stock	8.8925	8.8925	8.8925	8.8925	25620.0
2010-07-19 07:29:00	AAPL	Stock	8.9021	8.9036	8.9018	8.9036	28000.0
2010-07-19 07:30:00	AAPL	Stock	8.9036	8.9107	8.9036	8.9107	120400.0
2010-07-19 07:31:00	AAPL	Stock	8.9021	8.9021	8.895	8.895	5600.0
2010-07-19 07:34:00	AAPL	Stock	8.9007	8.9007	8.8996	8.8996	5600.0
2010-07-19 07:35:00	AAPL	Stock	8.8996	8.8996	8.8996	8.8996	2800.0
2010-07-19 07:36:00	AAPL	Stock	8.9018	8.9018	8.9014	8.9018	11200.0
2010-07-19 07:37:00	AAPL	Stock	8.8971	8.8979	8.8971	8.8971	25200.0
2010-07-19 07:38:00	AAPL	Stock	8.9011	8.9014	8.9011	8.9011	70280.0
2010-07-19 07:39:00	AAPL	Stock	8.9011	8.9032	8.8964	8.8964	89320.0
2010-07-19 07:40:00	AAPL	Stock	8.8996	8.8996	8.8979	8.8996	25200.0
2010-07-19 07:42:00	AAPL	Stock	8.8982	8.8982	8.8982	8.8982	2800.0
2010-07-19 07:43:00	AAPL	Stock	8.8982	8.8982	8.8925	8.8925	567196.0
2010-07-19 07:44:00	AAPL	Stock	8.8925	8.8925	8.8925	8.8925	8400.0
2010-07-19 07:45:00	AAPL	Stock	8.8964	8.8975	8.8964	8.8964	30800.0
2010-07-19 07:46:00	AAPL	Stock	8.8932	8.8936	8.8918	8.8936	42000.0
2010-07-19 07:47:00	AAPL	Stock	8.8954	8.9064	8.8954	8.8964	1189160.0

> showing 50 of 930,836 rows — these rows as CSV

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