PREVIEW / stock_1min / 2009-06-15

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-06-15.parquet
  size:    12.8 MB
  rows:    985,827
  symbols: 2,713

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-06-15 07:28:00	AAPL	Stock	4.8561	4.8561	4.8561	4.8561	2800.0
2009-06-15 07:43:00	AAPL	Stock	4.8393	4.8393	4.8393	4.8393	2800.0
2009-06-15 07:49:00	AAPL	Stock	4.8432	4.8432	4.8432	4.8432	2800.0
2009-06-15 07:56:00	AAPL	Stock	4.8518	4.8532	4.8518	4.8532	16800.0
2009-06-15 07:57:00	AAPL	Stock	4.8564	4.8564	4.8536	4.8536	11648.0
2009-06-15 07:58:00	AAPL	Stock	4.8468	4.8468	4.8468	4.8468	2800.0
2009-06-15 07:59:00	AAPL	Stock	4.8471	4.8471	4.8471	4.8471	16800.0
2009-06-15 08:00:00	AAPL	Stock	4.8536	4.8568	4.8414	4.8414	183176.0
2009-06-15 08:02:00	AAPL	Stock	4.8443	4.8443	4.8332	4.8332	94304.0
2009-06-15 08:03:00	AAPL	Stock	4.8286	4.8311	4.8286	4.8304	37100.0
2009-06-15 08:04:00	AAPL	Stock	4.8304	4.8304	4.8268	4.8271	24920.0
2009-06-15 08:05:00	AAPL	Stock	4.8271	4.8271	4.8214	4.825	93156.0
2009-06-15 08:06:00	AAPL	Stock	4.825	4.825	4.8225	4.8225	22400.0
2009-06-15 08:07:00	AAPL	Stock	4.8257	4.8296	4.8254	4.8286	39060.0
2009-06-15 08:08:00	AAPL	Stock	4.8286	4.8296	4.8286	4.8286	41440.0
2009-06-15 08:09:00	AAPL	Stock	4.83	4.8307	4.83	4.8307	61600.0
2009-06-15 08:10:00	AAPL	Stock	4.8321	4.8321	4.8304	4.8304	24500.0
2009-06-15 08:11:00	AAPL	Stock	4.8311	4.8311	4.8286	4.8307	74480.0
2009-06-15 08:12:00	AAPL	Stock	4.8343	4.8343	4.8264	4.8264	11200.0
2009-06-15 08:13:00	AAPL	Stock	4.8257	4.8257	4.8232	4.8232	37660.0
2009-06-15 08:14:00	AAPL	Stock	4.8232	4.8232	4.8211	4.8211	92932.0
2009-06-15 08:15:00	AAPL	Stock	4.8214	4.825	4.8182	4.825	116200.0
2009-06-15 08:16:00	AAPL	Stock	4.825	4.825	4.825	4.825	27160.0
2009-06-15 08:17:00	AAPL	Stock	4.8264	4.8264	4.8264	4.8264	2800.0
2009-06-15 08:18:00	AAPL	Stock	4.8254	4.8254	4.825	4.825	18200.0
2009-06-15 08:19:00	AAPL	Stock	4.8246	4.8246	4.8246	4.8246	5600.0
2009-06-15 08:20:00	AAPL	Stock	4.8225	4.8311	4.8225	4.8311	74452.0
2009-06-15 08:21:00	AAPL	Stock	4.8325	4.8375	4.8257	4.8375	78400.0
2009-06-15 08:22:00	AAPL	Stock	4.8332	4.8332	4.8321	4.8321	8400.0
2009-06-15 08:23:00	AAPL	Stock	4.8339	4.8357	4.8339	4.8357	32200.0
2009-06-15 08:24:00	AAPL	Stock	4.8375	4.8389	4.8375	4.8389	33600.0
2009-06-15 08:25:00	AAPL	Stock	4.8421	4.8429	4.84	4.84	19180.0
2009-06-15 08:26:00	AAPL	Stock	4.84	4.8429	4.84	4.8429	11480.0
2009-06-15 08:27:00	AAPL	Stock	4.8443	4.8468	4.8439	4.8464	95508.0
2009-06-15 08:28:00	AAPL	Stock	4.8468	4.8468	4.8468	4.8468	2800.0
2009-06-15 08:29:00	AAPL	Stock	4.8468	4.8468	4.8468	4.8468	2800.0
2009-06-15 08:30:00	AAPL	Stock	4.8468	4.8468	4.8464	4.8464	56000.0
2009-06-15 08:31:00	AAPL	Stock	4.8464	4.8464	4.8432	4.8432	25228.0
2009-06-15 08:32:00	AAPL	Stock	4.8432	4.8432	4.8432	4.8432	19600.0
2009-06-15 08:33:00	AAPL	Stock	4.8432	4.8432	4.8432	4.8432	14000.0
2009-06-15 08:34:00	AAPL	Stock	4.8439	4.8468	4.8432	4.8468	20160.0
2009-06-15 08:35:00	AAPL	Stock	4.8464	4.8493	4.8436	4.8436	17080.0
2009-06-15 08:36:00	AAPL	Stock	4.8446	4.8446	4.8432	4.8432	11200.0
2009-06-15 08:38:00	AAPL	Stock	4.8432	4.8464	4.8432	4.8464	16800.0
2009-06-15 08:39:00	AAPL	Stock	4.8464	4.8486	4.8464	4.8486	19600.0
2009-06-15 08:40:00	AAPL	Stock	4.8479	4.8479	4.8446	4.8446	18200.0
2009-06-15 08:41:00	AAPL	Stock	4.845	4.8468	4.8446	4.8446	50400.0
2009-06-15 08:42:00	AAPL	Stock	4.8464	4.8504	4.8464	4.8504	64400.0
2009-06-15 08:43:00	AAPL	Stock	4.8507	4.8536	4.8507	4.8529	64400.0
2009-06-15 08:44:00	AAPL	Stock	4.85	4.85	4.8486	4.8486	19600.0

> showing 50 of 985,827 rows — these rows as CSV

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