PREVIEW / stock_1min / 2009-06-18

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-06-18.parquet
  size:    12.3 MB
  rows:    940,030
  symbols: 2,714

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-18 07:28:00	AAPL	Stock	4.8454	4.8454	4.8454	4.8454	8400.0
2009-06-18 07:44:00	AAPL	Stock	4.8404	4.8404	4.8404	4.8404	14000.0
2009-06-18 07:48:00	AAPL	Stock	4.8368	4.8368	4.8368	4.8368	2800.0
2009-06-18 07:59:00	AAPL	Stock	4.8389	4.8389	4.8389	4.8389	28000.0
2009-06-18 08:00:00	AAPL	Stock	4.8393	4.8393	4.8296	4.8318	35588.0
2009-06-18 08:04:00	AAPL	Stock	4.8339	4.8339	4.8339	4.8339	2800.0
2009-06-18 08:07:00	AAPL	Stock	4.8364	4.8364	4.8364	4.8364	5600.0
2009-06-18 08:09:00	AAPL	Stock	4.8364	4.8364	4.8364	4.8364	17612.0
2009-06-18 08:10:00	AAPL	Stock	4.8339	4.8339	4.8339	4.8339	2800.0
2009-06-18 08:12:00	AAPL	Stock	4.8368	4.8368	4.8368	4.8368	14000.0
2009-06-18 08:14:00	AAPL	Stock	4.8375	4.8375	4.8375	4.8375	8400.0
2009-06-18 08:15:00	AAPL	Stock	4.8375	4.8375	4.8375	4.8375	2800.0
2009-06-18 08:19:00	AAPL	Stock	4.8375	4.8375	4.8375	4.8375	2800.0
2009-06-18 08:21:00	AAPL	Stock	4.8321	4.8321	4.8321	4.8321	8400.0
2009-06-18 08:22:00	AAPL	Stock	4.8321	4.8321	4.8321	4.8321	5376.0
2009-06-18 08:27:00	AAPL	Stock	4.8368	4.8368	4.8368	4.8368	2800.0
2009-06-18 08:30:00	AAPL	Stock	4.8375	4.8375	4.8375	4.8375	20748.0
2009-06-18 08:31:00	AAPL	Stock	4.8425	4.8425	4.8425	4.8425	25900.0
2009-06-18 08:32:00	AAPL	Stock	4.8425	4.8425	4.8425	4.8425	2800.0
2009-06-18 08:33:00	AAPL	Stock	4.8425	4.8425	4.8425	4.8425	14000.0
2009-06-18 08:34:00	AAPL	Stock	4.8425	4.8425	4.8421	4.8425	70700.0
2009-06-18 08:36:00	AAPL	Stock	4.8482	4.8482	4.8482	4.8482	10752.0
2009-06-18 08:37:00	AAPL	Stock	4.8464	4.8529	4.8464	4.8529	15708.0
2009-06-18 08:38:00	AAPL	Stock	4.8529	4.8571	4.8529	4.8571	28028.0
2009-06-18 08:40:00	AAPL	Stock	4.8568	4.8568	4.8482	4.8532	11200.0
2009-06-18 08:41:00	AAPL	Stock	4.8568	4.86	4.8539	4.8571	32060.0
2009-06-18 08:42:00	AAPL	Stock	4.8571	4.8571	4.8571	4.8571	2800.0
2009-06-18 08:43:00	AAPL	Stock	4.8568	4.8571	4.8557	4.8571	11200.0
2009-06-18 08:44:00	AAPL	Stock	4.8582	4.8582	4.8571	4.8582	39200.0
2009-06-18 08:45:00	AAPL	Stock	4.8582	4.8582	4.8582	4.8582	2800.0
2009-06-18 08:46:00	AAPL	Stock	4.8571	4.8571	4.8561	4.8561	15400.0
2009-06-18 08:47:00	AAPL	Stock	4.8561	4.8582	4.8561	4.8582	30800.0
2009-06-18 08:48:00	AAPL	Stock	4.8582	4.8582	4.855	4.8571	18340.0
2009-06-18 08:49:00	AAPL	Stock	4.8589	4.8607	4.8589	4.8607	16800.0
2009-06-18 08:51:00	AAPL	Stock	4.8611	4.8625	4.8611	4.8625	19600.0
2009-06-18 08:52:00	AAPL	Stock	4.8625	4.865	4.8625	4.8625	27300.0
2009-06-18 08:53:00	AAPL	Stock	4.8607	4.8607	4.8596	4.8596	32900.0
2009-06-18 08:54:00	AAPL	Stock	4.8571	4.8643	4.8571	4.8643	32424.0
2009-06-18 08:55:00	AAPL	Stock	4.8596	4.8596	4.8596	4.8596	4340.0
2009-06-18 08:57:00	AAPL	Stock	4.8639	4.8639	4.8639	4.8639	11200.0
2009-06-18 08:58:00	AAPL	Stock	4.8639	4.8661	4.8639	4.8661	25200.0
2009-06-18 09:00:00	AAPL	Stock	4.8639	4.8639	4.8639	4.8639	5320.0
2009-06-18 09:01:00	AAPL	Stock	4.8639	4.8639	4.8639	4.8639	8680.0
2009-06-18 09:03:00	AAPL	Stock	4.8632	4.8643	4.8625	4.8625	39200.0
2009-06-18 09:04:00	AAPL	Stock	4.8614	4.8614	4.8614	4.8614	2800.0
2009-06-18 09:05:00	AAPL	Stock	4.8614	4.8618	4.8614	4.8618	10696.0
2009-06-18 09:09:00	AAPL	Stock	4.8614	4.8625	4.8614	4.8614	19600.0
2009-06-18 09:10:00	AAPL	Stock	4.8614	4.8614	4.8607	4.8607	21840.0
2009-06-18 09:13:00	AAPL	Stock	4.8636	4.8643	4.8636	4.8639	55020.0
2009-06-18 09:14:00	AAPL	Stock	4.8639	4.8643	4.8639	4.8643	16800.0

> showing 50 of 940,030 rows — these rows as CSV

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