PREVIEW / stock_1min / 2009-06-19

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-06-19.parquet
  size:    12.4 MB
  rows:    951,034
  symbols: 2,704

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-19 04:32:00	AAPL	Stock	4.8871	4.8871	4.8871	4.8871	2800.0
2009-06-19 07:05:00	AAPL	Stock	4.9207	4.9207	4.9207	4.9207	8400.0
2009-06-19 07:11:00	AAPL	Stock	4.9218	4.9218	4.9218	4.9218	3500.0
2009-06-19 07:14:00	AAPL	Stock	4.8843	4.8843	4.8843	4.8843	2800.0
2009-06-19 07:28:00	AAPL	Stock	4.9075	4.9107	4.9075	4.9107	82600.0
2009-06-19 07:29:00	AAPL	Stock	4.9107	4.9107	4.9107	4.9107	14000.0
2009-06-19 07:31:00	AAPL	Stock	4.9036	4.9107	4.9036	4.9107	56000.0
2009-06-19 07:33:00	AAPL	Stock	4.9071	4.9071	4.9071	4.9071	2800.0
2009-06-19 07:34:00	AAPL	Stock	4.9071	4.9071	4.9071	4.9071	24500.0
2009-06-19 07:35:00	AAPL	Stock	4.9104	4.9104	4.9104	4.9104	2800.0
2009-06-19 07:38:00	AAPL	Stock	4.9104	4.9104	4.9104	4.9104	2800.0
2009-06-19 07:43:00	AAPL	Stock	4.91	4.9107	4.91	4.9107	22400.0
2009-06-19 07:45:00	AAPL	Stock	4.9086	4.9107	4.9086	4.9107	5600.0
2009-06-19 07:46:00	AAPL	Stock	4.9107	4.9107	4.9107	4.9107	37800.0
2009-06-19 07:47:00	AAPL	Stock	4.9193	4.9193	4.9193	4.9193	2800.0
2009-06-19 07:48:00	AAPL	Stock	4.9118	4.9118	4.9118	4.9118	8400.0
2009-06-19 07:50:00	AAPL	Stock	4.9121	4.9121	4.9121	4.9121	68908.0
2009-06-19 07:51:00	AAPL	Stock	4.9121	4.9121	4.9121	4.9121	68292.0
2009-06-19 07:55:00	AAPL	Stock	4.9132	4.9132	4.9129	4.9132	19600.0
2009-06-19 07:56:00	AAPL	Stock	4.9132	4.9132	4.9132	4.9132	46760.0
2009-06-19 07:57:00	AAPL	Stock	4.9154	4.9161	4.9132	4.9132	47320.0
2009-06-19 07:58:00	AAPL	Stock	4.9132	4.9132	4.9132	4.9132	97300.0
2009-06-19 07:59:00	AAPL	Stock	4.9132	4.9132	4.9132	4.9132	16800.0
2009-06-19 08:00:00	AAPL	Stock	4.9132	4.9161	4.9132	4.9161	136248.0
2009-06-19 08:01:00	AAPL	Stock	4.9154	4.9204	4.9154	4.9168	55440.0
2009-06-19 08:03:00	AAPL	Stock	4.9189	4.9236	4.9175	4.9232	130200.0
2009-06-19 08:04:00	AAPL	Stock	4.92	4.92	4.9154	4.9154	126840.0
2009-06-19 08:05:00	AAPL	Stock	4.9154	4.9161	4.9154	4.9161	18340.0
2009-06-19 08:06:00	AAPL	Stock	4.9143	4.9143	4.9143	4.9143	9828.0
2009-06-19 08:07:00	AAPL	Stock	4.915	4.9179	4.915	4.9179	154700.0
2009-06-19 08:08:00	AAPL	Stock	4.9182	4.9214	4.9179	4.9179	182000.0
2009-06-19 08:09:00	AAPL	Stock	4.9196	4.9214	4.9179	4.9179	119560.0
2009-06-19 08:10:00	AAPL	Stock	4.9196	4.9225	4.9196	4.9214	85400.0
2009-06-19 08:11:00	AAPL	Stock	4.9196	4.9221	4.9196	4.9221	63000.0
2009-06-19 08:12:00	AAPL	Stock	4.9225	4.9236	4.9221	4.9236	67340.0
2009-06-19 08:13:00	AAPL	Stock	4.9232	4.9232	4.9232	4.9232	2800.0
2009-06-19 08:14:00	AAPL	Stock	4.9214	4.9214	4.9214	4.9214	8400.0
2009-06-19 08:15:00	AAPL	Stock	4.9204	4.9204	4.9204	4.9204	2800.0
2009-06-19 08:16:00	AAPL	Stock	4.9171	4.9171	4.9171	4.9171	2800.0
2009-06-19 08:18:00	AAPL	Stock	4.9211	4.9229	4.9211	4.9221	84000.0
2009-06-19 08:19:00	AAPL	Stock	4.9221	4.9221	4.9221	4.9221	2800.0
2009-06-19 08:20:00	AAPL	Stock	4.9196	4.9196	4.9196	4.9196	13860.0
2009-06-19 08:21:00	AAPL	Stock	4.9229	4.9264	4.9229	4.9264	280000.0
2009-06-19 08:22:00	AAPL	Stock	4.9275	4.9282	4.9275	4.9279	24220.0
2009-06-19 08:23:00	AAPL	Stock	4.9275	4.9286	4.9264	4.9282	271180.0
2009-06-19 08:24:00	AAPL	Stock	4.9279	4.9282	4.9243	4.9282	167160.0
2009-06-19 08:25:00	AAPL	Stock	4.9286	4.9286	4.9257	4.9275	57120.0
2009-06-19 08:26:00	AAPL	Stock	4.9271	4.9286	4.9271	4.9286	51100.0
2009-06-19 08:27:00	AAPL	Stock	4.9286	4.9304	4.925	4.9304	95200.0
2009-06-19 08:28:00	AAPL	Stock	4.9293	4.935	4.9293	4.935	85820.0

> showing 50 of 951,034 rows — these rows as CSV

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