PREVIEW / stock_1min / 2009-04-16

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-04-16.parquet
  size:    12.5 MB
  rows:    949,650
  symbols: 2,713

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-04-16 07:32:00	AAPL	Stock	4.1961	4.1961	4.1961	4.1961	5600.0
2009-04-16 08:00:00	AAPL	Stock	4.1961	4.1982	4.1961	4.1964	98280.0
2009-04-16 08:01:00	AAPL	Stock	4.1893	4.1893	4.1893	4.1893	5628.0
2009-04-16 08:02:00	AAPL	Stock	4.1893	4.1893	4.1893	4.1893	14840.0
2009-04-16 08:09:00	AAPL	Stock	4.1893	4.1893	4.1893	4.1893	31780.0
2009-04-16 08:10:00	AAPL	Stock	4.1964	4.1964	4.1964	4.1964	5600.0
2009-04-16 08:14:00	AAPL	Stock	4.1964	4.1964	4.1964	4.1964	2800.0
2009-04-16 08:15:00	AAPL	Stock	4.1964	4.2054	4.1964	4.2054	22400.0
2009-04-16 08:16:00	AAPL	Stock	4.2054	4.2054	4.2054	4.2054	11200.0
2009-04-16 08:19:00	AAPL	Stock	4.205	4.2071	4.205	4.2071	14000.0
2009-04-16 08:21:00	AAPL	Stock	4.2071	4.2071	4.2071	4.2071	9800.0
2009-04-16 08:22:00	AAPL	Stock	4.2143	4.2143	4.2071	4.2079	69748.0
2009-04-16 08:23:00	AAPL	Stock	4.2079	4.2079	4.2079	4.2079	8596.0
2009-04-16 08:24:00	AAPL	Stock	4.2079	4.2079	4.2079	4.2079	2800.0
2009-04-16 08:26:00	AAPL	Stock	4.2054	4.2125	4.2054	4.2125	13608.0
2009-04-16 08:31:00	AAPL	Stock	4.2136	4.2136	4.2107	4.2107	8820.0
2009-04-16 08:32:00	AAPL	Stock	4.2136	4.2196	4.2132	4.2196	83300.0
2009-04-16 08:33:00	AAPL	Stock	4.2275	4.2286	4.2214	4.2286	11200.0
2009-04-16 08:38:00	AAPL	Stock	4.2214	4.2286	4.2214	4.2286	19068.0
2009-04-16 08:39:00	AAPL	Stock	4.2286	4.2286	4.225	4.225	19712.0
2009-04-16 08:40:00	AAPL	Stock	4.2321	4.2429	4.2321	4.2429	43400.0
2009-04-16 08:43:00	AAPL	Stock	4.2371	4.2371	4.2371	4.2371	2800.0
2009-04-16 08:44:00	AAPL	Stock	4.2371	4.2371	4.2286	4.2286	63056.0
2009-04-16 08:45:00	AAPL	Stock	4.225	4.2257	4.225	4.2257	27804.0
2009-04-16 08:46:00	AAPL	Stock	4.2304	4.2339	4.2304	4.2321	36456.0
2009-04-16 08:47:00	AAPL	Stock	4.2393	4.2461	4.2393	4.2439	49644.0
2009-04-16 08:48:00	AAPL	Stock	4.2411	4.2411	4.2411	4.2411	2800.0
2009-04-16 08:49:00	AAPL	Stock	4.2411	4.2421	4.2411	4.2421	5600.0
2009-04-16 08:50:00	AAPL	Stock	4.2421	4.2443	4.2421	4.2429	16800.0
2009-04-16 08:51:00	AAPL	Stock	4.2429	4.2432	4.2429	4.2432	19180.0
2009-04-16 08:52:00	AAPL	Stock	4.2429	4.2429	4.2421	4.2421	19600.0
2009-04-16 08:53:00	AAPL	Stock	4.2393	4.2393	4.2357	4.2361	23100.0
2009-04-16 08:54:00	AAPL	Stock	4.2393	4.2393	4.2393	4.2393	5600.0
2009-04-16 08:56:00	AAPL	Stock	4.2361	4.2361	4.2357	4.2361	12656.0
2009-04-16 09:01:00	AAPL	Stock	4.2361	4.2393	4.2361	4.2393	46760.0
2009-04-16 09:02:00	AAPL	Stock	4.2407	4.2407	4.24	4.2407	30520.0
2009-04-16 09:03:00	AAPL	Stock	4.2404	4.2407	4.2404	4.2407	8400.0
2009-04-16 09:04:00	AAPL	Stock	4.2375	4.2375	4.2375	4.2375	2800.0
2009-04-16 09:05:00	AAPL	Stock	4.2425	4.2425	4.2411	4.2411	5600.0
2009-04-16 09:06:00	AAPL	Stock	4.2393	4.2393	4.2393	4.2393	5600.0
2009-04-16 09:08:00	AAPL	Stock	4.2393	4.2396	4.2393	4.2396	9800.0
2009-04-16 09:09:00	AAPL	Stock	4.2429	4.2429	4.2429	4.2429	30800.0
2009-04-16 09:10:00	AAPL	Stock	4.2436	4.2489	4.2436	4.2446	84000.0
2009-04-16 09:11:00	AAPL	Stock	4.2461	4.2461	4.2429	4.2429	30800.0
2009-04-16 09:12:00	AAPL	Stock	4.2432	4.2432	4.2432	4.2432	2800.0
2009-04-16 09:13:00	AAPL	Stock	4.2461	4.2461	4.2461	4.2461	3920.0
2009-04-16 09:15:00	AAPL	Stock	4.2432	4.2432	4.2432	4.2432	5600.0
2009-04-16 09:16:00	AAPL	Stock	4.2436	4.2436	4.2436	4.2436	2800.0
2009-04-16 09:17:00	AAPL	Stock	4.2429	4.2454	4.2429	4.2454	11200.0
2009-04-16 09:19:00	AAPL	Stock	4.2421	4.2421	4.2421	4.2421	5600.0

> showing 50 of 949,650 rows — these rows as CSV

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