PREVIEW / stock_1min / 2009-09-18

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-09-18.parquet
  size:    13.1 MB
  rows:    994,477
  symbols: 2,765

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-09-18 06:33:00	AAPL	Stock	6.5714	6.5714	6.5714	6.5714	13944.0
2009-09-18 06:48:00	AAPL	Stock	6.5796	6.6071	6.5543	6.6071	123200.0
2009-09-18 06:49:00	AAPL	Stock	6.6068	6.6214	6.6068	6.6214	28000.0
2009-09-18 06:51:00	AAPL	Stock	6.6071	6.6214	6.6071	6.6189	84000.0
2009-09-18 06:53:00	AAPL	Stock	6.6207	6.6207	6.6207	6.6207	5600.0
2009-09-18 06:56:00	AAPL	Stock	6.6071	6.6071	6.6071	6.6071	47600.0
2009-09-18 06:57:00	AAPL	Stock	6.6107	6.6161	6.6107	6.6143	70000.0
2009-09-18 07:03:00	AAPL	Stock	6.6054	6.6054	6.605	6.6054	16800.0
2009-09-18 07:04:00	AAPL	Stock	6.6054	6.6054	6.6054	6.6054	5600.0
2009-09-18 07:05:00	AAPL	Stock	6.6036	6.6036	6.6036	6.6036	8400.0
2009-09-18 07:06:00	AAPL	Stock	6.6036	6.6036	6.6036	6.6036	5600.0
2009-09-18 07:07:00	AAPL	Stock	6.6114	6.6118	6.6114	6.6118	47600.0
2009-09-18 07:08:00	AAPL	Stock	6.6118	6.6118	6.6107	6.6118	8400.0
2009-09-18 07:09:00	AAPL	Stock	6.6118	6.6143	6.6118	6.6143	66136.0
2009-09-18 07:10:00	AAPL	Stock	6.6182	6.6182	6.6182	6.6182	8400.0
2009-09-18 07:11:00	AAPL	Stock	6.6118	6.6118	6.6118	6.6118	27300.0
2009-09-18 07:13:00	AAPL	Stock	6.6125	6.6125	6.6118	6.6118	16800.0
2009-09-18 07:15:00	AAPL	Stock	6.6118	6.6118	6.6118	6.6118	5600.0
2009-09-18 07:16:00	AAPL	Stock	6.6071	6.6071	6.6071	6.6071	140000.0
2009-09-18 07:18:00	AAPL	Stock	6.6043	6.6043	6.6043	6.6043	2800.0
2009-09-18 07:21:00	AAPL	Stock	6.6036	6.6036	6.6036	6.6036	2800.0
2009-09-18 07:29:00	AAPL	Stock	6.6036	6.6036	6.6036	6.6036	11200.0
2009-09-18 07:38:00	AAPL	Stock	6.5993	6.6071	6.5993	6.6046	15400.0
2009-09-18 07:39:00	AAPL	Stock	6.6071	6.6118	6.6071	6.6118	53200.0
2009-09-18 07:41:00	AAPL	Stock	6.6171	6.625	6.6171	6.6229	84000.0
2009-09-18 07:42:00	AAPL	Stock	6.6204	6.6204	6.6193	6.6196	25200.0
2009-09-18 07:44:00	AAPL	Stock	6.6086	6.6086	6.6086	6.6086	3080.0
2009-09-18 07:47:00	AAPL	Stock	6.6089	6.6089	6.6089	6.6089	5600.0
2009-09-18 07:54:00	AAPL	Stock	6.6164	6.6164	6.6164	6.6164	5600.0
2009-09-18 07:56:00	AAPL	Stock	6.6089	6.6089	6.6089	6.6089	2800.0
2009-09-18 07:58:00	AAPL	Stock	6.6089	6.6125	6.6089	6.6125	9800.0
2009-09-18 08:00:00	AAPL	Stock	6.6082	6.6157	6.5936	6.6036	153384.0
2009-09-18 08:01:00	AAPL	Stock	6.6043	6.6107	6.5968	6.6107	124180.0
2009-09-18 08:02:00	AAPL	Stock	6.6071	6.6079	6.6057	6.6075	87528.0
2009-09-18 08:03:00	AAPL	Stock	6.6104	6.6104	6.6075	6.6075	7000.0
2009-09-18 08:04:00	AAPL	Stock	6.6125	6.6182	6.6107	6.6107	233660.0
2009-09-18 08:05:00	AAPL	Stock	6.6107	6.6143	6.6107	6.6139	46200.0
2009-09-18 08:06:00	AAPL	Stock	6.6143	6.6143	6.6143	6.6143	25200.0
2009-09-18 08:07:00	AAPL	Stock	6.6143	6.6143	6.6143	6.6143	16800.0
2009-09-18 08:08:00	AAPL	Stock	6.6157	6.6157	6.6111	6.6125	28924.0
2009-09-18 08:09:00	AAPL	Stock	6.6132	6.6179	6.6129	6.6143	177716.0
2009-09-18 08:10:00	AAPL	Stock	6.6157	6.6179	6.6139	6.6161	91252.0
2009-09-18 08:11:00	AAPL	Stock	6.6161	6.6161	6.615	6.615	49000.0
2009-09-18 08:12:00	AAPL	Stock	6.6157	6.6161	6.6129	6.6161	98000.0
2009-09-18 08:13:00	AAPL	Stock	6.6157	6.6157	6.6143	6.6143	19600.0
2009-09-18 08:14:00	AAPL	Stock	6.6114	6.6143	6.6107	6.6143	44800.0
2009-09-18 08:15:00	AAPL	Stock	6.6143	6.6143	6.6104	6.6107	92540.0
2009-09-18 08:16:00	AAPL	Stock	6.6107	6.6107	6.6089	6.6089	33600.0
2009-09-18 08:17:00	AAPL	Stock	6.6093	6.6093	6.6071	6.6089	83804.0
2009-09-18 08:18:00	AAPL	Stock	6.6089	6.6089	6.6071	6.6071	57820.0

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

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