PREVIEW / stock_1min / 2010-04-27

all stock 1-min files

  file:    by_date/stock_1min/2010/2010-04-27.parquet
  size:    14.1 MB
  rows:    1,041,918
  symbols: 2,848

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-04-27 04:30:00	AAPL	Stock	9.5807	9.5807	9.5807	9.5807	2800.0
2010-04-27 05:08:00	AAPL	Stock	9.5786	9.5786	9.5786	9.5786	2800.0
2010-04-27 05:22:00	AAPL	Stock	9.5911	9.5911	9.5786	9.5786	8400.0
2010-04-27 05:30:00	AAPL	Stock	9.5786	9.5786	9.5732	9.5732	5600.0
2010-04-27 05:34:00	AAPL	Stock	9.5554	9.5554	9.5554	9.5554	2800.0
2010-04-27 05:45:00	AAPL	Stock	9.5539	9.5539	9.5539	9.5539	5600.0
2010-04-27 05:51:00	AAPL	Stock	9.5521	9.5521	9.5521	9.5521	2800.0
2010-04-27 05:58:00	AAPL	Stock	9.5446	9.5446	9.5446	9.5446	2800.0
2010-04-27 06:07:00	AAPL	Stock	9.5379	9.5379	9.5357	9.5357	14000.0
2010-04-27 06:09:00	AAPL	Stock	9.5129	9.5129	9.5	9.5	11200.0
2010-04-27 06:17:00	AAPL	Stock	9.5125	9.5125	9.5125	9.5125	2800.0
2010-04-27 06:18:00	AAPL	Stock	9.5129	9.5129	9.5129	9.5129	2800.0
2010-04-27 06:19:00	AAPL	Stock	9.5136	9.5136	9.5136	9.5136	2800.0
2010-04-27 06:24:00	AAPL	Stock	9.4932	9.4932	9.4932	9.4932	9520.0
2010-04-27 06:25:00	AAPL	Stock	9.5175	9.5175	9.4932	9.4932	8400.0
2010-04-27 06:31:00	AAPL	Stock	9.5261	9.5261	9.5257	9.5257	53200.0
2010-04-27 06:34:00	AAPL	Stock	9.5268	9.5268	9.5268	9.5268	14000.0
2010-04-27 06:35:00	AAPL	Stock	9.5268	9.5268	9.5268	9.5268	5600.0
2010-04-27 06:37:00	AAPL	Stock	9.5268	9.5268	9.5268	9.5268	5600.0
2010-04-27 06:41:00	AAPL	Stock	9.5179	9.5204	9.5179	9.5204	8400.0
2010-04-27 06:42:00	AAPL	Stock	9.5179	9.5179	9.5179	9.5179	2800.0
2010-04-27 06:45:00	AAPL	Stock	9.5179	9.5179	9.5179	9.5179	2800.0
2010-04-27 06:57:00	AAPL	Stock	9.5179	9.5179	9.5114	9.5114	11116.0
2010-04-27 07:00:00	AAPL	Stock	9.525	9.525	9.525	9.525	3920.0
2010-04-27 07:01:00	AAPL	Stock	9.5146	9.5146	9.5146	9.5146	2800.0
2010-04-27 07:04:00	AAPL	Stock	9.5286	9.5286	9.5286	9.5286	13440.0
2010-04-27 07:05:00	AAPL	Stock	9.5375	9.5375	9.5375	9.5375	2800.0
2010-04-27 07:15:00	AAPL	Stock	9.5425	9.5425	9.5425	9.5425	2800.0
2010-04-27 07:19:00	AAPL	Stock	9.5411	9.5411	9.5411	9.5411	2800.0
2010-04-27 07:20:00	AAPL	Stock	9.5425	9.5425	9.5425	9.5425	2800.0
2010-04-27 07:21:00	AAPL	Stock	9.5457	9.5464	9.5457	9.5464	6944.0
2010-04-27 07:22:00	AAPL	Stock	9.5464	9.5536	9.5464	9.5532	72660.0
2010-04-27 07:23:00	AAPL	Stock	9.55	9.55	9.55	9.55	14756.0
2010-04-27 07:24:00	AAPL	Stock	9.55	9.55	9.55	9.55	14000.0
2010-04-27 07:35:00	AAPL	Stock	9.5479	9.5479	9.5479	9.5479	4200.0
2010-04-27 07:36:00	AAPL	Stock	9.5475	9.5482	9.5475	9.5482	8400.0
2010-04-27 07:38:00	AAPL	Stock	9.5561	9.5561	9.5561	9.5561	5600.0
2010-04-27 07:39:00	AAPL	Stock	9.5561	9.5561	9.5464	9.5464	19600.0
2010-04-27 07:40:00	AAPL	Stock	9.5464	9.5464	9.5464	9.5464	30800.0
2010-04-27 07:45:00	AAPL	Stock	9.5432	9.5432	9.5432	9.5432	14000.0
2010-04-27 07:46:00	AAPL	Stock	9.5443	9.5443	9.5443	9.5443	4732.0
2010-04-27 07:47:00	AAPL	Stock	9.5411	9.5411	9.5393	9.5404	53368.0
2010-04-27 07:48:00	AAPL	Stock	9.5357	9.5357	9.5357	9.5357	2800.0
2010-04-27 07:49:00	AAPL	Stock	9.55	9.55	9.5357	9.55	36400.0
2010-04-27 07:50:00	AAPL	Stock	9.55	9.55	9.55	9.55	14000.0
2010-04-27 07:53:00	AAPL	Stock	9.5429	9.5429	9.5429	9.5429	2800.0
2010-04-27 07:59:00	AAPL	Stock	9.5429	9.5571	9.5429	9.5571	18200.0
2010-04-27 08:00:00	AAPL	Stock	9.5479	9.5536	9.5446	9.55	158564.0
2010-04-27 08:01:00	AAPL	Stock	9.5525	9.5525	9.5461	9.55	38192.0
2010-04-27 08:02:00	AAPL	Stock	9.55	9.5579	9.55	9.5571	38948.0

> showing 50 of 1,041,918 rows — these rows as CSV

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