PREVIEW / stock_1min / 2009-09-01

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-09-01.parquet
  size:    13.8 MB
  rows:    1,035,294
  symbols: 2,746

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-01 04:56:00	AAPL	Stock	6.0282	6.0282	6.0282	6.0282	2800.0
2009-09-01 05:28:00	AAPL	Stock	5.9489	5.9489	5.9489	5.9489	2800.0
2009-09-01 06:23:00	AAPL	Stock	5.9143	5.9286	5.9143	5.9286	5600.0
2009-09-01 06:24:00	AAPL	Stock	5.9286	5.9286	5.9286	5.9286	2800.0
2009-09-01 06:25:00	AAPL	Stock	5.9143	5.9286	5.9143	5.9286	5600.0
2009-09-01 06:26:00	AAPL	Stock	5.9357	5.9357	5.9357	5.9357	5600.0
2009-09-01 06:27:00	AAPL	Stock	5.9304	5.9304	5.9304	5.9304	2800.0
2009-09-01 06:34:00	AAPL	Stock	5.9321	5.9321	5.9321	5.9321	2800.0
2009-09-01 06:43:00	AAPL	Stock	5.9289	5.9289	5.9289	5.9289	2800.0
2009-09-01 06:45:00	AAPL	Stock	5.9286	5.9286	5.9286	5.9286	5600.0
2009-09-01 07:08:00	AAPL	Stock	5.9621	5.9643	5.9621	5.9643	24024.0
2009-09-01 07:10:00	AAPL	Stock	5.9643	5.9643	5.9643	5.9643	11228.0
2009-09-01 07:23:00	AAPL	Stock	5.9571	5.9571	5.9571	5.9571	7560.0
2009-09-01 07:24:00	AAPL	Stock	5.9643	5.9696	5.9611	5.9696	27328.0
2009-09-01 07:25:00	AAPL	Stock	5.9821	5.9821	5.9821	5.9821	5600.0
2009-09-01 07:30:00	AAPL	Stock	5.9786	5.9786	5.9786	5.9786	2800.0
2009-09-01 07:36:00	AAPL	Stock	5.98	5.9911	5.98	5.98	14000.0
2009-09-01 07:38:00	AAPL	Stock	5.9871	5.9871	5.9871	5.9871	4648.0
2009-09-01 07:56:00	AAPL	Stock	5.9786	6.0	5.9786	5.9821	17500.0
2009-09-01 07:57:00	AAPL	Stock	5.9821	5.9821	5.9821	5.9821	43708.0
2009-09-01 07:59:00	AAPL	Stock	5.9725	5.9725	5.9725	5.9725	2800.0
2009-09-01 08:00:00	AAPL	Stock	5.9871	5.9961	5.9786	5.9961	53200.0
2009-09-01 08:01:00	AAPL	Stock	5.9893	6.0075	5.9893	5.9929	730268.0
2009-09-01 08:03:00	AAPL	Stock	5.9896	5.9896	5.9875	5.9875	8400.0
2009-09-01 08:04:00	AAPL	Stock	5.9925	5.9929	5.9925	5.9929	15960.0
2009-09-01 08:05:00	AAPL	Stock	5.9954	5.9964	5.9954	5.9964	9604.0
2009-09-01 08:07:00	AAPL	Stock	5.9964	5.9964	5.9964	5.9964	25648.0
2009-09-01 08:08:00	AAPL	Stock	5.9954	6.0	5.9954	6.0	24164.0
2009-09-01 08:09:00	AAPL	Stock	6.0036	6.0057	6.0036	6.0054	54600.0
2009-09-01 08:10:00	AAPL	Stock	6.0064	6.0089	6.0064	6.0089	21280.0
2009-09-01 08:11:00	AAPL	Stock	6.0093	6.0093	6.0093	6.0093	14000.0
2009-09-01 08:12:00	AAPL	Stock	6.0139	6.0189	6.0139	6.0189	30800.0
2009-09-01 08:13:00	AAPL	Stock	6.0179	6.0211	6.0179	6.0211	16800.0
2009-09-01 08:14:00	AAPL	Stock	6.0211	6.0214	6.0211	6.0211	24528.0
2009-09-01 08:15:00	AAPL	Stock	6.0179	6.0179	6.0179	6.0179	2800.0
2009-09-01 08:20:00	AAPL	Stock	6.0132	6.0168	6.0132	6.0143	35000.0
2009-09-01 08:22:00	AAPL	Stock	6.0096	6.0154	6.0093	6.0154	57680.0
2009-09-01 08:23:00	AAPL	Stock	6.0125	6.0179	6.0125	6.0179	16520.0
2009-09-01 08:24:00	AAPL	Stock	6.0154	6.0154	6.0143	6.0143	17500.0
2009-09-01 08:25:00	AAPL	Stock	6.0143	6.0143	6.0143	6.0143	5600.0
2009-09-01 08:27:00	AAPL	Stock	6.0111	6.0143	6.0111	6.0143	5600.0
2009-09-01 08:29:00	AAPL	Stock	6.0107	6.0107	6.0036	6.0036	25984.0
2009-09-01 08:33:00	AAPL	Stock	6.0061	6.0061	6.0004	6.0004	8400.0
2009-09-01 08:35:00	AAPL	Stock	6.0057	6.0057	6.0057	6.0057	5600.0
2009-09-01 08:37:00	AAPL	Stock	6.0086	6.0086	6.0086	6.0086	2800.0
2009-09-01 08:38:00	AAPL	Stock	6.0071	6.0086	6.0071	6.0086	39200.0
2009-09-01 08:39:00	AAPL	Stock	6.0061	6.0061	6.0057	6.0057	14000.0
2009-09-01 08:40:00	AAPL	Stock	6.0071	6.0179	6.0071	6.0179	186032.0
2009-09-01 08:41:00	AAPL	Stock	6.0146	6.0146	6.0025	6.0143	139272.0
2009-09-01 08:43:00	AAPL	Stock	6.0107	6.0107	6.0107	6.0107	2800.0

> showing 50 of 1,035,294 rows — these rows as CSV

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