PREVIEW / stock_1min / 2009-09-29

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-09-29.parquet
  size:    12.4 MB
  rows:    941,907
  symbols: 2,771

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-29 07:36:00	AAPL	Stock	6.6568	6.6571	6.6568	6.6571	23940.0
2009-09-29 07:37:00	AAPL	Stock	6.6571	6.6571	6.6571	6.6571	5600.0
2009-09-29 07:39:00	AAPL	Stock	6.6643	6.6643	6.6643	6.6643	2800.0
2009-09-29 07:46:00	AAPL	Stock	6.6607	6.6607	6.6571	6.6571	24780.0
2009-09-29 07:54:00	AAPL	Stock	6.6568	6.6568	6.6568	6.6568	2800.0
2009-09-29 07:57:00	AAPL	Stock	6.6446	6.6454	6.6446	6.6454	5600.0
2009-09-29 07:58:00	AAPL	Stock	6.6482	6.6482	6.6482	6.6482	2800.0
2009-09-29 07:59:00	AAPL	Stock	6.6482	6.6482	6.6482	6.6482	8400.0
2009-09-29 08:00:00	AAPL	Stock	6.6482	6.6554	6.6482	6.6482	27300.0
2009-09-29 08:01:00	AAPL	Stock	6.6482	6.6482	6.6482	6.6482	17612.0
2009-09-29 08:02:00	AAPL	Stock	6.6543	6.6546	6.6543	6.6546	11060.0
2009-09-29 08:03:00	AAPL	Stock	6.6546	6.6575	6.6489	6.6493	46620.0
2009-09-29 08:04:00	AAPL	Stock	6.6486	6.6486	6.6486	6.6486	2800.0
2009-09-29 08:06:00	AAPL	Stock	6.65	6.65	6.65	6.65	11200.0
2009-09-29 08:07:00	AAPL	Stock	6.6507	6.6507	6.6507	6.6507	4200.0
2009-09-29 08:15:00	AAPL	Stock	6.655	6.6557	6.655	6.6557	12320.0
2009-09-29 08:17:00	AAPL	Stock	6.6532	6.6532	6.6532	6.6532	5600.0
2009-09-29 08:18:00	AAPL	Stock	6.6514	6.6532	6.6514	6.6532	7000.0
2009-09-29 08:19:00	AAPL	Stock	6.6536	6.655	6.6536	6.655	16800.0
2009-09-29 08:20:00	AAPL	Stock	6.655	6.6557	6.655	6.6557	30800.0
2009-09-29 08:23:00	AAPL	Stock	6.6561	6.6618	6.6561	6.6618	8400.0
2009-09-29 08:24:00	AAPL	Stock	6.6611	6.6618	6.6611	6.6618	17640.0
2009-09-29 08:25:00	AAPL	Stock	6.6643	6.6643	6.6607	6.6607	18900.0
2009-09-29 08:26:00	AAPL	Stock	6.6607	6.6607	6.6607	6.6607	11200.0
2009-09-29 08:27:00	AAPL	Stock	6.6632	6.6632	6.6589	6.6589	7000.0
2009-09-29 08:28:00	AAPL	Stock	6.6579	6.6579	6.6571	6.6571	11200.0
2009-09-29 08:31:00	AAPL	Stock	6.6571	6.6571	6.6571	6.6571	8400.0
2009-09-29 08:32:00	AAPL	Stock	6.6579	6.6579	6.6579	6.6579	2800.0
2009-09-29 08:33:00	AAPL	Stock	6.6571	6.6571	6.6571	6.6571	2800.0
2009-09-29 08:38:00	AAPL	Stock	6.6554	6.6554	6.6554	6.6554	2800.0
2009-09-29 08:39:00	AAPL	Stock	6.6539	6.6539	6.6514	6.6514	24584.0
2009-09-29 08:40:00	AAPL	Stock	6.6504	6.6504	6.65	6.6504	11200.0
2009-09-29 08:41:00	AAPL	Stock	6.6482	6.6504	6.6482	6.6504	42000.0
2009-09-29 08:42:00	AAPL	Stock	6.6525	6.6525	6.6496	6.65	47600.0
2009-09-29 08:43:00	AAPL	Stock	6.6525	6.6525	6.65	6.6518	19600.0
2009-09-29 08:46:00	AAPL	Stock	6.6518	6.6518	6.6518	6.6518	14000.0
2009-09-29 08:47:00	AAPL	Stock	6.6546	6.6554	6.6529	6.6554	87360.0
2009-09-29 08:48:00	AAPL	Stock	6.6568	6.6568	6.655	6.6554	14000.0
2009-09-29 08:50:00	AAPL	Stock	6.6521	6.6521	6.6511	6.6511	30240.0
2009-09-29 08:54:00	AAPL	Stock	6.6536	6.6536	6.6486	6.6486	35280.0
2009-09-29 08:55:00	AAPL	Stock	6.6482	6.65	6.6482	6.65	19600.0
2009-09-29 08:56:00	AAPL	Stock	6.6486	6.6486	6.6486	6.6486	2800.0
2009-09-29 08:57:00	AAPL	Stock	6.6471	6.6471	6.6464	6.6471	30100.0
2009-09-29 08:58:00	AAPL	Stock	6.6493	6.6496	6.6471	6.6471	13972.0
2009-09-29 08:59:00	AAPL	Stock	6.6475	6.6504	6.6461	6.6461	30576.0
2009-09-29 09:00:00	AAPL	Stock	6.6504	6.6543	6.6504	6.6543	22344.0
2009-09-29 09:01:00	AAPL	Stock	6.6546	6.6546	6.6546	6.6546	8400.0
2009-09-29 09:02:00	AAPL	Stock	6.6525	6.6525	6.6521	6.6521	11956.0
2009-09-29 09:03:00	AAPL	Stock	6.6521	6.6532	6.6521	6.6532	5600.0
2009-09-29 09:04:00	AAPL	Stock	6.6525	6.6571	6.6525	6.6554	137340.0

> showing 50 of 941,907 rows — these rows as CSV

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