PREVIEW / stock_1min / 2012-04-25

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-04-25.parquet
  size:    13.2 MB
  rows:    994,728
  symbols: 2,855

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
2012-04-25 04:00:00	AAPL	Stock	21.5643	21.7857	21.5643	21.7854	53732.0
2012-04-25 04:01:00	AAPL	Stock	21.7854	21.7854	21.785	21.785	11200.0
2012-04-25 04:02:00	AAPL	Stock	21.7796	21.8068	21.7796	21.8068	11900.0
2012-04-25 04:03:00	AAPL	Stock	21.8171	21.8214	21.8168	21.8211	14000.0
2012-04-25 04:04:00	AAPL	Stock	21.8068	21.8068	21.7857	21.7857	41720.0
2012-04-25 04:05:00	AAPL	Stock	21.7857	21.7857	21.7857	21.7857	14000.0
2012-04-25 04:06:00	AAPL	Stock	21.8121	21.8214	21.8071	21.8071	44800.0
2012-04-25 04:07:00	AAPL	Stock	21.8211	21.8211	21.8211	21.8211	2800.0
2012-04-25 04:12:00	AAPL	Stock	21.8264	21.8304	21.8264	21.8304	11200.0
2012-04-25 04:13:00	AAPL	Stock	21.8393	21.8393	21.8393	21.8393	2800.0
2012-04-25 04:15:00	AAPL	Stock	21.8407	21.855	21.8407	21.855	14000.0
2012-04-25 04:17:00	AAPL	Stock	21.8536	21.8536	21.8536	21.8536	5600.0
2012-04-25 04:19:00	AAPL	Stock	21.8546	21.8636	21.8546	21.8636	22400.0
2012-04-25 04:20:00	AAPL	Stock	21.8704	21.8782	21.8704	21.8761	14868.0
2012-04-25 04:22:00	AAPL	Stock	21.8571	21.8571	21.8571	21.8571	2800.0
2012-04-25 04:25:00	AAPL	Stock	21.8786	21.8786	21.8725	21.8725	5600.0
2012-04-25 04:28:00	AAPL	Stock	21.8743	21.8796	21.8743	21.8786	19040.0
2012-04-25 04:29:00	AAPL	Stock	21.8782	21.8786	21.8782	21.8786	5600.0
2012-04-25 04:30:00	AAPL	Stock	21.8746	21.8782	21.8693	21.8782	14000.0
2012-04-25 04:31:00	AAPL	Stock	21.875	21.875	21.8711	21.8711	18200.0
2012-04-25 04:32:00	AAPL	Stock	21.8643	21.8743	21.8643	21.8743	14000.0
2012-04-25 04:33:00	AAPL	Stock	21.8629	21.8646	21.8629	21.8646	5600.0
2012-04-25 04:34:00	AAPL	Stock	21.8643	21.8643	21.8457	21.8532	56000.0
2012-04-25 04:35:00	AAPL	Stock	21.8429	21.8429	21.8429	21.8429	5600.0
2012-04-25 04:36:00	AAPL	Stock	21.8393	21.8539	21.8393	21.8393	29400.0
2012-04-25 04:37:00	AAPL	Stock	21.8496	21.8532	21.8496	21.8496	89600.0
2012-04-25 04:38:00	AAPL	Stock	21.8514	21.8514	21.8514	21.8514	156380.0
2012-04-25 04:39:00	AAPL	Stock	21.8514	21.8518	21.8514	21.8518	112000.0
2012-04-25 04:40:00	AAPL	Stock	21.8518	21.8518	21.8464	21.8468	124572.0
2012-04-25 04:41:00	AAPL	Stock	21.8518	21.8539	21.8518	21.8539	230132.0
2012-04-25 04:42:00	AAPL	Stock	21.8686	21.8686	21.8686	21.8686	140000.0
2012-04-25 04:43:00	AAPL	Stock	21.8611	21.8611	21.8571	21.8571	38416.0
2012-04-25 04:44:00	AAPL	Stock	21.8657	21.8657	21.8571	21.8571	11200.0
2012-04-25 04:46:00	AAPL	Stock	21.8575	21.8575	21.8575	21.8575	2800.0
2012-04-25 04:47:00	AAPL	Stock	21.8554	21.8554	21.8554	21.8554	25564.0
2012-04-25 04:48:00	AAPL	Stock	21.8632	21.8632	21.8632	21.8632	2800.0
2012-04-25 04:49:00	AAPL	Stock	21.8539	21.8539	21.8539	21.8539	11816.0
2012-04-25 04:50:00	AAPL	Stock	21.8611	21.8611	21.8611	21.8611	2800.0
2012-04-25 04:51:00	AAPL	Stock	21.8636	21.8636	21.8636	21.8636	27020.0
2012-04-25 04:54:00	AAPL	Stock	21.855	21.855	21.8539	21.8539	12600.0
2012-04-25 04:55:00	AAPL	Stock	21.8539	21.8539	21.8539	21.8539	5600.0
2012-04-25 04:56:00	AAPL	Stock	21.8625	21.8632	21.8625	21.8632	27356.0
2012-04-25 04:57:00	AAPL	Stock	21.8686	21.8686	21.8632	21.8632	22400.0
2012-04-25 04:58:00	AAPL	Stock	21.8632	21.8679	21.8632	21.8679	11200.0
2012-04-25 04:59:00	AAPL	Stock	21.8686	21.8686	21.8686	21.8686	16800.0
2012-04-25 05:00:00	AAPL	Stock	21.8686	21.8686	21.8686	21.8686	14000.0
2012-04-25 05:01:00	AAPL	Stock	21.8686	21.8686	21.8686	21.8686	8400.0
2012-04-25 05:02:00	AAPL	Stock	21.8682	21.8743	21.8536	21.8536	32620.0
2012-04-25 05:03:00	AAPL	Stock	21.8571	21.8604	21.8571	21.8571	8400.0
2012-04-25 05:05:00	AAPL	Stock	21.8732	21.8732	21.8732	21.8732	27468.0

> showing 50 of 994,728 rows — these rows as CSV

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